Servlet框架(servlet+jsp)+Mysql实现的增删改查+分页（功能包学生信息录入、学生信息增删改查、分页等）

Servlet框架(servlet+jsp)+Mysql实现的增删改查+分页（功能包学生信息录入、学生信息增删改查、分页等）

@TOC

Servlet框架(servlet+jsp)+Mysql实现的增删改查+分页

本系统实现了一个java的servlet框架+jsp的学生信息增删改查+分页的实例，简单易懂，特别适合刚学servlet的伙伴。

实现功能截图

系统功能

本会议管理系统实现了以下功能：1、学生信息录入2、录入成功3、学生信息列表4、分页5、学生信息编辑6、学生信息删除

使用技术

数据库：mysql开发工具：Eclipse（Myeclispe、Idea也可以）知识点：servlet+jsp

代码

实体类Page.java

package bean; public class Page { private int totalPage; private int currentPage; private int totalRecord; private int currentRecord; private int pageSize=8; //获得和设置当前页 public int getCurrentPage(){ return currentPage; } public void setCurrentPage(int currentRecord,int pageSize){ if(currentRecord%pageSize==0){ currentPage=currentRecord/pageSize; } else{ currentPage=currentRecord/pageSize+1; } } //获得和设置当前记录 public int getCurrentRecord(){ return currentRecord; } public void setCurrentRecord(int currentRecord){ this.currentRecord=currentRecord; } //获得和设置每页记录数量 public int getPageSize(){ return pageSize; } public void setPageSize(int pageSize){ this.pageSize=pageSize; } //获得和设置总页数 public int getTotalPage(){ return totalPage; } public void setTotalPage(int totalRecord,int pageSize){ if(totalRecord%pageSize==0){ totalPage=totalRecord/pageSize; } else{ totalPage=totalRecord/pageSize+1; } } //获得和设置总记录 public int getTotalRecord(){ return totalRecord; } public void setTotalRecord(int totalRecord){ this.totalRecord=totalRecord; } }

StudentInfo.java

package bean; public class StudentInfo { private int id; //学号 private String name; //姓名 private int age; //年龄 private String gender; //性别 private String major; //专业 public StudentInfo(){ } public StudentInfo(int id,String name,int age,String gender,String major){ this.id=id; this.name=name; this.age=age; this.gender=gender; this.major=major; } public int getId(){ return id; } public void setId(int id){ this.id=id; } public String getName(){ return name; } public void setName(String name){ this.name=name; } public int getAge(){ return age; } public void setAge(int age){ this.age=age; } public String getGender(){ return gender; } public void setGender(String gender){ this.gender=gender; } public String getMajor(){ return major; } public void setMajor(String major){ this.major=major; } }

servlet 类AllServlet.java:

package dbservlet; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; 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 bean.Page; import bean.StudentInfo; public class AllServlet extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; //doPost方法 public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); String methodName=request.getParameter("methodName"); int method=Integer.parseInt(methodName); //将字符串解析为数字 try { switch(method) { case 0: insert(request,response); break; case 1: difpage(request,response); break; case 2: delete(request,response); break; case 3: update(request,response); break; case 4: update1(request,response); break; case 5: dispatch(request,response); break; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } //doGet方法 public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } //数据库连接方法 public Connection connect() throws ClassNotFoundException, SQLException{ Connection conn=null; Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost:3306/springside"; String user="root"; String password="xxxxx"; conn=DriverManager.getConnection(url,user,password); return conn; } //关闭数据库资源 public void close(Statement stat,Connection conn) throws SQLException{ if(stat!=null){ stat.close(); } if(conn!=null){ conn.close(); } } //插入方法 public void insert(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException , IOException,ServletException{ Connection conn=null; Statement stat=null; String id=request.getParameter("id"); String name=request.getParameter("name"); String age=request.getParameter("age"); String gender=request.getParameter("gender"); String major=request.getParameter("major"); conn=connect(); stat=conn.createStatement(); stat.execute("insert into student(id,name,age,gender,major) values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')"); close(stat,conn); request.getRequestDispatcher("InsertSuccess.jsp").forward(request, response); } //查询方法 public ArrayList select(String id,String name) throws ClassNotFoundException, SQLException{ Connection conn=null; Statement stat=null; ResultSet rs=null; conn=connect(); stat=conn.createStatement(); ArrayList result=new ArrayList(); if(id==""&&name==""){ rs=stat.executeQuery("select * from student"); } if(id!=""&&name==""){ rs=stat.executeQuery("select * from student where id="+id+""); } if(id==""&&name!=""){ rs=stat.executeQuery("select * from student where name='"+name+"'"); } if(id!=""&&name!=""){ rs=stat.executeQuery("select * from student where id="+id+" and name='"+name+"'"); } while(rs.next()) { StudentInfo st=new StudentInfo(); st.setId(rs.getInt("id")); st.setName(rs.getString("name")); st.setAge(rs.getInt("age")); st.setGender(rs.getString("gender")); st.setMajor(rs.getString("major")); result.add(st); } if(rs!=null){ rs.close(); } close(stat,conn); return result; } //条件查询跳转 public void dispatch(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{ String id5=request.getParameter("id"); String name5=request.getParameter("name"); if(select(id5,name5).isEmpty()){ request.getRequestDispatcher("selectnothing.jsp").forward(request, response); } else{ request.setAttribute("result", select(id5,name5)); request.getRequestDispatcher("idnameselect.jsp").forward(request, response); } } //设置分页相关参数方法 public Page setpage(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException{ String crd=request.getParameter("currentRecord"); //String id=request.getParameter("id"); // String name=request.getParameter("name"); ArrayList result=select("",""); Page pager=new Page(); pager.setTotalRecord(result.size()); pager.setTotalPage(result.size(),pager.getPageSize()); if(crd!=null) { int currentRecord=Integer.parseInt(crd); pager.setCurrentRecord(currentRecord); pager.setCurrentPage(currentRecord,pager.getPageSize()); } return pager; } //获得分页显示的子集 public void difpage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException{ // String id=request.getParameter("id"); // String name=request.getParameter("name"); ArrayList result=select("",""); //返回查询的结果集 Page pager=new Page(); pager=setpage(request,response); List subResult=null; int currentRecord=pager.getCurrentRecord(); if(currentRecord==0){ if(pager.getTotalRecord()<8){ subResult=(List) result.subList(0,pager.getTotalRecord()); } else{ subResult=(List) result.subList(0,pager.getPageSize()); } } else if(pager.getCurrentRecord()+pager.getPageSize()) result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize()); } else { subResult=(List) result.subList(pager.getCurrentRecord(),result.size()); } request.setAttribute("pager", pager); request.setAttribute("subResult", subResult); request.getRequestDispatcher("layout.jsp").forward(request, response); } //信息删除方法 public void delete(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{ Connection conn=null; Statement stat=null; conn=connect(); stat=conn.createStatement(); String id2=request.getParameter("id"); stat.execute("delete from student where id="+id2+""); request.getRequestDispatcher("delete.jsp").forward(request, response); } //信息修改方法 public void update1(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{ String id4=request.getParameter("id"); request.setAttribute("result", select(id4,"")); request.getRequestDispatcher("update1.jsp").forward(request, response); } //修改 public void update(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{ Connection conn=null; Statement stat=null; String id3=request.getParameter("id"); String name3=request.getParameter("name"); String age3=request.getParameter("age"); String gender3=request.getParameter("gender"); String major3=request.getParameter("major"); conn=connect(); stat=conn.createStatement(); stat.execute("update student set id="+id3+",name='"+name3+"',age="+age3+",gender='"+gender3+"',major='"+major3+"' where id="+id3+""); request.setAttribute("result", select(id3,"")); request.getRequestDispatcher("update.jsp").forward(request, response); } }

写在最后

如果运行代码中遇到问题，可以加博主个人主页交流

觉得有用，记得一键三连哦！

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。