1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/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"/>   这里是数据库驱动 此处是mysql的驱动
        <property name="url" value="jdbc:mysql://127.0.0.1/scott"/>  需要操作的数据库名
        <property name="username" value="root"/>   用户名
        <property name="password" value="a"/>   密码
      </dataSource>
    </environment>
 <mapper resource="com/yc/mybatis/dao/DeptMapper.xml"/> 
   
<!--     测试环境 -->
    <environment id="test">
     <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
</configuration>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yc.mybatis.dao.DeptMapper">  此处可为实体类的所在目录 也就是命名空间，自定义的
//查询
<select id="selectAll" resultType="com.yc.mybatis.bean.Dept"> resultType为转换的实体类型  id为命名方法
    select * from dept  
</select>  
//插入
 <insert id="insert">  
  insert into dept values(#{deptno},#{dname},#{loc})  参数值需要用#{}来表示，里面的参数名与实体类一致即可
  </insert>
 //更新
  <update id="update">  
  update dept set dname=#{dname},loc=#{loc} where deptno=#{deptno}
  </update>
  //删除
  <delete id="delete">   
  delete from dept where deptno=#{deptno}
  </delete>

  //查询                      
  <select id="selectByNo" resultType="com.yc.mybatis.bean.Dept">
     select *from dept where deptno=#{deptno}
  </select>
</mapper>
//注;select方法均需要在标签后加上resultType属性
而且必须在mybatis.xml内的映射标签下写入映射文件的路径如:

  <mappers>
    <mapper resource="com/yc/mybatis/dao/DeptMapper.xml"/>
  </mappers>

多个实体类的映射写法：  
  <mappers>
    <mapper resource="com/yc/mybatis/dao/DeptMapper.xml"/>
    <mapper resource="com/yc/mybatis/dao/EmpMapper.xml"/>
  </mappers> 

1
2
3
4
5
6
log4j.rootLogger=ERROR, stdout
log4j.logger.com.yc=TRACE //com.yc修改为需要打印日志的包名，其余不用修改
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

1
2
3
4
5
6
7
8
9
10
private SqlSession session;  
	@Before//before部分意思是先执行这部分在执行test部分,此部分为公共部分
	public void before() throws IOException
	{
	String resource = "mybatis.xml";//此处为框架配置文件名
	InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        session=sqlSessionFactory.openSession(true);
	}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
@Test//测试必须引入的包import junit.Test
	public void testTrans()
	{
		Dept dept=new Dept();
		dept.setDeptno(60);
		dept.setDname("信息部");
		dept.setLoc("广州");
		try{
	String path="com.yc.mybatis.dao.DeptMapper.insert";
	session.insert(path,dept);//两个参数，第一个是字符串定义的方法，第二个是对象参
	
	path="com.yc.mybatis.dao.DeptMapper.delete";
	session.delete(path,60);

	path="com.yc.mybatis.dao.DeptMapper.selectByNo";
	Dept dbdept=session.selectOne(path,60);
	Assert.assertEquals(dept.getDname(), dbdept.getDname());
	session.commit();//此按钮作用为如果try全部执行成功  就提交事务
		}catch(Exception e)
		{
			e.printStackTrace();
			session.rollback();//如果有异常就回滚到第一步，所有的事务都不提交
		}finally
		{
			session.close();//无论有无异常都会关闭session
		}
	
	}