Mybatis复习（1）

将配置文件转换为字节流 之后创建sqlSession 工厂
之后创建sqlsession（打开一个会话）
利用session来测试接口方法

InputStream is = Resources.getResourceAsStream("configuration.xml");
SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(is);
SqlSession session=sessionFactory.openSession();
        Tuser tuser=session.selectOne("selectOneUsers", 3);
        System.out.println(tuser);
        session.close();
     }
    //mybatis的用户的查询测试代码结束;

如何写configuration.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>
<!-- <typeAliases>
<typeAlias type="com.cb.Users"/>
</typeAliases> -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="username" value="scott" />
<property name="password" value="tiger" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/User.xml"/>
</mappers>
</configuration>    

mapper文件夹下的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.ask.mapper.UserMapper"> 

 <sql id="query_user">
    <if test="id!=null and id!=''">
             and id=#{id} 
    </if>
    <!-- 模糊查询 -->
    <if test="username!=null and username!=''">
        and username like '%${username}%'
    </if>
  </sql>

  <select id="getUsers" parameterType="user" resultType="user">
      select * from user 
      <where>
          <include refid="query_user"></include>
      </where>
  </select>
</mapper>



SqlMapConfig.xml

待续