Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- //doGet(request, response);
- final String jdbc_driver ="com.mysql.jdbc.Driver";
- final String db_url ="jdbc:mysql://localhost:3306/test_servlet";
- final String USER = "root";
- final String PASS = "";
- String film = request.getParameter("film");
- response.setContentType("text/html");
- PrintWriter out = response.getWriter();
- String title = "Database result";
- String docType =
- "<!doctype html public \"-//w3c//dtd html 4.0 " +
- "transitional//en\">\n";
- out.println(docType +
- "<html>\n" +
- "<head><title>" + title + "</title></head>\n" +
- "<body bgcolor=\"#f0f0f0\">\n" +
- "<h1 align=\"center\">" + title + "</h1>\n");
- try{
- Class.forName("com.mysql.jdbc.Driver");
- //Connection conn = DriverManager.getConnection(db_url, USER, PASS);
- Connection conn = DriverManager.getConnection(db_url, USER, PASS);
- Statement stmt = conn.createStatement();
- String sql = "SELECT name, description FROM film// WHERE name = " + "'" + film + "'" ;
- ResultSet rs = stmt.executeQuery(sql);
- while (rs.next()){
- String name = rs.getString("name");
- String description = rs.getString("description");
- out.println("Nome: " + name + "<br>");
- out.println("Descrizione" + description);
- }
- out.println("</body></html>");
- rs.close();
- stmt.close();
- conn.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement