使用JSP+SERVLET+JDBC实现对数据库的增删改查
时间:2025-07-11
时间:2025-07-11
使用JSP+SERVLET+JDBC实现对数据库的增删改查
使用JSP+SERVLET+JDBC实现对数据库的增删改查
首先,打开sql*plus,输入用户名(我用的scott)密码(我设置的是tiger)。 先建个表student,
Create table student (
id number(30) not null primary key,
name varchar(50) ,
age number(30),
gender varchar(30),
major varchar(50) );
1,打开myeclipse(我用的是myeclipse8.5)新建一个
web project
2,在project name 中输入合法名字,比如
normal
3,新建的normal工程
使用JSP+SERVLET+JDBC实现对数据库的增删改查
4,在src目录下建一个包,右击src选择new在选择
package
5,输入合法名字 比如bean
6,在bean目录下建一个class,右击bean选择new再选择class
使用JSP+SERVLET+JDBC实现对数据库的增删改查
7,输入名字Page
完整的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;
}
使用JSP+SERVLET+JDBC实现对数据库的增删改查
//获得和设置每页记录数量
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;
}
}
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){
使用JSP+SERVLET+JDBC实现对数据库的增删改查
this.id=id;
http://www.77cn.com.cn=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){
http://www.77cn.com.cn=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;
使用JSP+SERVLET+JDBC实现对数据库的增删改查
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);
case 1:
difpage(request,response);
break;
case 2:
delete(request,response);
break;
case 3:
update(request,response);
break;
使用JSP+SERVLET+JDBC实现对数据库的增删改查
case 4:
update1(request,response);
break;
case 5:
dispatch(request,response);
break;
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//doGet方法
public void doGet(HttpServletRequest …… 此处隐藏:12801字,全部文档内容请下载后查看。喜欢就下载吧 ……