SSM整合

ssm整合(文末配有SSM整合所需依赖)

目录结构


实现pojo实体类

package com.mySSM.pojo;

import java.io.Serializable;

public class Admin implements Serializable {
    private Integer id;
    private String username;
    private String password;
    private Double money;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public Double getMoney() {
        return money;
    }
    public void setMoney(Double money) {
        this.money = money;
    }
    @Override
    public String toString() {
        return "Admin{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", password='" + password + ''' +
                ", money=" + money +
                '}';
    }
}

dao层

dao接口

package com.mySSM.dao;

import com.mySSM.pojo.Admin;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
@Repository
public interface AdminDao {
    
    public List findAll();

    
    public int desMoney(@Param("username") String username, @Param("money") Double money);

    
    public int addMoney(@Param("username") String username,@Param("money") Double money);
}

dao的xml

    
        select * from ssmtest.admin
    
    
        update ssmtest.admin set money=money-#{money} where username=#{username}
    
    
        update ssmtest.admin set money=money+#{money} where username=#{username}
    

service层

   package com.mySSM.service;
   
   import com.mySSM.pojo.Admin;
   
   import java.util.List;
   
   public interface AdminService {
       public List findAll();
       public int updMoney(String username,Double money,String username2,Double money2);
   }

2.实现接口

 package com.mySSM.service.impl;
            
            import com.mySSM.dao.AdminDao;
            import com.mySSM.pojo.Admin;
            import com.mySSM.service.AdminService;
            import org.springframework.beans.factory.annotation.Autowired;
            import org.springframework.stereotype.Service;
            import org.springframework.transaction.annotation.Transactional;
            
            import javax.servlet.http.HttpServletRequest;
            import java.util.List;
            
            @Service
            @Transactional
            public class AdminServiceImpl implements AdminService {
                @Autowired
                private AdminDao adminDao;
                @Override
                public List findAll() {
                    System.out.println("执行了查询所有信息语句......");
                    List all = adminDao.findAll();
                    return all;
                }
            
                @Override
                public int updMoney(String username, Double money, String username2, Double money2) {
                    int i=adminDao.addMoney(username,money);
                    //手动增加异常,检验事务管理
                    int p=1/0;
                    int j=adminDao.desMoney(username2,money2);
                    if(i>0&&j>0){
                        return 1;
                    }
                    return 0;
                }
            }

controller层

    package com.mySSM.controller;
    
    import com.mySSM.pojo.Admin;
    import com.mySSM.service.AdminService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.test.annotation.Rollback;
    import org.springframework.transaction.annotation.Transactional;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import javax.servlet.http.HttpServletRequest;
    import java.util.List;
    
    @Controller
    public class Controllers {
        @Autowired
        @Qualifier("adminServiceImpl")
        private AdminService adminService;
    
        public AdminService getAdminService() {
            return adminService;
        }
    
        public void setAdminService(AdminService adminService) {
            this.adminService = adminService;
        }
    
        @RequestMapping("/findAll")
        public String findAll(HttpServletRequest request,String username){
            List all = adminService.findAll();
            request.setAttribute("userInfos",all);
            return "success";
        }
        @RequestMapping("/changeMoney")
        public String changeMoney(String username,Double money,String username2,Double money2){
            int i=adminService.updMoney(username,money,username2,money2);
            return "success";
        }
    }
    ```

spring.xml配置

  
  
  
      
          
          
      
      
          
          
          
          
      
      
          
          
          
      
      
          
      
  
      
          
      
      
          
              
              
          
      
      
          
          
      
      
  
  
  ```

springmvc层配置

jsp界面

<%--
              Created by IntelliJ IDEA.
              User: 19651
              Date: 2022/1/13
              Time: 19:46
              To change this template use File | Settings | File Templates.
            --%>
            <%@ page contentType="text/html;charset=UTF-8" language="java" %>
            
            
                
            
            
            查询
            修改钱数
            
            

web.xml配置

      
      
      
        Archetype Created Web Application
        
          contextConfigLocation
          classpath:applicationContext.xml
        
        
          org.springframework.web.context.ContextLoaderListener
        
      
        
          characterEncodingFilter
          org.springframework.web.filter.CharacterEncodingFilter
          
            encoding
            utf-8
          
        
        
          characterEncodingFilter
          /*
        
        
          dispatcherServlet
          org.springframework.web.servlet.DispatcherServlet
          
            contextConfigLocation
            classpath:springMvc.xml
          
          
          1
        
        
          dispatcherServlet
          /
        
      
      ```

事务管理(在service实现类上边标注)

xml形式

在spring配置文件中加上

注解形式(在service实现类上面注解@Transactional)

分页功能实现

导入依赖

 
     
       com.github.pagehelper
       pageHelper
       5.1.10
     

在spring配置文件中设置插件
在service层添加功能

 @Override
 public PageInfo findAlls(Integer start, Integer counts) {
 //start起始
     PageHelper.startPage(start,counts);
     List all = adminDao.findAll();
     PageInfo adminPageInfo=new PageInfo<>(all);
     return adminPageInfo;
 }

controller添加

 @RequestMapping("/findAllAdmins")
     public String findAllAdmins(HttpServletRequest request, HttpServletResponse response, Integer start, Integer end) throws ServletException, IOException {
         PageInfo alls = adminService.findAlls(start, end);
         //start要显示的页数，end每页显示的数量
         request.setAttribute("userInfos",alls);
         return "userInfos";
     }

jsp：

        
    当前页码:${userInfos.pageNum}

    

        
id
        
用户名
        
密码
        
钱数
    
    

            
${item.id}
            
${item.username}
            
${item.password}
            
${item.money}
        
    

pageNum 当前页码
pageSize 每页显示多少条数据
size 当前页显示多少条数据
startRow 第几条数据开始显示
endRow 显示到第几条数据
total 总共多少条数据
pages 总共多少页
startRow 第几条数据开始显示
list 查询的数据封装成列表
startRow 第几条数据开始显示
prePage 上一页
nextPage 下一页
isFirstPage 是否第一页
isLastPage 是否最后一页
hasPreviousPage 是否有上一页
hasNextPage 是否有下一页
navigatePages 显示多少个页码
navigateFirstPage 显示的第一个页码
navigateLagePage 显示的最后一个页码
navigatepageNums 将显示的页码封装成列表

	4.0
	UTF-8
	5.1.4.RELEASE


	
	
		javax
		javaee-api
		8.0
		provided
	
	
		org.glassfish.web
		javax.servlet.jsp.jstl
		1.2.4
	
	
		javax.servlet
		javax.servlet-api
		4.0.0
		provided
	
	
		javax.servlet
		jsp-api
		2.0
		provided
	
	
		org.apache.maven.plugins
		maven-resources-plugin
		2.6
		maven-plugin
	
	
		junit
		junit
		4.10
		test
	
	
		javax.servlet.jsp.jstl
		jstl-api
		1.2
	
	
	
	
		org.mybatis
		mybatis-spring
		2.0.0
	
	
		org.mybatis
		mybatis
		3.5.0
	
	
		org.ow2.asm
		asm
		7.0
	
	
		cglib
		cglib
		3.2.10
	
	
		org.apache.logging.log4j
		log4j-core
		2.10.0
	
	
		commons-logging
		commons-logging
		1.2
	
	
		org.javassist
		javassist
		3.23.1-GA
	
	
		mysql
		mysql-connector-java
		8.0.13
	
	
		org.slf4j
		slf4j-api
		1.7.25
	
	
		org.slf4j
		slf4j-log4j12
		1.7.25
		test
	
	
	
	
		aopalliance
		aopalliance
		1.0
	
	
		org.aspectj
		aspectjweaver
		1.9.2
	
	
		commons-codec
		commons-codec
		1.12
	
	
		org.apache.commons
		commons-lang3
		3.8.1
	
	
		commons-collections
		commons-collections
		3.2.2
	
	
		commons-fileupload
		commons-fileupload
		1.4
	
	
		commons-io
		commons-io
		2.6
	
	
		org.apache.commons
		commons-pool2
		2.6.0
	
	
		dom4j
		dom4j
		1.6.1
	
	
		com.alibaba
		druid
		1.1.13
	
	
		com.fasterxml.jackson.core
		jackson-core
		2.9.8
	
	
		com.fasterxml.jackson.core
		jackson-core
		2.9.8
	
	
		com.fasterxml.jackson.core
		jackson-databind
		2.9.8
	
	
		com.fasterxml.jackson.core
		jackson-annotations
		2.9.8
	
	
		org.json
		json
		20180813
	
	
		org.apache.taglibs
		taglibs-standard-impl
		1.2.5
	
	
	
	
		org.springframework
		spring-context-support
		${spring.version}
	
	
		org.springframework
		spring-core
		${spring.version}
	
	
		org.springframework
		spring-beans
		${spring.version}
	
	
		org.springframework
		spring-context
		${spring.version}
	
	
		org.springframework
		spring-aop
		${spring.version}
	
	
		org.springframework
		spring-tx
		${spring.version}
	
	
		org.springframework
		spring-orm
		${spring.version}
	
	
		org.springframework
		spring-web
		${spring.version}
	
	
		org.springframework
		spring-aspects
		${spring.version}
	
	
		org.springframework
		spring-jcl
		${spring.version}
	
	
		org.springframework
		spring-jms
		${spring.version}
	
	
		org.springframework
		spring-messaging
		${spring.version}
	
	
		org.springframework
		spring-test
		${spring.version}
		test
	
	
		org.springframework
		spring-webmvc
		${spring.version}