mybatis三种查询

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