问题描述
struts.xml<?xmlversion="1.0"encoding="UTF-8"?><!DOCTYPEstrutsPUBLIC"-//ApacheSoftwareFoundation//DTDStrutsConfiguration2.0//EN""http://struts.apache.org/dtds/struts-2.0.dtd"><struts><packagename="struts2"extends="struts-default"><actionname="add"class="com.SH2.Person"><resultname="success">/Success.jsp</result></action><actionname="Login"class="com.SH2.Person"method="Login"><resultname="success">/Wel.jsp</result><resultname="input">/Fail.jsp</result></action><actionname="Del"class="com.SH2.Person"method="delect"><resultname="success">/Del.jsp</result><resultname="input">/Fail1.jsp</result></action><actionname="Update"class="com.SH2.Person"method="Update"><resultname="success">/Login.jsp</result></action></package></struts>Peoson.javapackagecom.SH2;importjava.util.List;importjavax.servlet.http.HttpServletRequest;importorg.apache.struts2.ServletActionContext;importcom.SH.People;importcom.SH3.Update;importcom.opensymphony.xwork2.ActionContext;importcom.opensymphony.xwork2.ActionSupport;publicclassPersonextendsActionSupport{privateintPageCount;publicintgetPageCount(){returnPageCount;}publicvoidsetPageCount(intpageCount){PageCount=pageCount;}privateintpageSize=3;publicintgetPageSize(){returnpageSize;}publicvoidsetPageSize(intpageSize){this.pageSize=pageSize;}publicListgetList(){returnlist;}publicvoidsetList(Listlist){this.list=list;}privateListlist;privateintpageNow=1;publicintgetPageNow(){returnpageNow;}publicvoidsetPageNow(intpageNow){this.pageNow=pageNow;}privateintid;publicintgetId(){returnid;}publicvoidsetId(intid){this.id=id;}publicStringgetUname(){returnuname;}publicvoidsetUname(Stringuname){this.uname=uname;}publicStringgetPassword(){returnpassword;}publicvoidsetPassword(Stringpassword){this.password=password;}publicStringgetRepassword(){returnrepassword;}publicvoidsetRepassword(Stringrepassword){this.repassword=repassword;}privateStringuname;privateStringpassword;privateStringrepassword;@OverridepublicStringexecute()throwsException{Peoplep=newPeople();p.setUname(uname);p.setRepassword(repassword);p.setPassword(password);Update.save(p);returnSUCCESS;}publicStringLogin()throwsException{Updateu=newUpdate();PageCount=u.Count();HttpServletRequestrequest=ServletActionContext.getRequest();Stringpagenow=request.getParameter("pageNow");if(pagenow!=null){pageNow=Integer.parseInt(pagenow);}list=u.find(pageNow,pageSize);ActionContext.getContext().getSession().put("uname",uname);if(u.Login(uname,password)){returnSUCCESS;}returnINPUT;}publicStringdelect(){Update.delete(id);returnSUCCESS;}publicStringUpdate(){Peoplep=Update.Find(id);p.setPassword(password);p.setRepassword(repassword);Update.update(p);returnSUCCESS;}privatePeoplep=newPeople();publicPeoplegetP(){returnp;}publicvoidsetP(Peoplep){this.p=p;}}People.javapackagecom.SH;publicclassPeople{privateintid;publicintgetId(){returnid;}publicvoidsetId(intid){this.id=id;}publicStringgetUname(){returnuname;}publicvoidsetUname(Stringuname){this.uname=uname;}publicStringgetPassword(){returnpassword;}publicvoidsetPassword(Stringpassword){this.password=password;}publicStringgetRepassword(){returnrepassword;}publicvoidsetRepassword(Stringrepassword){this.repassword=repassword;}privateStringuname;privateStringpassword;privateStringrepassword;}People.hbm.xml<?xmlversion="1.0"?><!DOCTYPEhibernate-mappingPUBLIC"-//Hibernate/HibernateMappingDTD3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping><classname="com.SH.People"table="People"><idname="id"column="ID_"><generatorclass="native"/></id><propertyname="uname"/><propertyname="password"/><propertyname="repassword"></property></class></hibernate-mapping>Update.javapackagecom.SH3;mportjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.Listimportorg.hibernate.Query;importorg.hibernate.Session;importorg.hibernate.SessionFactory;importorg.hibernate.Transaction;importorg.hibernate.cfg.Configuration;importcom.SH.People;importcom.SH4.ConnOB;publicclassUpdate{privateintpageSize=3;privateintrowCount=0;privateintpageCount=0;privateConnectionct=null;privatePreparedStatementps=null;privateResultSetrs=null;publicstaticvoidsave(Peoplep){Configurationc=newConfiguration();c.configure();SessionFactoryf=c.buildSessionFactory();Sessionsession=f.getCurrentSession();Transactionr=session.beginTransaction();session.save(p);r.commit();}publicbooleanLogin(Stringuname,Stringpassword){booleanb=false;try{ct=newConnOB().getconn();ps=ct.prepareStatement("selectpasswordfromPeoplewhereuname='"+uname+"'");rs=ps.executeQuery();if(rs.next()){Stringp=rs.getString(1);if(p.equals(password)){b=true;}}}catch(Exceptione){e.printStackTrace();}returnb;}@SuppressWarnings("unchecked")publicListfind(intpageNow,intpageSize){Configurationc=newConfiguration();c.configure();SessionFactoryf=c.buildSessionFactory();Sessionsession=f.getCurrentSession();@SuppressWarnings("unused")Transactionr=session.beginTransaction();Listlist=session.createQuery("fromPeople").setFirstResult((pageNow-1)*pageSize).setMaxResults(pageSize).list();session.close();returnlist;}publicstaticvoiddelete(intid){Configurationc=newConfiguration();c.configure();SessionFactoryf=c.buildSessionFactory();Sessionsession=f.getCurrentSession();Transactionr=session.beginTransaction();Peoplep=(People)session.get(People.class,id);session.delete(p);r.commit();}publicstaticvoidupdate(Peoplep){Configurationc=newConfiguration();c.configure();SessionFactoryf=c.buildSessionFactory();Sessionsession=f.getCurrentSession();Transactionr=session.beginTransaction();session.update(p);r.commit();}publicstaticPeopleFind(intid){Peoplep=null;Configurationc=newConfiguration();c.configure();SessionFactoryf=c.buildSessionFactory();Sessionsession=f.getCurrentSession();Transactionr=session.beginTransaction();p=(People)session.get(People.class,id);r.commit();returnp;}publicintCount(){try{ct=newConnOB().getconn();ps=ct.prepareStatement("selectcount(*)fromPeople");rs=ps.executeQuery();if(rs.next()){rowCount=rs.getInt(1);}if(rowCount%pageSize==0){pageCount=rowCount/pageSize;}else{pageCount=rowCount/pageSize+1;}}catch(Exceptione){e.printStackTrace();}returnpageCount;}}Login.jsp<html><head></head><body><formaction="Login.action"><table><tr><td>用户名</td><td><inputtype="text"name="uname"/></td></tr><tr><td>密码</td><td><inputtype="password"name="password"/></td></tr></table><inputtype="submit"value="登录"/></form></body></html>Wel.jsp<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%><%@taglibprefix="s"uri="/struts-tags"%><%Stringpath=request.getContextPath();StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN"><html><head></head><body><%Stringu=(String)session.getAttribute("uname");if(u==null){response.sendRedirect("Login.jsp");}%><s:iteratorvalue="list"><tableborder=1><s:urlaction="Del"id="url"><s:paramname="id"value="%{id}"></s:param></s:url><s:urlvalue="Update.jsp"id="ul"><s:paramname="id"value="id"/><s:paramname="uname"value="uname"/><s:paramname="password"value="password"/><s:paramname="repassword"value="repassword"/></s:url><tr><th>用户名</th><th>密码</th><th>再次密码</th><th>删除</th><th>修改</th></tr><tr><td><s:propertyvalue="uname"/></td><td><s:propertyvalue="password"/></td><td><s:propertyvalue="repassword"/></td><td><s:ahref="%{url}">删除</s:a></td><td><s:ahref="%{ul}">编辑</s:a></td></tr></s:iterator></table><s:urlvalue="Login"id="u"><s:paramname="pageNow"value="1"></s:param></s:url><s:urlaction="Login"id="w"><s:paramname="pageNow"value="pageNow-1"></s:param></s:url><s:urlaction="Login"id="e"><s:paramname="pageNow"value="pageNow+1"></s:param></s:url><s:urlid="l"action="Login"><s:paramname="pageNow"value="PageCount"></s:param></s:url><s:ahref="%{u}">首页</s:a><s:ahref="%{i}"></s:a><s:iftest="pageNow!=1"><s:ahref="%{w}">上一页</s:a></s:if><s:iteratorvalue="list"status="status"><s:urlid="uul"action="Login"><s:paramname="pageNow"value="pageNow"/><s:paramname="PageCount"value="PageCount"></s:param></s:url></s:iterator><s:iftest="pageNow!=PageCount"><s:ahref="%{e}">下一页</s:a></s:if><s:ahref="%{l}">末页</s:a></body></html>为什么我的分页查询，显示第二页是错的呢，显示第2页的语句都可以发，重点看下action里的Login方法里的代码