基于Struts的新闻发布系统

// Decompiled by Jad v1.5.7f. Copyright 2000 Pavel Kouznetsov. // Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html // Decompiler options: packimports(3) // Source File Name: News.java package StudyNews; import java.io.PrintStream; import java.sql.ResultSet; import java.util.Vector; // Referenced classes of package StudyNews: // DB, Type public class News { public News() { } public void setId(int id) { this.id = id; } public void setTitle(String title) { this.title = title; } public void setContent(String content) { this.content = content; } public void setAuthor(String author) { this.author = author; } public void setTime(String time) { this.time = time; } public void setKeyword(String keyword) { this.keyword = keyword; } public void setType(int type) { this.type = type; } public void setViewCount(int viewCount) { this.viewCount = viewCount; } public int getId() { return id; } public String getTitle() { return title; } public String getContent() { return content; } public String getAuthor() { return author; } public String getTime() { return time; } public String getKeyword() { return keyword; } public int getType() { return type; } public int getViewCount(){ return viewCount; } public boolean Insert(DB db) throws Exception { String strSql = "Select max(id) From news"; ResultSet rs = db.OpenSql(strSql); int iMaxId; if(rs.next()) iMaxId = rs.getInt(1) + 1; else iMaxId = 1; strSql = "insert into news values(" + iMaxId + ",'" + title + "','" + content + "','" + author + "',getdate(),'" + keyword + "'," + type + ")"; return db.ExecSql(strSql) != 0; } public boolean Edit(DB db) throws Exception { String strSql = "update news set title='" + title + "'," + " content='" + content + "'," + " author='" + author + "'," + " keyword='" + keyword + "'," + " type=" + type + " where id=" + id; return db.ExecSql(strSql) != 0; } public static Vector SearchNewsTitle(DB db) throws Exception { Vector newsType = new Vector(); String strSql = null; strSql = "select * from type"; Vector newsList; for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList: " + newsList.size())) { Type type = new Type(); type.setTypeId(typeRs.getInt("typeId")); type.setTypeName(typeRs.getString("typeName")); newsList = new Vector(); newsList.add(type); strSql = "select top 5* from news where type=" + typeRs.getInt("typeId") + " order by time desc"; News news; for(ResultSet newsRs = db.OpenSql(strSql); newsRs.next(); newsList.add(news)) { news = new News(); news.setId(newsRs.getInt("id")); news.setTitle(newsRs.getString("title")); news.setTime(newsRs.getString("time")); news.setType(newsRs.getInt("type")); } newsType.add(newsList); } System.out.println("\nnewsType: " + newsType.size()); return newsType; } public static Vector SearchNewsTitle(DB db, int typeId, int pageId) throws Exception { Vector newsType = new Vector(); String strSql = null; strSql = "select * from type where typeid=" + typeId; Vector newsList; for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList: " + newsList.size())) { Type type = new Type(); type.setTypeId(typeRs.getInt("typeId")); type.setTypeName(typeRs.getString("typeName")); newsList = new Vector(); newsList.add(type); strSql = "select * from news where type=" + typeId + " order by time desc"; ResultSet newsRs = db.OpenSql(strSql); int iCount = 0; int iCurRecord = pageId * 10 + 1; if(newsRs.absolute(iCurRecord)){ do { News news = new News(); news.setId(newsRs.getInt("id")); news.setTitle(newsRs.getString("title")); news.setTime(newsRs.getString("time")); news.setType(newsRs.getInt("type")); newsList.add(news); } while(++iCount < 10 && newsRs.next()); } newsType.add(newsList); } System.out.println("\nnewsType: " + newsType.size()); strSql = "select * from type where typeid<>" + typeId; Type type; for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); newsType.add(type)) { type = new Type(); type.setTypeId(typeRs.getInt("typeId")); type.setTypeName(typeRs.getString("typeName")); } System.out.println("\nnewsType: " + newsType.size()); return newsType; } public static Vector SearchNewsTitle(DB db, int typeId, int pageId,String keyword) throws Exception { Vector newsType = new Vector(); String strSql = null; strSql = "select * from type where typeid=" + typeId; Vector newsList; for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); System.out.println("newsList: " + newsList.size())) { Type type = new Type(); type.setTypeId(typeRs.getInt("typeId")); type.setTypeName(typeRs.getString("typeName")); newsList = new Vector(); newsList.add(type); strSql = "select * from news where type=" + typeId +" and( title like '%"+keyword+"%' )"+" order by time desc"; ResultSet newsRs = db.OpenSql(strSql); int iCount = 0; int iCurRecord = pageId * 10 + 1; if(newsRs.absolute(iCurRecord)){ do { News news = new News(); news.setId(newsRs.getInt("id")); news.setTitle(newsRs.getString("title")); news.setTime(newsRs.getString("time")); news.setType(newsRs.getInt("type")); newsList.add(news); System.out.println("------------"+newsRs.getString("title")); } while(++iCount < 10 && newsRs.next()); } newsType.add(newsList); } System.out.println("\nnewsType: " + newsType.size()); strSql = "select * from type where typeid<>" + typeId; Type type; for(ResultSet typeRs = db.OpenSql(strSql); typeRs.next(); newsType.add(type)) { type = new Type(); type.setTypeId(typeRs.getInt("typeId")); type.setTypeName(typeRs.getString("typeName")); } System.out.println("\nnewsType: " + newsType.size()); return newsType; } public static Vector SearchRelativeNews(DB db, int newsId, String keyword) throws Exception { Vector newsList = new Vector(); String strSql = null; strSql = "select * from news where id<>" + newsId + " and keyword like '%" + keyword + "%' order by time desc"; News news; for(ResultSet rs = db.OpenSql(strSql); rs.next(); newsList.add(news)) { news = new News(); news.setId(rs.getInt("id")); news.setTitle(rs.getString("title")); news.setTime(rs.getString("time")); }