/* * serwletJDBC.java * * Created on 29 kwiecien 2007, 11:40 */ PACKAGE serwlety; import JAVA.io.*; import JAVA.net.*; import JAVA.SQL.*; import javax.servlet.*; import javax.servlet.http.*; /** * * @author student1 * @version */ PUBLIC class serwletJDBC EXTENDS HttpServlet { /** Initializes the servlet. */ PUBLIC void init(ServletConfig config) throws ServletException { super.init(config); } /** Destroys the servlet. */ PUBLIC void destroy() { } /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter OUT = response.getWriter(); try { DriverManager.registerDriver(NEW org.gjt.mm.mysql.Driver()); Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3307/sklep", "root", "root"); Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("select * from Produkty"); /* out.println("<table border=\"1\">"); out.println("<tr><td>id</td><td>nazwa</td><td>cena</td></tr>"); while(rset.next()) { out.println("<tr>"); out.println("<td>"+rset.getString("id")+"</td>"); out.println("<td>"+rset.getString("name")+"</td>"); out.println("<td>"+rset.getString("price")+"</td>"); out.println("</tr>"); } out.println("</table>"); */ OUT.println("<form method=\"get\">"); OUT.println("<select name=\"id\">"); WHILE(rset.next()) { OUT.println("<option "); OUT.println("value=\""+rset.getString("id")+"\">"); OUT.println(rset.getString("name")+"</option>"); } OUT.println("</select><input type=\"submit\" value=\"Pytaj\"</form>"); } catch (SQLException e) { OUT.println("Blad: " +e); } OUT.CLOSE(); } /** Handles the HTTP <code>GET</code> method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { IF(request.getParameter("id") != NULL) { PrintWriter OUT = response.getWriter(); int id_prod = INTEGER.parseInt(request.getParameter("id")); // OUT.print(id_prod); try { DriverManager.registerDriver(NEW org.gjt.mm.mysql.Driver()); Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3307/sklep", "root", "root"); Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("select * from Produkty where id=" + id_prod); OUT.println("<table border=\"1\">"); OUT.println("<tr><td>id</td><td>nazwa</td><td>cena</td></tr>"); WHILE(rset.next()) { OUT.println("<tr>"); OUT.println("<td>"+rset.getString("id")+"</td>"); OUT.println("<td>"+rset.getString("name")+"</td>"); OUT.println("<td>"+rset.getString("price")+"</td>"); OUT.println("</tr>"); } OUT.println("</table><a href=\"javascript:history.go(-1)\"><-- powrót</a>"); } catch (SQLException e) { OUT.println("Blad: " +e); } OUT.CLOSE(); } ELSE { processRequest(request, response); } } /** Handles the HTTP <code>POST</code> method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** Returns a short description of the servlet. */ PUBLIC String getServletInfo() { RETURN "Short description"; } }