SSM框架整合回顾(一)

<properties>
    <project.srping.version>5.0.0.RELEASE</project.srping.version>
  </properties>

  <dependencies>

    <!--Spring的依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${project.srping.version}</version>
    </dependency>


    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${project.srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${project.srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${project.srping.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${project.srping.version}</version>
    </dependency>



    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${project.srping.version}</version>
    </dependency>


    <!-- 德鲁伊连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.9</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.5</version>
    </dependency>
    <!--mybatis和Spring的整合-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>


    <!--日志-->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>1.7.25</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>1.7.25</version>
    </dependency>


    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
      <scope>provided</scope>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.16.20</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>

    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.13</version>
    </dependency>

    <!--PageHelper分页插件-->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
    </dependency>

  </dependencies>

  <build>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>
  </build>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
       http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd
">
    <!--引入后台的spring的配置文件-->
    <import resource="classpath:applicationContext.xml"/>

    <!--视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--配置前缀-->
        <property name="prefix" value="/WEB-INF/views/"/>
        <!--配置后缀-->
        <property name="suffix" value=".jsp"/>
    </bean>

    <!--SpringMVC注解解析器-->
    <mvc:annotation-driven/>


    <!--拦截器-->
    <mvc:interceptors>
        <mvc:interceptor>
            <!--拦截的路径/*一级路径 /**所有路径-->
            <mvc:mapping path="/**"/>
            <!--排除登录页面-->
            <mvc:exclude-mapping path="/login.do"/>
            <bean class="com.ujiuye.interceptor.LoginInterceptor"></bean>
        </mvc:interceptor>
    </mvc:interceptors>


</beans>

package com.ujiuye.controller;


import com.ujiuye.domain.User;
import com.ujiuye.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpSession;

@Controller
public class LoginController {

    @Autowired
    private IUserService userService;

    //登录方法
    @RequestMapping("login")
    public String login(String username, String password,
                        HttpSession session, Model model){
        User user = userService.selectLogin(username, password);
        if (user!=null){
            //user对象放入session作用域
            session.setAttribute("USER_IN_SESSION",user);
            //跳转到用户列表页面
            return "redirect:/user/query.do";
        }else {
            //跳转到登录页面,提示用户名或密码错误
            model.addAttribute("msg","用户名或者密码错误");
            return "forward:/login.jsp";
        }
    }
}

package com.ujiuye.controller;

import com.github.pagehelper.PageInfo;
import com.ujiuye.domain.User;
import com.ujiuye.qo.QueryObject;
import com.ujiuye.result.PageResult;
import com.ujiuye.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@Controller
@RequestMapping("user")
public class UserController {

    @Autowired
    private IUserService service;



    //多条件查询 + 分页
    @RequestMapping("query")
    public String query(@ModelAttribute("qo") QueryObject qo,Model model){
//        PageResult result = service.query2(qo);
//        model.addAttribute("result",result);
        PageInfo pageInfo = service.query3(qo);

        model.addAttribute("pageInfo",pageInfo);
        return "user/list";
    }

    //查询列表的方法
    @RequestMapping("list")
    public String list(Model model){
        List<User> list = service.list();
        model.addAttribute("list",list);
        return "user/list";
    }

    //跳转到用户编辑页面
    @RequestMapping("edit")
    public String edit(Long id,Model model){
        if (id!=null){
            User user = service.get(id);
            //往前台传数据
            model.addAttribute("user",user);
        }
        return "user/edit";
    }

    //保存
    @RequestMapping("saveOrUpdate")
    public String saveOrUpdate(User user){
        //判断user对象中的id的值,从而区分是在做新增还是修改
        if (user.getId()==null){
            service.save(user);
        }else {
            service.update(user);
        }
        return  "redirect:/user/list.do";
    }

    //删除
    @RequestMapping("delete")
    public String delete(Long id){
        //删除操作
        service.delete(id);
        return "redirect:/user/list.do";
    }
}

package com.ujiuye.domain;

import lombok.*;
import java.math.BigDecimal;

@Setter@Getter
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {

    private Long id;

    private String username;

    private String password;

    private Integer age;

    private BigDecimal salary;
}

package com.ujiuye.interceptor;


import org.springframework.web.servlet.HandlerInterceptor;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginInterceptor implements HandlerInterceptor {

    //登录检查,实现接口里的这个方法
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        //判断session中是否有"USER_IN_SESSION"的key
        HttpSession session = request.getSession();
        Object user = session.getAttribute("USER_IN_SESSION");
        if (user == null){
            //跳转到登录页面
            response.sendRedirect("login.jsp");
            return  false;
        }
        return true;
    }
}

package com.ujiuye.mapper;


import com.ujiuye.domain.User;
import com.ujiuye.qo.BaseQueryObject;
import com.ujiuye.qo.QueryObject;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserMapper {
    //增删改查
    void save(User user);
    void update(User user);
    void delete(Long id);
    //查单独一个
    User get(Long id);
    //查询所有
    List<User> list();
    //登录查询
    User selectLogin(@Param("username") String username,
                     @Param("password") String password);

    List<User> query(QueryObject qo);

    //查询结果集中的数据
    List<User> queryForList(BaseQueryObject qo);

    //查询总条数
    int queryForCount(QueryObject qo);
}

package com.ujiuye.qo;

import lombok.Getter;
import lombok.Setter;


@Setter@Getter
public class BaseQueryObject {

    private Integer currentPage = 1;

    private Integer pageSize = 3;

    public Integer getStart(){
        return (this.currentPage-1)*this.pageSize;
    }
}

package com.ujiuye.qo;

public class DepartemntQueryObject {

    private String deptName;
}

package com.ujiuye.qo;

import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;


@Getter@Setter
public class QueryObject extends BaseQueryObject {
    private String username;
    private BigDecimal salary;
}

package com.ujiuye.result;

import lombok.Getter;
import lombok.Setter;

import java.util.Collections;
import java.util.List;

@Setter
@Getter
public class PageResult {

    //结果集 数据
    private List<?> data;
    //总的条数
    private Integer totalCount;

    //计算出来
    //上一页
    private Integer prevPage;
    //下一页
    private Integer nextPage;
    //尾页
    private Integer endPage;

    //计算方法
    public PageResult(List<?> data, Integer totalCount, Integer currentPage, Integer pageSize) {
        this.data = data;
        this.totalCount = totalCount;
        this.prevPage= currentPage-1>1?currentPage-1:1;
        this.endPage=totalCount%pageSize == 0?totalCount/pageSize:totalCount/pageSize+1;
        this.nextPage = currentPage+1<endPage?currentPage+1:endPage;
    }

    public static PageResult EMPTY_LIST = new PageResult(Collections.emptyList(),0,1,1);
}

package com.ujiuye.service;

import com.alibaba.druid.sql.PagerUtils;
import com.github.pagehelper.PageInfo;
import com.ujiuye.domain.User;
import com.ujiuye.qo.BaseQueryObject;
import com.ujiuye.qo.QueryObject;
import com.ujiuye.result.PageResult;

import java.util.List;

public interface IUserService {
    //增
    void save(User user);
    //改
    void update(User user);
    //删
    void delete(Long id);
    //查单个
    User get(Long id);
    //查询所有
    List<User> list();
    //登录方法
    User selectLogin(String username,String password);

    List<User> query(QueryObject qo);

    PageResult query2(QueryObject qo);

    PageInfo query3(QueryObject qo);
}

package com.ujiuye.service.impl;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ujiuye.domain.User;
import com.ujiuye.mapper.UserMapper;
import com.ujiuye.qo.BaseQueryObject;
import com.ujiuye.qo.QueryObject;
import com.ujiuye.result.PageResult;
import com.ujiuye.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Collections;
import java.util.List;

@Service
public class UserServiceImpl implements IUserService {

    private static PageResult EMPTY_LIST =
            new PageResult(Collections.emptyList(), 0, 1, 1);


    @Autowired
    private UserMapper userMapper;

    public void save(User user) {
        userMapper.save(user);
    }

    public void update(User user) {
        userMapper.update(user);
    }

    public void delete(Long id) {
        userMapper.delete(id);
    }

    public User get(Long id) {
        return userMapper.get(id);
    }

    public List<User> list() {
        return userMapper.list();
    }

    public User selectLogin(String username, String password) {

        return userMapper.selectLogin(username, password);
    }

    public List<User> query(QueryObject qo) {

        return userMapper.query(qo);
    }

    public PageResult query2(QueryObject qo) {

        //查询总的条数qo
        int totlaCount = userMapper.queryForCount(qo);
        if(totlaCount == 0){
            //返回空结果集
            return PageResult.EMPTY_LIST;
        }
        //查询结果集数据
        List<User> data = userMapper.queryForList(qo);

        return new PageResult(data,totlaCount,qo.getCurrentPage(),qo.getPageSize());
    }

    public PageInfo query3(QueryObject qo) {
        PageHelper.startPage(qo.getCurrentPage(),qo.getPageSize());
        List<User>  list = userMapper.query(qo);
        return new PageInfo(list);
    }
}

package com.ujiuye.test;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ujiuye.domain.User;
import com.ujiuye.mapper.UserMapper;
import com.ujiuye.service.IUserService;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

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

@RunWith(SpringJUnit4ClassRunner.class)

@ContextConfiguration("classpath:applicationContext.xml")
public class App {

    @Autowired
    private SqlSessionFactory sqlSessionFactory;

    @Autowired
    private UserMapper userMapper;

    @Autowired
    private IUserService service;

    private User user = null;

    @Test
    public void testSave(){
        user = new User(null,"特朗普","123",30,new BigDecimal("1.00"));
        service.save(user);
    }

    @Test
    public void testUpdate(){
        user = new User(2L,"奥巴马","123",12,new BigDecimal("2000.00"));
        service.update(user);
    }

    @Test
    public void testDelete(){
        service.delete(9L);
    }

    @Test
    public void testGet(){
        System.out.println(service.get(7L));
    }

    @Test
    public void testList(){
        System.out.println(service.list());
    }

    @Test
    public void testLogin(){
        user = service.selectLogin("扎克伯格","456");
        System.out.println(user);
    }

    @Test
    public void testPageHelper(){
        PageHelper.startPage(2,3);
        List<User> list = userMapper.list();

        PageInfo pageInfo = new PageInfo(list);
        System.out.println(pageInfo.getList().get(0));
        System.out.println(pageInfo.getList().get(1));
        System.out.println(pageInfo.getList().get(2));
        System.out.println("上一页:"+pageInfo.getPrePage());
        System.out.println("下一页:"+pageInfo.getNextPage());
        System.out.println("总页数:"+pageInfo.getSize());
        System.out.println("首页:"+pageInfo.getNavigateFirstPage());
        System.out.println("尾页:"+pageInfo.getNavigateLastPage());
    }
}