项目结构（所需jar包，配置文件）
sqlMapConfig.xml的配置内容如下：
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEconfiguration
PUBLIC"-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--开启延迟加载 -->
<settings>
<!--全局的延迟加载的开关必须要开启 -->
<setting name="lazyLoadingEnabled" value="true"/>
<!--积极加载设置成false -->
<setting name="aggressiveLazyLoading" value="false"/>
<!--开启二级缓存,缓存中只要是需要配置的针对的都是二级缓存 -->
<setting name="cacheEnabled" value="true"/>
</settings>
<typeAliases>
<!--
自定义别名：
type:要定义别名的数据类型
alias：别名的内容
-->
<!--
非自定义别名：
在jdk中的所用的类的别名直接只用类名即可（不区分大小写）
如果是基本数据类型的包装类还可以使用基本数据类型的名字
-->
<typeAlias type="com.rl.model1.QueryCondition" alias="qc"/>
<typeAlias type="com.rl.model1.Person" alias="person"/>
</typeAliases>
<!--数据库的环境的配置 -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property 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="123456"/>
</dataSource>
</environment>
</environments>
<!--集中管理表的映射文件 -->
<mappers>
<mapperresource="com/rl/mapper/PersonTestMapper.xml"/>
<mapperresource="com/rl/mapper/PersonMapper.xml"/>
<mapperresource="com/rl/mapper/RoleMapper.xml"/>
<mapperresource="com/rl/mapper/OrdersMapper.xml"/>
<mapperresource="com/rl/mapper/OrderDetailMapper.xml"/>
</mappers>
</configuration>
sqlMapGenerator.xml的配置如下：
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEgeneratorConfigurationPUBLIC"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!--指定mysql的驱动包的路径，不要放在中文路径下 -->
<classPathEntrylocation="E:\MyEclipse10\MyBatis\lib\mysql-connector-java-5.0.8-bin.jar"/>
<!--配置数据源和生成的代码所存放的位置 -->
<contextid="context1">
<commentGenerator>
<!--去除自动生成的注释 -->
<propertyname="suppressAllComments"value="true"/>
</commentGenerator>
<jdbcConnection
driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://127.0.0.1:3306/mybatis"
userId="root"
password="123456"/>
<!--所生成的实体类的位置默认资源包src -->
<javaModelGeneratortargetPackage="com.rl.model1"
targetProject="mybatis0420"/>
<!--所生成的sqlMap的影射文件的位置,默认资源包src -->
<sqlMapGeneratortargetPackage="com.rl.mapper"
targetProject="mybatis0420"/>
<!--为哪些表生成代码 tableName:表名 schema:不用填写,其余属性是禁用例子查询的生成 -->
<tableschema=""tableName="role"enableCountByExample="false"
enableUpdateByExample="false"enableDeleteByExample="false"
enableSelectByExample="false"selectByExampleQueryId="false"/>
<tableschema=""tableName="person_role"enableCountByExample="false"
enableUpdateByExample="false"enableDeleteByExample="false"
enableSelectByExample="false"selectByExampleQueryId="false"/>
</context>
</generatorConfiguration>
log4j.properties的配置内容如下：
log4j.rootLogger=DEBUG,Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d[%t]%-5p[%c]-%m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
ehcache.xml的配置内容如下：
<ehcachexmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:noNamespaceSchemaLocation="../config/ehcache.xsd">
<diskStorepath="java.io.tmpdir"/>
<defaultCache
maxElementsInMemory="10000"
eternal="false"
timeToIdleSeconds="120"
timeToLiveSeconds="120"
maxElementsOnDisk="10000000"
diskExpiryThreadIntervalSeconds="120"
memoryStoreEvictionPolicy="LRU">
<persistencestrategy="localTempSwap"/>
</defaultCache>
</ehcache>
4 数据库表
创建数据库：create databasemybatis; use mybatis;
订单.sql
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2014/8/7 15:34:20 */
/*==============================================================*/
drop table if exists ORDERS;
drop table if exists ORDER_DETAIL;
/*==============================================================*/
/* Table: ORDERS */
/*==============================================================*/
create table ORDERS
(
ORDER_ID int(10) not null auto_increment,
PERSON_ID int(10),
TOTAL_PRICE float(10,2),
ADDR varchar(50),
primary key (ORDER_ID)
);
/*==============================================================*/
/* Table: ORDER_DETAIL */
/*==============================================================*/
create table ORDER_DETAIL
(
DETAIL_ID int(10) not null auto_increment,
ORDER_ID int(10),
PRICE float(10,2),
QUANTITY int(10),
ITEM_NAME varchar(10),
primary key (DETAIL_ID)
);
角色表.sql
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2014/8/7 16:28:01 */
/*==============================================================*/
drop table if exists PERSON_ROLE;
drop table if exists ROLE;
/*==============================================================*/
/* Table: PERSON_ROLE */
/*==============================================================*/
create table PERSON_ROLE
(
PERSON_ID int(10),
ROLE_ID int(10)
);
/*==============================================================*/
/* Table: ROLE */
/*==============================================================*/
create table ROLE
(
ROLE_ID int(10) not null auto_increment,
ROLE_NAME varchar(10),
DESCRIPT varchar(50),
primary key (ROLE_ID)
);
人员表.sql
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2014/8/7 9:59:18 */
/*==============================================================*/
drop table if exists PERSON;
/*==============================================================*/
/* Table: PERSON */
/*==============================================================*/
create table PERSON
(
PERSON_ID int(10) not null auto_increment,
NAME varchar(10),
GENDER varchar(1),
PERSON_ADDR varchar(50),
BIRTHDAY date,
primary key (PERSON_ID)
);
人员测试表.sql
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2014/8/7 9:15:56 */
/*==============================================================*/
drop table if exists PERSON_TEST;
/*==============================================================*/
/* Table: PERSON_TEST */
/*==============================================================*/
create table PERSON_TEST
(
ID int(10) not null auto_increment,
NAME varchar(10),
GENDER varchar(1),
ADDRESS varchar(50),
BIRTHDAY date,
primary key (ID)
);
7JavaBean的编写
Person.java
package com.rl.model;
import java.util.Date;
publicclass Person implements Serializable{
private Integerid;
private Stringname;
private Stringgender;
private Stringaddress;
private Datebirthday;
public Integer getId() {
returnid;
}
publicvoid setId(Integer id) {
this.id = id;
}
public String getName() {
returnname;
}
publicvoid setName(String name) {
this.name = name;
}
public String getGender() {
returngender;
}
publicvoid setGender(String gender) {
this.gender = gender;
}
public String getAddress() {
returnaddress;
}
publicvoid setAddress(String address) {
this.address = address;
}
public DategetBirthday() {
returnbirthday;
}
publicvoid setBirthday(Date birthday) {
this.birthday = birthday;
}
@Override
public String toString() {
return"Person [id=" +id +", name=" +name +", gender=" +gender
+", address=" +address +", birthday=" +birthday +"]";
}
}
OrderDetail.java
package com.rl.model1;
publicclass OrderDetail {
private IntegerdetailId;
private IntegerorderId;
private Floatprice;
private Integerquantity;
private StringitemName;
public Integer getDetailId() {
returndetailId;
}
publicvoid setDetailId(Integer detailId) {
this.detailId = detailId;
}
public Integer getOrderId() {
returnorderId;
}
publicvoid setOrderId(Integer orderId) {
this.orderId = orderId;
}
public Float getPrice() {
returnprice;
}
publicvoid setPrice(Float price) {
this.price = price;
}
public Integer getQuantity() {
returnquantity;
}
publicvoid setQuantity(Integer quantity) {
this.quantity = quantity;
}
public String getItemName() {
returnitemName;
}
publicvoid setItemName(String itemName) {
this.itemName = itemName;
}
}
Orders.java
package com.rl.model1;
import java.util.List;
publicclass Orders {
private IntegerorderId;
private IntegerpersonId;
private FloattotalPrice;
private Stringaddr;
private List<OrderDetail>detailList;
private Personperson;
public Person getPerson() {
returnperson;
}
publicvoid setPerson(Person person) {
this.person = person;
}
public List<OrderDetail> getDetailList() {
returndetailList;
}
publicvoid setDetailList(List<OrderDetail> detailList) {
this.detailList = detailList;
}
public Integer getOrderId() {
returnorderId;
}
publicvoid setOrderId(Integer orderId) {
this.orderId = orderId;
}
public Integer getPersonId() {
returnpersonId;
}
publicvoid setPersonId(Integer personId) {
this.personId = personId;
}
public Float getTotalPrice() {
returntotalPrice;
}
publicvoid setTotalPrice(Float totalPrice) {
this.totalPrice = totalPrice;
}
public String getAddr() {
returnaddr;
}
publicvoid setAddr(String addr) {
this.addr = addr;
}
}
Person.java
package com.rl.model1;
import java.io.Serializable;
import java.util.Date;
import java.util.List;
import javax.management.relation.Role;
/**
*做二级缓存的时候需要实现Serializable
*/
public class Person implements Serializable {
private static final long serialVersionUID = 7728191033619971201L;
private Integer personId;
private String name;
private String gender;
private String personAddr;
private Date birthday;
private List<Orders> ordersList;
private List<Role> roleList;
public List<Role> getRoleList() {
return roleList;
}
public void setRoleList(List<Role> roleList) {
this.roleList = roleList;
}
public List<Orders> getOrdersList() {
return ordersList;
}
public void setOrdersList(List<Orders> ordersList) {
this.ordersList = ordersList;
}
public Integer getPersonId() {
return personId;
}
public void setPersonId(Integer personId) {
this.personId = personId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getPersonAddr() {
return personAddr;
}
public void setPersonAddr(String personAddr) {
this.personAddr = personAddr;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
@Override
public String toString() {
return "Person [personId=" + personId + ", name=" + name + ", gender="
+ gender + ", personAddr=" + personAddr + ", birthday="
+ birthday + "]";
}
}
PersonRole.java
package com.rl.model1;
publicclassPersonRole {
private IntegerpersonId;
private IntegerroleId;
public Integer getPersonId() {
returnpersonId;
}
publicvoid setPersonId(Integer personId) {
this.personId = personId;
}
public Integer getRoleId() {
returnroleId;
}
publicvoid setRoleId(Integer roleId) {
this.roleId = roleId;
}
}
QueryCondition.java
package com.rl.model1;
import java.util.Date;
publicclassQueryCondition {
private Stringname;
private Stringgender;
private Datebirthday;
public String getName() {
returnname;
}
publicvoid setName(String name) {
this.name = name;
}
public String getGender() {
returngender;
}
publicvoid setGender(String gender) {
this.gender = gender;
}
public Date getBirthday() {
returnbirthday;
}
publicvoid setBirthday(Date birthday) {
this.birthday = birthday;
}
}
Role.java
package com.rl.model1;
import java.util.List;
publicclass Role {
private IntegerroleId;
private StringroleName;
private Stringdescript;
private List<Person>personList;
public List<Person> getPersonList() {
returnpersonList;
}
publicvoid setPersonList(List<Person> personList) {
this.personList = personList;
}
public Integer getRoleId() {
returnroleId;
}
publicvoid setRoleId(Integer roleId) {
this.roleId = roleId;
}
public String getRoleName() {
returnroleName;
}
publicvoid setRoleName(String roleName) {
this.roleName = roleName;
}
public String getDescript() {
returndescript;
}
publicvoid setDescript(String descript) {
this.descript = descript;
}
}
SqlHelper.java
package com.rl.util;
import java.util.Date;
import java.util.Map;
import org.apache.ibatis.jdbc.SqlBuilder;
public class SqlHelper {
public String getSql(Map<String,Object> map) {
//获得所有可能传递过来的参数
String name = (String) map.get("name");
String gender = (String) map.get("gender");
String personAddr = (String) map.get("personAddr");
Date birthday = (Date) map.get("birthday");
SqlBuilder.BEGIN();
//指定所有的列
SqlBuilder.SELECT("*");
SqlBuilder.FROM("person");
if(name != null){
//在SqlBuilder中不支持${}
SqlBuilder.WHERE("name like '%"+name+"%'");
}
if(gender != null){
SqlBuilder.WHERE("gender = #{gender}");
}
if(personAddr != null){
//在SqlBuilder中不支持${}
SqlBuilder.WHERE("person_addr like '%"+personAddr+"%'");
}
if(birthday != null){
SqlBuilder.WHERE("birthday < #{birthday}");
}
return SqlBuilder.SQL();
}
}
