【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-ArtReviewDao.java,希望本篇文章对您学习有所帮助。
package com.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.toolsBean.Change;
import com.toolsBean.DB;
import com.valueBean.ArtReviewSingle;
/*************************************
版权所有: 吉林省明日科技有限公司
完成日期: 2010-09-15
项目出处: 编程词典
服务社区: www.mingribook.com
学习社区: www.mrbccd.com
*************************************/
public class ArtReviewDao extends SuperDao{
public List getNewReviewList(int id) throws SQLException{
int top=5;
Object[] params={id};
String sql="SELECT TOP "+top+" * FROM tb_articleR WHERE artReview_rootId=? ORDER BY artReview_time DESC";
List artrlist=getList(sql,params);
return artrlist;
}
public List getMoreReviewList(int id,String showPage,String goWhich) throws SQLException{
String sqlall="select * from tb_articleR where artReview_rootId=?";
Object[] params={id};
setPerR(5);
createPage(sqlall,params,showPage,goWhich);
int currentP=getPage().getCurrentP();
int top1=getPage().getPerR();
int top2=(currentP-1)*top1;
String sql="";
if(currentP<=1)
sql="SELECT TOP "+top1+" * FROM tb_articleR WHERE artReview_rootId=? ORDER BY artReview_time";
else
sql="SELECT TOP "+top1+" * FROM tb_articleR i WHERE (artReview_rootId = ?) AND (artReview_time > (SELECT MAX(artReview_time) FROM (SELECT TOP "+top2+" * FROM tb_articleR WHERE artReview_rootId = i.artReview_rootId ORDER BY artReview_time) AS maxv)) ORDER BY artReview_time";
List artrlist=getList(sql,params);
return artrlist;
}
private List getList(String sql,Object[] params) throws SQLException{
List list=null;
DB mydb=new DB();
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
if(rs!=null){
list=new ArrayList();
while(rs.next()){
ArtReviewSingle single=new ArtReviewSingle();
single.setId(rs.getInt(1));
single.setArtRRootId(rs.getInt(2));
single.setArtRAuthor(rs.getString(3));
single.setArtRContent(rs.getString(4));
single.setArtRTime(Change.dateTimeChange(rs.getTimestamp(5)));
list.add(single);
}
}
return list;
}
public void insert(Object[] params) throws SQLException{
String sql="insert into tb_articleR values(?,?,?,?)";
DB mydb=new DB();
mydb.doPstm(sql, params);
}
public int delete(int id) throws SQLException{
String sql="delete from tb_articleR where id=?";
DB mydb=new DB();
mydb.doPstm(sql, new Object[]{id});
int i=mydb.getCount();
return i;
}
}
上一篇:
ArtManageForm.java
下一篇:
多年来只想说一句,我不怪你