spring+struts2+hibernate+ligerui+json整合开发(带分页)

最新推荐文章于 2024-08-09 14:40:40 发布

番茄很忙

最新推荐文章于 2024-08-09 14:40:40 发布

阅读量2.4k

点赞数

分类专栏： SSH 文章标签： hibernate struts2 spring ligerui 分页

本文链接：https://blog.csdn.net/FS_sky/article/details/32171145

版权

SSH 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

说明：

1、后台程序是参考本公司“杜师傅”的例子！加上自学了ligerui，整合来使用！

2、最近在做一个项目，使用到了上面的技术，不知道现在ssh发展到了上面地步，是不是已经快淘汰了，发现springMVC+mybatis、hibernate+esayui、juqeryui等是企业级应用比较广泛，本人在大学期间，就是学习ssh整合开发，个人感觉现在ssh在java企业应用中还是普遍存在的吧！

3、重在个人总结，技术积累，有什么不好的地方，还请各位牛人指点！相互学习、相互进步。

话不多说，下面是整合信息

一、项目结构：

二、把需要的jar包添加到lib目录，配置web.xml、applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_9" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<listener>
	<listener-class>org.springframework.web.context.ContextLoader</listener-class>
</listener>

    <display-name>Struts Blank</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>

<!-- <filter>
	<filter-name>loginFilter</filter-name>
	<filter-class>com.filter.LoginFilter</filter-class>
</filter>
<filter-mapping>
	<filter-name>loginFilter</filter-name>
	<url-pattern>/*</url-pattern>
</filter-mapping>
<filter>
	<filter-name>CharsetFilter</filter-name>
	<filter-class>com.filter.CharsetFilter</filter-class>
</filter> 
<filter-mapping>
	<filter-name>CharsetFilter</filter-name>
	<url-pattern>/*</url-pattern>
</filter-mapping>-->
<filter>
    <filter-name>CharacterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
</filter>
<filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

</web-app>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"  
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
    xmlns:context="http://www.springframework.org/schema/context"  
    xmlns:aop="http://www.springframework.org/schema/aop"  
    xmlns:tx="http://www.springframework.org/schema/tx"  
    xsi:schemaLocation="http://www.springframework.org/schema/beans    
           http://www.springframework.org/schema/beans/spring-beans-2.0.xsd   
           http://www.springframework.org/schema/context   
           http://www.springframework.org/schema/context/spring-context-2.0.xsd   
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd   
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
	<property name="configLocation" value="classpath:hibernate.cfg.xml"/>
</bean>

<bean id="TransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
	<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<tx:advice id="txAdvice" transaction-manager="TransactionManager">
	<tx:attributes>
		<tx:method name="insert*" propagation="REQUIRED"/>
		<tx:method name="delete*" propagation="REQUIRED"/>
		<tx:method name="update*" propagation="REQUIRED"/>
		<tx:method name="sum*" propagation="REQUIRED"/>
		<tx:method name="*" read-only="true"/>
	</tx:attributes>
</tx:advice>
<aop:config>
	<aop:pointcut id="allMethod" expression="execution(* com.dao.impl.*.*(..))"/>
	<aop:advisor advice-ref="txAdvice" pointcut-ref="allMethod"/>
</aop:config>

<!-- Dao Beans -->
<bean id="UserDao" class="com.dao.impl.UserDaoImpl">
	<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<!-- Service Beans -->
<bean id="UserService" class="com.service.UserService">
	<property name="userdao" ref="UserDao"/>
</bean>
</beans>

DAO



 

 

package com.dao.impl;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.common.PageUnit;
import com.dao.UserDao;
import com.tool.DBEncoding;

public class UserDaoImpl extends HibernateDaoSupport implements UserDao {

	public List userList(Map data,int pageNow,int pageSize) throws Exception{
		
		Session session=this.getHibernateTemplate().getSessionFactory().getCurrentSession();
		String sql = "select " +
						"t.ID," +
						"t.SFZH," +
						"t.YHXM," +
						"t.YHXB," +
						"decode(t.YHXB,'0','男','1','女','') as STR_YHXB," +
						"t.PHONE," +
						"t.PASSWORD," +
						"t.CSRQ," +
						"t.UPDATENUMBER," +
						"to_char(t.ADDDATE,'yyyy-MM-dd hh24:mi:ss') as ADDDATE," +
						"t.YXBS " +
						" from USERS t " +
						" where 1=1 ";
						//" and t.YXBS=0";
		String sql_where="";
		List<String> dataList=new ArrayList<String>();
		if(data!=null&&data.size()>0)
		{
			if(data.get("SFZH")!=null)
			{
				sql_where+=" and t.SFZH like ? ";
				dataList.add("%"+data.get("SFZH")+"%");
			}
			if(data.get("YHXM")!=null)
			{
				sql_where+=" and t.YHXM like ? ";
				dataList.add("%"+data.get("YHXM")+"%");
			}
		}
		sql+=sql_where+"order by t.ADDDATE desc";
		String sql_pageHear="select * from ( select zt.*,rownum m from ( ";
		String sql_pageFoot=" ) zt where rownum<=? ) where m>?";
		String sql_all=sql_pageHear+sql+sql_pageFoot;
		PreparedStatement ps=session.connection().prepareStatement(sql_all);
		int index=1;
		if(dataList!=null&&dataList.size()>0)
		{
			for(int i=0;i<dataList.size();i++)
			{
				ps.setString(index++, dataList.get(i));
			}
		}
		ps.setInt(index++, pageNow*pageSize);
		ps.setInt(index++, (pageNow-1)*pageSize);
		System.out.println("executeSQL:"+sql_all);
		ResultSet rs=ps.executeQuery();
		List l=null;
		try
		{
			if(rs!=null)
			{
				int pageCount=PageUnit.getPageCount(session,sql, dataList, pageSize);
				int Total = PageUnit.getRowCount(session, sql, dataList);
				l=new ArrayList();
				while(rs.next())
				{
					Map m=new HashMap();
					for(int i=0;i<rs.getMetaData().getColumnCount();i++)
					{
						String key=rs.getMetaData().getColumnName(i+1);
						m.put(key, DBEncoding.EncodingOutputDB(rs.getString(key)));
						if("null".equals(m.get(key)+""))
						{
							m.put(key,"");
						}
					}
					m.put("pageCount", pageCount);
					m.put("Total", Total);
					l.add(m);
				}
			}
			releaseSession(session);
		}
		finally
		{
			if(rs!=null)
			{
				rs.close();
			}
			if(ps!=null)
			{
				ps.close();
			}
		}
		return l;
	}

}

dao中的分页类

package com.common;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

import org.hibernate.Session;

import com.tool.DBEncoding;

public class PageUnit{
	public static int getPageCount(Session session,String sql, List<String> data, int pageSize)
			throws Exception {
		int pageCount=0;
		int rowCount=0;
		sql = "select count(*) from (" +sql+")";
		PreparedStatement ps=session.connection().prepareStatement(sql);
		int index=1;
		if(data!=null&&data.size()>0)
		{
			for(int i=0;i<data.size();i++)
			{
				ps.setString(index++, DBEncoding.EncodingInputDB(data.get(i)+""));
			}
		}
		System.out.println("executeSQL:"+sql);
		ResultSet rs=ps.executeQuery();
		try
		{
			if(rs!=null)
			{
				if(rs.next())
				{
					rowCount=Integer.parseInt(rs.getInt(1)+"");
				}
			}
			if(rowCount%pageSize==0)
			{
				pageCount=rowCount/pageSize;
			}
			else
			{
				pageCount=rowCount/pageSize+1;
			}
		}
		finally
		{
			if(rs!=null)
			{
				rs.close();
			}
			if(ps!=null)
			{
				ps.close();
			}
		}
		return pageCount;
	}
	public static int getRowCount(Session session,String sql,List<String> data) throws Exception{
		//int pageCount=0;
		int rowCount=0;
		sql = "select count(*) from (" +sql+")";
		PreparedStatement ps=session.connection().prepareStatement(sql);
		int index=1;
		if(data!=null&&data.size()>0)
		{
			for(int i=0;i<data.size();i++)
			{
				ps.setString(index++, DBEncoding.EncodingInputDB(data.get(i)+""));
			}
		}
		System.out.println("executeSQL:"+sql);
		ResultSet rs=ps.executeQuery();
		try
		{
			if(rs!=null)
			{
				if(rs.next())
				{
					rowCount=Integer.parseInt(rs.getInt(1)+"");
				}
			}
		}
		finally
		{
			if(rs!=null)
			{
				rs.close();
			}
			if(ps!=null)
			{
				ps.close();
			}
		}
		return rowCount;
	}
}

service类

package com.service;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.dao.UserDao;

public class UserService {
	private UserDao userdao;
	public UserDao getUserdao() {
		return userdao;
	}

	public void setUserdao(UserDao userdao) {
		this.userdao = userdao;
	}

	/**
	 * 带分页的查询用户信息
	 * @param data
	 * @param pageNow
	 * @param pageSize
	 * @return
	 */
	public List userList(Map data,int pageNow,int pageSize){
		List list = new ArrayList();
		try {
			list = userdao.userList(data, pageNow, pageSize);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

}

这时候应该写个测试类来测试一下结果

package com.test;

import java.util.List;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.factory.SpringContextFactory;
import com.service.UserService;

public class UserDaoTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		ClassPathXmlApplicationContext act=SpringContextFactory.getSpringContext();
		UserService us = (UserService)act.getBean("UserService");
		List list = us.userList(null, 1, 10);
		for(int i=0;i<list.size();i++){
			System.out.println(list.get(i));
		}

	}

}
package com.factory;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class SpringContextFactory {
	private static ClassPathXmlApplicationContext act=null;
	
	public static ClassPathXmlApplicationContext getSpringContext()
	{
		if(act==null)
		{
			act=new ClassPathXmlApplicationContext("applicationContext.xml");
		}
		return act;
	}
}

action 类

package com.action;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.factory.SpringContextFactory;
import com.opensymphony.xwork2.ActionSupport;
import com.service.UserService;

public class UserAction extends ActionSupport{
	private int pageNow = 1;
	private int pageSize = 10;
	private JSONObject Rows;
	private String action;
	
	@SuppressWarnings("unchecked")
	public String execute(){
		//HttpServletRequest request=ServletActionContext.getRequest();
		ClassPathXmlApplicationContext act=SpringContextFactory.getSpringContext();
		UserService us = (UserService)act.getBean("UserService");
		if(action.equals("ulist")){
			List userList = us.userList(null, pageNow, pageSize);
			/**
			 * json 
			 */
			HashMap maprow = new HashMap();
			if(userList!=null&&userList.size()>0){
				String Total=(((Map)userList.get(0)).get("Total"))+"";  
				maprow.put("Rows", userList);
				maprow.put("Total", Total);
			}
			Rows =JSONObject.parseObject(JSON.toJSONString(maprow));
			System.out.println(Rows);
			return SUCCESS;
		}
		return ERROR;
	}
	
	public int getPageNow() {
		return pageNow;
	}

	public void setPageNow(int pageNow) {
		this.pageNow = pageNow;
	}

	public int getPageSize() {
		return pageSize;
	}

	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public JSONObject getRows() {
		return Rows;
	}
	public void setRows(JSONObject rows) {
		Rows = rows;
	}

	public String getAction() {
		return action;
	}

	public void setAction(String action) {
		this.action = action;
	}
	
}

struts.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
	<package name="struts2" extends="json-default">
		<action name="UserAction" class="com.action.UserAction">
			<result type="json">
				<param name="root">Rows</param>
			</result>
		</action>
	</package>
</struts>

下面来使用ligerui的ligerGrid查询显示列表数据,userlist.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>用户列表</title>
<%@include file="include/head.jsp" %>
<script type="text/javascript">
	$(function(){
		$("#mainGrid").ligerGrid({
					title:"用户列表",
					columns:[
						{display:"主键",name:"ID",hide:"hidden"},
						{display:"身份证号",name:"SFZH",width:200},
						{display:"用户姓名",name:"YHXM",width:100},
						{display:"用户性别",name:"STR_YHXB"},
						{display:"手机号码",name:"PHONE"},
						{display:"出生日期",name:"CSRQ"},
						{display:"录入时间",name:"ADDDATE"},
						{display:"有效标示",name:"YXBS"}
					],
					//data:docData,
					url:'UserAction.action?action=ulist',
					sortName: 'au_id',
					width:"100%",height:"100%",checkbox:true,
					pagesizeParmName:"pageSize",
					pageParmName:"pageNow",
					pageSize:10,
					rowHeight:40,
					rownumbers:true,usePager:true
		});
	})
</script>
</head>
<body>
	<div id="mainGrid"></div>
</body>
</html>

显示结果

番茄很忙

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
1
评论
spring+struts2+hibernate+ligerui+json整合开发(带分页)

说明：1、后台程序是参考本公司“杜师傅”的例子！加上自学了ligerui，整合来使用！2、最近在做一个项目，使用到了上面的技术，不知道现在ssh发展到了上面地步，是不是已经快淘汰了，发现springMVC+mybatis、hibernate+esayui、juqeryui等是企业级应用比较广泛，本人在大学期间，就是学习ssh整合开发，个人感觉现在ssh在java企业应用中还是普遍存
复制链接

扫一扫

专栏目录