初步使用mybatis

1.创建maven项目具体流程

1.1创建一个普通的maven项目

1.2删除src文件，将当前项目作为父工程

1.3导入依赖以及解决静态资源导出失败问题（build中配置resource）

       MySQL依赖、junit依赖、mybatis依赖,

 <dependencies>
        <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>8.0.15</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.3</version>
        </dependency>
    </dependencies>
​
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
​

 

1.4创建一个模块

1.5模块内创建核心配置文件(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>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value=""/>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/mqx/dao/UserMapper.xml"/>
    </mappers>
</configuration>

1.6配置xxMapper.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="com.mqx.dao.UserMapper">
<select id="findAll" resultType="com.mqx.entity.User">
     select * from user
  </select>
    <select id="findById" resultType="com.mqx.entity.User">
        select * from user where id = #{id}
    </select>
    <insert id="insertUser" parameterType="com.mqx.entity.User">
        insert into user (id,name,password) values (#{id},#{name},#{password})
    </insert>
    <update id="updateUser" parameterType="com.mqx.entity.User">
        update user set name=#{name},password=#{password} where id = #{id}
    </update>
    <delete id="deleteUser">
        delete from user where id=#{id}
    </delete>
</mapper>

 

1.7配置userMapper工具类

public class MybatisUtil {
    private static SqlSession sqlSession;
    public static SqlSession getSqlSession(){
        String resource = "mybatis-config.xml";
        InputStream inputStream = null;
        try {
            inputStream = Resources.getResourceAsStream(resource);
        } catch (IOException e) {
            e.printStackTrace();
        }
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
         sqlSession = sqlSessionFactory.openSession();
        return sqlSession;
    }
}
​

1.8测试

 @Test
    //查询所有数据
    public void selectAll(){
​
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = mapper.findAll();
        for (User user : users) {
            System.out.println(user);
        }
​
​
​
          sqlSession.close();
    }
    @Test
    public void selectById(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        //根据id查询数据
        User user = mapper.findById(4);
        System.out.println(user);
​
    }
​
    //添加用户
    @Test
    public void addUser(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        //插入数据
        User user = new User(3,"莫钦翔","123456");
        int re = mapper.insertUser(user);
        if (re>0){
            System.out.println("插入成功！");
        }else {
            System.out.println("插入失败！");
        }
        sqlSession.commit();
        sqlSession.close();
​
    }
​
    //修改用户信息
    @Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = new User(1,"股神","123123");
        int num = mapper.updateUser(user);
        if (num>0){
            System.out.println("修改成功！");
        }else {
            System.out.println("修改失败！");
        }
        sqlSession.commit();
        sqlSession.close();
    }
​
    //删除用户
    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int num = mapper.deleteUser(3);
        if (num>0){
            System.out.println("修改成功！");
        }else {
            System.out.println("修改失败！");
        }
        sqlSession.commit();
        sqlSession.close();
​
    }

1.9注意点

增删改需要提交事务

idea连接数据库时设置时区： 命令行： set global time_zone='+8:00';