伯远帖 - Java Spring 4.0 集成 MyBatis 3.1 支持

1. pom.xml 添加MySQL组件

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

2. User.java定义User对象

package com.orm.mybatis;

public class User {
	private String sysVersion;
	private String mysqlVersion;
	
	public String getSysVersion() {
		return sysVersion;
	}
	
	public void setSysVersion(String sysVersion) {
		this.sysVersion = sysVersion;
	}
	
	public String getMysqlVersion() {
		return mysqlVersion;
	}
	
	public void setMysqlVersion(String mysqlVersion) {
		this.mysqlVersion = mysqlVersion;
	}
	
	public String toString() {
		return "sys_version\t" + sysVersion
				+ "\r\nmysql_version\t" + mysqlVersion;
	}
}

3. UserDao.java定义“对象-关系映射”

package com.orm.mybatis;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserDao {
	public List<User> selectAll();
}

4. UserMapper.xml描述“对象-关系映射”

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">

<mapper namespace="com.orm.mybatis.UserDao">
	<resultMap id="BaseResultMap" type="com.orm.mybatis.User">
        <result column="sys_version" property="sysVersion" jdbcType="CHAR" />
        <result column="mysql_version" property="mysqlVersion" jdbcType="CHAR" />
    </resultMap>

	<select id="selectAll" resultMap="BaseResultMap">
		SELECT * FROM version
	</select>
</mapper>

5. UserService.java定义查询服务界面

package com.orm.mybatis;

import java.util.List;

public interface UserService {
	public List<User> selectAll();
}

6. UserServiceImpl.java

package com.orm.mybatis;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
// import javax.annotation.Resource;
import org.springframework.stereotype.Service;

// import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl
	implements UserService {

	@Autowired
	private UserDao userDao;
	
	@Override
	public List<User> selectAll() {
		return userDao.selectAll();
	}
}

7. 测试类 DemoApplicationTests.java

package com.orm.mybatis;

import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

@RunWith(SpringRunner.class)
@SpringBootTest
public class DemoApplicationTests {

	@Autowired  
    private UserService userService;
	@Test
	public void contextLoads() {
		System.out.println("Hello Test !");
		List<User> userList = userService.selectAll();
		for(User user : userList) {
			System.out.println(user);
		}
	}

}

application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/sys
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.orm.mybatis