【Jsp精品源码栏目提醒】:网学会员--在 Jsp精品源码编辑为广大网友搜集整理了:Servlet实现增删改查功能 - 其它资料绩等信息,祝愿广大网友取得需要的信息,参考学习。
MVC 模式 M:Model,即模型,对于 JavaBean V:View, 即试图,对应
JSP 页面 C:Controller,即控制器,对应 Servlet 1. 以下为 MVC 实现一个简单的 增删改查 功能1gt 显示记录2gt 增加一条记录3gt 修改一条记录4gt 删除一条记录程序源代码:M 层:模型层1.封装一条信息的所有属性 JavaBean.java ,即 VOpackage muta.bean/ author help 封装一条信息的所有属性 /public class JavaBean private int id private String name private String password private String sex private int age public int getId return id public void setIdint id this.id id public String getName return name public void setNameString name this.name name public String getPassword return password public void setPasswordString password this.password password public String getSex return sex public void setSexString sex this.sex sex public int getAge return age public void setAgeint age this.age age 2.封装数据库连接以及操作 JavaBean 所用到的方法,即 DAOpackage muta.beanimport java.sql.Connectionimport java.sql.DriverManagerimport java.sql.PreparedStatementimport java.sql.ResultSetimport java.sql.SQLExceptionimport java.util.ArrayListimport java.util.List/ author help 操作数据库的方法 /public class SqlBean Connection con PreparedStatement pre ResultSet rs public SqlBean try Class.forNamequotcom.mysql.jdbc.Driverquot catch ClassNotFoundException e e.printStackTrace try conDriverManager.getConnectionquotjdbc:mysql://127.0.0.1:3306/MyServletquotquotrootquotquot122828quot catch SQLException e e.printStackTrace / author help 插入新的一条记录 return / public int getInsertString sqlJavaBean jBean int count 0 try pre con.prepareStatementsql pre.setString1jBean.getName pre.setString2jBean.getPassword pre.setString3jBean.getSex pre.setInt4jBean.getAge countpre.executeUpdate catch SQLException e e.printStackTrace finally try pre.close con.close catch SQLException e // TODO Auto-generated catch block e.printStackTrace return count/ author help 删除一条记录 return /public int getDeleteString sqlint id int count 0 try pre con.prepareStatementsql pre.setInt1 id countpre.executeUpdate catch SQLException e e.printStackTrace finally try pre.close con.close catch SQLException e // TODO Auto-generated catch block e.printStackTrace return count/ author help 根据ID查询某一条记录 return /public JavaBean getSearchByIdString sqlint id JavaBean jBean new JavaBean try pre con.prepareStatementsql pre.setInt1 id rspre.executeQuery whilers.next jBean.setIdrs.getIntquotidquot jBean.setNamers.getStringquotnamequot jBean.setPasswordrs.getStringquotpasswordquot jBean.setSexrs.getStringquotsexquot jBean.setAgers.getIntquotagequot catch SQLException e e.printStackTrace return jBean/ author help 更新某一条记录 return /public int getUpdateString sqlJavaBean jBean int count 0 try pre con.prepareStatementsql pre.setInt5jBean.getId pre.setString1jBean.getName pre.setString2jBean.getPassword pre.setString3jBean.getSex pre.setInt4jBean.getAge count pre.executeUpdate catch SQLException e // TODO Auto-generated catch block e.printStackTrace finally try pre.close con.close catch SQLException e // TODO Auto-generated catch block e.printStackTrace return count/ author help 显示所有记录 return /public List getSearchString sql List list new ArrayList //获取prepareStatement对象 try pre con.prepareStatementsql rs pre.executeQuery whilers.next JavaBean jBean new JavaBean jBean.setIdrs.getIntquotidquot jBean.setNamers.getStringquotnamequot jBean.setPasswordrs.getStringquotpasswordquot jBean.setSexrs.getStringquotsexquot jBean.setAgers.getIntquotagequot list.addjBean catch SQLException e // TODO Auto-generated catch block e.printStackTrace finally try pre.close con.close catch SQLException e // TODO Auto-generated catch block e.printStackTrace return list V 层:试图层 1. 显示记录集的页面 SearchList.
jsp lt page languagequotjavaquot importquotjava.util.quot pageEncodingquotUTF-8quotgt lt String path request.getContextPath String basePath request.getSchemequot://quotrequest.getServerNamequot:quotrequest.getServerPortpathquot/quot gt ltDOCTYPE HTML PUBLIC quot-//W3C//DTD HTML 4.01 Transitional//ENquotgt lthtmlgt ltheadgt ltmeta http-equivquotContent-Typequot contentquottext/html charsetUTF-8quotgt lttitlegt显示记录lt/titlegt lt/headgt ltbodygt ltcenter gt ltfont colorred size72gt学生信息如下:lt/fontgt lthrgt lttable border1 bgColorquotffffffquot widthquot500pxquot heightquot100pxquotgt lttrgt lttdgtIDlt/tdgtlttdgt姓名lt/tdgtlttdgt密码lt/tdgtlttdgt性别lt/tdgtlttdgt年龄lt/tdgtlttdgtltcentergt操作lt/centergtlt/tdgtlt/trgtltjsp:useBean idquotsBeanquotclassquotmuta.bean.SqlBeanquot/gtltjsp:useBean idquotjBeanquot classquotmuta.bean.JavaBeanquot/gtlt String sql quotselect from student order by idquot java.util.List list sBean.getSearchsql forjava.util.Iterator it list.iteratorit.hasNext //获取一个JavaBean对象 jBean muta.bean.JavaBeanit.next gt lttrgt lttdgtltjBean.getId gtlt/tdgt lttdgtltjBean.getName gtlt/tdgt lttdgtltjBean.getPassword gtlt/tdgt lttdgtltjBean.getSex gtlt/tdgt lttdgtltjBean.getAge gtlt/tdgt lttdgt lta hrefquotInsert.jspquotgt增加lt/agt lta hrefquotDeleteidltjBean.getIdgtquotgt删除lt/agtampnbsp lta hrefquotSearchByIdidltjBean.getIdgtquotgt更新lt/agt lt/tdgt lt/trgt lt gtlt/tablegtlt/centergtlt/bodygtlt/htmlgt2. 插入页面 Insert.jsplt page languagequotjavaquot importquotjava.util.quot pageEncodingquotUTF-8quotgtltString path request.getContextPathString basePath request.getSchemequot://quotrequest.getServerNamequot:quotrequest.getServerPortpathquot/quotgtltDOCTYPE HTML PUBLIC quot-//W3C//DTD HTML 4.01 Transitional//ENquotgtlthtmlgtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetUTF-8quotgtlttitlegt插入新值lt/titlegtlt/headgtltbodygtltcenter gtltfont colorred size72gt学生管理页面lt/fontgtlthrgtltform actionquotInsertquot methodquotpostquotgtlttable borderquot1quotgtlttrgtlttdgt姓名:lt/tdgtlttdgtltinput name quotnamequotgtlt/tdgtlt/trgtlttrgtlttdgt密码:lt/tdgtlttdgtltinput typequotpasswordquot name quotpasswordquotgtlt/tdgtlt/trgtlttrgtlttdgt性别:lt/tdgtlttdgtltinput typequotradioquot name quotsexquot valuequot男quotgt男 ltinput typequotradioquot name quotsexquot valuequot女quotgt女lt/tdgtlt/trgtlttrgtlttdgt年龄:lt/tdgtlttdgtltinput typequottextquot name quotagequotgtlt/tdgtlt/trgtlttrgtlttd colspanquot2quotgtltcentergtltinput typequotsubmitquot valuequot提交quotgtltinput typequotresetquot valuequot重置quotgtlt/centergtlt/tdgtlt/trgtlt/tablegtlt/formgtlta hrefquotSearchList.jspquotgt查询lt/agt lt/centergtlt/bodygtlt/htmlgt3. 更新页面 Update.jsplt page languagequotjavaquot importquotjava.util.quot pageEncodingquotUTF-8quotgtltString path request.getContextPathString basePath request.getSchemequot://quotrequest.getServerNamequot:quotrequest.getServerPortpathquot/quotgtltDOCTYPE HTML PUBLIC quot-//W3C//DTD HTML 4.01 Transitional//ENquotgtlthtmlgtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetUTF-8quotgtlttitlegt更新lt/titlegtlt/headgtltbodygtltcentergtltfont colorred size72gt学生管理页面lt/fontgtlthrgtltform actionquotUpdatequot methodquotpostquotquotgtlttable borderquot1quotgtlttrgtlttdgt学生ID:lt/tdgtlttdgtltinput namequotidquot valuequotltrequest.getAttributequotidquot gtquot readonlygtlt/tdgtlt/trgtlttrgtlttdgt学生姓名:lt/tdgtlttdgtltinput namequotnamequot valuequotltrequest.getAttributequotnamequot gtquot gtlt/tdgtlt/trgtlttrgtlttdgt学生密码:lt/tdgtlttdgtltinput typequotpasswordquot namequotpasswordquot valuequotltrequest.getAttributequotpasswordquot gtquotgtlt/tdgtlt/trgtlttrgtlttdgt学生性别:lt/tdgtlttdgtltinput typequotradioquot name quotsexquot valuequot男quotltrequest.getAttributequotmanquot gtgt男 ltinput typequotradioquot name quotsexquot valuequot女quotltrequest.getAttributequotwomanquot gtgt女 lt/tdgtlt/trgtlttrgtlttdgt学生年龄:lt/tdgtlttdgtltinput typequottextquot namequotagequot valuequotltrequest.getAttributequotagequot gtquot gtlt/tdgtlt/trgtlttrgtlttd colspanquot2quotgt ltcentergt ltinput typequotsubmitquot valuequot提交quotgt ltinput typequotresetquot valuequot重置quotgtlt/centergtlt/tdgtlt/trgtlt/tablegtlt/formgtlta hrefquotSearchList.jspquotgt查询lt/agtlt/centergtlt/bodygtlt/htmlgt4. 出错页面 Error.jsplt page languagequotjavaquot importquotjava.util.quot pageEncodingquotUTF-8quotgtltString path request.getContextPathString basePath request.getSchemequot://quotrequest.getServerNamequot:quotrequest.getServerPortpathquot/quotgtltDOCTYPE HTML PUBLIC quot-//W3C//DTD HTML 4.01 Transitional//ENquotgtlthtmlgtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetUTF-8quotgtlttitlegt出错啦!!!lt/titlegtlt/headgtltbodygt 对不起!您ltrequest.getAttributequoterrorquot gt失败lt/bodygtlt/htmlgtC 层:控制层—Servlet1.显示记录集的 Servlet----SearchById.javapackage muta.servletimport java.io.IOExceptionimport javax.servlet.ServletExceptionimport javax.servlet.http.HttpServletimport javax.servlet.http.HttpServletRequestimport javax.servlet.http.HttpServletResponseimport muta.bean.JavaBeanimport muta.bean.SqlBeanpublic class SearchById extends HttpServlet private static final long serialVersionUID 1L public void doGetHttpServletRequest request HttpServletResponse response throws ServletException IOException doPostrequestresponse public void doPostHttpServletRequest request HttpServletResponse response throws ServletException IOException response.setContentTypequottext/htmlquot request.setCharacterEncodingquotutf-8quot response.setCharacterEncodingquotutf-8quot //获取用户ID String sid request.getParameterquotidquot int id Integer.parseIntsid String sql quotselect from student where idquot SqlBean sBean new SqlBean JavaBean jBean sBean.getSearchByIdsql id //用户ID request.setAttributequotidquotjBean.getId //用户姓名 request.setAttributequotnamequotjBean.getName //用户密码 request.setAttributequotpasswordquotjBean.getPassword //用户性别 String sexquotquot String manquotquot String womanquotquot ifjBean.getSexnull sexjBean.getSex.trim ifsex.equalsquot男quot man quotcheckedquot else woman quotcheckedquot request.setAttributequotmanquotman request.setAttributequotwomanquotwoman //用户年龄 request.setAttributequotagequotjBean.getAge //转发 request.getRequestDispatcherquotUpdate.jspquot.forwardrequest response 2.增加记录的 Servlet----Insert.javapackage muta.servletimport java.io.IOExceptionimport javax.servlet.ServletExceptionimport javax.servlet.http.HttpServletimport javax.servlet.http.HttpServletRequestimport javax.servlet.http.HttpServletResponseimport muta.bean.SqlBeanimport muta.bean.JavaBeanpublic class Insert extends HttpServlet private static final long serialVersionUID 1L public void doGetHttpServletRequest request HttpServletResponse response throws ServletException IOException response.setContentTypequottext/htmlquot doPostrequestresponse public void doPostHttpServletRequest request HttpServletResponse response throws ServletException IOException response.setContentTypequottext/htmlquot request.setCharacterEncodingquotutf-8quot response.setCharacterEncodingquotutf-8quot //获取前台页面数据 String name request.getParameterquotnamequot String password request.getParameterquotpasswordquot String sex request.getParameterquotsexquot String sage request.getParameterquotagequot int age Integer.parseIntsage //封装到JavaBean对象中去 JavaBean jBean new JavaBean jBean.setNamename jBean.setPasswordpassword jBean.setSexsex jBean.setAgeage //调用模型层 String sql quotinsert into studentnamepasswordsexage valuesquot SqlBean sBean new SqlBean int count sBean.getInsertsqljBean String urlquotquot ifcountgt0 urlquotSearchList.jspquot else url quoterror.jspquot request.setAttributequoterrorquot quotquot //转发 request.getRequestDispatcherquotSearchList.jspquot.forwardrequest response 3.更新记录的 Servlet----Updated.javapackage muta.servletimport java.io.IOExceptionimport java.io.PrintWriterimport javax.servlet.ServletExceptionimport javax.servlet.http.HttpServletimport javax.servlet.http.HttpServletRequestimport javax.servlet.http.HttpServletResponseimport muta.bean.JavaBeanimport muta.bean.SqlBeanpublic class Update extends HttpServlet private static final long serialVersionUID 1L public void doGetHttpServletRequest request HttpServletResponse response throws ServletException IOException doPostrequestresponse public void doPostHttpServletRequest request HttpServletResponse response throws ServletException IOException response.setContentTypequottext/htmlquot request.setCharacterEncodingquotutf-8quot response.setCharacterEncodingquotutf-8quot //获得前台表单信息 String sid request.getParameterquotidquot int id Integer.parseIntsid String name request.getParameterquotnamequot String password request.getParameterquotpasswordquot String sex request.getParameterquotsexquot String sage request.getParameterquotagequot int age Integer.parseIntsage //.
上一篇:
(精品)【毕业论文 毕业设计】招聘管理系统的设计
下一篇:
告别一段感情