毕业设计(十一)---后台用户管理(1)之-用户信息分页显示[hibernateTemplate分页]

后台管理使用的网上找的模板，把头和侧边导航写成一个jsp 文件， 在每一个新的管理页面上进行引用。网上模板很多，。不详细说

用户信息显示其实就是 点击左侧的 "用户管理" 显示用户信息.

过程:

一:struts.xml 配置action

<action name="manageruser" class="ActionManagerUser" >
			<result name="success" >/admin/managerUser.jsp</result>
		</action>

二action调用manager方法

@Component("ActionManagerUser")
@Scope("prototype")
public class ActionManagerUser extends ActionSupport {
	private Manager manager;
	private PageBean pageBean;
	private int page;
	private String username;

	//此处省略 get  set 方法

	@Resource
	public void setManager(Manager manager) {
		this.manager = manager;
	}

	// 查找所有用户
	@Override
	public String execute() throws Exception {

		if(username==null){
			this.pageBean = manager.queryUsersForPage(7, page);	
		}else
		{
			this.pageBean = manager.queryUsersForPageByUsername(8, page,username);
		}
		

		return SUCCESS;
	}

}

三:manager调用分页查找方法:

public PageBean<Users> queryUsersForPage(int pageSize, int page) {
		// TODO Auto-generated method stub
		return userDao.queryUsersForPage(pageSize, page);
	}

四:userDaoImpl方法  【最重要】

@Override
	public int userNums() {
		List list = hibernateTemplate.find("select count(*) from Users");
		int num = Integer.parseInt(list.get(0).toString());
		return num;
	}

	
	
	@Override
	public PageBean<Users> queryUsersForPage(int pageSize, int page) {
		// 获取所以的记录数
		int allRow = this.userNums();
		// 获得总页数
		int totalPage = PageBean.countTotalPage(pageSize, allRow);
		// 计算当前页
		final int currentPage = PageBean.coutCurrentPage(page);
		// 当前要显示的起始数
		final int offset = PageBean.countOffset(pageSize, currentPage);
		// 获取要显示的页面信息 offset要显示页面的第一个的所以
		List<Users> list = this.getListForPage("from Users", offset, pageSize);
		// System.out.println(list);
		PageBean<Users> pagebean = new PageBean();
		pagebean.setPagesize(pageSize);
		pagebean.setCurrentPage(currentPage);
		pagebean.setAllRow(allRow);
		pagebean.setTotalPage(totalPage);
		pagebean.setList(list);
		pagebean.init();
		return pagebean;
	}

	
	
	public List<Users> getListForPage(final String hql, final int offset, final int length){
		List list = hibernateTemplate.executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException,SQLException{
				Query query = session.createQuery(hql);
				query.setFirstResult(offset);
				query.setMaxResults(length);
				List<Users> list = query.list();
				return list;
			}
		});
		return list;
	}

	

五：jsp页面显示代码

<table width="100%" border="0" cellpadding="0" cellspacing="1"
				bgcolor="#a8c7ce">
				<tr>
					<td width="5%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">序号</span>
						</div>
					</td>
					<td width="20%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">用户名</span>
						</div>
					</td>
					<td width="15%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">性别</span>
						</div>
					</td>
					<td width="20%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">邮箱</span>
						</div>
					</td>

					<td width="20%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">注册时间</span>
						</div>
					</td>
					<td width="20%" height="20" bgcolor="d3eaef" class="STYLE6"><div
							align="center">
							<span class="STYLE10">基本操作</span>
						</div>
					</td>
				</tr>

				<s:iterator value="pageBean.list" var="user" status="st">
					<tr>
						<td height="15" bgcolor="#FFFFFF" class="STYLE19"><div
								align="center">
								<s:property value="#st.index + 1" />
							</div>
						</td>
						<td height="15" bgcolor="#FFFFFF" class="STYLE19"><div
								align="center">
								<a href="findOneUser.action?userId=${user.username}去查看空间"
									target="_blank">${user.username }</a>
							</div>
						</td>
						<td height="15" bgcolor="#FFFFFF" class="STYLE19"><div
								align="center">${user.sex }</div>
						</td>
						<td height="15" bgcolor="#FFFFFF" class="STYLE19"><div
								align="center">${user.email }</div>
						</td>

						<td height="15" bgcolor="#FFFFFF" class="STYLE19"><div
								align="center">${ user.registerDate }</div>
						</td>
						<td height="15" bgcolor="#FFFFFF"><div align="center">
								<span class="STYLE21">删除 </span>
							</div>
						</td>
					</tr>
				</s:iterator>



				<tr>
					<table width="100%" border="0" cellspacing="0" cellpadding="0">
						<tr>
							<td width="33%"><div align="left">
									<span class="STYLE22">    共有<strong>
											${pageBean.allRow } </strong> 条记录，当前第<strong>${pageBean.currentPage}</strong>
										页，共 <strong> <s:property value="pageBean.totalPage" />
									</strong> 页</span>
								</div>
							</td>
							<td width="67%">
							<table width="312" border="0" align="right"
									cellpadding="0" cellspacing="0">
									<tr>
										<td width="49"><div align="center">
												<img style="cursor:pointer" src="images1/main_54.gif"
													width="40" height="15" οnclick="shouye();" />
											</div>
										</td>
										<td width="49"><div align="center">
												<img style="cursor:pointer" src="images1/main_56.gif"
													width="45" height="15" οnclick="shangyiye();" />
											</div>
										</td>
										<td width="49"><div align="center">
												<img style="cursor:pointer" src="images1/main_58.gif"
													width="45" height="15" οnclick="xiayiye();" />
											</div>
										</td>

										<td width="49"><div align="center">
												<img style="cursor:pointer" src="images1/main_60.gif"
													width="40" height="15" οnclick="weiye();" />
											</div>
										</td>
										<td width="37" class="STYLE22"><div align="center">转到</div>
										</td>
										<td width="22"><div align="center">
												<input type="text" name="textfield" id="jumppp"
													style="width:20px; height:12px; font-size:12px; border:solid 1px #7aaebd;" />
											</div>
										</td>
										<td width="22" class="STYLE22"><div align="center">页</div>
										</td>
										<td width="35"><img style="cursor:pointer"
											src="images1/main_62.gif" width="26" height="15"
											οnclick="jump();" /></td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
				</tr>

			</table>