jsp+mysql+servlet简略图书管理系统（含登录注册）

package servlet; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import book.Book; public class antiaojianFindServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String no=request.getParameter("no"); try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/bookimformation?useUnicode=true&characterEncoding=utf-8"; String username = "root"; String password = "5201314"; Connection conn = DriverManager.getConnection(url, username, password); String sql = "select * from imformation where no='"+no+"'"; Statement statement = conn.createStatement(); ResultSet resultSet = statement.executeQuery(sql); List<Book> list = new ArrayList<Book>(); if(resultSet.next()) { Book book = new Book(); book.setNo(resultSet.getInt("no")); book.setBookname(resultSet.getString("bookname")); book.setPrice(resultSet.getDouble("price")); book.setNumber(resultSet.getInt("number")); book.setAuthor(resultSet.getString("author")); list.add(book); } request.setAttribute("list", list); resultSet.close(); statement.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } request.getRequestDispatcher("chakanquanbutushu.jsp").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }