第3关：MyBatis的XML方式实现增删改查

任务描述

通过上一关的学习，相信大家对MyBatis都有一定的了解了吧。既然我们要用MyBtis来操作数据库，那么我们就要学会最基本的增删改查。本关我将教会大家如何用MyBatis的XML方式实现增删改查。

本关任务：用MyBatis配置XML方式实现对MySQL表t_user中的用户数据进行增删改查。

相关知识

为了完成本关任务，你需要掌握：

• XML方式；

• XML中常见标签和属性的用法。

mya/src/main/resources/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>
    <!--********** Begin **********-->

    <!--给pojo包起别名-->
    <typeAliases>
        <package name="com.test.pojo"/>
    </typeAliases>
    <!--配置数据库连接环境-->
    <environments default="development">
        <environment id="development">
        <!-- 使用JDBC事务管理 -->
            <transactionManager type="JDBC"/>
            <!-- 数据库连接池 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydb?useUnicode=true&amp;characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123123"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 加载映射文件(xml文件) -->
    <mappers>
    <mapper resource="mapper/UserMapper.xml"/>
    </mappers>

    <!--********** End **********-->


</configuration>

mya/src/main/java/com/test/mapper/UserMapper.java

package com.test.mapper;

import com.test.pojo.User;

import java.util.List;

public interface UserMapper {
 /*********** Begin **********/
    //添加user
   int insert(User user);
    //修改user
   int updateUser(User user);
    //删除user
   boolean deleteUser(int userId);
    //查询user
   List<User> selectUser();
 /*********** End **********/
}

mya/src/main/resources/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">
<!--********** Begin **********-->
	<!-- 命名空间 -->
<mapper namespace="com.test.mapper.UserMapper">

    <!-- 插入user方法 -->
    <insert id="insert" parameterType="User">
        insert into t_user(userId,userName,passWord)
        values(#{userId},#{userName},#{passWord})
    </insert>

    <!-- 修改user方法 -->
    <update id="updateUser" parameterType="User">
        update t_user set
            userName = #{userName},
            passWord = #{passWord}
            where userId = #{userId}
    </update>

    <!-- 删除方法 -->
    <delete id="deleteUser" parameterType="int">
        delete from t_user where UserId = #{UserId}
    </delete>

    <!-- 查询方法 -->
    <select id="selectUser" resultType="User">
        select * from t_user
    </select>

</mapper>
<!--********** End **********-->

mya/src/main/java/com/test/test/UserTest.java

package com.test.test;
import com.test.mapper.UserMapper;
import com.test.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 java.io.IOException;
import java.io.Reader;
import java.util.List;

public class UserTest {
    
    /*********** Begin **********/
    private static SqlSessionFactory sqlSessionFactory;
    //初始化
    public static void init() {
        try {
            Reader reader = Resources.getResourceAsReader("mybatis_config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    /*********** End **********/
    //添加数据
    public static int insertUser(User user) {
        /*********** Begin **********/
        init();
        SqlSession sqlSession = null;
        int line = 0;
        try {
            sqlSession = sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            line = mapper.insert(user);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return line;
        /*********** End **********/
    }

    //修改数据
    public static int updateUser(User user) {
        /*********** Begin **********/
        init();
        SqlSession sqlSession = null;
        int line = 0;
        try {
            sqlSession = sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            line = mapper.updateUser(user);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return line;
        /*********** End **********/
    }

    //删除数据
    public static boolean deleteUser(int userId) {
        /*********** Begin **********/
        init();
        SqlSession sqlSession = null;
        boolean res = false;
        try {
            sqlSession = sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            res = mapper.deleteUser(userId);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return res;
        /*********** End **********/
    }

    //查询数据
    public static List<User> selectUser() {
        /*********** Begin **********/
        init();
        SqlSession sqlSession = null;
        List<User> res = null;
        try {
            sqlSession = sqlSessionFactory.openSession();
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            res = mapper.selectUser();
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (sqlSession != null) {
                sqlSession.close();
            }
        }
        return res;
        
        /*********** End **********/
    }

}