Eclipse（Java+Html+Jsp+Mysql）简易注册登录查询显示数据系统 JAVA部分（三）

SERVLET部分详细介绍

删除信息部分：DeleteXx:

package com.edu.znjj.Servlet;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.edu.znjj.dao.XxDao;@WebServlet("/deleteXx.do")public class DeleteXx extends HttpServlet {private static final long serialVersionUID = 1L;protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String strId = request.getParameter("id");//将字符转换到Integer类型Integer id = Integer.parseInt(strId);XxDao dao = new XxDao();try{dao.delete(id);response.sendRedirect("findXx.do");} catch (SQLException e) {e.printStackTrace();response.sendRedirect("error.html");}}}

查找信息部分：FindXx:

package com.edu.znjj.Servlet;import java.io.IOException;import java.sql.SQLException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.edu.znjj.dao.XxDao;import com.edu.znjj.entity.Xx;import com.edu.znjj.entity.User;@WebServlet("/findXx.do")public class FindXxServlet extends HttpServlet {private static final long serialVersionUID = 1L;protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {XxDao dao = new XxDao();try {HttpSession session = request.getSession();User user = (User)session.getAttribute("user");List list = dao.findAll(user.getId());request.setAttribute("list",list);request.getRequestDispatcher("listXx.jsp").forward(request, response);} catch (SQLException e) {   e.printStackTrace();    response.sendRedirect("error.html"); }}}

 FindByIdXx部分：

package com.edu.znjj.Servlet;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.edu.znjj.dao.XxDao;import com.edu.znjj.entity.Xx;/ * Servlet implementation class FindByIdXxServlet */@WebServlet("/findByIdXx.do")public class FindByIdXxServlet extends HttpServlet {private static final long serialVersionUID = 1L;protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String strId=request.getParameter("id");Integer id = Integer.parseInt(strId);XxDao dao = new XxDao();try{Xx xx = dao.findById(id);request.setAttribute("xx",xx);request.getRequestDispatcher("showXx.jsp").forward(request, response);} catch (SQLException e) {e.printStackTrace();response.sendRedirect("error.html");}}}

注册页面：regist:

package com.edu.znjj.Servlet;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.edu.znjj.dao.UserDao;@WebServlet("/regist.do")public class RegistServlet extends HttpServlet {private static final long serialVersionUID = 1L;protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("UTF-8");String username = request.getParameter("userName");//获取账号//输出账号System.out.println(username);String userpwd = request.getParameter("userpwd");//获取密码System.out.println(userpwd);String email = request.getParameter("email");//获取邮箱System.out.println(email);String phone = request.getParameter("phone");System.out.println(phone);//获取电话//将数据保存到数据库中，调用数据库代码UserDao dao = new UserDao();try {dao.save(username, userpwd, email, phone);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();response.sendRedirect("error.html");}//创建一个对象，调用保存的方法//响应结果，url重定向到注册成功页面response.sendRedirect("registsuccess.html");}}