Java tutorial
/* MySQL and Java Developer's Guide Mark Matthews, Jim Cole, Joseph D. Gradecki Publisher Wiley, Published February 2003, ISBN 0471269239 */ import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class JDBCServlet extends HttpServlet { public void doGet(HttpServletRequest inRequest, HttpServletResponse outResponse) throws ServletException, IOException { PrintWriter out = null; Connection connection = null; Statement statement; ResultSet rs; try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost/products"); statement = connection.createStatement(); outResponse.setContentType("test/html"); out = outResponse.getWriter(); rs = statement.executeQuery("SELECT ID, title, price FROM product"); out.println("<HTML><HEAD><TITLE>Products</TITLE></HEAD>"); out.println("<BODY>"); out.println("<UL>"); while (rs.next()) { out.println( "<LI>" + rs.getString("ID") + " " + rs.getString("title") + " " + rs.getString("price")); } out.println("</UL>"); out.println("</BODY></HTML>"); } catch (ClassNotFoundException e) { out.println("Driver Error"); } catch (SQLException e) { out.println("SQLException: " + e.getMessage()); } } public void doPost(HttpServletRequest inRequest, HttpServletResponse outResponse) throws ServletException, IOException { doGet(inRequest, outResponse); } }