Facebook
From DeanDong, 10 Months ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 226
  1. package mypack;
  2. import java.io.*; import java.sql.*;
  3. import javax.servlet.*;
  4. import javax.servlet.http.*;
  5. public class QuizServlet extends HttpServlet {
  6. public void doGet(HttpServletRequest request, HttpServletResponse response)
  7. throws ServletException, 10Exception {
  8. response.setContentType ("text/html;charset=UTF-8");
  9. PrintWriter out = response.get Writer:
  10. out.println("<form acti >");
  11. try i
  12. Class. forName("com.mysql.jdbc.Driver");
  13. Connection con =
  14. DriverManager.getConnection ("jdbc:mysql://localhost:3306/qadb", "root", "root");
  15. Statement stmt = con.createStatement);
  16. ResultSet re
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25. package mypack;
  26.  
  27. import java.io.*;
  28.  
  29. import java.sql.*;
  30.  
  31. import javax.servlet.*;
  32.  
  33. import javax.servlet.http.*;
  34.  
  35. public class QuizServlet extends HttpServlet {
  36.  
  37. public void doGet(HttpServletRequest request, HttpServletResponse response)
  38.  
  39. throws ServletException, IOException {
  40.  
  41. response.setContentType("text/html;charset=UTF-8");
  42.  
  43. PrintWriter out = response.getWriter();
  44.  
  45. out.println("<form acti>");
  46.  
  47. try {
  48.  
  49. Class.forName("com.mysql.jdbc.Driver");
  50.  
  51. Connection con =
  52.  
  53. DriverManager.getConnection("jdbc:mysql://localhost:3306/qadb","root","root");
  54.  
  55. Statement stmt = con.createStatement();
  56.  
  57. ResultSet res = stmt.executeQuery("select * from quiz");
  58.  
  59. out.println("<table border=1>");