//mybatis帮助文档 **
http://www.mybatis.org/mybatis-3/zh/index.html
**
// 获取XML对象,得到配置资源
InputStream iStream = null;
try {
iStream = Resources.getResourceAsStream("mybatis.xml");
} catch (IOException e) {
e.printStackTrace();
}
// 使用工厂设计模式
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(iStream);
// 产生SQLsession
SqlSession session = factory.openSession();
**//第一种查询方式,适合查询结果需要遍历**
List<Student> list = session.selectList("a.b.selAll");
for(Student stu : list) {
System.out.println(stu.toString());
}
**//第二种查询方式**
int count = session.selectOne("a.b.selbyid");
System.out.println(count);
**//第三种查询方式,第二个参数用来作为Key值,适用于在查询结果中通过某列的值取到这行数据**
Map<Object,Object> map = session.selectMap("a.b.selbymap", "name");
System.out.println(map);
}
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="a.b">
<!-- id:方法名
resultType:返回值类型
parameterType:定义参数类型
-->
<select id="selAll" resultType="com.bjx.projo.Student">
select *from student
</select>
<select id="selbyid" resultType="int">
select count(*) from student
</select>
<select id="selbymap" resultType="int">
select id,name,sex,age from student
</select>
</mapper>