20170725

来源:互联网 发布:阿里巴巴代销传淘宝 编辑:程序博客网 时间:2024/06/12 18:12

链接语句:


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包:






原创粉丝点击