使用JSPSERVLETJDBC实现对数据库的增删改查（精）

public void setTotalRecord(int totalRecord{ this.totalRecord=totalRecord; } }

8,用相同的方法建一个StudentInfo类 完整的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; } }

9，在src目录下添加另一个包dbservlet在该包中建立一个AllServlet类 完整的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(\ response.setCharacterEncoding(\

String methodName=request.getParameter(\ int method=Integer.parseInt(methodName; try { switch(method { case 0:

insert(request,response; case 1:

difpage(request,response; break; case 2:

delete(request,response;