code079.java
1package pack02; 2 3import java.io.IOException; 4import java.sql.Connection; 5import java.sql.DriverManager; 6import java.sql.ResultSet; 7import java.sql.SQLException; 8import java.sql.Statement; 9import java.util.ArrayList; 10import java.util.List; 11 12import javax.servlet.ServletException; 13import javax.servlet.annotation.WebServlet; 14import javax.servlet.http.HttpServlet; 15import javax.servlet.http.HttpServletRequest; 16import javax.servlet.http.HttpServletResponse; 17 18//��ʾͼ�飬FindServlet�࣬��code081.jsp���� 19@WebServlet(name = "code079",urlPatterns = "/page04/pack02.code079") 20public class code079 extends HttpServlet 21{ 22 @Override 23 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 24 { 25 try 26 { 27 Class.forName("com.mysql.jdbc.Driver"); 28 String url = "jdbc:mysql://localhost:3306/test"; 29 String user = "root"; 30 String pwd = "mysql123"; 31 Connection conn = DriverManager.getConnection(url,user,pwd); 32 Statement stmt = conn.createStatement(); 33 34 String sql = "select * from tb_books"; 35 ResultSet result = stmt.executeQuery(sql); 36 List<code078> list1 = new ArrayList<code078>(); 37 while (result.next()) 38 { 39 code078 book = new code078(); 40 book.setId(result.getInt("id")); 41 book.setName(result.getString("name")); 42 book.setPrice(result.getDouble("price")); 43 book.setBookCount(result.getInt("bookCount")); 44 book.setAuthor(result.getString("author")); 45 list1.add(book); 46 } 47 request.setAttribute("list", list1); 48 result.close(); 49 stmt.close(); 50 conn.close(); 51 } catch (ClassNotFoundException e) 52 { 53 e.printStackTrace(); 54 } 55 catch (SQLException e) 56 { 57 e.printStackTrace(); 58 } 59 request.getRequestDispatcher("code080.jsp").forward(request, response); 60 } 61} 62