[html]view plaincopy

1. CREATETABLEtab_department(
2. idsINTPRIMARYKEYAUTO_INCREMENT,
3. de_nameVARCHAR(50)COMMENT'部门名称',
4. p_idsINTCOMMENT'上级部门id',
5. de_charge_personVARCHAR(50)COMMENT'部门负责人',
6. create_timeLONGCOMMENT'创建时间'
7. )COMMENT'部门表'

[html]view plaincopy

1. packagecom.tenghu.mybatis.model;
3. importjava.io.Serializable;
5. /**
6. *部门表
7. *@authorArvin_Li
8. *
9. */
10. publicclassDepartmentimplementsSerializable{
11. privatestaticfinallong serialVersionUID = 6998332095922284289L ;
13. privateintids;//部门编号
14. privateStringdeName;//部门名称
15. privateintpIds;//上级部门id
16. privateStringdeChargePerson;//部门负责人
17. privatelongcreateTime;//创建时间
19. //省略get和set方法
20. }

[html]view plaincopy

1. < xml version = "1.0" encoding = "UTF-8" >
2. <!DOCTYPEconfiguration
3. PUBLIC"-//mybatis.org//DTDConfig3.0//EN"
4. "http://mybatis.org/dtd/mybatis-3-config.dtd" >
5. < configuration >
6. <!--配置实体类别名-->
7. < typeAliases >
8. < typeAlias type = "com.tenghu.mybatis.model.Department" alias = "Department" />
9. </ typeAliases >
10. < environments default = "development" >
11. < environment id = "development" >
12. < transactionManager type = "JDBC" />
13. < dataSource type = "POOLED" >
14. < property name = "driver" value = "${jdbc.driver}" />
15. < property name = "url" value = "${jdbc.url}" />
16. < property name = "username" value = "${jdbc.username}" />
17. < property name = "password" value = "${jdbc.password}" />
18. </ dataSource >
19. </ environment >
20. </ environments >
22. <!--配置映射文件-->
23. < mappers >
24. < mapper resource = "com/tenghu/mybatis/model/xml/DepartmentMapper.xml" />
25. </ mappers >
26. </ configuration >

[html]view plaincopy

1. < xml version = "1.0" encoding = "UTF-8" >
2. <!DOCTYPEmapper
3. PUBLIC"-//mybatis.org//DTDMapper3.0//EN"
4. "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
5. < mapper namespace = "com.tenghu.mybatis.model.xml.DepartmentMapper" >
7. <!--配置映射字段-->
8. < resultMap type = "Department" id = "tab_department" >
9. < id property = "ids" column = "ids" />
10. < result property = "deName" column = "de_name" />
11. < result property = "pIds" column = "p_ids" />
12. < result property = "deChargePerson" column = "de_charge_person" />
13. < result property = "createTime" column = "create_time" />
14. </ resultMap >
16. <!--查询所有部门-->
17. < select id = "queryAllDepartment" resultMap = "tab_department" >
18. select*fromtab_department
19. </ select >
20. </ mapper >

[html]view plaincopy

1. packagecom.tenghu.mybatis.util;
3. importjava.io.IOException;
4. importjava.io.InputStream;
5. importjava.util.Properties;
7. importorg.apache.ibatis.io.Resources;
8. importorg.apache.ibatis.session.SqlSession;
9. importorg.apache.ibatis.session.SqlSessionFactory;
10. importorg.apache.ibatis.session.SqlSessionFactoryBuilder;
12. /**
13. *Mybatis工具类
14. *@authorArvin_Li
15. *@version1.0
16. *
17. */
18. publicclassMybatisUtil{
19. privateMybatisUtil(){}
21. //声明SqlSession工厂
22. privatestaticSqlSessionFactorysqlSessionFactory;
24. //使用静态代码块获取SqlSession工厂
25. static{
26. try{
27. //获取mybatis主配置文件流
28. InputStream inputStream = Resources .getResourceAsStream("mybatis-config.xml");
29. //创建属性文件对象
30. Properties properties = new Properties();
31. //加载属性配置文件
32. properties.load(Resources.getResourceAsStream("jdbc.properties"));
33. //创建SqlSessionFactory对象
34. sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream,properties);
35. }catch(IOExceptione){
36. e.printStackTrace();
37. }
38. }
40. /**
41. *开启SqlSession对象，不自动提交
42. *@return
43. */
44. publicstaticSqlSessionopenSession(){
45. returnsqlSessionFactory.openSession();
46. }
48. /**
49. *开启自动提交的SqlSession
50. *@return
51. */
52. publicstaticSqlSessionopenAutoCommitSession(){
53. returnsqlSessionFactory.openSession(true);
54. }
56. /**
57. *关闭SqlSession
58. *@paramsqlSession
59. */
60. publicstaticvoidcloseSession(SqlSessionsqlSession){
61. if(null!=sqlSession){
62. sqlSession.close();
63. }
64. sqlSession = null ;
65. }
66. }

[html]view plaincopy

1. packagecom.tenghu.mybatis.test;
3. importjava.util.List;
5. importorg.apache.ibatis.session.SqlSession;
6. importorg.junit.Test;
8. importcom.tenghu.mybatis.model.Department;
9. importcom.tenghu.mybatis.util.MybatisUtil;
11. /**
12. *部门测试类
13. *@authorArvin_Li
14. *
15. */
16. publicclassDepartmentTest{
17. //命名空间
18. privateString namespace = "com.tenghu.mybatis.model.xml.DepartmentMapper." ;
20. /**
21. *查询出所有部门
22. */
23. @Test
24. publicvoidtestQueryAllDepartment(){
25. //获取SqlSession
26. SqlSession sqlSession = MybatisUtil .openSession();
27. try{
28. //查询
29. List < Department > departList = sqlSession .selectList(namespace+"queryAllDepartment");
30. //输出部门信息
31. for(Departmentdepartment:departList){
32. System.out.println(department.getIds()+"\t"+department.getDeName()+"\t"+department.getpIds()+"\t"+department.getDeChargePerson());
33. }
34. }catch(Exceptione){
35. e.printStackTrace();
36. }finally{
37. //关闭SqlSession
38. MybatisUtil.closeSession(sqlSession);
39. }
40. }
41. }