教你使用MyBatis

MyBatis+MySQL的，记录如下：

①数据库

在MySQL中，test数据库下，简历user表，一共两个字段id和name，建表语句略。

②需导入的包

只有两个：

mybatis-3.0.3.jar

mysql-connector-java-5.1.9-bin.jar（JDBC包）

③目录结构

采用最简单的结构，domain包下有且仅有四个文件

configuration.xml

User.xml

User.java

Test.java

④实体类javabean，总共两个变量

view plaincopy to clipboardprint?

1         package domain; 

2           

3         publicclass User { 

4             privateint id; 

5             private String name = null; 

6             public User() { 

7             } 

8             public User(int id, String name) { 

9                 this.id = id; 

10              this.name = name; 

11          } 

12          publicint getId() { 

13              return id; 

14          } 

15          publicvoid setId(int id) { 

16              this.id = id; 

17          } 

18          public String getName() { 

19              return name; 

20          } 

21          publicvoid setName(String name) { 

22              this.name = name; 

23          } 

24          @Override 

25          public String toString() { 

26              return"User [id=" + id + ", name=" + name +"]"; 

27          } 

28      } 

⑤MyBatis总配置文件configuration.xml

 

view plaincopy to clipboardprint?

29      <?xml version="1.0" encoding="UTF-8" ?> 

30      <!DOCTYPE configuration PUBLIC  

31          "-//mybatis.org//DTD Config 3.0//EN" 

32          "http://mybatis.org/dtd/mybatis-3-config.dtd"> 

33      <configuration> 

34          <typeAliases> 

35              <typeAlias alias="User" type="domain.User" /> 

36          </typeAliases> 

37          <environmentsdefault="development"> 

38              <environment id="development"> 

39                  <transactionManager type="JDBC" /> 

40                  <dataSource type="POOLED"> 

41                      <property name="driver" value="com.mysql.jdbc.Driver" /> 

42                      <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8" /> 

43                      <property name="username" value="root" /> 

44                      <property name="password" value="" /> 

45                  </dataSource> 

46              </environment> 

47          </environments> 

48          <mappers> 

49              <mapper resource="domain/User.xml" /> 

50          </mappers> 

51      </configuration>  

⑥User类的配置文件User.xml

view plaincopy to clipboardprint?

52      <?xml version="1.0" encoding="UTF-8" ?> 

53      <!DOCTYPE mapper PUBLIC  

54          "-//mybatis.org//DTD Mapper 3.0//EN" 

55          "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 

56      <mapper namespace="User"> 

57          <select id="selectUser" parameterType="int" resultType="User"><!--[CDATA[ 

58              select * from user where id = #{id} 

59          ]]--></select> 

60      </mapper> 

⑦测试用例

 

61      package domain; 

62        

63      import java.io.IOException; 

64      import java.io.Reader; 

65      import org.apache.ibatis.io.Resources; 

66      import org.apache.ibatis.session.SqlSession; 

67      import org.apache.ibatis.session.SqlSessionFactory; 

68      import org.apache.ibatis.session.SqlSessionFactoryBuilder; 

69      import domain.User; 

70        

71      publicclass Test { 

72          publicstaticvoid main(String[] args) throws IOException { 

73              String resource ="domain/configuration.xml"; 

74              Reader reader = Resources.getResourceAsReader(resource); 

75              SqlSessionFactory ssf =new SqlSessionFactoryBuilder().build(reader); 

76              SqlSession session = ssf.openSession(); 

77              try { 

78                  User user = (User) session.selectOne("selectUser","1"); 

79                  System.out.println(user); 

80              }catch (Exception e) { 

81                  e.printStackTrace(); 

82              }finally { 

83                  session.close(); 

84              } 

85          } 

86      }