JAVAWEB学习-实现增删改查-03

今天继续写之前的没写完的增删改查,今天主要完成查,代码放后边

先看一下普通用户浏览的效果

代码

normal1.java

 1 package Test.test1;
 2 
 3 import javax.servlet.ServletException;
 4 import javax.servlet.annotation.WebServlet;
 5 import javax.servlet.http.HttpServlet;
 6 import javax.servlet.http.HttpServletRequest;
 7 import javax.servlet.http.HttpServletResponse;
 8 import java.io.IOException;
 9 import java.io.PrintWriter;
10 import java.sql.*;
11 
12 import Test.com.Bean;
13 import Test.test1.login;
14 
15 @WebServlet("/normal1")
16 public class normal1 extends HttpServlet {
17 
18     private static final long serialVersionUID = 1L;
19     Connection conn = null;
20     Statement stmt = null;
21     @Override
22     public void init() throws ServletException {
23         String dburl = "jdbc:mysql://localhost:3306/test001?useSSL=false&serverTimezone=UTC";
24         String username = "root";
25         String password = "1506583922";
26         try{
27             Class.forName("com.mysql.cj.jdbc.Driver");
28             conn = DriverManager.getConnection(dburl,username,password);
29             stmt = conn.createStatement();
30         }catch(SQLException se){
31             // 处理 JDBC 错误
32             se.printStackTrace();
33         }catch(Exception e){
34             // 处理 Class.forName 错误
35             e.printStackTrace();
36         }
37     }
38     @Override
39     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
40 
41         response.setContentType("text/html;charset=UTF-8");
42         PrintWriter out = response.getWriter();
43         String title1 = "新闻浏览";
44 
45         String docType = "<!DOCTYPE html> \n";
46         out.println(docType +
47                 "<html>\n" +
48                 "<head><title>" + title1 + "</title></head>\n" +
49                 "<body bgcolor=\"#f0f0f0\">\n" +
50                 "<h1 align=\"center\">" + title1 + "</h1>\n"
51 
52                 );
53         String sql;
54         sql = "SELECT news_title,news_text,news_writer,news_date FROM news_info";
55         try {
56             ResultSet rs = stmt.executeQuery(sql);
57             while (rs.next()) {
58                 out.println("<br>");
59                 String title = rs.getString("news_title");
60                 String text = rs.getString("news_text");
61                 String writer = rs.getString("news_writer");
62                 String date = rs.getString("news_date");
63 
64                 out.println(title);
65                 out.println("<br>");
66                 out.println(text);
67                 out.println("<br>");
68                 out.println("作者"+writer);
69                 out.println("日期: " + date);
70                 out.println("<br>");
71                 out.println("<br>");
72             }
73         }catch (Exception e){
74 
75         }
76         out.println("</body></html>");
77 
78     }
79     @Override
80     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
81         doGet(request, response);
82     }
83     @Override
84     public void destroy() {
85         try {
86             conn.close();
87         }catch (Exception e){
88             e.printStackTrace();
89         }
90     }
91 }

Text.java

 1 package Test.com;
 2 
 3 public class Text {
 4     private String news_title,news_text,news_writer,news_date;
 5     public String getNews_title(){return news_title;}
 6     public String getNews_text(){return news_text;}
 7     public String getNews_writer(){return news_writer;}
 8     public String getNews_date(){return news_date;}
 9 
10     public void setNews_title(String news_title) {
11         this.news_title = news_title;
12     }
13 
14     public void setNews_text(String news_text) {
15         this.news_text = news_text;
16     }
17 
18     public void setNews_writer(String news_writer) {
19         this.news_writer = news_writer;
20     }
21 
22     public void setNews_date(String news_date) {
23         this.news_date = news_date;
24     }
25 }