使用JSP+SERVLET+JDBC实现对数据库的增删改查.docx
《使用JSP+SERVLET+JDBC实现对数据库的增删改查.docx》由会员分享，可在线阅读，更多相关《使用JSP+SERVLET+JDBC实现对数据库的增删改查.docx（37页珍藏版）》请在冰豆网上搜索。
使用JSP+SERVLET+JDBC实现对数据库的增删改查
使用JSP+SERVLET+JDBC实现对数据库的增删改查
首先，打开sql*plus，输入用户名（我用的scott）密码（我设置的是tiger）。
先建个表student，
Createtablestudent（
idnumber（30）notnullprimarykey,
namevarchar（50）,
agenumber（30）,
gendervarchar（30）,
majorvarchar（50））;
1，打开myeclipse（我用的是myeclipse8.5）新建一个webproject
2，在projectname中输入合法名字，比如normal
3，新建的normal工程
4，在src目录下建一个包，右击src选择new在选择package
5，输入合法名字比如bean
6，在bean目录下建一个class，右击bean选择new再选择class
7，输入名字Page
完整的Page.java代码如下
packagebean;
publicclassPage{
privateinttotalPage;
privateintcurrentPage;
privateinttotalRecord;
privateintcurrentRecord;
privateintpageSize=8;
//获得和设置当前页
publicintgetCurrentPage（）{
returncurrentPage;
}
publicvoidsetCurrentPage（intcurrentRecord,intpageSize）{
if（currentRecord%pageSize==0）{
currentPage=currentRecord/pageSize;
}
else{
currentPage=currentRecord/pageSize+1;
}
}
//获得和设置当前记录
publicintgetCurrentRecord（）{
returncurrentRecord;
}
publicvoidsetCurrentRecord（intcurrentRecord）{
this.currentRecord=currentRecord;
}
//获得和设置每页记录数量
publicintgetPageSize（）{
returnpageSize;
}
publicvoidsetPageSize（intpageSize）{
this.pageSize=pageSize;
}
//获得和设置总页数
publicintgetTotalPage（）{
returntotalPage;
}
publicvoidsetTotalPage（inttotalRecord,intpageSize）{
if（totalRecord%pageSize==0）{
totalPage=totalRecord/pageSize;
}
else{
totalPage=totalRecord/pageSize+1;
}
}
//获得和设置总记录
publicintgetTotalRecord（）{
returntotalRecord;
}
publicvoidsetTotalRecord（inttotalRecord）{
this.totalRecord=totalRecord;
}
}
8,用相同的方法建一个StudentInfo类
完整的StudentInfo.java代码如下
packagebean;
publicclassStudentInfo{
privateintid;//学号
privateStringname;//姓名
privateintage;//年龄
privateStringgender;//性别
privateStringmajor;//专业
publicStudentInfo（）{
}
publicStudentInfo（intid,Stringname,intage,Stringgender,Stringmajor）{
this.id=id;
this.name=name;
this.age=age;
this.gender=gender;
this.major=major;
}
publicintgetId（）{
returnid;
}
publicvoidsetId（intid）{
this.id=id;
}
publicStringgetName（）{
returnname;
}
publicvoidsetName（Stringname）{
this.name=name;
}
publicintgetAge（）{
returnage;
}
publicvoidsetAge（intage）{
this.age=age;
}
publicStringgetGender（）{
returngender;
}
publicvoidsetGender（Stringgender）{
this.gender=gender;
}
publicStringgetMajor（）{
returnmajor;
}
publicvoidsetMajor（Stringmajor）{
this.major=major;
}
}
9，在src目录下添加另一个包dbservlet在该包中建立一个AllServlet类
完整的AllServlet.java代码如下
packagedbservlet;
importjava.io.IOException;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importbean.Page;
importbean.StudentInfo;
publicclassAllServletextendsHttpServlet{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
//doPost方法
publicvoiddoPost（HttpServletRequestrequest,HttpServletResponseresponse）
throwsServletException,IOException{
request.setCharacterEncoding（"UTF-8"）;
response.setCharacterEncoding（"UTF-8"）;
StringmethodName=request.getParameter（"methodName"）;
intmethod=Integer.parseInt（methodName）;
try{
switch（method）
{
case0:
insert（request,response）;
case1:
difpage（request,response）;
break;
case2:
delete（request,response）;
break;
case3:
update（request,response）;
break;
case4:
update1（request,response）;
break;
case5:
dispatch（request,response）;
break;
}
}catch（ClassNotFoundExceptione）{
//TODOAuto-generatedcatchblock
e.printStackTrace（）;
}catch（SQLExceptione）{
//TODOAuto-generatedcatchblock
e.printStackTrace（）;
}
}
//doGet方法
publicvoiddoGet（HttpServletRequestrequest,HttpServletResponseresponse）
throwsServletException,IOException{
doPost（request,response）;
}
//数据库连接方法
publicConnectionconnect（）throwsClassNotFoundException,SQLException{
Connectionconn=null;
Class.forName（"oracle.jdbc.driver.OracleDriver"）;
Stringurl="jdbc:
oracle:
thin:
@localhost:
1521:
orcl";
Stringuser="scott";
Stringpassword="tiger";
conn=DriverManager.getConnection（url,user,password）;
returnconn;
}
//关闭数据库资源
publicvoidclose（Statementstat,Connectionconn）throwsSQLException{
if（stat!
=null）{
stat.close（）;
}
if（conn!
=null）{
conn.close（）;
}
}
//插入方法
publicvoidinsert（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException{
Connectionconn=null;
Statementstat=null;
Stringid=request.getParameter（"id"）;
Stringname=request.getParameter（"name"）;
Stringage=request.getParameter（"age"）;
Stringgender=request.getParameter（"gender"）;
Stringmajor=request.getParameter（"major"）;
conn=connect（）;
stat=conn.createStatement（）;
stat.execute（"insertintostudent（id,name,age,gender,major）values（"+id+",'"+name+"',"+age+",'"+gender+"','"+major+"'）"）;
close（stat,conn）;
}
//查询方法
publicArrayListselect（Stringid,Stringname）throwsClassNotFoundException,SQLException{
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
conn=connect（）;
stat=conn.createStatement（）;
ArrayListresult=newArrayList（）;
if（id==""&&name==""）{
rs=stat.executeQuery（"select*fromstudent"）;
}
if（id!
=""&&name==""）{
rs=stat.executeQuery（"select*fromstudentwhereid="+id+""）;
}
if（id==""&&name!
=""）{
rs=stat.executeQuery（"select*fromstudentwherename='"+name+"'"）;
}
if（id!
=""&&name!
=""）{
rs=stat.executeQuery（"select*fromstudentwhereid="+id+"andname='"+name+"'"）;
}
while（rs.next（））
{
StudentInfost=newStudentInfo（）;
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）;
returnresult;
}
//条件查询跳转
publicvoiddispatch（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException,ServletException,IOException{
Stringid5=request.getParameter（"id"）;
Stringname5=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）;
}
}
//设置分页相关参数方法
publicPagesetpage（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException{
Stringcrd=request.getParameter（"currentRecord"）;
//Stringid=request.getParameter（"id"）;
//Stringname=request.getParameter（"name"）;
ArrayListresult=select（"",""）;
Pagepager=newPage（）;
pager.setTotalRecord（result.size（））;
pager.setTotalPage（result.size（）,pager.getPageSize（））;
if（crd!
=null）
{
intcurrentRecord=Integer.parseInt（crd）;
pager.setCurrentRecord（currentRecord）;
pager.setCurrentPage（currentRecord,pager.getPageSize（））;
}
returnpager;
}
//获得分页显示的子集
publicvoiddifpage（HttpServletRequestrequest,HttpServletResponseresponse）throwsServletException,IOException,ClassNotFoundException,SQLException{
//Stringid=request.getParameter（"id"）;
//Stringname=request.getParameter（"name"）;
ArrayListresult=select（"",""）;
Pagepager=newPage（）;
pager=setpage（request,response）;
ListsubResult=null;
intcurrentRecord=pager.getCurrentRecord（）;
if（currentRecord==0）{
if（pager.getTotalRecord（）<8）{
subResult=（List）result.subList（0,pager.getTotalRecord（））;
}
else{
subResult=（List）result.subList（0,pager.getPageSize（））;
}
}
elseif（pager.getCurrentRecord（）+pager.getPageSize（）{
subResult=（List）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）;
}
//信息删除方法
publicvoiddelete（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException,ServletException,IOException{
Connectionconn=null;
Statementstat=null;
conn=connect（）;
stat=conn.createStatement（）;
Stringid2=request.getParameter（"id"）;
stat.execute（"deletefromstudentwhereid="+id2+""）;
request.getRequestDispatcher（"delete.jsp"）.forward（request,response）;
}
//信息修改方法
publicvoidupdate1（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException,ServletException,IOException{
Stringid4=request.getParameter（"id"）;
request.setAttribute（"result",select（id4,""））;
request.getRequestDispatcher（"update1.jsp"）.forward（request,response）;
}
publicvoidupdate（HttpServletRequestrequest,HttpServletResponseresponse）throwsClassNotFoundException,SQLException,ServletException,IOException{
Connectionconn=null;
Statementstat=null;
Stringid3=request.getParameter（"id"）;
Stringname3=request.getParameter（"name"）;
Stringage3=request.getParameter（"age"）;
Str
升级会员 