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 }
