package s2jsp.lg.dao.impl;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import java.sql.*;
//import java.sql.Date;
//import s2jsp.lg.dao.impl.*;
import s2jsp.lg.dao.ReplyDao;
import s2jsp.lg.entity.Reply;
public class ReplyDaoImpl extends BaseDao implements ReplyDao {
private Connection con= null;
private PreparedStatement ps= null;
private ResultSet rs= null ;
public int addReply(Reply reply) {
String sql = "insert into TBL_REPLY(title,content,publishTime,modifyTime,uId,topicId) values(?,?,?,?," + reply.getUId()+ "," + reply.getTopicId() + ")";
String time=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date());
String[] parm={ reply.getTitle(), reply.getContent(), time, time };
try {
return this.chuli(sql, parm);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
public int deleteReply(int replyId) {
String sql = "delete from TBL_REPLY where replyId=" + replyId;
try {
return this.chuli(sql, null) ;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return replyId;
}
public int updateReply(Reply reply) {
String sql = "update TBL_REPLY set title=?, content=?, modifyTime=? where replyId="+reply.getReplyId();
String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
String[] parm = { reply.getTitle(), reply.getContent(), time };
try {
return this.chuli(sql, parm);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
public List findListReply(int page, int topicId) {
List list = new ArrayList();
con = null;
ps = null;
rs = null;
int rowBegin = 0;
if( page > 1 ) {
rowBegin = 10 * (page-1);
}
try {
con =BaseDao.getConnection();
String sql = "select top 10 * from TBL_REPLY where topicId=" + topicId + " and replyId not in(select top "+ rowBegin+ " replyId from TBL_REPLY where topicId=" + topicId + "order by publishTime )order by publishTime";
ps= con.prepareStatement(sql);
rs = ps.executeQuery();
while ( rs.next() ) {
Reply reply = new Reply();
reply.setReplyId(rs.getInt("replyId"));
reply.setTitle(rs.getString("title"));
reply.setContent(rs.getString("content"));
reply.setPublishTime(rs.getString("publishTime"));
reply.setModifyTime(rs.getString("modifyTime"));
reply.setTopicId(rs.getInt("topicId"));
reply.setUId(rs.getInt("uId"));
list.add(reply);
}
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
BaseDao.closeConnection(con);
BaseDao.closeStatement(ps);
}
return list;
}
public int findCountReply(int topicId){
int count = 0;
Connection con= null;
PreparedStatement ps= null;
ResultSet rs= null;
String sql= "select count(*) from TBL_REPLY where topicId=" + topicId;
try {
con=BaseDao.getConnection();
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while( rs.next() )
{
count = rs.getInt(1);
}
}
catch ( Exception e)
{
e.printStackTrace();
}
finally
{
BaseDao.closeConnection(con);
BaseDao.closeResultSet(rs);
BaseDao.closeStatement(ps);
}
return count;
}
public Reply findReply(int replyId) {
String sql = "select * from TBL_REPLY where replyId=?";
Reply reply = null;
try {
con=BaseDao.getConnection();
ps=con.prepareStatement(sql);
ps.setInt(1, replyId);
rs= ps.executeQuery();
while ( rs.next() ) {
reply = new Reply();
reply.setReplyId(rs.getInt("replyId"));
reply.setTitle(rs.getString("title"));
reply.setContent(rs.getString("content"));
reply.setPublishTime(rs.getString("publishTime"));
reply.setModifyTime(rs.getString("modifyTime"));
reply.setUId(rs.getInt("uId"));
}
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
BaseDao.closeConnection(con);
BaseDao.closeResultSet(rs);
BaseDao.closeStatement(ps);
}
return reply;
}
}
jspbbs.rar （94个子文件） 
jspbbs 
sqljdbc.jar 275KB
bbs_Data.MDF 1.94MB bbs_Log.LDF 1.75MB src test UserDaoImplTest.java 822B TopicDaoImplTest.java 546B BoardDaoImplTest.java 796B ReplyDaoImplTest.java 869B s2jsp lg dao ReplyDao.java 360B TopicDao.java 359B UserDao.java 321B BoardDao.java 175B impl BoardDB.java 604B BaseDao.java 2KB TopicDaoImpl.java 4KB ReplyDB.java 1KB TopicDB.java 1KB BoardDaoImpl.java 3KB UserDaoImpl.java 3KB ReplyDaoImpl.java 5KB ConnectionManager.java 1KB entity Board.java 914B User.java 1KB Topic.java 2KB Reply.java 2KB .project 1KB WebRoot Re.jsp 2KB list.jsp 5KB detail.jsp 6KB images 
13.gif 3KB 5.gif 4KB 2.gif 4KB 1.gif 4KB 8.gif 3KB 3.gif 4KB 12.gif 4KB 6.gif 3KB 11.gif 3KB 9.gif 4KB 7.gif 3KB post.gif 2KB 14.gif 3KB 4.gif 3KB topic.gif 311B
16.jpg 5KB logo.gif 4KB 15.gif 3KB 10.gif 3KB reply.gif 2KB board.gif 712B META-INF MANIFEST.MF 39B doLogin.jsp 1KB welcome.jsp 803B WEB-INF web.xml 375B classes test ReplyDaoImplTest.class 1KB UserDaoImplTest.class 1022B BoardDaoImplTest.class 2KB TopicDaoImplTest.class 1KB s2jsp lg dao ReplyDao.class 330B UserDao.class 353B ConnectionManager.class 2KB TopicDao.class 330B BoardDao.class 187B impl BoardDB.class 1KB UserDaoImpl.class 4KB BaseDao.class 2KB TopicDB.class 2KB BoardDaoImpl.class 3KB ReplyDaoImpl.class 5KB TopicDaoImpl.class 5KB ReplyDB.class 2KB entity User.class 2KB Topic.class 2KB Reply.class 2KB Board.class 2KB lib 
reg.html 4KB reg.jsp 4KB currentTime.jsp 1016B login.html 2KB Reply.jsp 2KB index.html 7KB post.jsp 4KB post.html 3KB login.jsp 2KB index.jsp 4KB list.html 5KB update.html 3KB error.jsp 2KB update.jsp 4KB EG.jsp 2KB doLogout.jsp 1KB Pos.jsp 2KB detail.html 3KB .mymetadata 291B .classpath 390B .myeclipse 资源评论
