Hi friends,
I code simple java servlet addingemployee but here no values r insert into database. After click submit button in html it shows blank wight screen.. could u help me any body...
following code
// Source File Name: addemployee.java


import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class addemployee extends HttpServlet
{
Connection con;
PrintWriter pw;
PreparedStatement p;
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException,IOException
{
try{
pw=res.getWriter();
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:tavi","scott","tiger");
System.out.println("connection established");
p = con.prepareStatement("insert into employee values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
String n1=req.getParameter("T1");
System.out.println("n1value"+n1);
String n2=req.getParameter("T2");
String n3=req.getParameter("T3");
String n4=req.getParameter("T4");
String n5=req.getParameter("T5");
String n6=req.getParameter("T6");
String n7=req.getParameter("T7");
String n8=req.getParameter("T8");
String n9=req.getParameter("T9");
String n10=req.getParameter("T10");
String n11=req.getParameter("T11");
String n12=req.getParameter("T12");
String n13=req.getParameter("T13");
String n14=req.getParameter("T14");
String n15=req.getParameter("T15");
String n16=req.getParameter("T16");
String n17=req.getParameter("T17");



p.setString(1,n1);
p.setString(2,n2);
p.setString(3,n3);
p.setString(4,n4);
p.setString(5,n5);
p.setString(6,n6);
p.setString(7,n7);
p.setString(8,n8);
p.setString(9,n9);
p.setString(10,n10);
p.setString(11,n11);
p.setString(12,n12);
p.setString(13,n13);
p.setString(14,n14);
p.setString(15,n15);
p.setString(16,n16);
p.setString(17,n17);
p.executeUpdate();
p.close();
con.close();
System.out.println("The values are inserted into the database");
}catch(Exception e){
System.out.println("Error in exception"+e);
}

}
}