jsp新闻发布系统 java

package db; import java.sql.*; import java.util.*; import data.*; public class NewsMgr { java.sql.Connection con = null; java.sql.PreparedStatement pst = null; java.sql.ResultSet res = null; java.sql.Statement st=null; //1.添加新闻 public int Add(News b) { con=ConnectionManager.Getcon(); int iVal=0; try { pst=con.prepareStatement("insert into news values(?,?,?,?,?,?,?)"); pst.setString(1,b.getTopic()); pst.setString(2,b.getContent()); pst.setInt(3,b.getHits()); pst.setInt(4,b.getCategoryid()); pst.setString(5,b.getPicture()); pst.setDate(6,b.getPublishtime()); pst.setString(7,b.getPublishuser()); iVal=pst.executeUpdate(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //1.添加新闻(重写) public int Add(String Topic,String Content,int Cid,String author) { con=ConnectionManager.Getcon(); int iVal=0; try { st=con.createStatement(); String sVal="insert into news(topic,content,categoryid,publishuser) values('"+Topic+"','"+Content+"','"+Cid+"','"+author+"')"; iVal=st.executeUpdate(sVal); st.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //2.修改新闻 public int Update (News b) { con=ConnectionManager.Getcon(); int iVal=0; try { String sVal="update news set topic=?,content=?,hits=?," +"categoryid=?,picture=?,publishtime=?,publishuser=? " +"where id=?"; pst=con.prepareStatement(sVal); pst.setString(1,b.getTopic()); pst.setString(2,b.getContent()); pst.setInt(3,b.getHits()); pst.setInt(4,b.getCategoryid()); pst.setString(5,b.getPicture()); pst.setDate(6,b.getPublishtime()); pst.setString(7,b.getPublishuser()); iVal=pst.executeUpdate(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //2.修改新闻(重写) public int Update (int id,String topic,String content,int cid,String author) { con=ConnectionManager.Getcon(); int iVal=0; try { String sVal="update news set topic=?,content=?,categoryid=?,publishuser=? where id=?"; pst=con.prepareStatement(sVal); pst.setString(1,topic); pst.setString(2,content); pst.setInt(3,cid); pst.setString(4,author); pst.setInt(5,id); iVal=pst.executeUpdate(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //3.删除新闻 public int Delete(int id) { con=ConnectionManager.Getcon(); int iVal=0; try { pst=con.prepareStatement("delete from news where id=?"); pst.setInt(1,id); iVal=pst.executeUpdate(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //4.新闻浏览次数加 public int GetAllBy(int id) { con=ConnectionManager.Getcon(); int iVal=0; try { pst=con.prepareStatement("update news set hits=hits+1 where id=?"); pst.setInt(1,id); iVal=pst.executeUpdate(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return iVal; } //5.根据CategoryId得到某栏目所有的新闻 public ArrayList GetNewsByCId(News b) { con=ConnectionManager.Getcon(); ArrayList al=new ArrayList(); try { String sVal="select * from news where categoryid=?" +"order by publishtime desc"; pst = con.prepareStatement(sVal); pst.setInt(1,b.getId()); res=pst.executeQuery(); while(res.next()) { News objnew=new News(); objnew.setId(res.getInt(1)); objnew.setTopic(res.getString(2)); objnew.setContent(res.getString(3)); objnew.setHits(res.getInt(4)); objnew.setCategoryid(res.getInt(5)); objnew.setPicture(res.getString(6)); objnew.setPublishtime(res.getDate(7)); objnew.setPublishuser(res.getString(8)); al.add(objnew); } res.close(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return al; } //5.根据CategoryId得到某栏目所有的新闻（重写） public List GetNewsByCId(int id) { con=ConnectionManager.Getcon(); List al=new ArrayList(); try { String sVal="select * from news where categoryid=? order by publishtime desc"; pst = con.prepareStatement(sVal); pst.setInt(1,id); res=pst.executeQuery(); while(res.next()) { News objnew=new News(); objnew.setId(res.getInt(1)); objnew.setTopic(res.getString(2)); objnew.setContent(res.getString(3)); objnew.setHits(res.getInt(4)); objnew.setCategoryid(res.getInt(5)); objnew.setPicture(res.getString(6)); objnew.setPublishtime(res.getDate(7)); objnew.setPublishuser(res.getString(8)); al.add(objnew); } res.close(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return al; } //5.根据CategoryId得到某栏目的前6个新闻 public List GetNewsSix(int id) { con=ConnectionManager.Getcon(); List al=new ArrayList(); try { String sVal="select top 6 * from news where categoryid=? order by publishtime desc"; pst = con.prepareStatement(sVal); pst.setInt(1,id); res=pst.executeQuery(); while(res.next()) { News objnew=new News(); objnew.setId(res.getInt(1)); objnew.setTopic(res.getString(2)); objnew.setContent(res.getString(3)); objnew.setHits(res.getInt(4)); objnew.setCategoryid(res.getInt(5)); objnew.setPicture(res.getString(6)); objnew.setPublishtime(res.getDate(7)); objnew.setPublishuser(res.getString(8)); al.add(objnew); } res.close(); pst.close(); con.close(); } catch (SQLException ex) { ex.printStackTrace(); } return al; } //6.根据ID得到新闻 public List GetAllById(int id) { con=ConnectionManager.Getcon(); List lt=new ArrayList(); try { pst = con.prepareStatement("select * from news where id=?");