Mybatis入门

1.搭建数据库

CREATE DATABASE	`mybatis`;
USE `mybatis`;
INSERT INTO `user` (`id`,`name`,pwd) VALUES(1,'张三','123456');
INSERT INTO `user` (`id`,`name`,pwd) VALUES(2,'李四','123456');
INSERT INTO `user` (`id`,`name`,pwd) VALUES(3,'王五','123456');

2、创建项目

• 2.1.新建普通maven项目
• 2.2.删除src目录
• 2.3.导入依赖

3、创建模块

• 3.1.编写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>

    <typeAliases>
        <package name="com.zhuo.pojo"/>
    </typeAliases>
    
    <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/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
        <!--每一个mapper.xml都需要在核心配置文件中配置-->
    <mappers>
        <mapper resource="org/mybatis/example/BlogMapper.xml"/>
    </mappers>
    
</configuration>

• 3.2编写mybatis工具类

public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory = null;
    static {
        try {
            //使用mybatis获取SqlsessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
    }
}

4、编写代码

• 实体类

    private int id;
    private String name;
    private String pwd;

    public User() {
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

• Dao接口

public interface UserDao {
    List<User> getUserList();
}

• 接口实现类 由原来的UserDaoImpl转换为DaoMapper.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">
<!--namaspace绑定一个对应的一个Dao/mapper接口-->
<mapper namespace="com.zhuo.dao.UserDao">
    <!--查询  id对应查询的方法名-->
    <select id="getUserList" resultType="com.zhuo.pojo.User">
        select * from user
    </select>
</mapper>

5、测试

• 注意点：Type interface com.zhuo.dao.UserDao is not known to the MapperRegistry.

• 资源过滤问题

• juint测试

public class UserTest {
    @Test
    public void test(){
        //第一步获取sqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //执行sql,要拿到sql，要么从mapper拿，要么从dao拿，返回结果集
        //方式一：getmapper
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> userList = mapper.getUserList();

        for (User user : userList) {
            System.out.println(user);
        }
        //关闭
        sqlSession.close();
    }
}

6.问题

### Error building SqlSession.
### The error may exist in com/zhuo/dao/UserMapper.xml
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.  Cause: org.xml.sax.SAXParseException; lineNumber: 6; columnNumber: 9; 2 字节的 UTF-8 序列的字节 2 无效

*原因：

新建mybatis项目时，在xml文件里面，特别是在复制之前的代码块或者有中文的代码块时，不管是否注释掉的，都要重新输入或者用utf-8的格式保存或者直接删掉

出错地方:
在xml的里面有一段中文，删除就可以了

• 配置文件没有注册
• 绑定接口错误
• 方法名不对
• 返回类型不对
• maven资源导出问题

8、curd

public interface UserDao {
    List<User> getUserList();
    User getUserById(int id);
    //增加一个用户
    int addUser(User user);
    //更改一个用户
    int updateUser(User user);
    //删除一个用户
    int deleteUser(int id);
}

<?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.zhuo.dao.UserDao">
    <select id="getUserList" resultType="com.zhuo.pojo.User">
        select * from user
    </select>
    <select id="getUserById" parameterType="int" resultType="com.zhuo.pojo.User">
        select * from user where id = #{id}
    </select>
    <insert id="addUser" parameterType="com.zhuo.pojo.User">
        insert into mybatis.user (id,name,pwd) value (#{id},#{name},#{pwd})
    </insert>
    <update id="updateUser" parameterType="com.zhuo.pojo.User">
        update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id};
    </update>
    <delete id="deleteUser">
        delete from mybatis.user where id = #{id};
    </delete>
</mapper>

    @Test
    public void test2(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.addUser(new User(5, "王者", "123456"));
        System.out.println(i);
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void test3(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        mapper.updateUser(new User(4,"哈哈","111111"));
        sqlSession.commit();
        sqlSession.close();
    }
  @Test
    public void test4(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        mapper.deleteUser(4);
        sqlSession.commit();
        sqlSession.close();
    }

• 注意：增删改需要事务提交