MyBatis学生信息查询-优快云博客

本文介绍了一个使用MyBatis实现的学生信息查询功能，包括基于ID查询学生数量及具体信息的方法，并提供了一个简单的测试用例。

1.mapper

<select id="selectStudentCount" parameterType="String"
        resultType="Integer">
    select count(*) from student where STU_ID= #{value}
</select>

2,java

public interface StudentMapper {
    public void insertStudent(Student student);
    public void deteteStudent(String id);
    public void updateStudent(Student student);
    public List<Student> selectStudentByQueryVo(QueryVo queryVo);
    public List<Student> selectStudent(String id);
    public Integer selectStudentCount(String id);
}

3,test

@Test
public void testInteger() throws IOException
{
    //读取配置信息
    String resource="applicationContext.xml";
    //根据配置文件构建sqlsessionFactory
    InputStream in=Resources.getResourceAsStream(resource);
    //通过sqlsessionFactory创建sqlsession
    SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(in);
    SqlSession sqlSession =sqlSessionFactory.openSession(); 
    //获取接口类
    StudentMapper studentMapper=sqlSession.getMapper(StudentMapper.class);
    Integer count=studentMapper.selectStudentCount("1")    ;
    List<Student> student=studentMapper.selectStudent("1");
    System.out.println(count);
    System.out.println(student);
    sqlSession.close();
}