Mybatis

来源：互联网发布：r 读取股票数据编辑：程序博客网时间：2024/05/01 21:18

一、Mybatis配置文件（mybatis.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">
<configuration>
    <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/ppt?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull" />
                <property name="username" value="root" />
                <property name="password" value="root" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/csair/mybatisXML/UserMapper.xml"/>
    </mappers>
</configuration>

二、数据库操作文件（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="com.csair.dao.UserDaoMybatis">

<select id="findOne" parameterType="int" resultType="com.csair.domain.User">
select * from user where id = #{id}
</select>

</mapper>

三、接口（UserDaoMybatis）

package com.csair.dao;

import com.csair.domain.User;

public interface UserDaoMybatis {

User findOne(int id);
}

四、测试类

package com.csair;

import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.csair.dao.UserDaoMybatis;
import com.csair.domain.User;

public class TestMybatis {

/**
* @param args
*/
public static void main(String[] args) throws Exception{
  String resource = "mybatis.xml";
  Reader reader = Resources.getResourceAsReader(resource);
  SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
  SqlSessionFactory factory = builder.build(reader);
  SqlSession session = factory.openSession();

  UserDaoMybatis userDao = session.getMapper(UserDaoMybatis.class);
  User user = userDao.findOne(7);
  System.out.println(user);
}

}
附加（spring+Mybatis配置）参照applicationContext文件