MyBatis3详细教程

一、准备工作 1.去官网下载 mybatis3.1 网址：/ 2.打开 eclipse，新建 java 项目，我建的是 mybatis,把下载的文件解压，打开文件夹找到 mybatis-3.1.0.jar 文件，把这个 jar 文件引入你的项目中 3.引入数据库驱动 jar,我的是 mysql 数据库的驱动 mysql-connector-java-5.0.4-bin.jar
}
public double getComm() { return comm;
}
public void setComm(double comm) { m = comm;
}
public int getEmpno() { return empno;
}
public void setEmpno(int empno) { this.empno = empno;
二、配置文件 1.在 src 源目录下，新建 sqlMapConfig.xml 文件，复制以下内容到 xml 文件中 <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-////DTD Config 3.0//EN" "/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url"
} }
EmpEntity 类 package com.rogrand.entity;
import java.util.Date;
/** * * @author scofield.hello */ public class EmpEntity {
private int empno;//员工编码
private String ename;//员工名称
private String dname;//部门名称
private String location;//部门所在地
//提供无参的构造方法和有参的构造方法，getter和setter方法 public DeptEntity() { }
public DeptEntity(int deptno, String dname, String location) {
private String job;//职位
private int mgr;//上级编号
private Date hiredate;//入职时间
private double sale;//工资
private double comm;//奖金
public EmpEntity() { }
public EmpEntity(int empno, String ename, String job, int mgr, Date hiredate, double sale, double comm) {
`comm` double(7,0) default NULL, `deptno` int(10) PRIMARY KEY (`empno`) )
DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `deptno` int(10) NOT NULL auto_increment, `dname` varchar(20) NOT NULL, `location` varchar(30) default '', PRIMARY KEY (`deptno`) ) 现在，我们向这两张表里插入数据： INSERT INTO `emp` VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17', '800', null, '20'); INSERT INTO `emp` VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20', '1600', '300', '30'); INSERT INTO `emp` VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22', '1250', '500', '30'); INSERT INTO `emp` VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02', '2975', null, '20'); INSERT INTO `emp` VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28', '1250', '1400', '30'); INSERT INTO `emp` VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01', '2850', null, '30'); INSERT INTO `emp` VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981 -06-09', '2450', null, '10'); INSERT INTO `emp` VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1987-07-15', '3000', null, '20'); INSERT INTO `emp` VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17', '5000', null, '10'); INSERT INTO `emp` VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08', '1500', '0', '30'); INSERT INTO `emp` VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1987-07-13', '1100', null, '20'); INSERT INTO `emp` VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03', '950', null, '30'); INSERT INTO `emp` VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03', '3000', null, '20'); INSERT INTO `emp` VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23', '1300', null, '10');
value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;chara cterEncoding=UTF-8"/>
<property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <mappers> </mappers> </configuration> 有过框架学习经验的人肯定可以看出来，dataSource元素内，是用来配置数据源 的，你需要改的地方是driver、url、username、password。 2.建数据库表，我使用的是EMP(员工)表和DEPT(部门)表，建表语句如下： DROP TABLE IF EXISTS `emp`; CREATE TABLE `emp` ( `empno` int(10) NOT NULL auto_increment, `ename` varchar(30) NOT NULL, `job` varchar(15) NOT NULL, `mgr` int(4) default NULL, `hiredate` date NOT NULL, `sale` double(7,0) NOT NULL,