new to servlet programing
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
public class pgm extends HttpServlet
{
Connection con;
Statement st=null;
public void doGet(HttpServletRequest req,
HttpServletResponse res)
throws ServletException, IOException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
String s1=req.getParameter("fn");
String s2=req.getParameter("ln");
String s3=req.getParameter("ph");
String s4=req.getParameter("ci");
String s5=req.getParameter("fn");
String s6=req.getParameter("pw");
st=con.createStatement();
int i=0;
i=st.executeUpdate("insert into data values(s1+","+s2+","+s3+","+s4+","+s5+","+s6)");
}
catch (SQLException se) {
System.out.println("We got an exception while executing our query:" +
"that probably means our SQL is invalid");
se.printStackTrace();
System.exit(1);}
PrintWriter pw=res.getWriter();
pw.println("Added successfully");
}
}
this is the sample project of reading from a html page and storing in database.while compiling this i am getting class not found exception and other errors like object does not exist. some one please help
