基于javaweb+mysql的jsp+servlet新闻发布管理系统(java+jsp+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
后台:管理新闻类型、新闻、评论、链接
前台:看新闻、评论
后台
前台
技术框架
JSP Servlet MySQL JDBC Tomcat jQuery Bootstrap JavaScript
基于javaweb+mysql的JSP+Servlet新闻发布管理系统(java+jsp+servlet+mysql)
page="1";
session.setAttribute("s_bPublishDate", s_bPublishDate);
session.setAttribute("s_aPublishDate", s_aPublishDate);
session.setAttribute("s_title", s_title);
}else{
s_bPublishDate=(String) session.getAttribute("s_bPublishDate");
s_aPublishDate=(String) session.getAttribute("s_aPublishDate");
s_title=(String) session.getAttribute("s_title");
}
Connection con=null;
News s_news=new News();
if(StringUtil.isNotEmpty(s_title)){
s_news.setTitle(s_title);
}
try{
con=dbUtil.getCon();
int total=newsDao.newsCount(con, s_news, s_bPublishDate, s_aPublishDate);
String pageCode=PageUtil.getPagation(request.getContextPath()+"/news?action=backList", total, Integer.parseInt(page), Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
List<News> newsBackList=newsDao.newsList(con, s_news,pageBean,s_bPublishDate,s_aPublishDate);
request.setAttribute("pageCode", pageCode);
request.setAttribute("newsBackList", newsBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻列表"));
request.setAttribute("mainPage", "/background/news/newsList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsDelete(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
String newsId=request.getParameter("newsId");
Connection con=null;
boolean delFlag;
try{
con=dbUtil.getCon();
int delNums=newsDao.newsDelete(con, newsId);
if(delNums==1){
delFlag=true;
}else{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
FileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);
String realPath = request.getServletContext().getRealPath("");
System.out.println("图片目录:" + realPath);
System.out.println("图片目录:" + realPath);
System.out.println("图片目录:" + realPath);
System.out.println("图片目录:" + realPath);
System.out.println("图片目录:" + realPath);
try {
List<FileItem> list = upload.parseRequest(request);
for (FileItem fileItem : list) {
String imageName = DateUtil.getCurrentDateStr();
File file = new File(PropertiesUtil.getValue("imagePath") + imageName + "." + fileItem.getName().split("\\.")[1]);
String newPath = PropertiesUtil.getValue("imageFile") + "/" + imageName + "." + fileItem.getName().split("\\.")[1];
fileItem.write(file);
String callback = request.getParameter("CKEditorFuncNum");
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + callback + ",'" + newPath + "',''" + ")");
out.println("</script>");
out.flush();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package com.demo.web;
}
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(linkId)){
linkDao.linkUpdate(con, link);
}else{
linkDao.linkAdd(con, link);
}
request.getRequestDispatcher("/link?action=backList").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
package com.demo.web;
public class InitServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
NewsDao newsDao=new NewsDao();
NewsTypeDao newsTypeDao=new NewsTypeDao();
@Override
public void init(ServletConfig config) throws ServletException {
ServletContext application=config.getServletContext();
this.refreshSystem(application);
}
private void refreshSystem(ServletContext application){
Connection con=null;
try{
con=dbUtil.getCon();
List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con);
application.setAttribute("newsTypeList", newsTypeList);
String sql="select * from t_news order by publishDate desc limit 0,8 ";
List<News> newestNewsList=newsDao.newsList(con, sql);
application.setAttribute("newestNewsList", newestNewsList);
sql="select * from t_news order by click desc limit 0,8";
List<News> hotNewsList=newsDao.newsList(con, sql);
application.setAttribute("hotNewsList", hotNewsList);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
}
}
package com.demo.web;
public class LinkServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
LinkDao linkDao=new LinkDao();
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
public class InitServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
NewsDao newsDao=new NewsDao();
NewsTypeDao newsTypeDao=new NewsTypeDao();
@Override
public void init(ServletConfig config) throws ServletException {
ServletContext application=config.getServletContext();
this.refreshSystem(application);
}
private void refreshSystem(ServletContext application){
Connection con=null;
try{
con=dbUtil.getCon();
List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con);
application.setAttribute("newsTypeList", newsTypeList);
String sql="select * from t_news order by publishDate desc limit 0,8 ";
List<News> newestNewsList=newsDao.newsList(con, sql);
application.setAttribute("newestNewsList", newestNewsList);
sql="select * from t_news order by click desc limit 0,8";
List<News> hotNewsList=newsDao.newsList(con, sql);
application.setAttribute("hotNewsList", hotNewsList);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(StringUtil.isNotEmpty(newsId)){
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻修改"));
}else{
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻添加"));
}
request.setAttribute("mainPage", "/background/news/newsSave.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
FileItemFactory factory=new DiskFileItemFactory();
ServletFileUpload upload=new ServletFileUpload(factory);
List<FileItem> items=null;
try {
items=upload.parseRequest(request);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Iterator itr=items.iterator();
News news=new News();
while(itr.hasNext()){
FileItem item=(FileItem) itr.next();
if(item.isFormField()){
String fieldName=item.getFieldName();
if("newsId".equals(fieldName)){
if(StringUtil.isNotEmpty(item.getString("utf-8"))){
news.setNewsId(Integer.parseInt(item.getString("utf-8")));
}
request.setAttribute("pageCode", this.genUpAndDownPageCode(newsDao.getUpAndDownPageId(con, newsId)));
request.setAttribute("navCode", NavUtil.genNewsNavigation(news.getTypeName(), news.getTypeId()+"",news.getTitle()));
request.setAttribute("title", news.getTitle());
request.setAttribute("mainPage", "news/newsShow.jsp");
request.getRequestDispatcher("foreground/newsTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private String genUpAndDownPageCode(List<News> upAndDownPage){
News upNews=upAndDownPage.get(0);
News downNews=upAndDownPage.get(1);
StringBuffer pageCode=new StringBuffer();
if(upNews.getNewsId()==-1){
pageCode.append("<p>上一篇:没有了</p>");
}else{
pageCode.append("<p>上一篇:<a href='news?action=show&newsId="+upNews.getNewsId()+"'>"+upNews.getTitle()+"</a></p>");
}
if(downNews.getNewsId()==-1){
pageCode.append("<p>下一篇:没有了</p>");
}else{
pageCode.append("<p>下一篇:<a href='news?action=show&newsId="+downNews.getNewsId()+"'>"+downNews.getTitle()+"</a></p>");
}
return pageCode.toString();
}
private void newsPreSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
Connection con=null;
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(newsId)){
News news=newsDao.getNewsById(con, newsId);
request.setAttribute("news", news);
}
List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con);
request.setAttribute("newsTypeList", newsTypeList);
if(StringUtil.isNotEmpty(newsId)){
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻修改"));
}else{
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻添加"));
}
private void login(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String userName=request.getParameter("userName");
String password=request.getParameter("password");
HttpSession session=request.getSession();
Connection con=null;
try{
con=dbUtil.getCon();
User user=new User(userName,password);
User currentUser=userDao.login(con, user);
if(currentUser==null){
request.setAttribute("error", "用户名或者密码错误!");
request.setAttribute("password", password);
request.setAttribute("userName", userName);
request.getRequestDispatcher("/background/login.jsp").forward(request, response);
}else{
session.setAttribute("currentUser", currentUser);
request.setAttribute("mainPage", "/background/default.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void logout(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.getSession().invalidate();
System.out.println(request.getContextPath()+"/background/login.jsp");
response.sendRedirect(request.getContextPath()+"/background/login.jsp");
}
}
package com.demo.web;
private void newsPreSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
Connection con=null;
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(newsId)){
News news=newsDao.getNewsById(con, newsId);
request.setAttribute("news", news);
}
List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con);
request.setAttribute("newsTypeList", newsTypeList);
if(StringUtil.isNotEmpty(newsId)){
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻修改"));
}else{
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻添加"));
}
request.setAttribute("mainPage", "/background/news/newsSave.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
FileItemFactory factory=new DiskFileItemFactory();
ServletFileUpload upload=new ServletFileUpload(factory);
List<FileItem> items=null;
try {
items=upload.parseRequest(request);
} catch (Exception e) {
// TODO Auto-generated catch block
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action=request.getParameter("action");
if("save".equals(action)){
commentSave(request,response);
}else if("backList".equals(action)){
commentBackList(request,response);
}else if("delete".equals(action)){
commentDelete(request,response);
}
}
private void commentSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
String content=request.getParameter("content");
String userIP=request.getRemoteAddr();
Comment comment=new Comment(Integer.parseInt(newsId), content, userIP);
Connection con=null;
try{
con=dbUtil.getCon();
commentDao.commentAdd(con, comment);
request.getRequestDispatcher("news?action=show&newsId="+newsId).forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void commentBackList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String s_bCommentDate=request.getParameter("s_bCommentDate");
String s_aCommentDate=request.getParameter("s_aCommentDate");
String page=request.getParameter("page");
HttpSession session=request.getSession();
if(StringUtil.isEmpty(page)){
}
private void login(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String userName=request.getParameter("userName");
String password=request.getParameter("password");
HttpSession session=request.getSession();
Connection con=null;
try{
con=dbUtil.getCon();
User user=new User(userName,password);
User currentUser=userDao.login(con, user);
if(currentUser==null){
request.setAttribute("error", "用户名或者密码错误!");
request.setAttribute("password", password);
request.setAttribute("userName", userName);
request.getRequestDispatcher("/background/login.jsp").forward(request, response);
}else{
session.setAttribute("currentUser", currentUser);
request.setAttribute("mainPage", "/background/default.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void logout(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.getSession().invalidate();
System.out.println(request.getContextPath()+"/background/login.jsp");
response.sendRedirect(request.getContextPath()+"/background/login.jsp");
}
}
package com.demo.web;
}
package com.demo.web;
public class IndexServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
NewsDao newsDao=new NewsDao();
NewsTypeDao newsTypeDao=new NewsTypeDao();
LinkDao linkDao=new LinkDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsBackList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String s_bPublishDate=request.getParameter("s_bPublishDate");
String s_aPublishDate=request.getParameter("s_aPublishDate");
String s_title=request.getParameter("s_title");
String page=request.getParameter("page");
HttpSession session=request.getSession();
if(StringUtil.isEmpty(page)){
page="1";
session.setAttribute("s_bPublishDate", s_bPublishDate);
session.setAttribute("s_aPublishDate", s_aPublishDate);
session.setAttribute("s_title", s_title);
}else{
s_bPublishDate=(String) session.getAttribute("s_bPublishDate");
s_aPublishDate=(String) session.getAttribute("s_aPublishDate");
s_title=(String) session.getAttribute("s_title");
}
Connection con=null;
News s_news=new News();
if(StringUtil.isNotEmpty(s_title)){
s_news.setTitle(s_title);
}
try{
con=dbUtil.getCon();
int total=newsDao.newsCount(con, s_news, s_bPublishDate, s_aPublishDate);
String pageCode=PageUtil.getPagation(request.getContextPath()+"/news?action=backList", total, Integer.parseInt(page), Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
List<News> newsBackList=newsDao.newsList(con, s_news,pageBean,s_bPublishDate,s_aPublishDate);
throws ServletException, IOException {
String userName=request.getParameter("userName");
String password=request.getParameter("password");
HttpSession session=request.getSession();
Connection con=null;
try{
con=dbUtil.getCon();
User user=new User(userName,password);
User currentUser=userDao.login(con, user);
if(currentUser==null){
request.setAttribute("error", "用户名或者密码错误!");
request.setAttribute("password", password);
request.setAttribute("userName", userName);
request.getRequestDispatcher("/background/login.jsp").forward(request, response);
}else{
session.setAttribute("currentUser", currentUser);
request.setAttribute("mainPage", "/background/default.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void logout(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.getSession().invalidate();
System.out.println(request.getContextPath()+"/background/login.jsp");
response.sendRedirect(request.getContextPath()+"/background/login.jsp");
}
}
package com.demo.web;
public class CommentServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
CommentDao commentDao=new CommentDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action=request.getParameter("action");
if("save".equals(action)){
commentSave(request,response);
}else if("backList".equals(action)){
commentBackList(request,response);
}else if("delete".equals(action)){
commentDelete(request,response);
}
}
private void commentSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
String content=request.getParameter("content");
String userIP=request.getRemoteAddr();
Comment comment=new Comment(Integer.parseInt(newsId), content, userIP);
Connection con=null;
try{
con=dbUtil.getCon();
commentDao.commentAdd(con, comment);
request.getRequestDispatcher("news?action=show&newsId="+newsId).forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
newsTypeDao.newsTypeUpdate(con, newsType);
}else{
newsTypeDao.newsTypeAdd(con, newsType);
}
request.getRequestDispatcher("/newsType?action=backList").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsTypeBackList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection con=null;
try{
con=dbUtil.getCon();
List<NewsType> newsTypeBackList=newsTypeDao.newsTypeList(con);
request.setAttribute("newsTypeBackList", newsTypeBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别维护"));
request.setAttribute("mainPage", "/background/newsType/newsTypeList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsTypeDelete(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsTypeId=request.getParameter("newsTypeId");
Connection con=null;
try{
private void newsTypeSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection con=null;
String newsTypeId=request.getParameter("newsTypeId");
String typeName=request.getParameter("typeName");
NewsType newsType=new NewsType(typeName);
if(StringUtil.isNotEmpty(newsTypeId)){
newsType.setNewsTypeId(Integer.parseInt(newsTypeId));
}
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(newsTypeId)){
newsTypeDao.newsTypeUpdate(con, newsType);
}else{
newsTypeDao.newsTypeAdd(con, newsType);
}
request.getRequestDispatcher("/newsType?action=backList").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsTypeBackList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection con=null;
try{
con=dbUtil.getCon();
List<NewsType> newsTypeBackList=newsTypeDao.newsTypeList(con);
request.setAttribute("newsTypeBackList", newsTypeBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别维护"));
request.setAttribute("mainPage", "/background/newsType/newsTypeList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void linkBackList(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
Connection con=null;
try{
con=dbUtil.getCon();
List<Link> linkBackList=linkDao.linkList(con, "select * from t_link order by orderNum");
request.setAttribute("linkBackList", linkBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("友情链接管理", "友情链接维护"));
request.setAttribute("mainPage", "/background/link/linkList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void linkPreSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
String linkId=request.getParameter("linkId");
Connection con=null;
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(linkId)){
Link link=linkDao.getLinkById(con, linkId);
request.setAttribute("link", link);
}
if(StringUtil.isNotEmpty(linkId)){
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("友情链接管理", "友情链接修改"));
private void newsBackList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String s_bPublishDate=request.getParameter("s_bPublishDate");
String s_aPublishDate=request.getParameter("s_aPublishDate");
String s_title=request.getParameter("s_title");
String page=request.getParameter("page");
HttpSession session=request.getSession();
if(StringUtil.isEmpty(page)){
page="1";
session.setAttribute("s_bPublishDate", s_bPublishDate);
session.setAttribute("s_aPublishDate", s_aPublishDate);
session.setAttribute("s_title", s_title);
}else{
s_bPublishDate=(String) session.getAttribute("s_bPublishDate");
s_aPublishDate=(String) session.getAttribute("s_aPublishDate");
s_title=(String) session.getAttribute("s_title");
}
Connection con=null;
News s_news=new News();
if(StringUtil.isNotEmpty(s_title)){
s_news.setTitle(s_title);
}
try{
con=dbUtil.getCon();
int total=newsDao.newsCount(con, s_news, s_bPublishDate, s_aPublishDate);
String pageCode=PageUtil.getPagation(request.getContextPath()+"/news?action=backList", total, Integer.parseInt(page), Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
List<News> newsBackList=newsDao.newsList(con, s_news,pageBean,s_bPublishDate,s_aPublishDate);
request.setAttribute("pageCode", pageCode);
request.setAttribute("newsBackList", newsBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻列表"));
request.setAttribute("mainPage", "/background/news/newsList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsDelete(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
String newsId=request.getParameter("newsId");
int total=newsDao.newsCount(con, s_news, s_bPublishDate, s_aPublishDate);
String pageCode=PageUtil.getPagation(request.getContextPath()+"/news?action=backList", total, Integer.parseInt(page), Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(PropertiesUtil.getValue("backPageSize")));
List<News> newsBackList=newsDao.newsList(con, s_news,pageBean,s_bPublishDate,s_aPublishDate);
request.setAttribute("pageCode", pageCode);
request.setAttribute("newsBackList", newsBackList);
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻列表"));
request.setAttribute("mainPage", "/background/news/newsList.jsp");
request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsDelete(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
String newsId=request.getParameter("newsId");
Connection con=null;
boolean delFlag;
try{
con=dbUtil.getCon();
int delNums=newsDao.newsDelete(con, newsId);
if(delNums==1){
delFlag=true;
}else{
delFlag=false;
}
ResponseUtil.write(delFlag, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
package com.demo.web;
try {
List<FileItem> list = upload.parseRequest(request);
for (FileItem fileItem : list) {
String imageName = DateUtil.getCurrentDateStr();
File file = new File(PropertiesUtil.getValue("imagePath") + imageName + "." + fileItem.getName().split("\\.")[1]);
String newPath = PropertiesUtil.getValue("imageFile") + "/" + imageName + "." + fileItem.getName().split("\\.")[1];
fileItem.write(file);
String callback = request.getParameter("CKEditorFuncNum");
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + callback + ",'" + newPath + "',''" + ")");
out.println("</script>");
out.flush();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
package com.demo.web;
public class UserServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
UserDao userDao=new UserDao();
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
e.printStackTrace();
}
}
}
private String genUpAndDownPageCode(List<News> upAndDownPage){
News upNews=upAndDownPage.get(0);
News downNews=upAndDownPage.get(1);
StringBuffer pageCode=new StringBuffer();
if(upNews.getNewsId()==-1){
pageCode.append("<p>上一篇:没有了</p>");
}else{
pageCode.append("<p>上一篇:<a href='news?action=show&newsId="+upNews.getNewsId()+"'>"+upNews.getTitle()+"</a></p>");
}
if(downNews.getNewsId()==-1){
pageCode.append("<p>下一篇:没有了</p>");
}else{
pageCode.append("<p>下一篇:<a href='news?action=show&newsId="+downNews.getNewsId()+"'>"+downNews.getTitle()+"</a></p>");
}
return pageCode.toString();
}
private void newsPreSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
Connection con=null;
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(newsId)){
News news=newsDao.getNewsById(con, newsId);
request.setAttribute("news", news);
}
List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con);
request.setAttribute("newsTypeList", newsTypeList);
if(StringUtil.isNotEmpty(newsId)){
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻修改"));
}else{
request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻添加"));
}
request.setAttribute("mainPage", "/background/news/newsSave.jsp");
DbUtil dbUtil=new DbUtil();
CommentDao commentDao=new CommentDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action=request.getParameter("action");
if("save".equals(action)){
commentSave(request,response);
}else if("backList".equals(action)){
commentBackList(request,response);
}else if("delete".equals(action)){
commentDelete(request,response);
}
}
private void commentSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String newsId=request.getParameter("newsId");
String content=request.getParameter("content");
String userIP=request.getRemoteAddr();
Comment comment=new Comment(Integer.parseInt(newsId), content, userIP);
Connection con=null;
try{
con=dbUtil.getCon();
commentDao.commentAdd(con, comment);
request.getRequestDispatcher("news?action=show&newsId="+newsId).forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
public class NewsServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
NewsDao newsDao=new NewsDao();
NewsTypeDao newsTypeDao=new NewsTypeDao();
CommentDao commentDao=new CommentDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void newsDelete(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException{
String newsId=request.getParameter("newsId");
Connection con=null;
boolean delFlag;
try{
con=dbUtil.getCon();
int delNums=newsDao.newsDelete(con, newsId);
if(delNums==1){
delFlag=true;
}else{
delFlag=false;
}
ResponseUtil.write(delFlag, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
package com.demo.web;
public class CommentServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
DbUtil dbUtil=new DbUtil();
CommentDao commentDao=new CommentDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action=request.getParameter("action");
if("save".equals(action)){
commentSave(request,response);
}else if("backList".equals(action)){
commentBackList(request,response);
}else if("delete".equals(action)){
commentDelete(request,response);
}
}