我的SSH项目之旅(7.个人中心之分页和Junit测试)

最新推荐文章于 2026-06-16 22:25:59 发布

最新推荐文章于 2026-06-16 22:25:59 发布 · 126 阅读

标签

#junit #SSH #JSP #Bean #Spring

SSH组合专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一个基于Struts和Hibernate的个人中心分页功能实现方案，涵盖了后端数据查询、Struts Action处理流程及JSP页面展示等内容。

接下来开发个人中心

个人中心包括内容：

1、修改个人信息

2、列出我提出的问题

3、列出我回答过的问题

4、列出被采纳的问题

分页大概的流程从后台DAO去数据

public List queryByItem(int itemid, int currentPage, int lineSize)

throws Exception {

// TODO Auto-generated method stub

List all = null;

String hql = "FROM Question AS q WHERE q.itemid=?";

Query q = super.getSession().createQuery(hql);

q.setInteger(0, itemid);

q.setFirstResult((currentPage - 1) * lineSize);

q.setMaxResults(lineSize);

all = q.list();

return all;

}

经过struts action

public ActionForward selectitem(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response) {

List all = null;

int currentPage = 1;

int lineSize = 10;

int allRecorders = 0;

try {

currentPage = Integer.parseInt(request.getParameter("cp"));

} catch (Exception e) {

}

try {

allRecorders = this.questiondao.getByItemCount(Integer

.parseInt(request.getParameter("itemid")));

all = this.questiondao.queryByItem(Integer.parseInt(request

.getParameter("itemid")), currentPage, lineSize);

} catch (NumberFormatException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

request.setAttribute("currentPage", currentPage);

request.setAttribute("lineSize", lineSize);

request.setAttribute("allRecorders", allRecorders);

request.setAttribute("all", all);

request.setAttribute("jspUrl", "show.do");

request.setAttribute("status", "selectitem");

request.setAttribute("flagname", "itemid");

request.setAttribute("flagvalue", request.getParameter("itemid"));

try {

request.setAttribute("allitem", this.itemdao.queryAll());

} catch (Exception e) {

e.printStackTrace();

}

return mapping.findForward("showlist");

}

在JSP页面嵌入相关代码

<jsp:include page="split_page.jsp">

<jsp:param name="jspUrl" value="${jspUrl}" />

<jsp:param name="lineSize" value="${lineSize}"/>每页显示条数

<jsp:param name="allRecorders" value="${allRecorders}" />

<jsp:param name="keyWord" value="<%=request.getAttribute("keyWord")%>" />

<jsp:param name="currentPage" value="${currentPage}" />

<jsp:param name="status" value="${status}" />

<jsp:param name="flagname" value="${flagname}" />

<jsp:param name="flagvalue" value="${flagvalue}" />

<jsp:param name="searchFlag" value="T" />

</jsp:include>

分页程序部分代码 split_page.jsp

// 计算总页数

pageSize = (allRecorders+lineSize-1)/lineSize ;

<form name="spage" action="<%=jspUrl%>" onSubmit="change()">

<input type="hidden"

name="status" value="${status}"> <input type="hidden"

name="${param.flagname}" value=${param.flagvalue}> <%

if ("T".equals(searchFlag)) {

%> 输入查询关键字：<input type="text" name="kw"

value="<%=keyWord.equals("null") ? "" : keyWord%>"> <input

type="submit" value="查询"> <br>

<br>

if (allRecorders > 0) {

%> <input type="button" value="首页" onClick="openPage(1)"

<%=currentPage == 1 ? "disabled" : ""%>> <input type="button"

value="上一页" onClick="openPage(<%=currentPage - 1%>)"

<%=currentPage == 1 ? "disabled" : ""%>> <input type="button"

value="下一页" onClick="openPage(<%=currentPage + 1%>)"

<%=currentPage == pageSize ? "disabled" : ""%>> <input type="button"

value="尾页" onClick="openPage(<%=pageSize%>)"

<%=currentPage == pageSize ? "disabled" : ""%>> <input type="hidden"

name="cp" value=""> <font color="red" size="5"><%=currentPage%></font>

/ <font color="red" size="5"><%=pageSize%></font> 跳转到 <select

name="selpage" onChange="selOpenPage()">

for (int x = 1; x <= pageSize; x++) {

}

</select> 页 <%

}

Spring Junit4测试

public class UserDAOTest extends AbstractDependencyInjectionSpringContextTests { @Override复写父类的方法，找到配制文件 protected String[] getConfigLocations() { // TODO Auto-generated method stub return new String[]{"classpath:applicationContext.xml"}; } //引入在Spring注入的bean private UserDAO userdao; public void setUserdao(UserDAO userdao) { this.userdao = userdao; } public void testLoadUser() throws Exception{ // User user=this.userdao.queryByUserid("fantlam"); // assertNotNull(user); boolean b=this.userdao.isExists("fantlam", "你在吗", "我在"); assertEquals(true,b); } //可以直接运行程序 public static void main(String[] args){ // junit.swingui.TestRunner.run(UserDAOTest.class);因为conmon-logging的原因，使用junit.awtui或junit.swingui包下的TestRunner会出现错误/ 故采用junit.textui包 junit.textui.TestRunner.run(UserDAOTest.class); } }

applicationContext.xml

<bean id="userdao" class="dj.fantlam.myssh.dao.UserDAO"

abstract="true">

</bean>

<bean id="userdaoimpl" class="dj.fantlam.myssh.daoimpl.UserDAOImpl"

parent="userdao">

</property>

</bean>

关于spring junit测试的类关系

org.springframework.test

Class AbstractTransactionalDataSourceSpringContextTests

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.springframework.test.ConditionalTestCase

org.springframework.test.AbstractSpringContextTests

org.springframework.test.AbstractSingleSpringContextTests

org.springframework.test.AbstractDependencyInjectionSpringContextTests

org.springframework.test.AbstractTransactionalSpringContextTests

org.springframework.test.AbstractTransactionalDataSourceSpringContextTests

All Implemented Interfaces:

Test

org.hibernate.QueryException: could not resolve property: qid of: dj.fantlam.myssh.vo.Answer [SELECT COUNT(q.qid) FROM dj.fantlam.myssh.vo.Question AS q WHERE q.qid IN (SELECT a.qid FROM dj.fantlam.myssh.vo.Answer AS a WHERE a.userid=?)]

解决方法：

在answer.hbm.xml添加属性

</property>

</property>

加入

<many-to-one name="question"

class="dj.fantlam.myssh.vo.Question" fetch="select"

insert="false" update="false">

</many-to-one>

这样做了之后的确可以解决问题，但破坏了表的关联属性，导致无法进行其它插入等操作，所以这种方法不行。

根据表的一对多的关系，把整个HQL语句改成

String hql = "SELECT COUNT(q.qid) FROM Question AS q WHERE q.qid IN (SELECT a.question.qid FROM Answer AS a WHERE a.userid=? AND status=?)";