ibatis基础（二）：查询所有的对象

假设数据库的student表中有如下的字段和数据：

对应的Student.java如下:

public class Student {
    private Integer id;
    private String name;
    private float score;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public float getScore() {
        return score;
    }
    public void setScore(float score) {
        this.score = score;
    }
    @Override
    public String toString() {
        return this.id+"\t"+this.name+"\t"+this.score;
    }
}

此时我们要查询所有的对象需在Student.xml中添加如下代码：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
    
<sqlMap>
    <!--typeAlias用于简写  -->
    <typeAlias alias="Student" type="com.jim.bean.Student"/>
    <!-- id代表索引名称   resultClass代表返回类型-->
    <select id="SelectAllStudent" resultClass="Student">
        select *
        from student
    </select>
</sqlMap>

编写junit进行测试：

    @Test
    public void queryAllStudent() throws Exception{
        Reader reader=Resources.getResourceAsReader("SqlMapConfig.xml");//读取总配置文件
        SqlMapClient sqlmapclient=SqlMapClientBuilder.buildSqlMapClient(reader);//创建SqlMapClient来操作数据库
        reader.close();
        List<Student> students=sqlmapclient.queryForList("SelectAllStudent");//调用我们写在xml中的sql语句
        for(Student student:students){
            System.out.println(student);
        }
    }

查看结果，成功查询出所以学生的信息：