下面举个例子：先看看项目的简单部署吧，如图：
先看核心文件，UserTest.java
|
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
|
package com.rollen;
import java.io.*;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class UserTest {
public static void main(String[] args) {
String resource = "com/rollen/configure.xml";
Reader reader = null;
try {
reader = Resources.getResourceAsReader(resource);
} catch (IOException e) {
e.printStackTrace();
}
SqlSessionFactory factory = new SqlSessionFactoryBuilder()
.build(reader);
factory.getConfiguration().addMapper(UserInfoMapper.class);
SqlSession sqlSession = factory.openSession();
try {
UserInfoMapper userInfoMapper = sqlSession
.getMapper(UserInfoMapper.class);
User user = userInfoMapper.getUser(10);
System.out.println(user);
} finally {
sqlSession.close();
}
}
} |
主要要注意的是比如要注册，也就是这行代码：
|
1
|
factory.getConfiguration().addMapper(UserInfoMapper.class);
|
UserInfoMapper.java代码如下：
|
1
2
3
4
5
6
7
8
|
package com.rollen;
import org.apache.ibatis.annotations.Select;
public interface UserInfoMapper {
@Select("select * from user_tb where age= #{age}")
public User getUser(int age);
} |
user.java 代码如下：
|
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
|
package com.rollen;
public class User {
private String name;
private int age;
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @param name the name to set
*/
public void setName(String name) {
this.name = name;
}
/**
* @return the age
*/
public int getAge() {
return age;
}
/**
* @param age the age to set
*/
public void setAge(int age) {
this.age = age;
}
/* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
// TODO Auto-generated method stub
return "name: "+name+"age: "+age;
}
} |
最后的configure.xml文件代码为：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?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> <typeAliases>
<typeAlias alias="User" type="com.rollen.User" />
</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/user_db" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
</configuration> |
参考文章：http://www.laokboke.net/2012/09/25/mybatis-annotation/
==============================================================================
本文转自被遗忘的博客园博客，原文链接：http://www.cnblogs.com/rollenholt/archive/2012/11/07/2758008.html，如需转载请自行联系原作者