please solve my problem
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import javax.sql.*;
import java.sql.*;
public class Student extends HttpServlet
{
Connection dbon;
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbc:odbc:user");
System.out.println("Connection established");
}
catch (ClassNotFoundException e)
{
System.out.println("Database driver not found");
System.out.println(e.toString());
}
catch (Exception e)
{
System.out.println(e.toString());
}
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String name=req.getParameter("name");
int rows=0;
try
{
PreparedStatement s=dbcon.prepareStatement("select *form tabel where(name),(?)");
s.setString(1,name);
}
catch (Exception e)
{
System.out.println(e.toString());
}
try
{
PreparedStatement s=dbcon.prepareStatement("select from name");
ResultSet r=S.executeQuery();
}
catch
{
System.out.pritnln(e.toString());
}
{
out.println("<html>");
out.println("<head><title>NIIT</title></head>");
out.println("<body bgcolor=pink>");
out.println("Student Details" + name);
}
try
{
dbcon.close();
}
catch (Exception e)
{
System.out.println(e.toString());
}
}
}
}
