BBS网站代码,jsp,java,javaScript,HTNL语言 BBS网站,我对它使用到了JS

文件名称: BBS网站代码,jsp,java,javaScript,HTNL语言

所属分类: 其它

开发工具:

文件大小: 1mb

下载次数: 0

上传时间: 2009-04-19

提供者: u0110*****

下载 (1mb)

不能下载？报告错误

详细说明： BBS网站,我对它使用到了JSP,java,HTML,javaScript等技术,相信它是学习JSP的一个好东西 public interface IReplyDao { /** * 根据主题id，查找回复的信息 * @param replyId * @return 回复 */ public Reply findReply(int replyId); /** * 增加回复信息，返回增加个数 * @param reply * @return */ public int addReply(Reply reply); /** * 根据回复id删除回复，返回删除个数 * @param replyId * @return */ public int deleteReply(int replyId); /** * 修改回复信息，返回修改个数 * @param reply * @return */ public i nt updateReply(Reply reply); /** * 查询回复，返回某主题第page页回复的列表 * @param page * @param topicId * @return */ public List findListReply(int page, int topicId); /** * 根据主题id查询出该主题的回复条数 * @param topicId 主题id * @return 回复条数 */ public int findCountReply(int topicId); /** * 返回回帖的页数 * @return */ public int findReplyPage(int topicId); } ....................... public interface ITopicDao { public Topic findTopic(int topicId); //根据主题id，查找主题的信息 public int addTopic(Topic topic); //增加主题，返回增加个数 public int deleteTopic(int topicId); //根据主题id删除主题，放回删除个数 public int updateTopic(Topic topic); //更新一个主题的信息，返回更新个数 public List findListTopic(int page, int boardId); //查询帖子，返回某版第page页的帖子列表 public int findTopicCount(int boardId);//根据boardId查询版块主题数 public int findTopicPage(int boardId);//返回主题的页数 Topic findFinalTopic( int boardId ); } public interface IBoardDao { //增加一个论坛版块 public int addBoard(Board board); /* 查找版块map，key是父版块号，value是子级版块对象集合 * * @return 封装了版块信息的Map * @throws DbAccessException */ Map> findAllBoard(); /** * 根据版块id查找版块 * * @param boardId * @return */ Board findBoard(int boardId); } /*完成论坛用户数据层的操作 * */ public class UserDaoImpl extends BaseDao implements IUserDao{ //创建一个存储User用户的数组 private List users = new ArrayList(); //声明Connection的引用 private Connection conn = null; private PreparedStatement pst = null; private ResultSet rst = null; /** * 增加用户 */ public int addUser(User user) { //定义返回值 int ret_val = 0; String sqlStr = "insert into TBL_USER values(?,?,?,?,?)"; //得到联接 conn =super.getCon(); try { SimpleDateFormat hmFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); pst = conn.prepareStatement(sqlStr); pst.setString(1, user.getUName()); pst.setString(2, user.getUPass()); pst.setString(3, user.getHead()); pst.setString(4, hmFormat.format(new Date())); pst.setInt(5, user.getGender()); //返回影响的行数 ret_val =pst.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally { this.closeAll(conn, pst); } return ret_val; /* for (User temp : users) { if(temp == null) { temp = user; temp.setUId(user.getUId()); return 1; } } */ } //删除User对象信息 public int deleteUser(int userId) { int ret_val = 0; String sqlStr = "delete from tbl_user where uid =?"; //得到联接 conn = this.getCon(); try { pst = conn.prepareStatement(sqlStr); pst.setInt(1, userId); ret_val = pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { this.closeAll(conn, pst); } return ret_val; } public int updateUser(User user) { //得到联接 conn = this.getCon(); int ret_val = 0; String sqlStr = "update tbl_user set uid=?,uname=?,upass=?,head=?,regTime=?,gender=?"; //String sqlStr = "update TBL_USER set uName='"+user.getUId()+"','"+user.getUName()+"','"+user.getUPass()+"','"+user.getHead()+"',getDate()"+",'"+user.getGender()+"'"; try { //得到时间日期的方法 SimpleDateFormat hmFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); pst = conn.prepareStatement(sqlStr); pst.setInt(1, user.getUId()); pst.setString(2, user.getUName()); pst.setString(3, user.getUPass()); pst.setString(4, user.getHead()); pst.setString(5, hmFromat.format(new Date())); pst.setInt(6, user.getGender()); ret_val = pst.executeUpdate(); System.out.println("成功更新了"+ret_val+"行数据"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { this.closeAll(conn, pst); } return ret_val; /* for(int i = 0; i < users.size(); i++) { if(users.get(i) != null && users.get(i).getUName().equals(user.getUName())) { if(users.get(i).getUId()!= i) { throw new Exception("用户id不能修改!"); } users = (List) user; return 1; } } */ } public List findAll() { //创建保存对象的容器集合 List lists = new ArrayList(); //创建结果集 ResultSet rst = null; PreparedStatement pst = null; String sqlStr = "select * from tbl_user where uName=?"; conn = this.getCon(); try { SimpleDateFormat hmFromat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); pst = conn.prepareStatement(sqlStr); rst = pst.executeQuery(); while(rst.next()) { User user = new User(); user.setUId(rst.getInt(1)); user.setUName(rst.getString(2)); user.setUPass(rst.getString(3)); user.setHead(rst.getString(4)); user.setRegTime(hmFromat.format(new Date())); lists.add(user); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { this.closeAll(conn, pst, rst); } return lists; } //根据用户名查找论坛用户 public User findUser(String uName) { User user = new User(); String sqlStr = "select * from tbl_user where uName=? "; //得到联接 conn = this.getCon(); //执行预处理操作 try { pst = conn.prepareStatement(sqlStr); pst.setString(1, uName); //得到结果集 rst = pst.executeQuery(); while(rst.next()) { user.setUId(rst.getInt("uId")); user.setUName(rst.getString("uName")); user.setUPass(rst.getString("Upass")); user.setGender(rst.getInt("gender")); user.setHead(rst.getString("head")); user.setRegTime(rst.getString("regTime")); } } catch (SQLException e) { e.printStackTrace(); }finally { this.closeAll(conn, pst, rst); } return user; } //根据id查找论坛用户 public User findUser(int uId) { User user = new User(); String sqlStr = "select * from tbl_user where uId=?"; //得到联接 conn = this.getCon(); try { //执行预处理操作 pst = conn.prepareStatement(sqlStr); pst.setInt(1, uId); //得到结果集 rst = pst.executeQuery(); while(rst.next()) { user.setUId(rst.getInt("uid")); user.setUName(rst.getString("uName")); user.setUPass(rst.getString("Upass")); user.setHead(rst.getString("head")); user.setRegTime(rst.getString("regTime")); user.setGender(rst.getInt("gender")); } } catch (SQLException e) { e.printStackTrace(); }finally { this.closeAll(conn, pst, rst); } return user; } ...展开收缩

(系统自动生成,下载前可以参看下载内容)