javaee学生信息管理系统课程设计

package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import cn.itcast.servlet.BaseServlet; import domain.Student; public class SelectStudentDb extends HttpServlet{ public HttpServletRequest httpServletRequest; public HttpServletResponse httpServletResponse; public List list =new ArrayList(); public void sele(String sname,String sage) throws ClassNotFoundException, SQLException{ PreparedStatement pstmt; Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/students"; String username="root"; String password = "123"; Connection con= DriverManager.getConnection(url,username,password); String sql = "select * from stu where sName = ? and sAge=?"; pstmt = con.prepareStatement(sql); pstmt.setString(1, sname); pstmt.setString(2, sage); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { Student s = new Student(); System.out.print(rs.getString(1)); s.setSnum(rs.getString(1)); s.setSname(rs.getString(2)); s.setSage(rs.getString(3)); s.setSgender(rs.getString(4)); list.add(s); } findAll(httpServletRequest,httpServletResponse,list); } public void findAll(HttpServletRequest httpServletRequest,HttpServletResponse httpServletResponse,List list){ httpServletRequest.setAttribute("student1", list); } }