MyEclipse+MySql+Struts2+Hibernate3新闻发布系统

package com.caojun.action; import java.util.Iterator; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.struts2.ServletActionContext; import com.caojun.model.News; import com.caojun.model.NewsType; import com.caojun.model.User; import com.caojun.service.NewsService; import com.caojun.service.impl.NewsServiceImpl; import com.caojun.service.impl.NewsTypeServiceImpl; import com.caojun.service.impl.UserServiceImpl; import com.opensymphony.xwork2.ActionSupport; public class NewsAction extends ActionSupport { private int newsID; private String title; private String content; private java.sql.Date releaseDate; private int userID; private int newsTypeID; private List<News> allNews; private int pageSize = 10; private int pageNow = 1; private int totalCount; private List<User> allUsers; private List<NewsType> allNewsType; public List<User> getAllUsers() { return allUsers; } public void setAllUsers(List<User> allUsers) { this.allUsers = allUsers; } public List<NewsType> getAllNewsType() { return allNewsType; } public void setAllNewsType(List<NewsType> allNewsType) { this.allNewsType = allNewsType; } public int getNewsID() { return newsID; } public void setNewsID(int newsID) { this.newsID = newsID; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getContent() { return content; } public void setContent(String content) { this.content = content; } public java.sql.Date getReleaseDate() { return releaseDate; } public void setReleaseDate(java.sql.Date releaseDate) { this.releaseDate = releaseDate; } public int getUserID() { return userID; } public void setUserID(int userID) { this.userID = userID; } public int getNewsTypeID() { return newsTypeID; } public void setNewsTypeID(int newsTypeID) { this.newsTypeID = newsTypeID; } public List<News> getAllNews() { return allNews; } public void setAllNews(List<News> allNews) { this.allNews = allNews; } public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } public int getPageNow() { return pageNow; } public void setPageNow(int pageNow) { this.pageNow = pageNow; } public int getTotalCount() { return totalCount; } public void setTotalCount(int totalCount) { this.totalCount = totalCount; } public String createNews(){ HttpSession session = ServletActionContext.getRequest().getSession(); User user = (User)session.getAttribute("user"); News news = new News(); news.setTitle(this.title); news.setContent(this.content); news.setReleaseDate(this.releaseDate); news.setUserID(user.getId()); news.setNewsTypeID(this.newsTypeID); NewsService newsService = new NewsServiceImpl(); newsService.createNews(news); this.allNews = newsService.queryAllNews(this.pageSize, this.pageNow); for(Iterator<News> it = allNews.iterator();it.hasNext();){ News n = it.next(); User u1 = new UserServiceImpl().queryUser(n.getUserID()); n.setUser(u1); NewsType newsType = new NewsTypeServiceImpl().queryNewsType(n.getNewsTypeID()); n.setNewsType(newsType); } this.totalCount = newsService.queryAllNews().size(); return SUCCESS; } public String showNews(){ NewsService newService = new NewsServiceImpl(); News news = newService.queryNews(this.newsID); User user = new UserServiceImpl().queryUser(news.getUserID()); news.setUser(user); NewsType newsType = new NewsTypeServiceImpl().queryNewsType(news.getNewsTypeID()); news.setNewsType(newsType); HttpServletRequest request = ServletActionContext.getRequest(); request.setAttribute("news", news); this.allUsers = new UserServiceImpl().queryAllUsers(); this.allNewsType = new NewsTypeServiceImpl().queryAllNewsTypes(); return SUCCESS; } public String showAllNews(){ NewsService newsService = new NewsServiceImpl(); this.allNews = newsService.queryAllNews(this.pageSize, this.pageNow); for(Iterator<News> it = allNews.iterator();it.hasNext();){ News n = it.next(); User user = new UserServiceImpl().queryUser(n.getUserID()); n.setUser(user); NewsType newsType = new NewsTypeServiceImpl().queryNewsType(n.getNewsTypeID()); n.setNewsType(newsType); } this.totalCount = newsService.queryAllNews().size(); return SUCCESS; } public String showNewsByTypeID(){ NewsService newsService = new NewsServiceImpl(); this.allNews = newsService.queryAllNews(this.newsTypeID); return SUCCESS; } public String updateNews(){ NewsService newsService = new NewsServiceImpl(); News news = newsService.queryNews(this.newsID); news.setTitle(this.title); news.setContent(this.content); news.setReleaseDate(this.releaseDate); news.setUserID(this.userID); news.setNewsTypeID(this.newsTypeID); newsService.updateNews(news); this.allNews = newsService.queryAllNews(this.pageSize, this.pageNow); for(Iterator<News> it = allNews.iterator();it.hasNext();){ News n = it.next(); User user = new UserServiceImpl().queryUser(n.getUserID()); n.setUser(user); NewsType newsType = new NewsTypeServiceImpl().queryNewsType(n.getNewsTypeID()); n.setNewsType(newsType); } this.totalCount = newsService.queryAllNews().size(); return SUCCESS; } public String deleteNews(){ NewsService newsService = new NewsServiceImpl(); News news = newsService.queryNews(this.newsID); newsService.deleteNews(news); this.allNews = newsService.queryAllNews(this.pageSize, this.pageNow); for(Iterator<News> it = allNews.iterator();it.hasNext();){ News n = it.next(); User user = new UserServiceImpl().queryUser(n.getUserID()); n.setUser(user); NewsType newsType = new NewsTypeServiceImpl().queryNewsType(n.getNewsTypeID()); n.setNewsType(newsType); } this.totalCount = newsService.queryAllNews().size(); return SUCCESS; } public String showAllNewsTypes(){ this.allNewsType = new NewsTypeServiceImpl().queryAllNewsTypes(); return SUCCESS; } }