Mybatis授课资料 - 精简.docxVIP

MybatisMybatis介绍MyBatis是支持普通SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis消除了几乎所有的JDBC代码和参数的手工设置以及对结果集的检索封装。MyBatis可以使用简单的XML或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录.JDBC-MyBatis-Hibernate数据库Model:实体类xmlmybatis快速入门编写第一个基于mybaits的测试例子:2.1. 添加jar包【mybatis】mybatis-3.1.1.jar【MYSQL驱动包】mysql-connector-java-5.1.7-bin.jar2.2.建库+表create database mybatis;use mybatis;CREATE TABLE users(id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), age INT);INSERT INTO users(NAME, age) VALUES(Tom, 12);INSERT INTO users(NAME, age) VALUES(Jack, 11);添加Mybatis的配置文件conf.xml?xml version=1.0 encoding=UTF-8?!DOCTYPE configuration PUBLIC -////DTD Config 3.0//EN /dtd/mybatis-3-config.dtdconfiguration!-- 从下面的多个environment中加载一个叫development的环境 --environments default=development!-- 开发模式 --environment id=development!-- 使用JDBC的事务处理，比如：提交、回滚 --transactionManager type=JDBC /!-- 使用缓存，用来避免创建新的连接实例时耗费的时间 --dataSource type=POOLEDproperty name=driver value=com.mysql.jdbc.Driver /property name=url value=jdbc:mysql://localhost:3306/mybatis /property name=username value=root /property name=password value=root //dataSource/environment/environments/configuration定义表所对应的实体类public class User {private int id;private String name;private int age; //get,set方法}定义操作users表的sql映射文件userMapper.xml?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN /dtd/mybatis-3-mapper.dtdmapper namespace=com.qst.mybatis_test.test1.userMapper!-- select：查询操作；id：标识；parameterType：接收的参数类型，resultType：返回值类型 --select id=getUser parameterType=int resultType=com.qst.mybatis_test.test1.Userselect * from users where id=#{id}/select/mapper在conf.xml文件中注册userMapper.xml文件!-- 注册映射文件 --mappersmapper resource=com/qst/mybatis_test/test1/userMapper.xml//mappers编写测试代码：执行定义的select语句public class Test {public static void main(String[] args) throws IOException {String resource = conf.xml; //加载mybatis的配置文件（它也加载关联的映射文件）Reader reader = Resources.getResourceAsReader(resource); //构建sqlSession的工厂SqlSessionFactory sessionFactory =