Mybatis笔记.docx

Mybatis入门Mybatis开发步骤：导入jar包。D:\GS\Hibernate\02Hibernate-MyBatis\lib\c3p0-.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\ehcache-core-2.6.8.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\log4j-1.2.17.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\mchange-commons-java-.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\mybatis-3.2.7.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\mybatis-ehcache-1.0.3.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\mysql-connector-java-5.1.21.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\slf4j-api-1.7.5.jarD:\GS\Hibernate\02Hibernate-MyBatis\lib\slf4j-log4j12-1.7.5.jar建立好包结构，导入junit库。拷贝一个mybatis-config.xml文件，修改里面的跟数据库连接相关的参数。?xml version=1.0 encoding=UTF-8 ?!DOCTYPE configurationPUBLIC -////DTD Config 3.0//EN/dtd/mybatis-3-config.dtdconfiguration!-- 加载外部的资源文件 --properties resource=perties/properties!-- settingssetting name=cacheEnabled value=true//settings --!-- 定义一些别名 --!-- typeAliasestypeAlias type=cn.domain.Person alias=person//typeAliases --!-- 声明数据连接环境 --environments default=developmentenvironment id=developmenttransactionManager type=JDBC /dataSource type=POOLEDproperty name=driver value=${driverClass} /property name=url value=${jdbcUrl} /property name=username value=${user} /property name=password value=${password} //dataSource/environment/environmentsmappers!-- 映射文件mapper resource=cn/cache/cache.xml/ --/mappers/configurationmybatis框架不像Hibernate那样能够自动生成表，他必须提前建好表。Create table book(id int ,name varchar(22),page int primarykey(id))建立一个实体类：Book.javapublic class Book {private int id;private String name;private int page;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) { = name;}public int getPage() {return page;}public void setPage(int page) {this.page = page;}}注意一定要保证数据库列名和实体的属性名按照规范对应，即如果出现下划线就用驼峰结构。定义一个关于实体的配置文件，一般是xml文件?xml version=1.0 encoding=UTF-8 ? !DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN /dtd/mybatis-3-mapper.dtd!-- namespace必须定义，非绑定到类或是接口的方式 --mapper names