JSP,JDBC and HTML(Very Urgent)

View Answers

July 9, 2008 at 4:08 PM

Hi raghavendran, I completed the code:

I am not using any html. I used only jsp & jdbc.

HOme Page:
FindEmp.jsp

<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>

<HTML>

<BODY BGCOLOR="LIGHTYELLOW">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Employee","","");
Statement stmt=null;
%>
<FORM METHOD="GET" ACTION="process.jsp">

<H3> <P ALIGN="CENTER"> <FONT SIZE=6> EMPLOYEE DETAILS </FONT> </P> </H3> </BR> </BR>
<BR>
<BR>
<TABLE CELLSPACING=5 CELLPADDING=5 BGCOLOR="LIGHTBLUE" COLSPAN=2 ROWSPAN=2 ALIGN="CENTER">
<TR>
<TD> <FONT SIZE=5> Enter Employee ID </TD>
<TD> <INPUT TYPE="TEXT" ID="id" NAME="id"> </FONT> </TD>
</TR>
<TR>
<TD> <FONT SIZE=5> Enter Employee Name </TD>
<TD><INPUT TYPE="TEXT" ID="name" NAME="name"> </FONT> </TD>
</TR>
<TR>
<TD> <FONT SIZE=5> Enter New Name (For UPDATE only) </TD>
<TD><INPUT TYPE="TEXT" NAME="nname"> </FONT> </TD>
</TR>
<TR>
<TD>Employee Ids: <SELECT NAME="empIds" ONCHANGE="document.getElementById('id').value=this.options[this.selectedIndex].text"><option>Select One</option>
<%
String rec="SELECT Emp_code,Emp_name FROM Employee";
try {
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(rec);
while(rs.next())
{
%>
<option><%= rs.getInt(1)%></option>
<%}
}
catch(Exception e){System.out.println(e);}
%>
</SELECT>
</TD>
</TR>
<TR> <FONT SIZE=6> <B>
<TD><INPUT TYPE="RADIO" NAME="r1" VALUE="add" >Insert </TD>
</TR>
<TR>
<TD><INPUT TYPE="RADIO" NAME="r1" VALUE="del" >Delete </TD>
</TR>
<TR>
<TD><INPUT TYPE="RADIO" NAME="r1" VALUE="mod" >Update </TD>
</TR>
<TR>
<TD><INPUT TYPE="RADIO" NAME="r1" VALUE="query">Query </TD>

</TR>
</FONT> </B>
<TR> <TD><INPUT TYPE="SUBMIT" VALUE="Submit"> <INPUT TYPE="RESET" VALUE="Reset"> </TD>
</TR>
<%
if(session.getAttribute("empcode")!=null && session.getAttribute("empname")!=null)
{
%>
<script language="javascript">
document.getElementById('id').value=<%=session.getAttribute("empcode").toString()%>
document.getElementById('name').value='<%=session.getAttribute("empname").toString()%>'
</script>
<%
session.removeAttribute("empcode");
session.removeAttribute("empname");
}%>
</FORM>

</BODY>
</HTML>

Note: Please align textboxes & combo box according to ur requirement.

process.jsp:

<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>

<html>
<body>
<%
Connection con=null;
Statement stmt=null;
//ResultSet rs=null;
String radioSelected=request.getParameter("r1");
String name=request.getParameter("name");
String code=request.getParameter("id");

String query=null;
int EmpID=Integer.parseInt(code);
int status;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Employee","","");
stmt=con.createStatement();
if(radioSelected.equals("add")){
query="INSERT INTO Employee (Emp_code,Emp_name) VALUES("+EmpID+",'"+name+"')";
status=stmt.executeUpdate(query);
if(status==1){//This is for successful insertion
%>
<script language="javascript">
alert("Insertion successful");
document.location="FindEmp.jsp";
</script>
<%
}else{
%>
<script language="javascript">
alert("Insertion Failed");
document.location="FindEmp.jsp";
</script>
<% }
}
else if(radioSelected.equals("del")){
query="DELETE * FROM Employee where Emp_code="+EmpID+"";
status=stmt.executeUpdate(query);
if(status==1){//This is for successful Deletion
%>
<script language="javascript">
alert("Deletion successful");
document.location="FindEmp.jsp";
</script>
<%
}else{
%>
<script language="javascript">
alert("Deletion Failed Bcoz,Employee Id Not Found");
document.location="FindEmp.jsp";
</script>
<% }

}
else if(radioSelected.equals("mod")){
String new_name=request.getParameter("nname");
query="UPDATE Employee SET Emp_name='"+new_name+"' where Emp_code="+EmpID+"";
status=stmt.executeUpdate(query);
if(status==1){//This is for successful updation
%>
<script language="javascript">
alert("Record Updated successfully");
document.location="FindEmp.jsp";
</script>
<%
}else{
%>
<script language="javascript">
alert("Updation Failed");
document.location="FindEmp.jsp";
</script>
<% }
}
else if(radioSelected.equals("query")){
query="Select Emp_code, Emp_name from Employee where Emp_code="+EmpID+"";
ResultSet rs=stmt.executeQuery(query);

if(rs.next()) //If record found....
{
session.setAttribute("empcode",rs.getInt(1));
session.setAttribute("empname",rs.getString(2));
%>
<script language="javascript">
document.location="FindEmp.jsp";
</script>
<%
}
else{
%>
<script language="javascript">
alert("Employee Id Not Found");
document.location="FindEmp.jsp";
</script>
<%}
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
con.close();
stmt.close();
//rs.close();
}

%>
</body>
</html>

For query radio button, i changed slightly. Not immediately after clicking the radio button, after selecting the radio button then click submit button. Then it displays selected employee id details.

I didn't do any validations for ur text boxes like number only allowed for employee id text box etc.

Thanks
Sreenivas