基于javaweb+mysql的jsp+servlet小说阅读管理系统(java+jsp+bootstrap+servlet+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的JSP+Servlet小说阅读管理系统(java+jsp+bootstrap+servlet+mysql)
项目介绍
项目主要包括管理员与用户两种角色; 管理员角色包含以下功能:管理员登录,主页面,分类查看,修改个人信息,上传小说,查看小说,删除小说,评论顶收藏小说等功能。 用户角色包含以下功能:用户注册,用户登录,查看销售,查看小说,发布小说,搜索小说,查看个人信息等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否
技术栈
- 后端:servlet 2. 前端:JSP+css+javascript+bootstrap+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中util/DBUtil.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/jsp_xiaoshuo_site
}
}else{
out.print("{\"state\":2}"); //用户已存在
}
}else if(type.equals("changenickname")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setNickname(value);
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("setsex")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setSex(value);
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("setbirthday")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setBirthday(value);
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("changeemail")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setEmail(value);;
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("changepassword")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
String[] v=value.split(",");
String old=v[0];
String New=v[1];
if(us.getPassword().equals(old)){
us.setPassword(New);
ud.update(us);
out.print("{\"state\":0}");//成功
}else{
User currentUser = ud.getUser(username);
session.setAttribute("user", currentUser);
resp.sendRedirect("/jsp_xiaoshuo_site/jsp/main.jsp");
out.close();
}
}
}
}
/**
*
* 此类用于用户修改头像 或者上传头像
*
*/
@SuppressWarnings("serial")
public class ChangeIconServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
/* UserDao ud=new UserDao();
User user=ud.getUser("tyqinjava");
user.setUser_icon("/face/1.png");
ud.update(user);*/
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/plain;charset=utf-8");
PrintWriter out=resp.getWriter();
String changeIcon=req.getParameter("changeIcon");
String iconName=req.getParameter("iconname");
HttpSession session=req.getSession();
UserDao ud=new UserDao();
if(changeIcon!=null&&iconName!=null){ //更改头像逻辑
User user=(User)session.getAttribute("user"); //session不同步问题先不讨论
if(user==null){
out.print("{\"state\":1}"); //session 过期
if(type.equals("getuserpost")){
UserDao ud=new UserDao();
User u=ud.getUser(user_id);//当前浏览的用户
if(u==null)return;
PostDao pd=new PostDao();
List<Post> ps=pd.getPosts(u.getUser_id());//用户发表过的帖子
JSONArray jsonArray=new JSONArray();
/*time
* pid
* title
* isSamll*/
for(Post p:ps){
JSONObject json=new JSONObject();
json.put("time", p.getPost_time());
json.put("pid", p.getPost_id());
json.put("title", p.getTitle());
if(isSmall){
json.put("isSmall", "true");
}else{
json.put("isSmall", "false");
}
jsonArray.put(json);
}
out.print(jsonArray.toString());
}else if(type.equals("delpost")){
String pid=req.getParameter("pid");
if(pid==null)return;
int post_id=Integer.parseInt(pid);
PostDao pd=new PostDao();
Post p=pd.getPost(post_id);
if(p==null)return;
pd.delPost(post_id);
CollectionDao cld=new CollectionDao();
cld.delCollectionByPostId(post_id);
CommentDao cd=new CommentDao();
out.print("ok");
}else if(type.equals("delcollection")){
String clid=req.getParameter("clid");
if(clid==null)return;
int cl_id=Integer.parseInt(clid);
CollectionDao cld=new CollectionDao();
cld.delCollectionById(cl_id);
out.print("ok");
return;
}else if(type.equals("getusercollection")){
if(uid==null){return;}
CollectionDao cld=new CollectionDao();
List<Collection> cls=cld.getCollectionByUserId(user_id);
if(cls.size()==0)return;
PostDao pd=new PostDao();
user.setReg_time(date);
ud.insertUser(user);
User currentUser = ud.getUser(username);
session.setAttribute("user", currentUser);
resp.sendRedirect("/jsp_xiaoshuo_site/jsp/main.jsp");
out.close();
}
}
}
}
/**
*
* 此类用于用户修改头像 或者上传头像
*
*/
@SuppressWarnings("serial")
public class ChangeIconServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
/* UserDao ud=new UserDao();
User user=ud.getUser("tyqinjava");
user.setUser_icon("/face/1.png");
ud.update(user);*/
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/plain;charset=utf-8");
PrintWriter out=resp.getWriter();
String changeIcon=req.getParameter("changeIcon");
String iconName=req.getParameter("iconname");
HttpSession session=req.getSession();
UserDao ud=new UserDao();
if(changeIcon!=null&&iconName!=null){ //更改头像逻辑
//评论相关
@SuppressWarnings("serial")
public class CommentServlet extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
String type=req.getParameter("type");
String content=req.getParameter("content");
String pid=req.getParameter("pid");
PrintWriter out=resp.getWriter();
if(type==null||content==null||pid==null){
return;
}
HttpSession session=req.getSession();
User user=(User)session.getAttribute("user");
if(user==null){
out.print("<script type='text/javascript'>"
+ "window.location.href='/jsp_xiaoshuo_site/index.jsp'"
+ "</script>");
return;
}
int post_id=Integer.parseInt(pid);
Comment com=new Comment();
com.setContent(content);
com.setPost_id(post_id);
com.setUser_id(user.getUser_id());
Date now=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm");
String time=sdf.format(now);
com.setTime(time);
CommentDao cd=new CommentDao();
cd.insert(com);
out.print("<script type='text/javascript'>"
+ "window.location.href='/jsp_xiaoshuo_site/jsp/postdetail.jsp?pid="+pid+"'"
+ "</script>");
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
}
out.print("删除成功!");
}
}
@SuppressWarnings("unused")
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
}
/**
*
* 登录
*
*
*
*/
@SuppressWarnings("serial")
public class LoginServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/plain;charset=utf-8");
req.setCharacterEncoding("utf-8");
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("setbirthday")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setBirthday(value);
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("changeemail")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
us.setEmail(value);;
ud.update(us);
out.print("{\"state\":0}");//成功
}
}else if(type.equals("changepassword")){
User us=(User)session.getAttribute("user");
if(us==null){
out.print("{\"state\":1}"); //session 过期
}else{
String[] v=value.split(",");
String old=v[0];
String New=v[1];
if(us.getPassword().equals(old)){
us.setPassword(New);
ud.update(us);
out.print("{\"state\":0}");//成功
}else{
out.print("{\"state\":2}");//密码输入错误
}
}
}
}
}
public class CommentServlet extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
String type=req.getParameter("type");
String content=req.getParameter("content");
String pid=req.getParameter("pid");
PrintWriter out=resp.getWriter();
if(type==null||content==null||pid==null){
return;
}
HttpSession session=req.getSession();
User user=(User)session.getAttribute("user");
if(user==null){
out.print("<script type='text/javascript'>"
+ "window.location.href='/jsp_xiaoshuo_site/index.jsp'"
+ "</script>");
return;
}
int post_id=Integer.parseInt(pid);
Comment com=new Comment();
com.setContent(content);
com.setPost_id(post_id);
com.setUser_id(user.getUser_id());
Date now=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm");
String time=sdf.format(now);
com.setTime(time);
CommentDao cd=new CommentDao();
cd.insert(com);
out.print("<script type='text/javascript'>"
+ "window.location.href='/jsp_xiaoshuo_site/jsp/postdetail.jsp?pid="+pid+"'"
+ "</script>");
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
}
json.put("content", c.getContent());
jsonArray.put(json);
}
out.print(jsonArray.toString());
}
}
/**
*
* 此类用于处理编辑器图片上传功能
* 在处理有中文的url请求时没用
* 这个问题以后再来讨论
*
*/
@SuppressWarnings("serial")
public class ImageUploadServlet extends HttpServlet{
@SuppressWarnings("rawtypes")
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//生成文件标识
resp.setContentType("text/html;charset=utf-8");
ServletContext sc=this.getServletContext();
String tempFile="/temp";
String filePath="/images/tiezi";
//删除帖子
@SuppressWarnings("serial")
public class DeletePostServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/plain;charset=utf-8");
PrintWriter out=resp.getWriter();
String id=req.getParameter("id");
PostDao postDao = new PostDao();
postDao.delPost(Integer.parseInt(id));
out.print("删除成功!");
}
@SuppressWarnings("unused")
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
}
public class HandleSession implements HttpSessionListener {
private int count=0;
@Override
public void sessionCreated(HttpSessionEvent se) {
++count;
System.out.println("当前共计有:"+count+"个用户在线");
System.out.println("sessionCreate");
}
@Override
public void sessionDestroyed(HttpSessionEvent se) {
if(count>0){
jsonArray.put(json);
}
out.print(jsonArray.toString());
}else if(type.equals("delpost")){
String pid=req.getParameter("pid");
if(pid==null)return;
int post_id=Integer.parseInt(pid);
PostDao pd=new PostDao();
Post p=pd.getPost(post_id);
if(p==null)return;
pd.delPost(post_id);
CollectionDao cld=new CollectionDao();
cld.delCollectionByPostId(post_id);
CommentDao cd=new CommentDao();
out.print("ok");
}else if(type.equals("delcollection")){
String clid=req.getParameter("clid");
if(clid==null)return;
int cl_id=Integer.parseInt(clid);
CollectionDao cld=new CollectionDao();
cld.delCollectionById(cl_id);
out.print("ok");
return;
}else if(type.equals("getusercollection")){
if(uid==null){return;}
CollectionDao cld=new CollectionDao();
List<Collection> cls=cld.getCollectionByUserId(user_id);
if(cls.size()==0)return;
PostDao pd=new PostDao();
UserDao ud=new UserDao();
JSONArray jsonArray=new JSONArray();
for(Collection c:cls){
Post p=pd.getPost(c.getPost_id());
int uuid=pd.getUserIdByPostId(p.getPost_id());
User u=ud.getUser(uuid);
JSONObject json=new JSONObject();
/*time
* cl_id
* pid
* title
* isSamll
* uid
* unickname
* pid time tile isSmall
*/
json.put("cl_id",c.getCollection_id());
json.put("pid", p.getPost_id());
@SuppressWarnings("serial")
public class VerCodeServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("image/jpeg");
OutputStream out = resp.getOutputStream();
final char[] e = { 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R',
'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' };
int height = 32;
int width = 100;
BufferedImage bufferImg = new BufferedImage
(100, 32, BufferedImage.TYPE_INT_RGB);
Graphics2D g = bufferImg.createGraphics();
Random rand = new Random();
g.setColor(Color.white);
g.fillRect(0, 0, width, height);
Font f = new Font("Fixedsys", Font.PLAIN, 32);
g.setFont(f);
g.setColor(Color.white);
g.drawRect(0, 0, width - 1, height - 1);
StringBuffer str = new StringBuffer();
for (int i = 0; i < 4; i++) {
str.append(e[rand.nextInt(36)]);
}
g.setColor(Color.black);
}
/**
*
* 登录
*
*
*
*/
@SuppressWarnings("serial")
public class LoginServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/plain;charset=utf-8");
req.setCharacterEncoding("utf-8");
PrintWriter out=resp.getWriter();
String username=req.getParameter("username");
String password=req.getParameter("password");
HttpSession session=req.getSession();
if(username==null||password==null){
return;
}
UserDao ud=new UserDao();
User user=ud.getUser(username);
if(user!=null){
if(user.getPassword().equals(password)){
out.print("{\"state\":0}");
session.setAttribute("user", user);
out.close();
}else{
out.print("{\"state\":2}");
PostDao pd=new PostDao();
Post p=pd.getPost(post_id);
p.setHot(p.getHot()+1);
pd.update(p);
hot.add(post_id);
out.print("ok");
}else{
boolean isAgain=false;
for(Integer i:hot){
if(i==post_id){
isAgain=true;
break;
}else {
continue;
}
}
if(isAgain){
out.print("again");
return;
}
PostDao pd=new PostDao();
Post p=pd.getPost(post_id);
p.setHot(p.getHot()+1);
pd.update(p);
hot.add(post_id);
out.print("ok");
return;
}
}
}
}
/**
*
* 此类用于处理基本资料的更改
*
*
*/
g.setFont(f);
g.setColor(Color.white);
g.drawRect(0, 0, width - 1, height - 1);
StringBuffer str = new StringBuffer();
for (int i = 0; i < 4; i++) {
str.append(e[rand.nextInt(36)]);
}
g.setColor(Color.black);
for (int i = 0; i < 30; i++) {
g.drawLine(0, rand.nextInt(width), rand.nextInt(width), rand.nextInt(height));
}
Color c = new Color(rand.nextInt(256), rand.nextInt(256), rand.nextInt(256));
g.setColor(c);
g.drawString(str.toString(), 0, 32);
HttpSession session = req.getSession();
session.setAttribute("vercode", str.toString());
ImageIO.write(bufferImg, "jpeg", out);
}
}
public class CoreFilter implements Filter{
private FilterConfig config=null;
@Override
public void init(FilterConfig filterConfig) throws ServletException {
config=filterConfig;
}
@Override
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
throws IOException, ServletException {
String pass=config.getInitParameter("pass");
HttpServletRequest req=(HttpServletRequest)request;
String[] path=pass.split(";");
String uri=req.getRequestURI();
req.setCharacterEncoding("utf-8");
resp.setContentType("text/plain;charset=utf-8");
String type=req.getParameter("type");
String uid=req.getParameter("uid");
int user_id=0;
if(uid!=null){
user_id=Integer.parseInt(uid);
}
PrintWriter out=resp.getWriter();
if(type==null)return;
HttpSession session=req.getSession();
User user=(User)session.getAttribute("user");
if(user==null){
return;
}
boolean isSmall=false;
if(user_id==user.getUser_id())
isSmall=true;
if(type.equals("getuserpost")){
UserDao ud=new UserDao();
User u=ud.getUser(user_id);//当前浏览的用户
if(u==null)return;
PostDao pd=new PostDao();
List<Post> ps=pd.getPosts(u.getUser_id());//用户发表过的帖子
JSONArray jsonArray=new JSONArray();
/*time
* pid
* title
* isSamll*/
for(Post p:ps){
JSONObject json=new JSONObject();
json.put("time", p.getPost_time());
json.put("pid", p.getPost_id());
json.put("title", p.getTitle());
if(isSmall){
json.put("isSmall", "true");
}else{
json.put("isSmall", "false");
}
jsonArray.put(json);
}
JSONObject json=new JSONObject();
json.put("cid", c.getComment_id());
json.put("uid", u.getUser_id());
json.put("nickname", u.getNickname());
json.put("uicon", u.getUser_icon());
json.put("time", c.getTime());
json.put("agree", c.getAgree());
json.put("content", c.getContent());
jsonArray.put(json);
}
out.print(jsonArray.toString());
}
}
/**
*
* 此类用于处理编辑器图片上传功能
* 在处理有中文的url请求时没用
* 这个问题以后再来讨论
*
*/
@SuppressWarnings("serial")
public class ImageUploadServlet extends HttpServlet{
@SuppressWarnings("rawtypes")
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//生成文件标识
resp.setContentType("text/html;charset=utf-8");