在eclipse里基于SSH實現增刪改查源代碼_第1頁
在eclipse里基于SSH實現增刪改查源代碼_第2頁
在eclipse里基于SSH實現增刪改查源代碼_第3頁
在eclipse里基于SSH實現增刪改查源代碼_第4頁
在eclipse里基于SSH實現增刪改查源代碼_第5頁
已閱讀5頁，還剩22頁未讀， 繼續免費閱讀

下載本文檔

版權說明：本文檔由用戶提供并上傳，收益歸屬內容提供方，若內容存在侵權，請進行舉報或認領

文檔簡介

sshdemo修改版：將原有的sshdemo簡化，這是在eclipse里，基于SSH框架實現增刪改查的源代碼，四個功能全部實現；已經測試過。addstudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><!--<LINKhref="css/admin.css"type="text/css"rel="stylesheet">--><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>注冊</title></head><body><tableclass="position"> <trclass="position"> <tdclass="position">學生信息</td> </tr></table><s:formaction="addStudent"><table> <tr> <td>姓名</td> <td><inputtype="text"name="sname"/></td> </tr> <tr> <td>性別</td> <td><inputtype="radio"name="sex"checkedvalue='男'/>男  <inputtype="radio"name="sex"value='女'>女</td> </tr> <tr> <td>學號</td> <td><inputtype="text"name="sno"/></td> </tr> <tr> <td>年齡</td> <td><inputtype="text"name="age"/></td> </tr> <tr> <td>專業</td> <td><inputtype="text"name="pro"/></td> </tr> <tralign="center"> <tdcolspan="2"> <inputtype="submit"value="添加"/>  <inputtype="reset"/> </td> </tr></table></s:form></body></html>deletestudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>Inserttitlehere</title></head><body><h1>刪除成功</h1></body></html>editstudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><!--<LINKhref="css/admin.css"type="text/css"rel="stylesheet">--><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>修改</title></head><body><tableclass="position"> <trclass="position"> <tdclass="position">學生信息</td> </tr></table><s:formaction="editStudent"> <inputtype="hidden"name='sid'value=<s:propertyvalue="student.sid"/>> <tableclass="editTable"border="1"align="center"width="70%"> <trclass="editTr"> <tdclass="editLeftTd">姓名</td> <tdclass="editRightTd"><inputtype="text"name='sname'value=<s:propertyvalue="student.sname"/>></input></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">性別</td> <tdclass="editRightTd"><inputtype="text"name='sex'value=<s:propertyvalue="student.sex"/>></input></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">學號</td> <tdclass="editRightTd"><inputtype="text"name='sno'value=<s:propertyvalue="student.sno"/>></input></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">年齡</td> <tdclass="editRightTd"><inputtype="text"name='age'value=<s:propertyvalue="student.age"/>></input></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">專業</td> <tdclass="editRightTd"><inputtype="text"name='pro'value=<s:propertyvalue=""/>></input></td> </tr> <trclass="editFooterTr"> <tdclass="editFooterTd"colspan="2"> <inputtype="submit"value="保存"/> <inputtype="reset"value="重置"> </td> </tr> </table></s:form> </body></html>saveeditstudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>Inserttitlehere</title></head><body><h1>用戶<s:textname="sname"></s:text>修改成功</h1><ahref="searchstudent.jsp">返回</a></body></html>savestudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>Inserttitlehere</title></head><body><h1>用戶<s:textname="sname"></s:text>添加成功</h1><ahref="searchstudent.jsp">返回</a></body></html>searchstudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><!--<LINKhref="css/admin.css"type="text/css"rel="stylesheet">--><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>查詢</title></head><scripttype="text/javascript">functiondel(){if(confirm("確定刪除該記錄嗎")){returntrue;}returnfalse;}</script><body><tableclass="position"> <trclass="position"> <tdclass="position">查詢</td> </tr></table><s:formaction="searchStudent"> <inputtype="hidden"name="type"value=""> <table> <tr> <td>姓名</td> <td><inputtype="text"name="sname"></td> </tr> <tr> <td>學號</td> <td><inputtype="text"name="sno"></td> </tr> <tr> <tdcolspan="2"align="center"> <inputtype="submit"value="查詢"> <inputtype="reset"value="重置"> </td> </tr> </table></s:form><hr><tableclass="position"> <trclass="position"> <tdclass="position">查詢結果</td> </tr></table><tableclass="listTable"border="1"align="center"width="70%"> <trclass="listHeaderTr"> <td>姓名</td> <td>性別</td> <td>學號</td> <td>年齡</td> <td>專業</td> <td>操作</td> <tr> <s:iteratorvalue="students"status="stat"> <trclass="listTr"> <td><s:propertyvalue="sname"/></td> <td><s:propertyvalue="sex"/></td> <td><s:propertyvalue="sno"/></td> <td><s:propertyvalue="age"/></td> <td><s:propertyvalue="pro"/></td> <td> <ahref="showStudent.action?sid=<s:propertyvalue="sid"/>&type=show">查看詳情</a> <ahref="showStudent.action?sid=<s:propertyvalue="sid"/>&type=update">修改</a> <ahref='deleteStudent.action?sid=<s:propertyvalue="sid"/>'onclick="returndel()">刪除</a> <ahref="addstudent.jsp">添加</a> </td> </tr> </s:iterator></table></body></html>showstudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><%@taglibprefix="s"uri="/struts-tags"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><!--<LINKhref="css/admin.css"type="text/css"rel="stylesheet">--><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>注冊</title></head><body><tableclass="position"> <trclass="position"> <tdclass="position">學生信息</td> </tr></table><tableclass="editTable"border="1"align="center"width="70%"> <trclass="editTr"> <tdclass="editLeftTd">姓名</td> <tdclass="editRightTd"><s:propertyvalue="student.sname"/></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">性別</td> <tdclass="editRightTd"><s:propertyvalue="student.sex"/></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">學號</td> <tdclass="editRightTd"><s:propertyvalue="student.sno"/></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">年齡</td> <tdclass="editRightTd"><s:propertyvalue="student.age"/></td> </tr> <trclass="editTr"> <tdclass="editLeftTd">專業</td> <tdclass="editRightTd"><s:propertyvalue=""/></td> </tr> <trclass="editFooterTr"> <tdclass="editFooterTd"colspan="2"> <inputtype="button"value="返回"onclick="javascript:history.back();"/> </td> </tr></table></body></html>updatestudent.jsp<%@pagelanguage="java"contentType="text/html;charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""/TR/html4/loose.dtd"><html><head><metahttp-equiv="Content-Type"content="text/html;charset=UTF-8"><title>Inserttitlehere</title></head><body><h1>用戶保存成功</h1></html>下面四個.xml文件路徑：WebContent/WEB-INF/applicationContext.xml<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-2.0.xsd"> <importresource="datasource.xml"/> <importresource="student.xml"/> </beans>datasource.xml<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="/schema/beans" xmlns:xsi="/2001/XMLSchema-instance" xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-2.0.xsd"><beanid="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <propertyname="driverClass"> <value>com.mysql.jdbc.Driver</value> </property> <propertyname="jdbcUrl"> <value>jdbc:mysql://:3306/root</value> </property> <propertyname="user"> <value>root</value> </property> <propertyname="password"> <value>root</value> </property> <propertyname="minPoolSize"> <value>5</value> </property> <propertyname="maxPoolSize"> <value>40</value> </property> </bean> <beanid="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" destroy-method="close"> <propertyname="dataSource"> <refbean="dataSource"/> </property> <propertyname="mappingResources"> <list> <value> ssh/demo/dao/model/Student.hbm.xml </value> </list> </property> <propertyname="hibernateProperties"> <props> <propkey="hibernate.dialect"> org.hibernate.dialect.MySQL5Dialect </prop> <propkey="hibernate.show_sql">false</prop> </props> </property> </bean></beans>student.xml<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-2.0.xsd"> <beanid="addStudentAction"class="ssh.demo.action.AddStudentAction"scope="prototype"> <propertyname="studentDAO"> <refbean="studentDAO"/> </property></bean><beanid="searchStudentAction"class="ssh.demo.action.SearchStudentAction"scope="prototype"> <propertyname="studentDAO"> <refbean="studentDAO"/> </property></bean><beanid="showStudentAction"class="ssh.demo.action.ShowStudentAction"scope="prototype"> <propertyname="studentDAO"> <refbean="studentDAO"/> </property></bean><beanid="deleteStudentAction"class="ssh.demo.action.DeleteStudentAction"scope="prototype"> <propertyname="studentDAO"> <refbean="studentDAO"/> </property></bean><beanid="editStudentAction"class="ssh.demo.action.EditStudentAction"scope="prototype"> <propertyname="studentDAO"> <refbean="studentDAO"/> </property></bean><beanid="studentDAO"class="ssh.demo.dao.impl.StudentDAO"> <propertyname="sessionFactory"> <refbean="sessionFactory"/> </property></bean></beans>web.xml<?xmlversion="1.0"encoding="UTF-8"?><web-appid="WebApp_9"version="2.4"xmlns="/xml/ns/j2ee"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/j2ee/xml/ns/j2ee/web-app_2_4.xsd"><display-name>StrutsBlank</display-name><filter><filter-name>struts2</filter-name><filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class></filter><filter-mapping><filter-name>struts2</filter-name><url-pattern>/*</url-pattern></filter-mapping><welcome-file-list><welcome-file>index.html</welcome-file></welcome-file-list><listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener></web-app>ssh.demo.actionAddStudentAction.javapackagessh.demo.action;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;importcom.opensymphony.xwork2.ActionSupport;publicclassAddStudentActionextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateStringsname; privateStringsex; privateStringsno; privateintage; privateStringpro; privateIStudentDAOstudentDAO; publicIStudentDAOgetStudentDAO(){ returnstudentDAO; } publicvoidsetStudentDAO(IStudentDAOstudentDAO){ this.studentDAO=studentDAO; } publicStringgetSname(){ returnsname; } publicvoidsetSname(Stringsname){ this.sname=sname; } publicStringgetSex(){ returnsex; } publicvoidsetSex(Stringsex){ this.sex=sex; } publicStringgetSno(){ returnsno; } publicvoidsetSno(Stringsno){ this.sno=sno; } publicintgetAge(){ returnage; } publicvoidsetAge(intage){ this.age=age; } publicStringgetPro(){ returnpro; } publicvoidsetPro(Stringpro){ =pro; } @Override publicStringexecute()throwsException{ Studentstudent=newStudent(); student.setSname(sname); student.setSex(sex); student.setAge(age); student.setSno(sno); student.setPro(pro); student=studentDAO.saveStudent(student); //intsid=student.getSid(); //System.out.println("sid="+sid); returnSUCCESS; }}DeleteStudentAction.javapackagessh.demo.action;importjava.util.List;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;importcom.opensymphony.xwork2.ActionSupport;publicclassDeleteStudentActionextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateintsid; privateStringtype; privateStudentstudent; privateIStudentDAOstudentDAO; privateList<Student>students; publicStringgetType(){ returntype; } publicvoidsetType(Stringtype){ this.type=type; } publicIStudentDAOgetStudentDAO(){ returnstudentDAO; } publicvoidsetStudentDAO(IStudentDAOstudentDAO){ this.studentDAO=studentDAO; } publicintgetSid(){ returnsid; } publicvoidsetSid(intsid){ this.sid=sid; } publicStudentgetStudent(){ returnstudent; } publicvoidsetStudent(Studentstudent){ this.student=student; } publicList<Student>getStudents(){ returnstudents; } publicvoidsetStudents(List<Student>students){ this.students=students; } @Override publicStringexecute()throwsException{ //TODOAuto-generatedmethodstub student=studentDAO.load(sid); studentDAO.deleteStudent(sid); students=studentDAO.findAllStudent(); returnSUCCESS; }}EditStudentAction.javapackagessh.demo.action;importcom.opensymphony.xwork2.ActionSupport;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;publicclassEditStudentActionextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateintsid; privateStringsname; privateStringsex; privateStringsno; privateintage; privateStringpro; privateIStudentDAOstudentDAO; publicIStudentDAOgetStudentDAO(){ returnstudentDAO; } publicvoidsetStudentDAO(IStudentDAOstudentDAO){ this.studentDAO=studentDAO; } publicintgetSid(){ returnsid; } publicvoidsetSid(intsid){ this.sid=sid; } publicStringgetSname(){ returnsname; } publicvoidsetSname(Stringsname){ this.sname=sname; } publicStringgetSex(){ returnsex; } publicvoidsetSex(Stringsex){ this.sex=sex; } publicStringgetSno(){ returnsno; } publicvoidsetSno(Stringsno){ this.sno=sno; } publicintgetAge(){ returnage; } publicvoidsetAge(intage){ this.age=age; } publicStringgetPro(){ returnpro; } publicvoidsetPro(Stringpro){ =pro; } @Override publicStringexecute()throwsException{ Studentstudent=newStudent(); student.setSid(sid); student.setSname(sname); student.setSex(sex); student.setAge(age); student.setSno(sno); student.setPro(pro); studentDAO.editStudent(student); returnSUCCESS; }}SearchStudentAction.javapackagessh.demo.action;importjava.util.List;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;importcom.opensymphony.xwork2.ActionSupport;publicclassSearchStudentActionextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateStringsname; privateStringsno; privateList<Student>students; privateStringtype; privateIStudentDAOstudentDAO; publicStringgetSname(){ returnsname; } publicvoidsetSname(Stringsname){ this.sname=sname; } publicStringgetSno(){ returnsno; } publicvoidsetSno(Stringsno){ this.sno=sno; } publicList<Student>getStudents(){ returnstudents; } publicvoidsetStudents(List<Student>students){ this.students=students; } publicIStudentDAOgetStudentDAO(){ returnstudentDAO; } publicvoidsetStudentDAO(IStudentDAOstudentDAO){ this.studentDAO=studentDAO; } publicStringgetType(){ returntype; } publicvoidsetType(Stringtype){ this.type=type; } @Override publicStringexecute()throwsException{ if(sname==null&&sno==null){ students=studentDAO.findAllStudent(); }else{ Studentexample=newStudent(); if(!sname.trim().equals("")){ example.setSname(sname); } if(!sno.trim().equals("")){ example.setSno(sno); } students=studentDAO.findStudent(example); } returnINPUT; }}ShowStudentAction.javapackagessh.demo.action;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;importcom.opensymphony.xwork2.ActionSupport;publicclassShowStudentActionextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateintsid; privateStringtype; privateStudentstudent; privateIStudentDAOstudentDAO; publicStringgetType(){ returntype; } publicvoidsetType(Stringtype){ this.type=type; } publicIStudentDAOgetStudentDAO(){ returnstudentDAO; } publicvoidsetStudentDAO(IStudentDAOstudentDAO){ this.studentDAO=studentDAO; } publicintgetSid(){ returnsid; } publicvoidsetSid(intsid){ this.sid=sid; } publicStudentgetStudent(){ returnstudent; } publicvoidsetStudent(Studentstudent){ this.student=student; } @Override /*publicStringexecute()throwsException{ student=studentDAO.load(sid); if(type.equals("show")){ returnSUCCESS; } elseif(type.equals("update")){ returnERROR; } else{ returnINPUT; } }*/ publicStringexecute()throwsException{ student=studentDAO.load(sid); if(type.equals("show")){ returnSUCCESS; } elseif(type.equals("update")){ returnERROR; } else{ returnINPUT; } } }UpdateStudentAction.javapackagessh.demo.action;importssh.demo.dao.model.Student;importcom.opensymphony.xwork2.ActionSupport;publicclassUpdateStudentActioniextendsActionSupport{ /** * */ privatestaticfinallongserialVersionUID=1L; privateintsid; privateStudentstudent; publicintgetSid(){ returnsid; } publicvoidsetSid(intsid){ this.sid=sid; } publicStudentgetStudent(){ returnstudent; } publicvoidsetStudent(Studentstudent){ this.student=student; } @Override publicStringexecute()throwsException{ //TODOAuto-generatedmethodstub returnsuper.execute(); }}ssh.demo.daoIStudentDAO.javapackagessh.demo.dao;importjava.util.List;importssh.demo.dao.model.Student;publicinterfaceIStudentDAO{ publicStudentsaveStudent(Studentstudent); publicList<Student>findAllStudent(); publicList<Student>findStudent(Studentstudent); publicStudentload(intid); publicintdeleteStudent(intsid); publicinteditStudent(Studentstudent);}ssh.demo.dao.implStudentDAO.javapackagessh.demo.dao.impl;importjava.util.List;importjava.util.ResourceBundle;importorg.springframework.orm.hibernate3.support.HibernateDaoSupport;importssh.demo.dao.IStudentDAO;importssh.demo.dao.model.Student;publicclassStudentDAOextendsHibernateDaoSupportimplementsIStudentDAO{ @Override publicStudentsaveStudent(Studentstudent){ getHibernateTemplate().saveOrUpdate(student); returnstudent; } @Override publicList<Student>findAllStudent(){ Stringhql="fromStudent"; List<Student>res=getHibernateTemplate().find(hql); returnres; } @Override publicList<Student>findStudent(Studentstudent){ //TODOAuto-generatedmethodstub List<Student>

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯系上傳者。文件的所有權益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網頁內容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
  • 4. 未經權益所有人同意不得將文件中的內容挪作商業或盈利用途。
  • 5. 人人文庫網僅提供信息存儲空間，僅對用戶上傳內容的表現方式做保護處理，對用戶上傳分享的文檔內容本身不做任何修改或編輯，并不能對任何下載內容負責。
  • 6. 下載文件中如有侵權或不適當內容，請與我們聯系，我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論