转自:http://blog.csdn.net/fangguozi/article/details/22793907
什么是 MyBatis?
MyBatis 是支持普通 SQL 查询,存储过程和高级映射的优秀持久层框架。MyBatis 消除 了几乎所有的 JDBC 代码和参数的手工设置以及结果集的检索。MyBatis 使用简单的 XML 或注解用于配置和原始映射,将接口和 Java 的 POJOs(Plan Old Java Objects,普通的 Java 对象)映射成数据库中的记录。
1、首先我们来创建我们的数据库(我这边用的是postgreSQL)
- CREATE TABLE users
- (
- id integer NOT NULL,
- username character(20),
- password character(20),
- CONSTRAINT user_pkey PRIMARY KEY (id)
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE users
- OWNER TO postgres;
- INSERT INTO users(id, username, password) VALUES (1, 'guozi', '123456');
2、导入所需要的jar,这里指简单的导入上述的两个;
3、编写我们的entity(只是一个javabean:User.java)
- public class User {
- private int id;
- private String userName;
- private String passWord;
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getUserName() {
- return userName;
- }
- public void setUserName(String userName) {
- this.userName = userName;
- }
- public String getPassWord() {
- return passWord;
- }
- public void setPassWord(String passWord) {
- this.passWord = passWord;
- }
- }
4、编写我们的mybatis的配置文件(mybatis-config.xml)
- <?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">
- <!-- XML 配置文件包含对 MyBatis 系统的核心设置,包含获取数据库连接实例的数据源和 决定事务范围和控制的事务管理器。 -->
- <configuration>
- <environments default="development">
- <!-- environment 元素体中包含对事 务管理和连接池的环境配置 -->
- <environment id="development">
- <transactionManager type="JDBC" />
- <dataSource type="POOLED">
- <property name="driver" value="org.postgresql.Driver" />
- <property name="url" value="jdbc:postgresql://127.0.0.1:5432/test" />
- <property name="username" value="postgres" />
- <property name="password" value="postgres" />
- </dataSource>
- </environment>
- </environments>
- <mappers>
- <!-- mappers 元素是包含所有 mapper 映射器的列表, 这些 mapper 的 XML 文件包含 SQL 代码和映射定义信息 -->
- <mapper resource="org/mybatis/example/entity/UserMapper.xml" />
- </mappers>
- </configuration>
- public interface UserDao {
- public User getUserById(Integer id);
- }
6、映射文件:UserMapper.xml
- <?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="org.mybatis.example.dao.UserDao">
- <select id="getUserById" parameterType="int" resultType="org.mybatis.example.entity.User">
- select * from users where id=#{id}
- </select>
- </mapper>
7、最后我们来测试下:Test.java
- public class Test {
- public static void main(String[] args) throws IOException {
- String resource = "mybatis-config.xml";
- InputStream inputStream = Resources.getResourceAsStream(resource);
- SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
- SqlSession session = sqlSessionFactory.openSession();
- UserDao dao = session.getMapper(UserDao.class);
- User user = dao.getUserById(1);
- System.out.println(user.getUserName());
- }
- }
运行结果:guozi