Mybatis入门配置

来源：互联网发布：php7 mysql 一键安装编辑：程序博客网时间：2024/05/21 08:35

从 XML 中构建 SqlSessionFactory:
每个基于 MyBatis 的应用都是以一个 SqlSessionFactory 的实例为中心的。SqlSessionFactory 的实例可以通过 SqlSessionFactoryBuilder 获得。而 SqlSessionFactoryBuilder 则可以从 XML 配置文件或一个预先定制的 Configuration 的实例构建出 SqlSessionFactory 的实例。

String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session=sqlSessionFactory.openSession();

UserInfo u=session.selectOne("selectUserInfo",1);

数据库配置文件Jdbc.properties内容： driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=root
password=test

实体类： package com.ib;
public class UserInfo {
private int id;
}

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">
<configuration>
<properties resource="jdbc.properties">
</properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/ib/UserInfoMapper.xml" />
</mappers>
</configuration>

com/ib/UserInfoMapper.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.ib.UserInfo">
<select id="selectUserInfo" resultType="com.ib.UserInfo">
select id from hib_user_info where id = #{id}
</select>
</mapper>

阅读全文

0 0