新闻发布系统JSP+SERVLET版本

package com.news.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import com.news.entity.Commet; import com.news.entity.FirstTitle; import com.news.entity.SecondNews; import com.news.entity.User; /** * 新闻方法类 * * @author Administrator * */ public class NewsDao extends DBConnection { private Connection conn = null; // 用于保存数据库连接 private PreparedStatement pstmt = null; // 用于执行SQL语句 private ResultSet rs = null; // 用户保存查询结果集 /** * 添加新闻的方法 * * @param news * @return boolean */ public boolean addNews(SecondNews news) { boolean result = false; String sql = "insert into secondNews values(?,?,?,?,?)"; String[] param = { news.getUserId() + "", news.getNewsTitle(), news.getNewsContent(), news.getCreateTime(), news.getFirstId() + "" }; if (this.executeSQL(sql, param) != 0) { result = true; } return result; } public List daoHangFindResult(int typeId) { List list = new ArrayList(); try { String sql = "select * from dbo.secondNews where firstId=" + typeId + ""; conn = this.getConn(); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { SecondNews secondNews = new SecondNews(); secondNews.setNewsId(rs.getInt("newsId")); secondNews.setNewsTitle(rs.getString("newsTitle")); secondNews.setNewsContent(rs.getString("newsContent")); secondNews.setCreateTime(rs.getString("createTime")); secondNews.setFirstId(rs.getInt("firstId")); list.add(secondNews); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } public FirstTitle getFirstID(int firstId){ FirstTitle ff=null; try { conn=this.getConn(); String sql="select * from dbo.firstTitle where firstId="+firstId; pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ ff=new FirstTitle(); ff.setFirstId(rs.getInt("firstId")); ff.setTitleName(rs.getString("titleName")); } } catch (Exception e) { e.printStackTrace(); } finally { closeAll(conn, pstmt, rs); } return ff; } /** * 查询所有新闻的方法 * * @return list集合 */ public List selectNews() { List list = new ArrayList(); try { conn = this.getConn(); String sql = "select newsId, u.userName,newsTitle, newsContent,createTime ,t.titleName from secondNews as n, firstTitle as t, [user] as u where n.userId=u.userId and t.firstId=n.firstId"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { SecondNews news = new SecondNews(); User user = new User(); FirstTitle firstTitle = new FirstTitle(); news.setNewsId(rs.getInt("newsId")); news.setNewsTitle(rs.getString("newsTitle")); news.setNewsContent(rs.getString("newsContent")); news.setCreateTime(rs.getString("createTime")); news.setUser(user); user.setUserName(rs.getString("userName")); news.setFirstTitle(firstTitle); firstTitle.setTitleName(rs.getString("titleName")); list.add(news); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } /** * 根据新闻ID来删除新闻 * * @param newsId * @return */ public boolean deleteNewsById(int newsId) { boolean result = false; String sql = "delete secondNews where newsId=?"; String[] param = { newsId + "" }; if (this.executeSQL(sql, param) != 0) { result = true; } return result; } /** * 根据分类ID来查询对应的新闻 * * @param firstId * @return */ public List selectNewsByFirstId(int firstId) { List list = new ArrayList(); try { conn = this.getConn(); String sql = "select newsId, u.userName,newsTitle, newsContent,createTime ,t.titleName,n.firstId from secondNews as n, firstTitle as t, [user] as u where n.userId=u.userId and t.firstId=n.firstId and n.firstId=?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, firstId); rs = pstmt.executeQuery(); while (rs.next()) { SecondNews news = new SecondNews(); User user = new User(); FirstTitle firstTitle = new FirstTitle(); news.setNewsId(rs.getInt("newsId")); news.setNewsTitle(rs.getString("newsTitle")); news.setNewsContent(rs.getString("newsContent")); news.setCreateTime(rs.getString("createTime")); news.setUser(user); user.setUserName(rs.getString("userName")); news.setFirstTitle(firstTitle); firstTitle.setTitleName(rs.getString("titleName")); list.add(news); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return list; } /** * 根据新闻ID查询对应的详细新闻 * * @param newsId * @return */ public SecondNews selectNewsBynewsId(int newsId) { SecondNews news = null; try { conn = this.getConn(); String sql = "select newsId, u.userName,newsTitle, newsContent,createTime ,t.titleName,n.firstId from secondNews as n, firstTitle as t, [user] as u where n.userId=u.userId and t.firstId=n.firstId and n.newsId=?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, newsId); rs = pstmt.executeQuery(); while (rs.next()) { news = new SecondNews(); User user = new User(); FirstTitle firstTitle = new FirstTitle(); news.setFirstId(rs.getInt("firstId")); news.setNewsId(rs.getInt("newsId")); news.setNewsTitle(rs.getString("newsTitle")); news.setNewsContent(rs.getString("newsContent")); news.setCreateTime(rs.getString("createTime")); news.setUser(user); user.setUserName(rs.getString("userName")); news.setFirstTitle(firstTitle); firstTitle.setTitleName(rs.getString("titleName")); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return news; } /** * 根据新闻ID修改新闻信息 * * @param news * @return */ public boolean updateNews(SecondNews news) { boolean result = false; String sql = "update secondNews set userId=?, newsTitle=?, newsContent=?, createTime=?, firstId=? where newsId=?"; String[] param = { news.getUserId() + "", news.getNewsTitle(), news.getNewsContent(), news.getCreateTime(), news.getFirstId() + "", news.getNewsId() + "" }; if (this.executeSQL(sql, param) != 0) { result = true; } return result; } /** * 用户编号查看详细新闻 * * @param news_id * @return SecondNews实体类的对象 */ public SecondNews findNewsContentById(int news_id) { SecondNews secondNews = null; try { conn = this.getConn(); String sql = "select * From [secondNews] where newsid=?"; pstmt = conn.prepareStatement(sql); pstmt.setInt(1, news_id); rs = pstmt.executeQuery(); while (rs.next()) { secondNews = new SecondNews(); secondNews.setNewsId(rs.getInt("newsId")); secondNews.setUserId(rs.getInt("userId")); secondNews.setNewsTitle(rs.getString("newsTitle")); secondNews.setNewsContent(rs.getString("newsContent")); secondNews.setCreateTime(rs.getString("createTime")); secondNews.setFirstId(rs.getInt("firstId")); } } catch (Exception e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, rs); } return secondNews; } /** * 新闻快速搜索 * * @param firstId * @param news_title * @return List对象集合 */ public List findSpeedForNews(int firstId, String news_title) { List list = new ArrayList(); try { conn = this.getConn(); String sql = "select * From [secondNews] where firstId='" + firstId + "' and newsTitle like '%" + news_title + "%'"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery();