mybatis初试

​ 引入mybatis、junit、log4j依赖

public class BookType implements Serializable {
    private Integer bookTypeId;
    private String bookTypeName;
    
    ...//手动实现无参  有参构造  getset方法   重写hashcode和equals  toString
}

CREATE TABLE `booktype` (
  `bookType_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '书籍类型id(主键)',
  `bookType_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '书籍的类型名称',
  PRIMARY KEY (`bookType_id`) USING BTREE
)

public interface BookTypeMapper {
    
    public BookType selectById(Integer id);
}

    
        SELECT BOOKTYPE_ID,BOOKTYPE_NAME FROM BOOKTYPE WHERe BOOKTYPE_ID=#{id}
    

//在创建BookTypeMapperTest之前，需要在mybatis-config.xml配置文件中添加以下代码
//
//    
//

//创建BookTypeMapperTest测试类
public class BookTypeMapperTest {

    @Test
    public void selectById() {
   		//1.读取mybatis的配置文件
        InputStream in = BookTypeMapperTest.class.getClassLoader().getResourceAsStream("mybatis-config.xml");
        //2.通过SqlSessionFactoryBuilder构建者得到SqlSessionFactory工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
        //3.通过SqlSessionFactory工厂得到SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //4.运用SqlSession执行方法得到结果
        BookType bookType = sqlSession.selectOne("abc.selectById",1);
        System.out.println(bookType);
        //5.关闭SqlSession
        sqlSession.close();
    }
}