MyBatis细细研磨(1)——快速构建

1. 在mysql中创建一个mybatis库，设置字符集为UTF8

create database mybatis default character set utf8;

2. 创建表bd_user

CREATE TABLE `bd_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

3. 创建maven项目,添加必要的依赖

<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.45</version>
</dependency>
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.5</version>
</dependency>

4.创建实体类

public class User {

    private Long id;    
    private String name;    
    private Integer age;
       //省略getter和setter
}

4. 创建主配置文件

<?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>
    <environments default="develop">
        <environment id="develop">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>          
            </dataSource>
        </environment>
    </environments>
    
</configuration>

5. 创建映射文件

<?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.funshion.dao.UserDao">
    <insert id="insert">
        insert into bd_user(id,name,age) values(#{id},#{name},#{age})
    </insert>
</mapper>

6. 将映射关系添加到主配置中

<mappers>
    <mapper resource="mapper/UserDao.xml"/>
</mappers>

7.测试

public class MyBatisTest {
    
    private static SqlSessionFactory sqlSessionFactory;
    
    private SqlSession sqlSession;

    @BeforeClass
    public static void init() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
    }
    
    @Before
    public void setUp() {
        sqlSession = sqlSessionFactory.openSession();
    }
    
    @Test
    public void test01() {
        User user = new User();
        user.setId(1l);
        user.setAge(10);
        user.setName("张三");
        sqlSession.insert("com.funshion.dao.UserDao.insert", user);
        sqlSession.commit();
    }
        
    @After
    public void tearDown() {
        sqlSession.close();
    }
    
    
}

8. 项目结构

项目结构