34,576
社区成员
发帖
与我相关
我的任务
分享
</select>
<select id="selectPendingPostItemCount" resultType="java.lang.Integer" flushCache="true" useCache="false">
select count(*)
from file_resources
where objectName in (SELECT PostID FROM postinfo where PostLink not in (select PostLink from poststatus)
group by postid having count(1) = 1)
</select>
SqlSession refreshSession = SessionFactorySingleton.getInstance().getOpenSession();
FileResourcesMapper fileMapper = refreshSession.getMapper(FileResourcesMapper.class);
while(true){
int count = fileMapper.selectPendingPostItemCount();
Thread.sleep(50000);
}
</select>
<select id="selectPendingPostItemCount" resultType="java.lang.Integer" flushCache="true" useCache="false">
select count(*)
from file_resources
where objectName in (SELECT PostID FROM postinfo where PostLink not in (select PostLink from poststatus)
group by postid having count(1) = 1)
</select>
// SqlSession refreshSession = SessionFactorySingleton.getInstance().getOpenSession();
SqlSession refreshSession = getNewOpenSession(); //get new open session from new SqlSessionFactoryBuilder
FileResourcesMapper fileMapper = refreshSession.getMapper(FileResourcesMapper.class);
while(true){
int count = fileMapper.selectPendingPostItemCount();
refreshSession.clearCache();
refreshSession.commit();
fileMapper = refreshSession.getMapper(ColafileResourcesMapper.class);
Thread.sleep(50000);
}
<mapper namespace="com.mybatis.inter.FileResourcesMapper" >
<resultMap id="BaseResultMap" type="com.mybatis.model.FileResources" >
<id column="objectLink" property="objectlink" jdbcType="VARCHAR" />
。。。。。。