基于javaweb+mysql的jsp+servlet小说阅读管理系统(java+jsp+bootstrap+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的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
out.close();
}
}
}
package servlets;
//删除帖子
@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 {
}
}
package listener;
public class HandleSession implements HttpSessionListener {
e.printStackTrace();
}
}
//这个方法用于出来表单域
@SuppressWarnings("unused")
private void processFormField(FileItem item){
String name=item.getFieldName();
String value=item.getString();
}
//这个方法用于处理文件域
private String processUploadFile(FileItem item,String filePath){
String fileName=item.getName();
System.out.println(fileName);
int index=fileName.lastIndexOf("\\");
fileName=fileName.substring(index+1,fileName.length());
long fileSize=item.getSize();
if(fileName.equals("")&&fileSize==0){
return null;
}
UUID uid=UUID.randomUUID();
String fileid=uid.toString();
File uploadFile=new File(filePath+"/"+fileid);
try {
item.write(uploadFile);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return fileid;
}
}
package servlets;
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 {
}
}
package servlets;
@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);
String vercode = (String) session.getAttribute("vercode");
String vr = req.getParameter("vercode");
if (username == null) {
if (vercode.equals(vr)) {
out.print("{\"state\":0}");
return;
} else {
out.print("{\"state\":111}");
return;
}
} else {
if (password == null || email == null || nickName == null) {
User user = ud.getUser(username);
if (user == null) { // 用户不存在
String data = "{\"state\":0}";
out.print(data);
out.close();
} else { // 用户存在
String data = "{\"state\":1}";
out.print(data);
out.close();
}
} else {
User user = new User();
user.setUser_name(username);
user.setPassword(password);
user.setNickname(nickName);
user.setEmail(email);
Date now = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String date = dateFormat.format(now);
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();
}
}
}
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());
json.put("title", p.getTitle());
json.put("time", c.getTime());
json.put("uid",u.getUser_id());
json.put("unickname", u.getNickname());
if(isSmall){
json.put("isSmall", "true");
}else{
json.put("isSmall", "false");
HttpSession session = req.getSession();
String vercode = (String) session.getAttribute("vercode");
String vr = req.getParameter("vercode");
if (username == null) {
if (vercode.equals(vr)) {
out.print("{\"state\":0}");
return;
} else {
out.print("{\"state\":111}");
return;
}
} else {
if (password == null || email == null || nickName == null) {
User user = ud.getUser(username);
if (user == null) { // 用户不存在
String data = "{\"state\":0}";
out.print(data);
out.close();
} else { // 用户存在
String data = "{\"state\":1}";
out.print(data);
out.close();
}
} else {
User user = new User();
user.setUser_name(username);
user.setPassword(password);
user.setNickname(nickName);
user.setEmail(email);
Date now = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String date = dateFormat.format(now);
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();
}
}
}
}
package servlets;
@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}");
out.close();
}
}else{
out.print("{\"state\":1}");
out.close();
}
}
}
package servlets;
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}");
out.close();
}
}else{
out.print("{\"state\":1}");
out.close();
}
}
}
package servlets;
//删除帖子
@SuppressWarnings("serial")
public class DeletePostServlet extends HttpServlet{
@Override
*
* 此类用于用户修改头像 或者上传头像
*
*/
@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 过期
}else{
user.setUser_icon("face/"+iconName);
ud.update(user);
out.print("{\"state\":0}");
}
}else{
User user=(User)session.getAttribute("user"); //session不同步问题先不讨论
if(user==null){
out.print("{\"state\":1}"); //session 过期
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());
}
}
package servlets;
/**
*
* 此类用于处理编辑器图片上传功能
* 在处理有中文的url请求时没用
* 这个问题以后再来讨论
*
*/
@SuppressWarnings("serial")
String nickName = req.getParameter("nickname");
String email = req.getParameter("email");
UserDao ud = new UserDao();
HttpSession session = req.getSession();
String vercode = (String) session.getAttribute("vercode");
String vr = req.getParameter("vercode");
if (username == null) {
if (vercode.equals(vr)) {
out.print("{\"state\":0}");
return;
} else {
out.print("{\"state\":111}");
return;
}
} else {
if (password == null || email == null || nickName == null) {
User user = ud.getUser(username);
if (user == null) { // 用户不存在
String data = "{\"state\":0}";
out.print(data);
out.close();
} else { // 用户存在
String data = "{\"state\":1}";
out.print(data);
out.close();
}
} else {
User user = new User();
user.setUser_name(username);
user.setPassword(password);
user.setNickname(nickName);
user.setEmail(email);
Date now = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String date = dateFormat.format(now);
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();
}
}
}
}
package servlets;
filePath=sc.getRealPath(filePath);
PrintWriter out=resp.getWriter();
try {
DiskFileItemFactory df=new DiskFileItemFactory();
//设置向硬盘写数据时所用的缓冲区的大小
df.setSizeThreshold(4*1024); //4K
//设置临时目录
df.setRepository(new File(tempFile));
//创建一个上传器
ServletFileUpload sf=new ServletFileUpload(df);
sf.setSizeMax(4*1024*1024);
List items=sf.parseRequest(req);
Iterator iter=items.iterator();
String filename=null;
while(iter.hasNext()){
FileItem item=(FileItem)iter.next();
if(item.isFormField()){
processFormField(item);
}else{
filename=processUploadFile(item,filePath);
}
}
if(filename==null)return;
out.print("{\"url\":\"tiezi/"+filename+"\",state:\"SUCCESS\"}");
}catch(Exception e){
e.printStackTrace();
}
}
//这个方法用于出来表单域
@SuppressWarnings("unused")
private void processFormField(FileItem item){
String name=item.getFieldName();
String value=item.getString();
}
//这个方法用于处理文件域
private String processUploadFile(FileItem item,String filePath){
String fileName=item.getName();
System.out.println(fileName);
if(changeIcon!=null&&iconName!=null){ //更改头像逻辑
User user=(User)session.getAttribute("user"); //session不同步问题先不讨论
if(user==null){
out.print("{\"state\":1}"); //session 过期
}else{
user.setUser_icon("face/"+iconName);
ud.update(user);
out.print("{\"state\":0}");
}
}else{
User user=(User)session.getAttribute("user"); //session不同步问题先不讨论
if(user==null){
out.print("{\"state\":1}"); //session 过期
}else{
user.setUser_icon(iconName); //上传头像
ud.update(user);
out.print("{\"state\":0}");
}
}
}
}
package servlets;
//评论相关
@SuppressWarnings("serial")
public class CommentServlet extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
System.out.println(fileName);
int index=fileName.lastIndexOf("\\");
fileName=fileName.substring(index+1,fileName.length());
long fileSize=item.getSize();
if(fileName.equals("")&&fileSize==0){
return null;
}
UUID uid=UUID.randomUUID();
String fileid=uid.toString();
File uploadFile=new File(filePath+"/"+fileid);
try {
item.write(uploadFile);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return fileid;
}
}
package servlets;
/**
*
*
* 发小说
*
*/
}
}
}
package servlets;
//删除帖子
@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 {
}
}
package listener;
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());
json.put("title", p.getTitle());
json.put("time", c.getTime());
json.put("uid",u.getUser_id());
json.put("unickname", u.getNickname());
if(isSmall){
json.put("isSmall", "true");
}else{
json.put("isSmall", "false");
}
jsonArray.put(json);
}
out.print(jsonArray.toString());
}else if(type.equals("getusercomment")){
if(uid==null){return;}
CommentDao cd=new CommentDao();
List<Comment> cs=cd.getCommentByUserId(user_id);
JSONArray jsonArray=new JSONArray();
for(Comment c:cs){
PostDao pd=new PostDao();
String isExist="false";
Post p=pd.getPost(c.getPost_id()); //发表的帖子
JSONObject json=new JSONObject();
if(p!=null){
isExist="true";
UserDao ud=new UserDao();
User u=ud.getUser(p.getUser_id()); //创建人
json.put("uid", u.getUser_id());
json.put("title",p.getTitle());
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
PrintWriter out=resp.getWriter();
String type=req.getParameter("type");
String title=req.getParameter("title");
String content=req.getParameter("content");
if(type==null||title==null||content==null){
return;
}
HttpSession session=req.getSession();
User user=(User)session.getAttribute("user");
if(user==null){
out.print("<script type='text/javascript'>"+""
+ "alert('发小说成功!');"
+ "window.location='/jsp_xiaoshuo_site/index.jsp';"
+ "</script>");
out.close();
return;
}
ServletContext sc=getServletContext();
String path=sc.getRealPath("/WEB-INF/tie");
String fileid=UUID.randomUUID().toString();
PrintWriter outContent=new PrintWriter(new File(path+"/"+fileid),"utf-8");
outContent.print(content);
outContent.flush();
outContent.close();
PostDao pd=new PostDao();
Post p=new Post();
p.setUser_id(user.getUser_id());
p.setSrc("/"+fileid);
p.setTitle(title);
p.setType(type);
Date now=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm");
String formatDate=sdf.format(now);
p.setPost_time(formatDate);
pd.insert(p);
List<Post> ps=pd.getPosts(user.getUser_id());
int post_id=getMaxIdPost(ps);
resp.sendRedirect("/jsp_xiaoshuo_site/jsp/postdetail.jsp?pid="+post_id);
}
public int getMaxIdPost(List<Post> posts){
if(posts.size()==0)return 0;
int max=-1;
for(int i=0;i<posts.size();i++){
package servlets;
//获取评论
@SuppressWarnings("serial")
public class GetCommentServlet extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
}
@SuppressWarnings("unused")
@Override
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 strStart=req.getParameter("start");
String strEnd=req.getParameter("end");
String strPid=req.getParameter("pid");
String hot=req.getParameter("hot");
List<String[]> agree=new ArrayList<String[]>();
if(strStart==null||strEnd==null||strPid==null)return;
int start=Integer.parseInt(strStart);
int end=Integer.parseInt(strEnd);
int pid=Integer.parseInt(strPid);
if(hot!=null){
CommentDao cd=new CommentDao();
List<Comment> coms=cd.getHotComment(pid); //获取热门评论
if(coms.size()==0){
out.print("[]");
return;
}
JSONArray jsonArray=new JSONArray();
UserDao ud=new UserDao();