查询单个数据
- 查询用户的总记录数
- 在MyBatis中,对于Java中常用的类型都设置了类型别名,别名不区分大小写
- 例如: java.lang.Integer --> int | INT | integer | Integer
- 例如: int --> _int | _integer
- 例如: Map --> map,List-->list
java中常用的类型别名
SelectMapper 接口
public interface SelectMapper {
/**
* 查询用户的总数量
* @return
*/
Integer getCount();
}
MyBatis的映射文件 SelectMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.mybatis.mapper.SelectMapper">
<!--Integer getCount();-->
<select id="getCount" resultType="Integer">
select count(*) from t_user
</select>
</mapper>
测试
public class SelectMapperTest {
@Test
public void testCount(){
SqlSession sqlSession = SqlSessionUtil.getSqlSession();
SelectMapper mapper = sqlSession.getMapper(SelectMapper.class);
Integer count = mapper.getCount();
System.out.println(count);
}
}