Insert Operation

View Answers

September 30, 2008 at 4:38 PM

Hi friend,

As per your requirement code to solve your problem :

Some points remmeber :

1.Create a file "home.jsp" having a button "Add Employee"
2.After click on button pop up window "insertrecord.jsp".
3.On pop up window having a form if record insert successfully
prints a message "Record insert successfully".

"home.jsp"

<HTML>
<head>

</head>
<BODY BGCOLOR="LIGHTYELLOW">
<FORM NAME="form" METHOD="GET" ACTION="process.jsp">
<br><br>

<H3> <P ALIGN="CENTER"> <FONT SIZE=6> EMPLOYEE DETAILS </FONT> </P> </H3>
<BR>
<BR>
<TABLE CELLSPACING=5 CELLPADDING=5 BGCOLOR="LIGHTBLUE" COLSPAN=2 ROWSPAN=2 ALIGN="CENTER">
<TR>
<TD> <INPUT TYPE="button" NAME="s1" VALUE="Add Employee" onClick="window.open('insertrecord.jsp','mywindow','width=500,height=350,toolbar=no,resizable=yes,menubar=yes')">
</FONT> </TD>
</TR>
</TR> </FONT>

</FORM>
</BODY>
</HTML>

"insertrecord.jsp"

<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY>
<%
String employee_name="";
String email="";

if(request.getParameter("employee_name")!=null && request.getParameter("employee_name")!="")
{
employee_name = request.getParameter("employee_name").toString();
email = request.getParameter("email").toString();

Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "userdetails";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";

int sumcount=0;
Statement st;
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
String query = "insert into employee set employee_name='"+employee_name+"',email='"+email+"'";
st = conn.createStatement();
int i = st.executeUpdate(query);
if(i>0)
{
out.println("insert successfully");
}
}
catch (Exception e) {
e.printStackTrace();
}
}
%>
<form>
<table>
<tr><td>Name</td><td><input type="text" name="employee_name"></td></tr>
<tr><td>Email</td><td><input type="text" name="email"></td></tr>
<tr><td> </td><td><input type="submit" name="submit" value="Submit"></td></tr>
</table>
</form>
</BODY>
</HTML>

For read more in details examples on "Pop Up Window" in jsp to visit....

http://www.roseindia.net/jsp/pop-window.shtml

http://www.roseindia.net/jsp/popup-window-using-ajax-in-jsp.shtml

Thanks

September 30, 2008 at 4:39 PM

"home.jsp"

<HTML>
<head>

</head>
<BODY BGCOLOR="LIGHTYELLOW">
<FORM NAME="form" METHOD="GET" ACTION="process.jsp">
<br><br>

<H3> <P ALIGN="CENTER"> <FONT SIZE=6> EMPLOYEE DETAILS </FONT> </P> </H3>
<BR>
<BR>
<TABLE CELLSPACING=5 CELLPADDING=5 BGCOLOR="LIGHTBLUE" COLSPAN=2 ROWSPAN=2 ALIGN="CENTER">
<TR>
<TD> <INPUT TYPE="button" NAME="s1" VALUE="Add Employee" onClick="window.open('insertrecord.jsp','mywindow','width=500,height=350,toolbar=no,resizable=yes,menubar=yes')">
</FONT> </TD>
</TR>
</TR> </FONT>

</FORM>
</BODY>
</HTML>

Thanks

September 30, 2008 at 4:47 PM

Replace " __LongTerm__" :
with
onClick="window.open('insertrecord.jsp','mywindow','width=500,height=350,toolbar=no,resizable=yes,menubar=yes')">

Thanks