JSP+Servlet+JavaBean开发的新闻管理发布系统

package com.rj2.daoimp; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import com.rj2.connectionmanager.ConnectionManager; import com.rj2.dao.TnewsDao; import com.rj2.factory.Factory; import com.rj2.vo.IndexList; import com.rj2.vo.Tcol; import com.rj2.vo.Tnews; public class TnewsDaoImp implements TnewsDao { public void doNewsAdd(Tnews tnews) { // TODO Auto-generated method stub Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; String sql = "insert into t_news(f_newsname,f_newscontent,f_col_id) values(?,?,?)"; try { pstate = conn.prepareStatement(sql); pstate.setString(1, tnews.getfNewsName()); pstate.setString(2, tnews.getfNewsContent()); pstate.setInt(3, tnews.getfColId()); pstate.execute(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public void doNewsDelete(int fId) { // TODO Auto-generated method stub Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; String sql = "delete from t_news where f_id=?"; try { pstate = conn.prepareStatement(sql); pstate.setInt(1, fId); pstate.execute(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public void doNewsUpdate(Tnews tnews) { // TODO Auto-generated method stub Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; String sql = "update t_news set f_newsname=?,f_newscontent=? where f_id=?"; try { pstate = conn.prepareStatement(sql); pstate.setString(1, tnews.getfNewsName()); pstate.setString(2, tnews.getfNewsContent()); pstate.setInt(3, tnews.getfId()); pstate.execute(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public Tnews getNewsContent(int fId) { // TODO Auto-generated method stub Tnews tnews = null; Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; ResultSet rs = null; String sql = "select * from t_news where f_id=?"; try { pstate = conn.prepareStatement(sql); pstate.setInt(1, fId); rs = pstate.executeQuery(); rs.next(); tnews = new Tnews(rs.getInt("f_id"), rs.getString("f_newsname"), rs.getString("f_newscontent"), rs.getInt("f_col_id")); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { rs.close(); pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return tnews; } public List<Tnews> getNewsName(String searchtype, String searchcontent) { // TODO Auto-generated method stub List<Tnews> li = new ArrayList<Tnews>(); Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; ResultSet rs = null; String sql = ""; if(searchtype.equals("newsname")) { sql = "select * from t_news where f_newsname like ?"; } else { sql = "select * from t_news where f_newscontent like ?"; } try { pstate = conn.prepareStatement(sql); pstate.setString(1, "%"+searchcontent+"%"); rs = pstate.executeQuery(); while(rs.next()){ li.add(new Tnews(rs.getInt("f_id"), rs.getString("f_newsname"), rs.getString("f_newscontent"), rs.getInt("f_col_id"))); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { rs.close(); pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return li; } public List<Tnews> getNewsNameList(int fId) { // TODO Auto-generated method stub List<Tnews> li = new ArrayList<Tnews>(); Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; ResultSet rs = null; String sql = "select * from t_news where f_col_id=?;"; try { pstate = conn.prepareStatement(sql); pstate.setInt(1,fId); rs = pstate.executeQuery(); while(rs.next()) { li.add(new Tnews(rs.getInt("f_id"), rs.getString("f_newsname"), rs.getString("f_newscontent"), rs.getInt("f_col_id"))); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { rs.close(); pstate.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return li; } public List<Tnews> getNewsList(int fId, int len) { // TODO Auto-generated method stub List<Tnews> li = new ArrayList<Tnews>(); Connection conn = ConnectionManager.getConnection(); PreparedStatement pstate = null; ResultSet rs = null; int flag = 1; String sql = "select * from t_news where f_col_id=?"; try { pstate = conn.prepareStatement(sql); pstate.setInt(1, fId); rs = pstate.executeQuery(); while(rs.next() && flag <= len){ li.add(new Tnews(rs.getInt("f_id"), rs.getString("f_newsname"), rs.getString("f_newscontent"), rs.getInt("f_col_id"))); flag++; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return li; } public List<IndexList> getIndexNews() { // TODO Auto-generated method stub List<IndexList> li = new ArrayList<IndexList>(); List<Tcol> collist = Factory.getTcolDao().getColList(6); List<Tnews> newslist = null; Iterator<Tcol> it = collist.iterator(); Tcol tcol = null; while(it.hasNext()){ tcol = it.next(); newslist = Factory.getTnewsDao().getNewsList(tcol.getfId(), 5); li.add(new IndexList(tcol.getfId(), tcol.getfName(), newslist)); } return li; } }