发布时间 : 星期六 文章使用JSPSERVLETJDBC实现对数据库的增删改查(精)更新完毕开始阅读845b62ba80c758f5f61fb7360b4c2e3f5727258f
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;