简单新闻管理系统(jsp)
一、构思
主页中有添加，删除，修改新闻功能，跟数据库连接，分别跳转处理
Navicat for mysql：
列表如图所示：
二、开始编写
新闻主页：
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java"
pageEncoding="UTF-8" %>
<html>
<head>
<title>新闻主页</title>
</head>
<body>
<h1 align="center">新闻主页</h1>
<div>
<table align="center" border="1">
<tr bgcolor="#7fffd4" align="center">
<th>新闻条目</th>
<th>新闻标题</th>
<th>发布日期</th>
<th>修改</th>
<th>删除</th>
</tr>
<%
NewsDao newsDao = new NewsDao();
List<News> list = new ArrayList<News>();
list = newsDao.listAll();
int num = 0;
%>
<%
for(int i=0;i<list.size()&&list!=null;i++){
%>
<tr>
<td align="center"><%=++num%></td>
<td align="center"><a href="/select.jsp?id=<%=list.get(i).getId()%>"><%=list.get(i).getNewsTitle()%></a></td>
<td align="center"><%=list.get(i).getDate()%></td>
<td align="center"><a href="/update.jsp?id=<%=list.get(i).getId()%>">修改</a></td>
<td align="center"><a href="/delete.jsp?id=<%=list.get(i).getId()%>">删除</a></td>
</tr>
<%}%>
</table>
<p align="center"><a href="/add.jsp">添加</a></p>
</div>
</body>
</html>浏览页面
select.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>浏览页面</title>
</head>
<body>
<%
News news = new News();
NewsDao newsDao = new NewsDao();
int id = Integer.parseInt(request.getParameter("id"));
news = newsDao.selectNewsById(id);//获取新闻全部内容
%>
<h1 align="center"><%=news.getNewsTitle()%></h1>
<form action="index.jsp" method="post">
<table align="center">
<tr><td>标题：<%=news.getAuthor()%></td></tr><br/>
<tr><td>日期：<%=news.getDate()%></td></tr><br/>
<tr><td>内容：<%=news.getContent()%></td></tr><br/>
<tr><td><p align="center">
<input type="submit" value="返回"></p></td></tr>
</table>
</form>
</body>
</html>
修改页面//添加页面
add.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>添加页面</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");//处理乱码问题
%>
<form action="adds.jsp?id=<%=request.getParameter("id")%>" method="post">
<p align="center">标题：<input type="text" name="newsTitle"></p>
<p align="center">作者：<input type="text" name="author"></p>
<p align="center">日期：<input type="text" name="date"></p>
<p align="center">内容：<textarea
style="width: 300px;length:500;" name="content"><%=request.getAttribute("content")%></textarea></p><br/>
<p align="center"><input type="submit" value="添加"></p>
</form>//回到添加处理页面adds.jsp
</body>
</html>adds.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>处理页面</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");//处理乱码问题
News news = new News();
NewsDao newsDao = new NewsDao();
news.setNewsTitle(request.getParameter("newsTitle"));
news.setAuthor(request.getParameter("author"));
news.setDate(request.getParameter("date"));
news.setContent(request.getParameter("content"));//从add.jsp获取值赋给news
boolean flag = newsDao.insertNews(news);
if(flag){
request.getRequestDispatcher("/index.jsp").forward(request,response);//跳转到新闻主页（重定向）
}
%>
</body>
</html>edit.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>修改页面</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");//处理乱码问题
News news = new News();
NewsDao newsDao = new NewsDao();
int id = Integer.parseInt(request.getParameter("id"));//从主页中获取id
news = newsDao.selectNewsById(id);//获取原值
%>
<form action="updates.jsp?id=<%=request.getParameter("id")%>" method="post">
<table align="center">
<p align="center">标题：<input type="text" value="<%=news.getNewsTitle()%>" name="newsTitle"></p><br/>
<p align="center">作者：<input type="text" value="<%=news.getAuthor()%>" name="author"></p><br/>
<p align="center">日期：<input type="text" value="<%=news.getDate()%>" name="date"></p><br/>
<p align="center">内容：<textarea
style="width: 300px;length:500;" name="content"><%=news.getContent()%></textarea></p><br/>//修改页面中含有原来的新闻
<p align="center"><input type="submit" value="修改"></p>
</table>
</form>
</body>
</html>edits.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>处理页面</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
NewsDao newsDao = new NewsDao();
News news = new News();
int id = Integer.parseInt(request.getParameter("id"));//由于request.getParameter的返回值是String类型，因此需要强制转换成int型
news.setId(id);
news.setNewsTitle(request.getParameter("newsTitle"));
news.setAuthor(request.getParameter("author"));
news.setDate(request.getParameter("date"));
news.setContent(request.getParameter("content"));//赋予新的修改内容
boolean flag = newsDao.updateNews(news,id);
if(flag){
request.getRequestDispatcher("/select.jsp").forward(request,response);//跳转到浏览页面
}
%>
</body>
</html>delete.jsp（删除页面）
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>删除页面</title>
</head>
<body>
<%
NewsDao newsDao = new NewsDao();
int id =Integer.parseInt( request.getParameter("id"));
boolean flag = newsDao.deleteNewsById(id);//直接调用删除方法
if(flag){
request.getRequestDispatcher("/index.jsp").forward(request,response);//跳转回主页
}
%>
</form>
</body>
</html>这便是我所写的简单新闻管理系统，还有很多不足，欢迎广大同僚来踩踩
若是有什么问题，希望能给我提提意见^_^
1646
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
