ssm整合（springmvc、spring、mybatis）

待我称王封你为后i 2024-04-17 21:30 32阅读 0赞

# 一、项目目录结构 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70]

# 二、导包 #

<properties>
      		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      		<junit.version>4.12</junit.version>
      		<slf4j.version>1.7.25</slf4j.version>
      		<commons-fileupload.version>1.4</commons-fileupload.version>
        	<commons-io.version>2.6</commons-io.version>
      		<javax.servlet.jsp-api.version>2.3.1</javax.servlet.jsp-api.version>
    		<javax.servlet-api.version>3.1.0</javax.servlet-api.version>
      		<mysql.version>5.1.38</mysql.version>
      		<mybatis.version>3.4.6</mybatis.version>
      		<spring.version>5.0.8.RELEASE</spring.version>
      		<aspect.version>1.8.10</aspect.version>
      		<c3p0.version>0.9.5.2</c3p0.version>
      		<mybatis-spring.version>1.3.2</mybatis-spring.version>
      		<spring-webmvc.version>5.1.6.RELEASE</spring-webmvc.version>
      </properties>
      <dependencies>
      
      <dependency>
    	    <groupId>org.springframework</groupId>
    	    <artifactId>spring-webmvc</artifactId>
    	    <version>${spring-webmvc.version}</version>
    	</dependency>
      
    		<dependency>
    		    <groupId>org.mybatis</groupId>
    		    <artifactId>mybatis-spring</artifactId>
    		    <version>${mybatis-spring.version}</version>
    		</dependency>
      
    		<dependency>
    			<groupId>com.mchange</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>${c3p0.version}</version>
    		</dependency>
      
      <dependency>
    			<groupId>org.aspectj</groupId>
    			<artifactId>aspectjweaver</artifactId>
    			<version>${aspect.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.aspectj</groupId>
    			<artifactId>aspectjrt</artifactId>
    			<version>${aspect.version}</version>
    		</dependency>
      
      
      <dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-context</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    	<dependency>
    	    <groupId>org.springframework</groupId>
    	    <artifactId>spring-jdbc</artifactId>
    	    <version>${spring.version}</version>
    	</dependency>
    	
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-test</artifactId>
    			<version>${spring.version}</version>
    			<scope>test</scope>
    		</dependency>
      
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>${mybatis.version}</version>
    </dependency>
        	
    	<dependency>
    	    <groupId>mysql</groupId>
    	    <artifactId>mysql-connector-java</artifactId>
    	    <version>${mysql.version}</version>
    	</dependency>
    	
    		<dependency>
    			<groupId>javax.servlet.jsp</groupId>
    			<artifactId>javax.servlet.jsp-api</artifactId>
    			<version>${javax.servlet.jsp-api.version}</version>
    			<scope>provided</scope>
    		</dependency>
    		<dependency>
    			<groupId>javax.servlet</groupId>
    			<artifactId>javax.servlet-api</artifactId>
    			<version>${javax.servlet-api.version}</version>
    			<scope>provided</scope>
    		</dependency>
    		
    	<dependency>
          <groupId>commons-fileupload</groupId>
          <artifactId>commons-fileupload</artifactId>
          <version>${commons-fileupload.version}</version>
        </dependency>
        <dependency>
          <groupId>commons-io</groupId>
          <artifactId>commons-io</artifactId>
          <version>${commons-io.version}</version>
        </dependency>
    		
    	<dependency>
    	    <groupId>org.slf4j</groupId>
    	    <artifactId>slf4j-log4j12</artifactId>
    	    <version>${slf4j.version}</version>
    	    <scope>test</scope>
    	</dependency>
      
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>${junit.version}</version>
          <scope>test</scope>
        </dependency>
      </dependencies>

# 三、domian、service、controller #

## 3.1.domain包 ##

##### 3.1.1.BaseBean #####

package com.blog.domain;
    
    public class BaseBean {
    	private Integer uid;
    	private String uname;
    	private Integer age;
    	private String address;
    	public Integer getUid() {
    		return uid;
    	}
    	public void setUid(Integer uid) {
    		this.uid = uid;
    	}
    	public String getUname() {
    		return uname;
    	}
    	public void setUname(String uname) {
    		this.uname = uname;
    	}
    	public Integer getAge() {
    		return age;
    	}
    	public void setAge(Integer age) {
    		this.age = age;
    	}
    	public String getAddress() {
    		return address;
    	}
    	public void setAddress(String address) {
    		this.address = address;
    	}
    	@Override
    	public String toString() {
    		return "BaseBean [uid=" + uid + ", uname=" + uname + ", age=" + age + ", address=" + address + "]";
    	}
    	
    }

##### 3.1.2.Account #####

package com.blog.domain;
    
    public class Account {
    	private Integer id;
    	private String name;
    	private Double money;
    	private Double transferMoney;
    	public Integer getId() {
    		return id;
    	}
    	public void setId(Integer id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public Double getMoney() {
    		return money;
    	}
    	public void setMoney(Double money) {
    		this.money = money;
    	}
    	public Double getTransferMoney() {
    		return transferMoney;
    	}
    	public void setTransferMoney(Double transferMoney) {
    		this.transferMoney = transferMoney;
    	}
    	
    }

## 3.2.service包 ##

##### 3.2.1.AccountService接口 #####

package com.blog.service;
    
    import com.blog.domain.Account;
    
    public interface AccountService {
    	//转账操作:账户a给账户b转账
    	public void transfer(Account a,Account b);
    }

##### 3.2.2.AccountServiceImpl实现类 #####

package com.blog.service;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import com.blog.domain.Account;
    import com.blog.mapper.AccountMapper;
    
    @Service
    @Transactional(isolation=Isolation.DEFAULT,propagation=Propagation.REQUIRED,readOnly=false)
    public class AccountServiceImpl implements AccountService {
    	@Autowired
    	private AccountMapper accountMapper;
    	
    	@Override
    	public void transfer(Account a, Account b) {
    		//扣钱
    		accountMapper.reduce(a);
    		
    		//异常
    		//int x=1/0;
    		
    		//减钱
    		accountMapper.increase(b);
    	}
    
    }

##### 3.2.3.BaseSerive接口 #####

package com.blog.service;
    
    import com.blog.domain.BaseBean;
    
    public interface BaseService {
    	public BaseBean getOneById(Integer uid);
    }

##### 3.2.4.BaseServiceImpl实现类 #####

package com.blog.service;
    
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import com.blog.domain.BaseBean;
    import com.blog.mapper.BaseMapper;
    
    @Service
    public class BaseServiceImpl implements BaseService {
    	@Resource(name="baseMapper")
    	private BaseMapper baseMapper;
    	
    	@Override
    	public BaseBean getOneById(Integer uid) {
    		return baseMapper.getOneById(uid);
    	}
    
    }

## 3.3.controlller包 ##

##### 3.3.1.BaseController #####

package com.blog.controller;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.blog.domain.BaseBean;
    import com.blog.service.BaseService;
    
    @Controller
    @RequestMapping(value="/base")
    public class BaseController {
    	@Resource(type=BaseService.class)
    	private BaseService baseService;
    	
    	@GetMapping(value="/getOneById")
    	public @ResponseBody String getOneById(@RequestParam Integer uid) {
    		BaseBean bean = baseService.getOneById(uid);
    		System.out.println(bean);
    		return "成功访问";//给前端相应数据“成功访问”
    	}
    	@GetMapping(value="/")
    	public String toNewJsp() {
    		return "new";//会跳转到/webapp/views/new.jsp,前提是new.jsp存在
    	}
    }

# 三、mybatis相关配置 #

### 1.mybatis配置文件mybatisConfig.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	<typeAliases>
    		
    		
    	 	
    	 	<package name="com.blog.domain"/>
    	 </typeAliases>
    	 
      	<mappers>
      		
      		<package name="com.blog.mapper"/>
      	</mappers>
    </configuration>

### 2.mapper接口和mapper.xml映射文件 ###

##### 2.1.BaseMapper 接口 #####

@Repository
    public interface BaseMapper {
    	public BaseBean getOneById(Integer uid);
    }

##### 2.2.BaseMapper .xml映射文件 #####

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper
      PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.blog.mapper.BaseMapper">
    	<select id="getOneById" parameterType="Integer" resultType="BaseBean">
    		select * from t_user where uid = #{uid}
    	</select>
    </mapper>

##### 2.3.AccountMapper接口 #####

package com.blog.mapper;
    
    import com.blog.domain.Account;
    
    public interface AccountMapper {
    	//账户加钱操作
    	public void increase(Account a);
    	//账户扣钱操作
    	public void reduce(Account a);
    }

##### 2.4.AccountMapper.xml映射文件 #####

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper
      PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.blog.mapper.AccountMapper">
    	<update id="increase" parameterType="Account">
    		update t_account set money = money+#{transferMoney} where id=#{id}
    	</update>
    	<update id="reduce" parameterType="Account">
    		update t_account set money = money-#{transferMoney} where id=#{id}
    	</update>
    </mapper>

# 四、spring相关配置applicationContext-core.xml #

<?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:tx="http://www.springframework.org/schema/tx"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	
    	xsi:schemaLocation="
    	http://www.springframework.org/schema/beans 
    	http://www.springframework.org/schema/beans/spring-beans.xsd
    	http://www.springframework.org/schema/context 
    	http://www.springframework.org/schema/context/spring-context.xsd
    	http://www.springframework.org/schema/tx 
    	http://www.springframework.org/schema/tx/spring-tx.xsd
    	http://www.springframework.org/schema/aop 
    	http://www.springframework.org/schema/aop/spring-aop.xsd">
    	
    	
    	<context:property-placeholder location="classpath:db.properties"/>
    	
    	<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		<property name="driverClass" value="${dataSource.driverClass}"/>
    		<property name="jdbcUrl" 	 value="${dataSource.jdbcUrl}"/>
    		<property name="user" 		 value="${dataSource.user}"/>
    		<property name="password" 	 value="${dataSource.password}"/>
    	</bean>
    	
    	
    	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource"/>
    		
    		<property name="configLocation"  value="classpath:mybatisConfig.xml"/>
    	</bean>
    	
    	
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="com.blog.mapper"/>
    	</bean>
    	
    	<context:component-scan base-package="com.blog.*"/>
    	
    	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource"/>
    	</bean>
    	
    	<tx:annotation-driven/>
    </beans>

# 五、springmvc相关配置springmvc-servlet.xml #

<?xml version="1.0" encoding="UTF-8"?>

<mvc:annotation-driven/>
    
    <context:component-scan base-package="com.blog.controller"/>
    
    <mvc:resources location="/views/" mapping="/views/**"/>
    
    
    <mvc:view-controller path="/" view-name="index"/>
    
    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    	<property name="prefix" value="/views/" />
    	<property name="suffix" value=".jsp" />
    </bean>
    
    <mvc:annotation-driven enable-matrix-variables="true">
    	<mvc:message-converters register-defaults="true">
    		<bean class="org.springframework.http.converter.StringHttpMessageConverter">
    			<constructor-arg value="UTF-8" />
    		</bean>
    	</mvc:message-converters>
    </mvc:annotation-driven>
    
    
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" >
    	<property name="maxUploadSize" value="5120000"/>
    </bean>

\# 六、web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1">
      <display-name>blog</display-name>
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext*.xml</param-value>
      </context-param>
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-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>
      </filter>
      <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    </web-app>

# 七、db.properties(请根据自己的数据库进行修改) #

dataSource.driverClass=com.mysql.jdbc.Driver
    dataSource.jdbcUrl=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8
    dataSource.user=blog
    dataSource.password=blog

# 八、测试 #

### 1.测试BaseService ###

@RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath:applicationContext-core.xml")
    public class TestBaseService {
    	@Resource(type=BaseService.class)
    	private BaseService baseService;
    	
    	@Test
    	public void test1() {
    		BaseBean bean = baseService.getOneById(15);
    		System.out.println(bean);
    	}
    }

### 2.测试事务管理 ###

package com.blog.test;
    
    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 com.blog.domain.Account;
    import com.blog.service.AccountService;
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath:applicationContext-core.xml")
    public class TestAccountService {
    	@Autowired
    	private AccountService accountService;
    	
    	@Test
    	public void test1() {
    		Double transferMoney = 1000d;
    		Account a = new Account();
    		Account b = new Account();
    		a.setId(1);
    		b.setId(2);
    		a.setTransferMoney(transferMoney);
    		b.setTransferMoney(transferMoney);
    		accountService.transfer(a, b);
    	}
    }

### 3.postman测试springmvc ###

##### 3.1.页面跳转（） #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70 1]

##### 3.2.响应前端数据 #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/e891f20d27a5470f95b5bae7bc2ebaae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/282d6cb4a2f0481dbfb1b9161ac1c239.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoT0xn_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/2b1a2de0cf0f4ef4a79843d489f7c288.png