SSM+EasyUI-CSDN博客

本文链接：https://blog.csdn.net/sgnever/article/details/51168206

学习使用SSM和EasyUI进行项目
MyBatis就不说了，因为没有复杂的数据关系，并没有什么难点，因此dao层就可以无视
最开始的就是配置

引入jar包
准备配置文件
先写好jdbc.property。

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmtest1??useUnicode=true&amp;characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root
c3p0.pool.size.max=20
c3p0.pool.size.min=5
c3p0.pool.size.ini=3
c3p0.pool.size.increment=2

spring配置

<?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:mvc="http://www.springframework.org/schema/mvc"
    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-3.0.xsd 
            http://www.springframework.org/schema/mvc 
            http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd 
            http://www.springframework.org/schema/context 
            http://www.springframework.org/schema/context/spring-context-3.0.xsd 
            http://www.springframework.org/schema/aop 
            http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
            http://www.springframework.org/schema/tx 
            http://www.springframework.org/schema/tx/spring-tx-3.0.xsd " >
            <!-- 使用标注扫描组件:service -->
    <context:component-scan base-package="service.impl" />
    <!-- 扫描mybatis映射接口类:使用sqlSession的getMapper的实现方式 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="dao" />
        <!-- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> -->
    </bean>

    <context:property-placeholder location="classpath:jdbc.properties"/>

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driverClassName}" />
        <property name="jdbcUrl" value="${jdbc.url}" />
        <property name="user" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="maxPoolSize" value="${c3p0.pool.size.max}" />
        <property name="minPoolSize" value="${c3p0.pool.size.min}" />
        <property name="initialPoolSize" value="${c3p0.pool.size.ini}" />
        <property name="acquireIncrement" value="${c3p0.pool.size.increment}" />
    </bean>
    <!-- classpath: -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
        <property name="mapperLocations" value="classpath:dao/impl/*.xml" />   <!-- 加载mapper文件 -->
    </bean>

    <!-- Spring提供的SqlSession的实现类sqlSessionTemplate -->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
    </bean>


</beans>

springmvc配置
因为这个练习没有增删改，所以这个没有配置aop

<?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:mvc="http://www.springframework.org/schema/mvc"
    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-3.0.xsd 
    http://www.springframework.org/schema/mvc 
    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd 
    http://www.springframework.org/schema/context 
    http://www.springframework.org/schema/context/spring-context-3.0.xsd 
    http://www.springframework.org/schema/aop 
    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
    http://www.springframework.org/schema/tx 
    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">
    <!-- 注解方式 -->
    <mvc:annotation-driven />

    <!-- 自动扫描Controller -->
    <context:component-scan base-package="action" />
    <!-- 配置一个springmvc框架的视图解析器 -->
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 通过setter方法注入前缀 /WEB-INF/jsps/showMsg.jsp -->
        <property name="prefix" value="/" />
        <!-- 通过setter方法注入后缀 -->
        <property name="suffix" value=".jsp" />
    </bean>

</beans>

用datagrid写好页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css"
    href="${pageContext.request.contextPath }/css/default/easyui.css">
<link rel="stylesheet" type="text/css"
    href="${pageContext.request.contextPath }/css/icon.css">
<script type="text/javascript"
    src="${pageContext.request.contextPath }/js/jquery.min.js"></script>
<script type="text/javascript"
    src="${pageContext.request.contextPath }/js/jquery.easyui.min.js"></script>
    <script type="text/javascript"
    src="${pageContext.request.contextPath }/js/easyui-lang-zh_CN.js"></script>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>显示所有联系人</title>
</head>
<body>
    <div align='center' id='tab_person' style="width:900px;height:350px"></div>
    <script>
        $('#tab_person').datagrid({
            url : '${pageContext.request.contextPath}/user/allUser.do',
            title : '用户表',
            fixed : true,
            isFiled:'id',
            pagination : true,
            pageSize : 10,//分页大小  
            pageList : [ 10, 20, 30 ],//每页的个数
            fitColumns : true,
            singleSelect : true,
            iconCls:"icon-save",//图标
            columns : [ [ {
                field : 'id',
                title : 'id',
            }, {
                field : 'name',
                title : '用户名',
            }, {
                field : 'pass',
                title : '密码',
            },
             {

                field : 'del',
                title : '删除',
                formatter : function() {
                    return "<a href='index.jsp?id=15'>删除</a>";
                }
            }, {
                field : 'upt',
                title : '修改',
                formatter : function() {
                    return "<a href='#'>修改</a>";
                }
            } ] ],
            loadMsg : '正在加载....',
            fitColumns : true
        });
    </script>
</body>
</html>

service

package service.impl;

import java.math.BigDecimal;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import service.UserService;
import util.PaginationContext;
import dao.UserDao;
import entity.User;
import entity.easyui.Data;
@Service
public class UserServiceImpl implements UserService{
    @Resource
    private UserDao userDao;

    public UserDao getUserDao() {
        return userDao;
    }

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    public Data<User> getUser() {
        // TODO Auto-generated method stub
        Integer page = PaginationContext.getPage();
        Integer rows = PaginationContext.getRows();
        int offset = (page - 1) * rows;
        List<User> l = userDao.queryAllUser(offset, rows);
        Data<User> dg = new Data<User>();
        dg.setRows(l);
        System.out.println("offset is"+offset);
        BigDecimal count = userDao.queryUserCount();
        System.out.println("count"+count);
        dg.setTotal(count.longValue());
        System.out.println(dg.getRows());
        return dg;
    }

}

为了service可以实时获取page和rows，创建一个filter，就是用来随时捕获datagrid里的数据

filter

package filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import util.PaginationContext;

public class PaginationFilter implements Filter{

    public void destroy() {
        // TODO Auto-generated method stub

    }

    public void doFilter(ServletRequest req, ServletResponse resp,
            FilterChain chain) throws IOException, ServletException {
        // TODO Auto-generated method stub
        String page = req.getParameter("page");
        //System.out.println("String page = "+page);
        String rows = req.getParameter("rows");
        //System.out.println("String rows = "+rows);
        if(page !=null){
            Integer pageValue = Integer.parseInt(page);
            PaginationContext.setPage(pageValue);
        }
        if(rows!=null){
            Integer rowsValue = Integer.parseInt(rows);
            PaginationContext.setRows(rowsValue);
        }
        chain.doFilter(req, resp);
    }

    public void init(FilterConfig filterConfig) throws ServletException {
        // TODO Auto-generated method stub

    }

}

将filter里面的数据传给PaginationContext，因为PaginationContext里面将这两个变量存入ThreadLoacl，使得对应的action能获取，代码如下

package util;

public class PaginationContext {
    private static ThreadLocal<Integer> Page = new ThreadLocal<Integer>();
    private static ThreadLocal<Integer> Rows = new ThreadLocal<Integer>();

    public static Integer getPage(){
        Integer PageValue = Page.get();
        if (PageValue == null)
            return 1;
        return PageValue;
    }
    public static void setPage(Integer PageValue) {
        PaginationContext.Page.set(PageValue);
    }
    public static Integer getRows() {
        Integer size = Rows.get();
        if (size == null)
            return 10;
        return size;
    }

    public static void setRows(Integer size) {
        Rows.set(size);
    }
}

action
最就是action，调用service就够了
嗯。。注解一定要写对

package action;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import service.UserService;
import util.PaginationContext;
import entity.User;
import entity.easyui.Data;

@Controller
@RequestMapping("user")
public class UserAction {
    @Resource
    private UserService userService;

    public UserService getUserService() {
        return userService;
    }

    public void setUserService(UserService userService) {
        this.userService = userService;
    }
    @RequestMapping("/allUser.do")
    @ResponseBody
    public Data<User> queryUser(Model m){
        Data<User> dg =userService.getUser();
        System.out.println("page is "+PaginationContext.getPage());
        System.out.println("row is "+PaginationContext.getRows());
        return dg;
    }

}

还有一点。。就是不要忘了web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    id="WebApp_ID" version="3.0">
    <display-name>BaseSSM</display-name>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring/applicationContext.xml</param-value>
    </context-param>
    <!-- 配置spring编码 -->
     <filter>
        <filter-name>PaginationFilter</filter-name>
        <filter-class>filter.PaginationFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>PaginationFilter</filter-name>
        <url-pattern>*.do</url-pattern>
    </filter-mapping> 
     <filter>
        <filter-name>encodingFilter</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>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>*.do</url-pattern>
    </filter-mapping>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>*.jsp</url-pattern>
    </filter-mapping> 
    <!-- spring前端控制器 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- 配置springmvc的前端控制器 -->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc/springmvc-servlet.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
</web-app>