Mybatis框架-01：快速入门实例（快速搭建一个Mybatis工程）

ゞ浴缸里的玫瑰 2022-02-05 13:45 375阅读 0赞

## 第一步：创建工程 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70][]

## 第二步：引入jar包 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70 1][]

## 第三步：数据库建表 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70 2][]

## 第四步：创建于数据库表对应的实体类 ##

@Setter@Getter
    public class Customer {
        private Integer cust_id;
        private String cust_name;
        private String cust_profession;
        private String cust_phone;
        private String email;
    
        @Override
        public String toString() {
            return "Customer{" +
                    "cust_id=" + cust_id +
                    ", cust_name='" + cust_name + '\'' +
                    ", cust_profession='" + cust_profession + '\'' +
                    ", cust_phone='" + cust_phone + '\'' +
                    ", email='" + email + '\'' +
                    '}';
        }
    }

## 第五步：创建核心配置文件SqlMappingConfig.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>
        
        <environments default="development">
            <environment id="development">
                
                <transactionManager type="JDBC" />
                
                <dataSource type="POOLED">
                    <property name="driver" value="com.mysql.jdbc.Driver" />
                    <property name="url"
                              value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />
                    <property name="username" value="root" />
                    <property name="password" value="123456" />
                </dataSource>
            </environment>
        </environments>
    
    
       
    </configuration>

## 第六步：创建类的映射文件Customer.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="myTest">
        
        <select id="queryCustomerById" parameterType="Int" resultType="com.ctbu.domain.Customer">
    	   SELECT * FROM `customer` WHERE cust_id  = #{cust_id}
    	</select>
    </mapper>

## 第七步：将创建的映射文件引入核心配置文件中 ##

<mappers>
            <mapper resource="com/ctbu/domain/Customer.xml"></mapper>
        </mappers>

## 第八步：编写测试类测试工程 ##

public class TestOne {
        @Test
        public void test1() throws IOException {
            //创建SqlSessionFactoryBuilder对象
            SqlSessionFactoryBuilder factoryBuilder = new SqlSessionFactoryBuilder();
            //加载核心配置文件
            InputStream inputStream = Resources.getResourceAsStream("SqlMappingConfig.xml");
            //创建SqlSessionFactory对象
            SqlSessionFactory sqlSessionFactory = factoryBuilder.build(inputStream);
            //创建session对象
            SqlSession session = sqlSessionFactory.openSession();
            //执行sqlsession对象执行查询
            //第一个参数是customer.xml的statement的id
            //第二额参数是执行sql需要的参数
            Customer customer = session.selectOne("queryCustomerById", 1);
    
            System.out.println(customer);
    
            session.close();
    
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70]: /images/20220205/dc1cc3c5e4d04834b5deb11a0e2eacd6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70 1]: /images/20220205/88d3134b2dc24da6a8891071f074fb71.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70 2]: /images/20220205/f73dd751109a452b96d39c527cc57bdf.png