mybatis学习二：配置mybatis，使用Mapper映射接口完成CURD

1、引入mybatis依赖：

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>

2、编写实体类：

package org.spring.teach.entity;

public class User {
 
    private Integer id;
    private String name;
    private String username;
    private String password;
    private String gender;
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    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 getGender() {
        return gender;
    }
 
    public void setGender(String gender) {
        this.gender = gender;
    }
 
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", gender='" + gender + '\'' +
                '}';
    }
}

3、编写Mapper映射接口：

package org.spring.teach.dao;

import org.spring.teach.entity.User;

import java.util.List;

public interface UserMapper {

    List<User> findAll();

    User findById(Integer id);

    int save(User user);

    int delete(Integer id);

    int update(User user);
}

4、编写Mapper.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="org.spring.teach.dao.UserMapper">
    <insert id="save" parameterType="User">
		insert into t_user values(t_user_seq.nextval,#{username},#{name},#{password},#{gender})
	</insert>

    <select id="findAll" resultType="User">
		select * from t_user
	</select>

    <select id="findById" parameterType="int" resultType="User">
        select * from t_user where id = #{id}
    </select>
    <update id="update" parameterType="User">
        update t_user set username = #{username},name = #{name},password = #{password},gender = #{gender} where id = #{id}
    </update>
    <delete id="delete" parameterType="int">
        delete from t_user where id = #{id1}
    </delete>
</mapper>

5、配置mybatis配置文件：

<?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>
    <!--<properties/>-->
    <settings>
        <!--用于配置sql运行时的日志输出，控制台可以输出当前执行的sql语句-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <!--用于给实体类配置别名-->
    <typeAliases>
        <typeAlias type="org.spring.teach.entity.User" alias="User"/>
    </typeAliases>
    <!--<typeHandlers/>
    <objectFactory type=""/>
    <objectWrapperFactory type=""/>
    <reflectorFactory type=""/>-->
    <!--配置数据库环境，可以配置多个环境，尽管可以配置多个环境，每个 SqlSessionFactory 实例只能选择其一-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 连接池的配置 -->
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.OracleDriver" />
                <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
                <property name="username" value="c##root" />
                <property name="password" value="c##root" />
            </dataSource>
        </environment>
    </environments>
    <!--<databaseIdProvider type=""/>-->
    <!-- 指定映射文件的位置 -->
    <mappers>
        <mapper resource="org/spring/teach/entity/UserMapper.xml" />
    </mappers>
</configuration>

6、测试：

注：需要调用sqlSession的getMapper(UserMapper.class);来获取dao。

public class TestCase {

    private SqlSession sqlSession;
    private UserMapper dao;

    @Before
    public void before() {
        SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder();
        SqlSessionFactory ssf = ssfb.build(TestCase.class.getClassLoader().getResourceAsStream("mybatisConfigure.xml"));
        sqlSession = ssf.openSession();
        dao = sqlSession.getMapper(UserMapper.class);
    }

    @After
    public void after() {
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void save() {
        User user = new User();
        user.setUsername("赵六");
        user.setName("赵六");
        user.setPassword("534634634");
        user.setGender("男");
        int row = dao.save(user);
        System.out.println(row);
    }

    @Test
    public void findAll() {
        List<User> list = dao.findAll();
        System.out.println(list);
    }

    @Test
    public void findById() {
        User user = dao.findById(1);
        System.out.println(user);
    }

    @Test
    public void update() {
        User user = new User();
        user.setId(62);
        user.setUsername("赵六");
        user.setName("赵六");
        user.setPassword("gfnvcvsdv");
        user.setGender("女");
        int row = dao.update(user);
        System.out.println(row);
    }

    @Test
    public void delete() {
        int row = dao.delete(64);
        System.out.println(row);
    }

}