链接语句:
int count =0 ;
InputStream is=null;
SqlSession sqlSession=null;
try {
is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory factory =new SqlSessionFactoryBuilder().build(is);
sqlSession = factory.openSession();
读取语句:
count= sqlSession.selectOne("com.yy.dao.UserDao.count");
xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mypper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yy.dao.UserDao">
<select id="count" resultType="int">
select count(*) from jdbc
</select>
<mapper>
导入po包:
配置:
<mappers>
<mapper resource="com/yy/dao/UserMapper.xml"/>
</mappers>
加入jar包: