第一个Mybatis项目,查询全部信息(第一期)

在开始框架的学习前,我们需要先搭好环境,在Eclipse上安装好Tomcat服务器,这里我自己用的是8.5

创建数据库CREATE DATABASE IF NOT EXISTS bookdb DEFAULT CHARSET=UTF8;
新建books表,创建id,书名,作者,类别四个字段,建表代码如下:

CREATE TABLE IF NOT EXISTS books(
id INT(20) PRIMARY KEY AUTO_INCREMENT,
bookname VARCHAR(20),
author VARCHAR(20),
category VARCHAR(10)
)DEFAULT CHARSET=UTF8;

插入几条数据:

INSERT INTO books VALUES(1,'克苏鲁神话','洛夫克拉夫特','恐怖');
INSERT INTO books VALUES(2,'三体','刘慈欣','科幻');
INSERT INTO books VALUES(3,'财务诡计','霍华德施利特','金融');
INSERT INTO books VALUES(4,'红书','荣格','心理');

完整表格:

新建一个动态Web项目mybatis01
创建完成后将SSM框架需要用到的jar包导入到lib这个文件夹里然后选择全部jar包点击Build path构建好路径
这里是我自己用的jar包,全部如下:

现在我们的环境基本搭建完毕,就可以开始愉快的学习了

配置log4j

在src下创建log4j.properties,代码如下:

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.jiheng=DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

创建实体类entity

新建com.jiheng.entity包,创建实体类Book:

package com.jiheng.entity;

public class Book {
  private int id;
  private String bookname;
  private String author;
  private String category;
  
  public Book(){}
  
  public Book(int id,String bookname,String author,String category){
	  this.id = id;
	  this.bookname = bookname;
	  this.author = author;
	  this.category = category;
  }
  /*构造方法*/

public int getId() {
	return id;
}

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

public String getBookname() {
	return bookname;
}

public void setBookname(String bookname) {
	this.bookname = bookname;
}

public String getAuthor() {
	return author;
}

public void setAuthor(String author) {
	this.author = author;
}

public String getCategory() {
	return category;
}

public void setCategory(String category) {
	this.category = category;
}
/*get set方法*/  

public void show(){
	System.out.println("编号:"+id+"--书名:"+bookname+"--作者:"+author+"--分类:"+category);
}
/*遍历一本书的信息*/
}

Mybatis主配置文件

在src下创建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>   
	<!-- 配置环境,默认环境id为development -->
	<environments default="development">
		<environment id="development">
		<!-- 配置事务管理类型为 JDBC -->
			<transactionManager type="JDBC"/>
			<!-- 配置数据源类型为连接池 -->
			<dataSource type="POOLED">
			<!-- 分别配置数据库连接的驱动,url,用户名,密码 -->
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://localhost:3306/bookdb?characterEncoding=utf8"/>
				<property name="username" value="root"/>
				<property name="password" value="123456"/>
			</dataSource>
		</environment>
	</environments>	
	<!-- 配置映射文件的位置,可以有多个映射文件 -->	
	<mappers>
		<mapper resource="com/jiheng/dao/BookMapper.xml"/>
	</mappers>
</configuration>

根据实际业务修改一下用户名密码,数据库名字端口号就行了,没什么好说的

数据访问层Dao

新建com.jiheng.dao包,创建IBookDao接口代码如下:

package com.jiheng.dao;

import java.util.List;

import com.jiheng.entity.Book;

public interface IBookDao {
   public List<Book> findAllBooks();//查找全部书籍
}

一并创建Book的映射文件BookMapper.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.jiheng.dao.IBookDao">	 	
 	<select id="findAllBooks" resultType="com.jiheng.entity.Book">
		SELECT * FROM books
 	</select>
</mapper>

在mapper标签里面写好增删改查语句就OK

创建接口的实现类IBookDaoImpl如下:

package com.jiheng.dao;

import java.io.IOException;
import java.io.Reader;
import java.util.ArrayList;
import java.util.List;

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 com.jiheng.entity.Book;

public class IBookDaoImpl implements IBookDao {

	@Override
	public List<Book> findAllBooks() {
		SqlSession session = null;
		List<Book> list = new ArrayList<Book>();
		try {
			//1.读取主配置文件mybatis-config.xml
			String resource = "mybatis-config.xml";
			Reader reader = Resources.getResourceAsReader(resource);
			//2.根据主配置文件mybatis-config.xml构建SqlSessionFactory对象factory
			SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
			SqlSessionFactory factory = builder.build(reader);
			//3.根据SqlSessionFactory对象创建SqlSession对象session
			session = factory.openSession();
			//4.调用SqlSession对象session的selectList方法执行查询数据库的操作，返回映射后的结果集合
			list = session.selectList("com.jiheng.dao.IBookDao.findAllBooks");			
		} catch (IOException e1) {
			e1.printStackTrace();
		}finally {
			session.close();
		}
		return list;
	}

}

测试代码

创建com.jiheng.test包并创建测试类TestBook01:

package com.jiheng.test;


import java.util.List;

import com.jiheng.dao.IBookDao;
import com.jiheng.dao.IBookDaoImpl;
import com.jiheng.entity.Book;

public class TestBook01 {

	public static void main(String[] args) {
       findAllBooks();
	}

	public static void findAllBooks(){
		IBookDao bookDao = new IBookDaoImpl();
		List<Book> list = bookDao.findAllBooks();
		   for(int i=0;i<list.size();i++){
			   list.get(i).show();
		   }
	}
}

好了,到此通过Mybatis查找全部书籍信息的功能就完成了,运行测试类,结果如下:
项目结构可以参考下图