mybatis下的环境配置

1.全局配置文件  <mappers >内配置sql文件的路径 ， jdbc.properties是配置文件的路径

<?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>

<typeAliases>

<typeAlias type="com.lm.user.User" alias="user"/>

</typeAliases>//给类起了个别名

也可以用引包的方式引用包下的全部类

<package name="com.lm.user"/>

<environments default="develop">

<environment id="develop">

<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/lm/user/user_sql.xml"/>

</mappers>

</configuration>

2.配置数据库连接的properties文件

url=jdbc\:db2\://127.0.0.1\:50000/TEST02

username=administrator

driver=com.ibm.db2.jcc.DB2Driver

password=linmu

3.sql的配置文件

<?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="lm_user">

<select id="selectAllUsers" parameterType="com.lm.user.User" resultType="com.lm.user.User" >

SELECT * FROM USER WHERE ID=#{id}

</select>

</mapper>

4.java代码调用示例

InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");

SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(inputStream);

SqlSession sqlSession=factory.openSession();

User user=new User();

user.setId("zhaoxlei");

List<User> list=sqlSession.selectList("lm_user.selectAllUsers",user.getId());

System.out.println(list.get(0).getName());

sqlSession.commit();