Spring MyBatis整合之Mapper代理和批量扫描

超、凢脫俗 2022-04-24 13:36 225阅读 0赞

目录结构

![20190426152443260.png][]

数据库配置文件db.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost/mytest
    jdbc.username=root
    jdbc.password=123456

MySQL数据库建表语句

CREATE TABLE `user` (
      `uid` int(15) NOT NULL AUTO_INCREMENT,
      `username` varchar(20) NOT NULL,
      `password` varchar(30) NOT NULL,
      `name` varchar(30) NOT NULL,
      `sex` varchar(5) NOT NULL,
      PRIMARY KEY (`uid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8;

日志log4j.properties

log4j.rootLogger=DEBUG,stdout
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

JavaBean类User.java

public class User {
    	private int uid; 
    	private String username;
    	private String password;
        private String name;
        private String sex;
    	public int getUid() {
    		return uid;
    	}
    	public void setUid(int uid) {
    		this.uid = uid;
    	}
    	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 String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getSex() {
    		return sex;
    	}
    	public void setSex(String sex) {
    		this.sex = sex;
    	}
    	@Override
    	public String toString() {
    		return "User [uid=" + uid + ", username=" + username + ", password=" + password + ", name=" + name + ", sex="
    				+ sex + "]";
    	}
    }

Spring全局配置文件applicationContext.xml

MyBatis全局配置文件SqlMapConfig.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>
     	<settings>
     		
     		<setting name="cacheEnabled" value="true"/>
     	</settings>
     	<mappers>
     	</mappers>
     
     </configuration>

Mapper接口UserMapper.java

public interface UserMapper {
        public User findUserById(int id)throws Exception;
    
    }

Mapper映射文件UserMapper.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.it.mapper.UserMapper">
    	
    	<cache />
    	<resultMap type="com.it.po.User" id="userMap">
    		<id property="uid" column="uid"/>
    		<result property="name" column="name"/>
    		<result property="username" column="username"/>
    		<result property="password" column="password"/>
    		<result property="sex" column="sex"/>
    	</resultMap>
    	<select id="findUserById" parameterType="int" resultMap="userMap" flushCache="true">
    		select * from user where uid=#{id};
    	</select>
    	
    </mapper>

测试类Test.java

package test;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import com.it.mapper.UserMapper;
    import com.it.po.User;
    
    public class Test {
    	
    	@org.junit.Test
    	public void findUserById() throws Exception {
    		ApplicationContext applicationContext =new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
    		UserMapper userMapper =(UserMapper) applicationContext.getBean("userMapper");
    		User user1 =userMapper.findUserById(94);
    		System.out.println(user1);
    		
    
    	}
    
    }

[20190426152443260.png]: /images/20220214/401c07bca1d948c9b7a53397ec0dbc86.png