基于servlet的新闻管理后台系统源代码

package com.cxw.dao; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.cxw.bean.NewsBean; import com.cxw.dao.utils.DBUtils; public class NewsDaoImp implements NewsDao { private PreparedStatement pst; private ResultSet result; /* * (non-Javadoc) 增加新闻条目 * * @see com.cxw.dao.NewsDao#addNews(com.cxw.dao.NewsDao) */ @Override public void addNews(NewsBean news) { String sql = "insert into news (n_eid, n_title, n_message, n_time, n_type)values (?,?,?,?,?)"; try { pst = DBUtils.getConnection().prepareStatement(sql) ; // System.out.println(news.getN_id()); pst.setString(1, news.getN_eid()) ; pst.setString(2, news.getN_title()) ; pst.setString(3, news.getN_message()) ; pst.setString(4, news.getN_time()) ; pst.setString(5, news.getN_type()) ; pst.executeUpdate() ; } catch (SQLException e) { e.printStackTrace(); } } /* * (non-Javadoc) 根据ID删除新闻 * * @see com.cxw.dao.NewsDao#delNewsById(java.lang.String) */ @Override public void delNewsById(String id) { // This is class com.cxw.cotroller.ModifyNewsServlet, using the GET method 出现这个是删除的sql语句出现错误 String sql = "delete from news where n_id=?" ; try { pst = DBUtils.getConnection().prepareStatement(sql) ; pst.setString(1, id) ; pst.executeUpdate() ; } catch (SQLException e) { e.printStackTrace(); } finally { // this.edi.closeAll() ; } } /* * (non-Javadoc) 根据id修改新闻信息 * * @see com.cxw.dao.NewsDao#modNewsById(java.lang.String, java.lang.String, * java.lang.String, java.lang.String, com.cxw.bean.EditorBean) */ @Override public void modNewsById(String id, String title, String message,String time) { String sql = "update news set n_title=?,n_message=?,n_time=? where n_id=?" ; try { pst = DBUtils.getConnection().prepareStatement(sql) ; pst.setString(1, title) ; pst.setString(2, message) ; pst.setString(3, time) ; pst.setString(4, id) ; pst.executeUpdate() ; } catch (SQLException e) { e.printStackTrace(); } } /* * (non-Javadoc) 查看编辑自己写的所有的新闻信息 * * @see com.cxw.dao.NewsDao#findAllNews() */ @Override public List<NewsBean> findAllNews() { List<NewsBean> news = new ArrayList<NewsBean>() ; String sql = "select * from news" ; try { pst = DBUtils.getConnection().prepareStatement(sql) ; result = pst.executeQuery() ; while (result.next()) { NewsBean newsBean = new NewsBean() ; newsBean.setN_id(result.getString(1)) ; // System.out.println(result.getString(2)+"------------------"); newsBean.setN_eid(result.getString(2)) ; newsBean.setN_title(result.getString(3)) ; newsBean.setN_message(result.getString(4)) ; newsBean.setN_time(result.getString(5)) ; newsBean.setN_type(result.getString(6)); news.add(newsBean) ; } } catch (SQLException e) { e.printStackTrace(); } return news; } /* (non-Javadoc) * 根据编辑的名字查看自己写的所有新闻 * @see com.cxw.dao.NewsDao#findEditorMyselfNews() */ @Override public List<NewsBean> findEditorMyselfNews(String id) { List<NewsBean> news = new ArrayList<NewsBean>() ; String sql = "select * from news where n_eid=?" ; try { pst = DBUtils.getConnection().prepareStatement(sql) ; pst.setString(1, id); result = pst.executeQuery() ; while (result.next()) { NewsBean newsBean = new NewsBean() ; newsBean.setN_id(result.getString(1)) ; // System.out.println(result.getString(2)+"------------------"); newsBean.setN_eid(result.getString(2)) ; newsBean.setN_title(result.getString(3)) ; newsBean.setN_message(result.getString(4)) ; newsBean.setN_time(result.getString(5)) ; news.add(newsBean) ; } } catch (SQLException e) { e.printStackTrace(); } return news; } /* (non-Javadoc) * 根据新闻的类别 查找新闻 * @see com.cxw.dao.NewsDao#findNewsByType(java.lang.String) */ @Override public List<NewsBean> findNewsByType(String n_type) { List<NewsBean> news = new ArrayList<NewsBean>() ; String sql = "select * from news where n_type=?" ; try { pst = DBUtils.getConnection().prepareStatement(sql) ; pst.setString(1, n_type); result = pst.executeQuery() ; while (result.next()) { NewsBean newsBean = new NewsBean() ; newsBean.setN_id(result.getString(1)) ; // System.out.println(result.getString(2)+"------------------"); newsBean.setN_eid(result.getString(2)) ; newsBean.setN_title(result.getString(3)) ; newsBean.setN_message(result.getString(4)) ; newsBean.setN_time(result.getString(5)) ; newsBean.setN_type(result.getString(6)) ; news.add(newsBean) ; } } catch (SQLException e) { e.printStackTrace(); } return news; } @Override public NewsBean findNewsById(String id) { NewsBean newsBean = new NewsBean() ; String sql = "select * from news where n_id=?" ; try { pst = DBUtils.getConnection().prepareStatement(sql); pst.setString(1, id); result = pst.executeQuery() ; while (result.next()) { newsBean.setN_id(result.getString(1)) ; newsBean.setN_eid(result.getString(2)) ; newsBean.setN_title(result.getString(3)) ; newsBean.setN_message(result.getString(4)) ; newsBean.setN_time(result.getString(5)) ; } } catch (SQLException e) { e.printStackTrace(); } return newsBean; } }