Servlet实现增删改查功能

MVCMVCMVCMVC模式模式模式模式�M：Model，即模型，对于JavaBean�V：View，即试图，对应JSP页面�C：Controller，即控制器，对应Servlet1.以下为MVC实现一个简单的增删改查功能1显示记录2增加一条记录3修改一条记录4删除一条记录程序源代码：M层：模型层1.封装一条信息的所有属性JavaBean.java，即VOpackagepackagepackagepackagemuta.bean;/***@author@author@author@authorhelp*封装一条信息的所有属性*/publicpublicpublicpublicclassclassclassclassJavaBean{privateprivateprivateprivateintintintintid;privateprivateprivateprivateStringname;privateprivateprivateprivateStringpassword;privateprivateprivateprivateStringsex;privateprivateprivateprivateintintintintage;publicpublicpublicpublicintintintintgetId(){returnreturnreturnreturnid;}publicpublicpublicpublicvoidvoidvoidvoidsetId(intintintintid){thisthisthisthis.id=id;}publicpublicpublicpublicStringgetName(){returnreturnreturnreturnname;}publicpublicpublicpublicvoidvoidvoidvoidsetName(Stringname){thisthisthisthis.name=name;}publicpublicpublicpublicStringgetPassword(){returnreturnreturnreturnpassword;}publicpublicpublicpublicvoidvoidvoidvoidsetPassword(Stringpassword){thisthisthisthis.password=password;}publicpublicpublicpublicStringgetSex(){returnreturnreturnreturnsex;}publicpublicpublicpublicvoidvoidvoidvoidsetSex(Stringsex){thisthisthisthis.sex=sex;}publicpublicpublicpublicintintintintgetAge(){returnreturnreturnreturnage;}publicpublicpublicpublicvoidvoidvoidvoidsetAge(intintintintage){thisthisthisthis.age=age;}}2.封装数据库连接以及操作JavaBean所用到的方法，即DAOpackagepackagepackagepackagemuta.bean;importimportimportimportjava.sql.Connection;importimportimportimportjava.sql.DriverManager;importimportimportimportjava.sql.PreparedStatement;importimportimportimportjava.sql.ResultSet;importimportimportimportjava.sql.SQLException;importimportimportimportjava.util.ArrayList;importimportimportimportjava.util.List;/***@author@author@author@authorhelp*操作数据库的方法*/publicpublicpublicpublicclassclassclassclassSqlBean{Connectioncon;PreparedStatementpre;ResultSetrs;publicpublicpublicpublicSqlBean(){trytrytrytry{Class.forName(com.mysql.jdbc.Driver);}catchcatchcatchcatch(ClassNotFoundExceptione){e.printStackTrace();}trytrytrytry{con=DriverManager.getConnection(jdbc:mysql://127.0.0.1:3306/MyServlet,root,122828);}catchcatchcatchcatch(SQLExceptione){e.printStackTrace();}}/***@author@author@author@authorhelp**插入新的一条记录*@return@return@return@return*/publicpublicpublicpublicintintintintgetInsert(Stringsql,JavaBeanjBean){intintintintcount=0;trytrytrytry{pre=con.prepareStatement(sql);pre.setString(1,jBean.getName());pre.setString(2,jBean.getPassword());pre.setString(3,jBean.getSex());pre.setInt(4,jBean.getAge());count=pre.executeUpdate();}catchcatchcatchcatch(SQLExceptione){e.printStackTrace();}finallyfinallyfinallyfinally{trytrytrytry{pre.close();con.close();}catchcatchcatchcatch(SQLExceptione){//TODOTODOTODOTODOAuto-generatedcatchblocke.printStackTrace();}}returnreturnreturnreturncount;}/***@author@author@author@authorhelp**删除一条记录*@return@return@return@return*/publicpublicpublicpublicintintintintgetDelete(Stringsql,intintintintid){intintintintcount=0;trytrytrytry{pre=con.prepareStatement(sql);pre.setInt(1,id);count=pre.executeUpdate();}catchcatchcatchcatch(SQLExceptione){e.printStackTrace();}finallyfinallyfinallyfinally{trytrytrytry{pre.close();con.close();}catchcatchcatchcatch(SQLExceptione){//TODOTODOTODOTODOAuto-generatedcatchblocke.printStackTrace();}}returnreturnreturnreturncount;}/***@author@author@author@authorhelp**根据ID查询某一条记录*@return@return@return@return*/publicpublicpublicpublicJavaBeangetSearchById(Stringsql,intintintintid){JavaBeanjBean=newnewnewnewJavaBean();trytrytrytry{pre=con.prepareStatement(sql);pre.setInt(1,id);rs=pre.executeQuery();whilewhilewhilewhile(rs.next()){jBean.setId(rs.getInt(id));jBean.setName(rs.getString(name));jBean.setPassword(rs.getString(password));jBean.setSex(rs.getString(sex));jBean.setAge(rs.getInt(age));}}catchcatchcatchcatch(SQLExceptione){e.printStackTrace();}returnreturnreturnreturnjBean;}/***@author@author@author@authorhelp**更新某一条记录*@return@return@return@return*/publicpublicpublicpublicintintintintgetUpdate(Stringsql,JavaBeanjBean){intintintintcount=0;trytrytrytry{pre=con.prepareStatement(sql);pre.setInt(5,jBean.getId());pre.setString(1,jBean.getName());pre.setString(2,jBean.getPassword());pre.setString(3,jBean.getSex());pre.setInt(4,jBean.getAge());count=pre.executeUpdate();}catchcatchcatchcatch(SQLExceptione){//TODOTODOTODOTODOAuto-generatedcatchblocke.printStackTrace();}finallyfinallyfinallyfinally{trytrytrytry{pre.close();con.close();}catchcatchcatchcatch(SQLExceptione){//TODOTODOTODOTODOAuto-generatedcatchblocke.printStackTrace();}}returnreturnreturnreturncount;}/***@author@author@author@authorhelp**显示所有记录*@return@return@return@return*/publicpublicpublicpublicListgetSearch(Stringsql){Listlist=newnewnewnewArrayList();//获取prepareStatement对象trytrytrytry{pre=con.prepareStatement(sql);rs=pre.executeQuery();whilewhilewhilewhile(rs.next()){JavaBeanjBean=newnewnewnewJavaBean();jBean.setId(rs.getInt(id));jBean.setName(rs.getString(name));jBean.setPassword(rs.getString(password));jBean.setSex(rs.ge