Maven整合Spring+Mybatis

一、环境

eclipse：Version: 2019-03 (4.11.0)
jdk：jdk-12.0.1
maven：apache-maven-3.6.2

二、创建maven项目

打开eclipse->new->other->maven project

三、创建包和配置文件

四、配置pom.xml、jdbc.properties、log4j.properties

• 1、pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.nys.ms1</groupId>
	<artifactId>mybatis_spring0</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<properties>
		<spring_version>4.3.2.RELEASE</spring_version>
	</properties>
	<dependencies>
		<!-- spring依赖包 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring_version}</version>
		</dependency>
		<!-- mybatis依赖包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.8</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>
		<!-- mysql依赖包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.38</version>
		</dependency>
		<!-- junit依赖包 -->
		<dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!-- aop联盟 -->
        <dependency>
    		<groupId>aopalliance</groupId>
    		<artifactId>aopalliance</artifactId>
    		<version>1.0</version>
		</dependency>
		<!-- @Resource依赖包 -->
		<dependency>
    		<groupId>javax.annotation</groupId>
    		<artifactId>jsr250-api</artifactId>
    		<version>1.0</version>
		</dependency>
	</dependencies>
</project>

• 2、jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/nys
jdbc.username=root
jdbc.password=nys123

• 3、log4j.properties

log4j.rootCategory=DEBUG, stdout
 
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[QC] %p [%t] %C.%M(%L) | %m%n

五、创建数据（mysql）

-->>create database nys;
-->>use nys;
-->>create table users(
	uid int primary key auto_increment,
	uname varchar(10) not null,
	uage int not null
	)
-->>insert into users(uname,uage) values
	("nys",21),
	("zs",22),
	("tmh",21),
	("llj",22),
	("zbs",23),
	("tml",20),
	("ljy",20)

六、配置mybatis_spring.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:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-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/context http://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 配置自动扫描IOC注解 -->
    <context:component-scan base-package="service"></context:component-scan>
    <!-- 加载jdbc属性文件 -->
    <context:property-placeholder location="classpath:jdbc.properties" />
    <!-- 配置数据库连接jdbc -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${jdbc.driver}"></property>
		<property name="url" value="${jdbc.url}"></property>
		<property name="username" value="${jdbc.username}"></property>
		<property name="password" value="${jdbc.password}"></property>
	</bean>
    <!-- myBatis配置 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 配置数据库表对应的java实体类 -->
        <property name="typeAliasesPackage" value="pojo" />
        <!-- 自动扫描mapper.xml, 当mapper.xml与mapper.java不在同一目录下时，此配置为必须 -->
        <property name="mapperLocations" value="classpath:mapper/*.xml" />
    </bean>
    <!--配置自动扫描mapper文件，包括扫描mapper.java以及同目录下的xml文件-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="mapper" />
    </bean>
</beans>

七、创建类

• 类结构图
  
• 1、pojo类Users.java

package pojo;

import org.springframework.beans.factory.annotation.Autowired;

public class Users {
	@Autowired //自动创建get,set方法
	private Integer uid;
	@Autowired //自动创建get,set方法
	private String uname;
	@Autowired //自动创建get,set方法
	private Integer uage;
	@Override
	public String toString() {
		return "Users [uid=" + uid + ", uname=" + uname + ", uage=" + uage + "]";
	}
	
}

• 2、接口UsersMapper.java

package mapper;

import pojo.Users;

public interface UsersMapper {
	Users selectByUname(String uname);
}

• 3、接口UsersService.java

package service;

import pojo.Users;

public interface UsersService {
	Users getUsersByUname(String uname);
}

• 4、UsersService.java的实现类UsersServiceImpl.java

package service.impl;
import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import mapper.UsersMapper;
import pojo.Users;
import service.UsersService;
@Service("usersService")
public class UsersServiceImpl implements UsersService {
	@Resource
	private UsersMapper usersMapper;
	public Users getUsersByUname(String uname) {
		Users users=usersMapper.selectByUname(uname);
		return users;
	}

}

八、配置UsersMapper.xml文件

注：由于maven项目中，src/main/java目录下的非.java文件均不会被编译到target中，所以这里如果将UsersMapper.xml文件创建到UsersMapper.java同位置，之后的test中将会报错"Invalid bound statement (not found)"。详情：Eclipse报错：Invalid bound statement (not found)
按照maven的结构，我们应该将UsersMapper.xml文件创建于java/main/resources/下，并创建一系列与UsersMapper.java包同名的文件夹来存放该xml文件

• UsersMapper.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="mapper.UsersMapper">
    <select id="selectByUname" parameterType="java.lang.String" resultType="Users">
        select * from users where uname = #{uname}
    </select>
</mapper>

九、编写测试

• UsersMapperTest.java

package mapper;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import pojo.Users;
import service.UsersService;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:mybatis_spring.xml")
public class UsersMapperTest {
	@Resource
	private UsersService usersService;
	@Test
	public void testSelectByid() {
		Users users=usersService.getUsersByUname("nys");
		System.out.println(users);
	}
}

• 整体项目结构
  

十、运行测试