JSP+SQL失物招领系统(毕业设计)

package com.bean; /** * 新闻管理 * */ import java.io.File; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.List; import com.util.Constant; import com.util.DBO; public class NewsBean { private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); private List list; private ResultSet rs = null; //不置顶新闻分页 private int EVERYPAGENUM = 2; private int count = -1; private int qq = 0; private String sql="select count(*) from news where up='0' "; private String sql2="select * from news where up='0' order by id desc "; private String sql3="select count(*) from news where up='1' "; private String sql4="select * from news where up='1' order by id desc "; public void setEVERYPAGENUM(int EVERYPAGENUM){ this.EVERYPAGENUM=EVERYPAGENUM; } public int getMessageCount() { //得到信息总数 DBO dbo=new DBO(); dbo.open(); try { rs = dbo.executeQuery(sql); rs.next(); count = rs.getInt(1); return count; } catch (SQLException ex) { ex.printStackTrace(); return -1; } finally { dbo.close(); } } public int getPageCount() { //得到共多少页（根据每页要显示几条信息） if (count % EVERYPAGENUM == 0) { return count / EVERYPAGENUM; } else { return count / EVERYPAGENUM + 1; } } public List getMessage(int page) { //得到每页要显示的信息 DBO dbo=new DBO(); dbo.open(); List list = new ArrayList(); try { rs = dbo.executeQuery(sql2); for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) { rs.next(); } for (int t = 0; t < EVERYPAGENUM; t++) { if (rs.next()) { qq++; List list2=new ArrayList(); list2.add(rs.getInt(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getInt(7)); list2.add(rs.getInt(8)); list2.add(rs.getInt(9)); list.add(list2); } else { break; //减少空循环的时间 } } return list; } catch (SQLException ex) { ex.printStackTrace(); return list; } finally { dbo.close(); } } ///////////////////////////////////////// //置顶新闻分页 public int getMessageCountUp() { //得到信息总数 DBO dbo=new DBO(); dbo.open(); try { rs = dbo.executeQuery(sql3); rs.next(); count = rs.getInt(1); return count; } catch (SQLException ex) { ex.printStackTrace(); return -1; } finally { dbo.close(); } } public List getMessageUp(int page) { //得到每页要显示的信息 DBO dbo=new DBO(); dbo.open(); List list = new ArrayList(); try { rs = dbo.executeQuery(sql4); for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) { rs.next(); } for (int t = 0; t < EVERYPAGENUM; t++) { if (rs.next()) { qq++; List list2=new ArrayList(); list2.add(rs.getInt(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getInt(7)); list2.add(rs.getInt(8)); list2.add(rs.getInt(9)); list.add(list2); } else { break; //减少空循环的时间 } } return list; } catch (SQLException ex) { ex.printStackTrace(); return list; } finally { dbo.close(); } } //add news public int addNews(String title,String pic,String content,String adder,String ifhide){ String sql = "insert into news (title,pic,content,addtime,adder,ifhide,visit,up) " + "values ('"+title+"','"+pic+"','"+content+"','"+date+"','"+adder+"','"+ifhide+"','0','0')"; String sql2 = "update news set ifhide='0' where pic!='无'"; DBO dbo = new DBO(); dbo.open(); try{ if(!pic.equals("无")){ dbo.executeUpdate(sql2); } int i = dbo.executeUpdate(sql); if(i == 1){ return Constant.SUCCESS; } else{ return Constant.SYSTEM_ERROR; } }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //update news no pic public int updateNews(int id,String title,String content,String adder,String ifhide){ String sql = "update news set title = '"+title+"',content='"+content+"',addtime='"+date+"'," + "adder='"+adder+"',ifhide='"+ifhide+"' where id = '"+id+"' "; DBO dbo = new DBO(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1){ return Constant.SUCCESS; } else{ return Constant.SYSTEM_ERROR; } }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } // update news with pic public int updateNewsWithPic(int id,String title,String pic,String content,String adder,String ifhide){ String sql = "update news set title = '"+title+"',pic='"+pic+"',content='"+content+"',addtime='"+date+"'," + "adder='"+adder+"',ifhide='"+ifhide+"' where id = '"+id+"' "; DBO dbo = new DBO(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1){ return Constant.SUCCESS; } else{ return Constant.SYSTEM_ERROR; } }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //delete news public int delNews(int id[],String dir){ DBO dbo = new DBO(); dbo.open(); try{ for(int i = 0;i<id.length;i++){ rs = dbo.executeQuery("select pic from news where id='"+id[i]+"'"); rs.next(); String str=rs.getString(1); del(dir+str); dbo.executeUpdate("delete from news where id = '"+id[i]+"'"); } return Constant.SUCCESS; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } public void del(String filepath) { try{ File f = new File(filepath);//定义文件路径 if(f.exists()){//判断是文件还是目录 f.delete();//递归调用 } }catch(Exception e){ } } //屏蔽、显示新闻 public int hideNews(int id){ String sql = "update news set ifhide='1' where id='"+id+"'"; String sql2 = "update news set ifhide='0' where id='"+id+"'"; String sql3 = "select ifhide,pic from news where id='"+id+"'"; DBO dbo = new DBO(); dbo.open(); try{ rs = dbo.executeQuery(sql3); rs.next(); int i = rs.getInt(1); String pic=rs.getString(2); if(!pic.trim().equals("无")){ dbo.executeUpdate("update news set ifhide='0' where pic!='无'"); } if(i == 1){ int flag = dbo.executeUpdate(sql2); if(flag == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; } else{ int flag = dbo.executeUpdate(sql); if(flag == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; } }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //置顶 取消置顶 新闻 public int upNews(int id){ String sql = "upd