Mybatis复习（1）

来源：互联网发布：缺少mysql.sock 编辑：程序博客网时间：2024/05/21 16:55

将配置文件转换为字节流之后创建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 mapperPUBLIC "-//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待续

0 0