Mybatis教程..docxVIP

MybatisMybatis介绍(ibatis)MyBatis是支持普通SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis消除了几乎所有的JDBC代码和参数的手工设置以及对结果集的检索封装。MyBatis可以使用简单的XML或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录.JDBC-dbutils(自动封装)-MyBatis-Hibernatesession.get(Class c, id);//查找映射文件(全类名—表名, 属性名与表字段名)/表 select * from users where id=?User user = session.getSession(userClass, id)user.setName(“tt”); flush()//脏数据检查 clear();mybatis快速入门编写第一个基于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.dtdconfigurationenvironments default=developmentenvironment id=developmenttransactionManager 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.dtd mapper namespace=com.softeem.mybatis_test.test1.userMapper select id=getUser parameterType=int resultType=com.softeem.mybatis_test.test1.Userselect * from users where id=#{id}/select/mapper在conf.xml文件中注册userMapper.xml文件mappersmapper resource=com/softeem/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 sessionFact