初学Mybatis01

Mybatis入门

创建maven项目导入依赖

创建对应的实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Integer id;
    private String username;
    private String password;
    private String email;
    private String tel;
}

编写UserDao

package com.mybatiss.dao;

import com.mybatiss.entity.User;

public interface UserDao {

    User getUserById(Integer id);

    int addUser(User user);

    int updateUser(User user);

    int delUser(Integer id);

    User getUser(Integer id, String username);
}

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>
    <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/bbb" />
                <property name="username" value="root" />
                <property name="password" value="root" />
            </dataSource>
        </environment>
    </environments>

    <!--对应实体类的配置映射-->
    <mappers>
        <mapper resource="mapper/UserMapping.xml"></mapper>
    </mappers>
</configuration>

创建映射文件

<?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.mybatiss.dao.UserDao">
    <select id="getUserById" parameterType="int" resultType="com.mybatiss.entity.User">
        select * from user where id=#{id}
    </select>
    <insert id="addUser">
        insert into user values(#{id},#{username},#{password},#{email},#{tel})
    </insert>

    <update id="updateUser">
        update user set username = #{username},password = #{password},email = #{email},tel = #{tel} where id = #{id}
    </update>

    <delete id="delUser">
        delete from user where id = #{id}
    </delete>
    
    <select id="getUser" resultType="com.mybatiss.entity.User">
        select * from user where id = #{param1} and username = #{param2}
    </select>
</mapper>

创建测试

package com.mybatiss.test;

import com.mybatiss.dao.UserDao;
import com.mybatiss.entity.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;

public class Test2 {

    public static void main(String[] args) throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        UserDao userDao = session.getMapper(UserDao.class);
        User user = userDao.getUserById(2);
        System.out.println(user);
        /*int i = userDao.addUser(new User(null, "xxzx", "12332", "23435@qq.com", "1293791374"));
        session.commit();
        System.out.println(i);*/
       /* userDao.updateUser(new User(148, "xxzx", "12332", "23435@qq.com", "1293791374"));
        session.commit();*/

        /*int i = userDao.delUser(148);
        session.commit();*/

       /* User user22 = userDao.getUser(2, "李思思");
        System.out.println(user22);*/
    }
}

常见错误

数据库时区错误

解决方案：在数据库的url后加入时区

jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai

mapper.xml配置错误

原因：上图原因是配置的问题，有两种情况，按需修改下图蓝线位置

解决方案：
情况1：主配置文件Mybatis-config.xml的mapper配置错误

情况2：UserMapper.xml resultType全路径写错

main方法测试报错

解决方案：推荐使用Junit测试单元，也有可能是maven和idea的版本不兼容问题，可以尝试降低版本

参数不对应错误

UserMapper.xml里面的参数与调用时不对应

解决方案1：UserDao中方法参数添加注解

 User getUser(@Param("id") Integer id,@Param("username") String username);

解决方案2：UserMapper.xml中使用参数占位符

<select id="getUser" resultType="com.mybatiss.entity.User">
    select * from user where id = #{param1} and username = #{param2}
</select>