Home

JAVA JDBC

Here is some sample codes to create Guest Book

import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; import java.util.*; public class guestbook extends HttpServlet { Connection con; boolean more; ResultSet rs; Statement stmt; String strsql; String dsn; public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter pw = response.getWriter(); dsn="jdbc:odbc:guest"; strsql = "select *from info"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundException cnfe) { System.out.println("Class Not Found"); } try{ con = DriverManager.getConnection(dsn,"Guest",""); stmt = con.createStatement(); rs = stmt.executeQuery(strsql); more=rs.next(); response.setContentType("text/html"); pw.println("<center>"); pw.println("<form name=addbook>"); pw.println("<input type=button value=\"Add Your Entry in Guest Book\" onClick=\'document.location.replace(\"file:///c:/jsdk2.0/examples/addbook.html\")\'>"); pw.println("</form>"); while(more) { pw.println("<table border=2>"); pw.println("<tr>"); pw.println("<td width=150> Name : </td> <td width=400> " + rs.getString("name") + "</td>"); pw.println("</tr>"); pw.println("<tr>"); pw.println("<td width=150> Email : </td> <td width=400> " + rs.getString("email") + "</td>"); pw.println("</tr>"); pw.println("<tr>"); pw.println("<td width=150> Comments : </td><td width=400> " + rs.getString("comment") + "</td>"); pw.println("</tr>"); pw.println("<tr>"); pw.println("<td width=150> Date : </td> <td width=400> " + rs.getString("date") + "</td>"); pw.println("</tr>"); pw.println("</table>"); pw.println("<br>"); more=rs.next(); } pw.println("</center>"); pw.close(); rs.close(); stmt.close(); con.close(); }catch(SQLException sqle) { System.out.println("There is an error " + sqle); } } }



import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; import java.util.*; public class savebook extends HttpServlet { Connection con; Statement stmt; java.util.Date dt; String strsql; String name; String email; String comments; String dsn; String date; public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { dt = new java.util.Date(); date = String.valueOf(dt); PrintWriter pw = response.getWriter(); dsn="jdbc:odbc:guest"; name = request.getParameter("txtname"); email = request.getParameter("txtemail"); comments = request.getParameter("txtcomments"); strsql = "insert into info values('" + name +"','" + email +"','"+comments +"','" + date +"')"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch(ClassNotFoundException cnfe) { System.out.println("Class Not Found"); } try{ con = DriverManager.getConnection(dsn,"Guest",""); stmt = con.createStatement(); stmt.executeUpdate(strsql); response.setContentType("text/html"); pw.println("<script> document.location.replace(\"http://localhost:8080/servlet/guestbook\"); </script>"); pw.close(); stmt.close(); con.close(); }catch(SQLException sqle) { System.out.println("There is an error " + sqle); } } }