基于struts框架简单的新闻发布系统

package dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Vector; import util.Constants; import domain.UserNews; public class UserNewsDao { public static boolean insert(DBCon db,UserNews userNews)throws SQLException{ String sql; ResultSet rs; int iMaxId; sql="select max(id) from news"; rs=db.openSql(sql); if(rs.next()){ iMaxId=rs.getInt(1)+1; }else{ iMaxId=1; } sql="insert into news values("+iMaxId+",'"+userNews.getTitle()+"','" +userNews.getContent()+"','"+userNews.getAuthor()+"',getDate(),'" +userNews.getKeyword()+"',"+userNews.getType()+")"; if(db.execSql(sql)==0){ return false; }else{ return true; } } public static boolean edit(DBCon db,UserNews userNews){ String sql; sql="update news set title='"+userNews.getTitle()+"'," +"content='"+userNews.getContent()+"'," +"author='"+userNews.getAuthor()+"'," +"keyword='"+userNews.getKeyword()+"'," +"type="+userNews.getType() +"where id="+userNews.getId(); if(db.execSql(sql)==0){ return false; }else{ return true; } } //通过给定的数据源查找新闻 public static Vector searchNewsTitle(DBCon db)throws SQLException{ Vector newslist=new Vector();//定义动态数组，vector和hashtable是同步的。 String sql="select * from news order by time desc"; ResultSet rs=db.openSql(sql);//执行sql语句 while(rs.next()){ UserNews news=new UserNews(); news.setId(rs.getInt("id")); news.setTitle(rs.getString("title")); news.setTime(rs.getString("time")); news.setType(rs.getInt("type")); newslist.add(news); } //System.out.println("newslist:"+newslist.size()); return newslist;//返回一个newslist,应用于session.setAttribute(Constants.NEWS_LIST_KEY, UserNewsDao.searchNewsTitle(db))中 } public static Vector searchRelativeNews(DBCon db,int newsId,String keyword) throws SQLException{ Vector newslist=new Vector(); String sql="select * from news where id<>"+newsId+" and title like '%" +keyword+"%' order by time desc";//<>表示不等于，选择相关信息排除当前信息。 ResultSet rs=db.openSql(sql); while(rs.next()){ UserNews news=new UserNews(); news.setId(rs.getInt("id")); news.setTitle(rs.getString("title")); news.setTime(rs.getString("time")); news.setType(rs.getInt("type")); newslist.add(news); } System.out.println("newslist:"+newslist.size()); return newslist; } public static UserNews getDetail(DBCon db,int newsId,boolean bEdit) throws SQLException{ Vector newslist=new Vector(); String rplContent; String sql="select * from news where id="+newsId; ResultSet rs=db.openSql(sql); UserNews news=new UserNews(); while(rs.next()){ news.setId(newsId); news.setTitle(rs.getString("title")); news.setAuthor(rs.getString("author")); rplContent=rs.getString("content"); if(!bEdit){ rplContent=rplContent.replaceAll("\n", "<br>"); } news.setContent(rplContent); news.setTime(rs.getString("time")); news.setKeyword(rs.getString("keyword")); news.setType(rs.getInt("type")); } return news; } public static boolean delete(DBCon db,int newsId){ String sql="delete from news where id="+newsId; if(db.execSql(sql)==0){ return false; }else{ return true; } } }