基于javaweb+mysql的jsp+servlet个人日记管理系统(java+jsp+servlet++mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
个人日记的增删改查管理
技术框架
JSP Servlet MySQL CSS JavaScript layui
基于javaweb+mysql的JSP+Servlet个人日记管理系统(java+jsp+servlet++mysql)
@WebServlet("/userServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private UserService userService = null;
public UserServlet() {
userService = new UserServiceImpl();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = userService.login(request.getParameter("username"), request.getParameter("password"));
if (user != null) {
session.setAttribute("user", user);
// session.setAttribute("msg", "login success!");
// session.setAttribute("url", "/index.jsp");
// request.getRequestDispatcher("/forward.jsp").forward(request, response);
response.sendRedirect("dailyListServlet");
} else {
session.setAttribute("msg", "username or password was wrong!");
session.setAttribute("url", "/login.jsp");
request.getRequestDispatcher("/forward.jsp").forward(request, response);
}
}
}
DailyCustom dailyCustom = new DailyCustom();
int count = dailyService.getCount();
List<Daily> dailyList = dailyService.getAllDailyByPage(pageIndex, pageSize,request.getParameter("keyword"),request.getParameter("start"),request.getParameter("end"));
dailyCustom.setPageIndex(pageIndex);
dailyCustom.setPageSize(pageSize);
dailyCustom.setCount(count);
dailyCustom.setDailyList(dailyList);
request.setAttribute("dailyCustom", dailyCustom);
request.getRequestDispatcher("daily-list.jsp").forward(request, response);
}
}
/**
* Servlet implementation class DailyDelServlet
*/
@WebServlet("/dailyDelServlet")
public class DailyDelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DailyDelServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
dailyCustom.setPageSize(pageSize);
dailyCustom.setCount(count);
dailyCustom.setDailyList(dailyList);
request.setAttribute("dailyCustom", dailyCustom);
request.getRequestDispatcher("daily-list.jsp").forward(request, response);
}
}
/**
* Servlet implementation class DailyDelServlet
*/
@WebServlet("/dailyDelServlet")
public class DailyDelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DailyDelServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
PrintWriter out = response.getWriter();
Map<String,Object> map = new HashMap<String,Object>();
DailyService dailyService = new DailyServiceImpl();
String[] delIds = request.getParameterValues("delId");
int result = dailyService.delDailyById(delIds);
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("user");
String dailyJson = request.getParameter("daily");
JSONObject jsonObject = JSON.parseObject(dailyJson);
String title = jsonObject.getString("title");
String context = jsonObject.getString("context");
String records = jsonObject.getString("records");
String type = jsonObject.getString("type");
Daily daily = new Daily();
daily.setTitle(title);
daily.setContext(context);
daily.setUid(user.getUid());
daily.setRecords(records);
daily.setType(type);
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.insertDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "添加成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,添加失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
*/
@WebServlet("/dailyAddServlet")
public class DailyAddServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DailyAddServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("user");
String dailyJson = request.getParameter("daily");
JSONObject jsonObject = JSON.parseObject(dailyJson);
String title = jsonObject.getString("title");
String context = jsonObject.getString("context");
String records = jsonObject.getString("records");
String type = jsonObject.getString("type");
Daily daily = new Daily();
daily.setTitle(title);
daily.setContext(context);
daily.setUid(user.getUid());
daily.setRecords(records);
daily.setType(type);
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.insertDaily(daily);
Map<String,Object> map = new HashMap<>();
String type = jsonObject.getString("type");
Daily daily = new Daily();
daily.setTitle(title);
daily.setContext(context);
daily.setUid(user.getUid());
daily.setRecords(records);
daily.setType(type);
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.insertDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "添加成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,添加失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
/**
* Servlet implementation class DailyAddServlet
*/
public class DailyDelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DailyDelServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
PrintWriter out = response.getWriter();
Map<String,Object> map = new HashMap<String,Object>();
DailyService dailyService = new DailyServiceImpl();
String[] delIds = request.getParameterValues("delId");
int result = dailyService.delDailyById(delIds);
if(result>0) {
map.put("code", 0);
map.put("msg", "删除成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,删除失败");
map.put("count", 0);
}
out.print(JSON.toJSON(map));
out.close();
}
}
/**
* Servlet implementation class HomeServlet
request.setCharacterEncoding("utf-8");
String action = request.getParameter("action");
if(SHOW.equals(action)) {
response.sendRedirect("dailyListServlet");
}else if(RECORD.equals(action)) {
response.sendRedirect("daily-record.jsp");
}else if(CLEAR.equals(action)) {
response.sendRedirect("daily-clear.jsp");
}else {
response.sendRedirect("daily-update.jsp");
}
}
}
/**
* Servlet implementation class DailyDescServlet
*/
@WebServlet("/dailyDescServlet")
public class DailyDescServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DailyDescServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
DailyService dailyService = new DailyServiceImpl();
}else {
map.put("code", 500);
map.put("msg", "服务器异常,修改失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
@WebServlet("/userServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private UserService userService = null;
public UserServlet() {
userService = new UserServiceImpl();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = userService.login(request.getParameter("username"), request.getParameter("password"));
private static final String SHOW = "show";
private static final String RECORD = "add";
private static final String CLEAR = "del";
private static final String UPDATE = "up";
public HomeServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action = request.getParameter("action");
if(SHOW.equals(action)) {
response.sendRedirect("dailyListServlet");
}else if(RECORD.equals(action)) {
response.sendRedirect("daily-record.jsp");
}else if(CLEAR.equals(action)) {
response.sendRedirect("daily-clear.jsp");
}else {
response.sendRedirect("daily-update.jsp");
}
}
}
/**
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.insertDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "添加成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,添加失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
/**
* Servlet implementation class DailyAddServlet
*/
@WebServlet("/dailyUpdateServlet")
public class DailyUpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
map.put("code", 0);
map.put("msg", "修改成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,修改失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
@WebServlet("/userServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private UserService userService = null;
public UserServlet() {
userService = new UserServiceImpl();
}
daily.setRecords(records);
daily.setType(type);
daily.setDid(jsonObject.getShort("did"));
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.updateDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "修改成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,修改失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
@WebServlet("/userServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private UserService userService = null;
public UserServlet() {
userService = new UserServiceImpl();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
private static final String SHOW = "show";
private static final String RECORD = "add";
private static final String CLEAR = "del";
private static final String UPDATE = "up";
public HomeServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action = request.getParameter("action");
if(SHOW.equals(action)) {
response.sendRedirect("dailyListServlet");
}else if(RECORD.equals(action)) {
response.sendRedirect("daily-record.jsp");
}else if(CLEAR.equals(action)) {
response.sendRedirect("daily-clear.jsp");
}else {
response.sendRedirect("daily-update.jsp");
}
}
}
/**
* Servlet implementation class DailyDescServlet
*/
@WebServlet("/dailyDescServlet")
public class DailyDescServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DailyDescServlet() {
public UserServlet() {
userService = new UserServiceImpl();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = userService.login(request.getParameter("username"), request.getParameter("password"));
if (user != null) {
session.setAttribute("user", user);
// session.setAttribute("msg", "login success!");
// session.setAttribute("url", "/index.jsp");
// request.getRequestDispatcher("/forward.jsp").forward(request, response);
response.sendRedirect("dailyListServlet");
} else {
session.setAttribute("msg", "username or password was wrong!");
session.setAttribute("url", "/login.jsp");
request.getRequestDispatcher("/forward.jsp").forward(request, response);
}
}
}
@WebServlet("/dailyListServlet")
public class DailyListServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
*/
public DailyUpdateServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("user");
String dailyJson = request.getParameter("daily");
JSONObject jsonObject = JSON.parseObject(dailyJson);
String title = jsonObject.getString("title");
String context = jsonObject.getString("context");
String records = jsonObject.getString("records");
String type = jsonObject.getString("type");
Daily daily = new Daily();
daily.setTitle(title);
daily.setContext(context);
daily.setUid(user.getUid());
daily.setRecords(records);
daily.setType(type);
daily.setDid(jsonObject.getShort("did"));
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.updateDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "修改成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,修改失败");
map.put("count", 0);
}
daily.setUid(user.getUid());
daily.setRecords(records);
daily.setType(type);
DailyService dailyService = new DailyServiceImpl();
int result = dailyService.insertDaily(daily);
Map<String,Object> map = new HashMap<>();
if(result>0) {
map.put("code", 0);
map.put("msg", "添加成功");
map.put("count", 0);
}else {
map.put("code", 500);
map.put("msg", "服务器异常,添加失败");
map.put("count", 0);
}
response.getWriter().print(JSON.toJSON(map));
response.getWriter().close();
// response.getWriter().print("3");
// response.getWriter().close();
}
}
User user = userService.login(request.getParameter("username"), request.getParameter("password"));
if (user != null) {
session.setAttribute("user", user);
// session.setAttribute("msg", "login success!");
// session.setAttribute("url", "/index.jsp");
// request.getRequestDispatcher("/forward.jsp").forward(request, response);
response.sendRedirect("dailyListServlet");
} else {
session.setAttribute("msg", "username or password was wrong!");
session.setAttribute("url", "/login.jsp");
request.getRequestDispatcher("/forward.jsp").forward(request, response);
}
}
}
@WebServlet("/dailyListServlet")
public class DailyListServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private DailyService dailyService;
public DailyListServlet() {
dailyService = new DailyServiceImpl();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String pageI = request.getParameter("pageIndex");
int pageIndex = 1;
int pageSize = 5;
if(pageI!=null && pageI!="") {
pageIndex = Integer.parseInt(pageI);