mybatis学习笔记二——基本实现

mybatis简单的执行代码实现

1.编写配置文件

mybatis-config.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>
    //引入外部properties文件
    <properties resource="jdbc.properties" />
    //配置别名
    <typeAliases>
        <package name="cn.itcast.pojo"/>
    </typeAliases>
       <!-- 配置数据库连接的环境 本项目只配置了一个，可配置多个 -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
            </dataSource>
        </environment>
    </environments>
    <!--指定所有的Mapper映射文件-->
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

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="cn.itcast.mapper.UserMapper">
  
    <!--结果集映射配置
        id：这个结果集的唯一标识，不可重复
        type：这个映射所表示的java对象类型，可以用别名
    -->
    <resultMap id="userResultMap" type="User">
        <!--配置主键信息
            property：主键在java中的属性名
            column：主键在数据库中的列命
        -->
        <id property="id" column="id"/>
        <!--配置普通字段信息 解决列名和字段名不匹配的问题-->
        <!--<result property="userName" column="user_name"/>-->
    </resultMap>

    
    <!-- 这里定义一条SQL语句，其实就是一个statement
		select：代表是一条查询的SQL，我们还可以定义：update\insert\delete
			id: 这个statement的唯一标示，自定义，但是不能重复
			parameterType：SQL参数类型，这里要写类的全名
			resultType：返回结果类型，这里写类的全名
	 -->
    <select id="queryUserById" parameterType="java.lang.Long" resultType="userResultMap">
        SELECT <include refid="CommonSql.commonSql"/> FROM tb_user WHERE id = #{id}
    </select>
    <!--查询所有用户：
        resultType:返回的结果虽然是一个List，这里依然写List中的元素类型，Mybatis会自动判断返回值个数并且做封装
    -->
    <select id="queryAll" resultType="User">
        SELECT <include refid="CommonSql.commonSql"/>  FROM tb_user
    </select>
    <!--添加用户-->
    <insert id="insertUser" parameterType="User" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
        INSERT INTO tb_user (
			id,
			user_name,
			password,
			name,
			age,
			sex,
			birthday,
			created,
			updated
		)
		VALUES
			(
				NULL,
				#{userName},
				#{password},
				#{name},
				#{age},
				#{sex},
				#{birthday},
				NOW(),
				NOW()
			);

    </insert>
    <!--修改用户-->
    <update id="updateUser" parameterType="User">
        UPDATE tb_user
		SET
			user_name = #{userName},
			password = #{password},
			name = #{name},
			age = #{age},
			sex = #{sex},
			birthday = #{birthday},
			updated = NOW()
		WHERE
			id = #{id};

    </update>
    <!--删除用户-->
    <delete id="deletUserById" parameterType="Long">
        DELETE FROM tb_user  WHERE id =#{id};
    </delete>
   
    
</mapper>

其中<include refid="CommonSql.commonSql"/> 引入外部sql片段。

2.书写dao层接口

UserDao.java

package cn.itcast.test;

import cn.itcast.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserDao {
    /**
     * 根据id查询用户
     * @param id
     * @return
     */
    User queryUserById(Long id);

    /**
     * 查询全部用户
     * @return
     */
    List<User> queryAll();

    /**
     * 添加用户
     * @param user
     */
    void insertUser(User user);

    /**
     * 修改用户
     * @param user
     */
    void updateUser(User user);

    /**
     * 根据id删除用户
     * @param id
     */
    void deletUserById(Long id);


}

3.书写dao的实现类

UserDaoImpl.java

import cn.itcast.pojo.User;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

public class UserDaoImpl implements UserDao {
    private SqlSession sqlSession;
    //通过构造函数接收sqlsession
    public UserDaoImpl(SqlSession sqlSession) {
        this.sqlSession = sqlSession;
    }

    /**
     * 根据id查询用户
     *
     * @param id
     * @return
     */
    public User queryUserById(Long id) {
        return sqlSession.selectOne("userDao.queryUserById",id);
    }

    /**
     * 查询全部用户
     *
     * @return
     */
    public List<User> queryAll() {
        return sqlSession.selectList("userDao.queryall");
    }

    /**
     * 添加用户
     *
     * @param user
     */
    public void insertUser(User user) {
        sqlSession.insert("userDao.insertUser",user);
    }

    /**
     * 修改用户
     *
     * @param user
     */
    public void updateUser(User user) {
        sqlSession.update("userDao.updateUser",user);
    }

    /**
     * 根据id删除用户
     *
     * @param id
     */
    public void deletUserById(Long id) {
        sqlSession.delete("userDao.deleteUserById",id);
    }
}

4.编写测试类

import cn.itcast.pojo.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.Date;
import java.util.List;

public class UserDaoTest {
    private UserDao userDao;
    @Before
    public void setUp() throws Exception {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession(true);
        this.userDao = new UserDaoImpl(session);
    }

    @Test
    public void queryUserById() {
        User user = userDao.queryUserById(1L);
        System.out.println(user);
    }

    @Test
    public void queryAll() {
        List<User> list = userDao.queryAll();
        for (User user : list) {
            System.out.println(user);
        }
    }
    @Test
    public void insertUser() {
        User user = new User();
        user.setAge(16);
        user.setBirthday(new Date());
        user.setName("张安");
        user.setPassword("123456");
        user.setSex(2);// 2代表女性
        user.setUserName("xiaoyingying");

        // 插入用户
        userDao.insertUser(user);

    }

    @Test
    public void updateUser() {
        User user = userDao.queryUserById(10L);
        user.setAge(55);
        userDao.updateUser(user);
    }

    @Test
    public void deletUserById() {
        userDao.deletUserById(13L);
    }
}