Java Reference
In-Depth Information
private Connection link;
private String URL = "jdbc:odbc:HomeDB";
public void init() throws ServletException
{
super.init();
try
{
link = DriverManager.getConnection(URL,"","");
}
catch (SQLException ex)
{
ex.printStackTrace();
System.exit(1);
}
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException
{
String surname,forenames,telNum;
surname = request.getParameter("Surname");
forenames = request.getParameter("Forenames");
telNum = request.getParameter("PhoneNum");
response.setContentType("text/HTML");
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Servlet + JDBC</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
String insertion = "INSERT INTO PhoneNums"
+ " VALUES('" + surname + "','"
+ forenames + "','" + telNum + "')";
try
{
statement = link.createStatement();
statement.executeUpdate(insertion);
statement.close(); //Ensures committal.
}
catch (SQLException sqlEx)
{
out.println("<BR><CENTER><H2>Unable to execute"
+ " insertion!</H2></CENTER>");
out.println("</BODY>");
Search WWH ::
Custom Search