java notes表CURD到Servlet MVC

最新推荐文章于 2022-10-11 23:27:58 发布

chichaka0663

最新推荐文章于 2022-10-11 23:27:58 发布

阅读量67

点赞数

原文链接：https://my.oschina.net/u/3715016/blog/1650202

版权

NotesServlet.java代码

package org.jsoft.servlet;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.jsoft.dao.UserDao2;
import org.jsoft.vo.UserVo;

/**
* Servlet implementation class Notes
*/
public class NotesServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

   /**
   * @see HttpServlet#HttpServlet()
   */
   public NotesServlet() {
       super();
       // TODO Auto-generated constructor stub
   }

   /**
   * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
   * response)
   */
   protected void doGet(HttpServletRequest request,
           HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated method stub

System.out.println("doGet");
doPost(request, response);

}

   /**
   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
   * response)
   */
   protected void doPost(HttpServletRequest request,
           HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated method stub
       System.out.println("doPost");
       request.setCharacterEncoding("UTF-8");
       String action = request.getParameter("action");
       if (action == null) {

           return;
       }
       if (action.equals("add")) {
           add(request, response);
       } else if (action.equals("delete")) {
           delete(request, response);
       } else if (action.equals("update")) {
           update(request, response);
       } else if (action.equals("select")) {
           select(request, response);
       }

}

   // 增加用户（注册）
   private void add(HttpServletRequest request, HttpServletResponse response) {
       System.out.println("注册中");
       response.setCharacterEncoding("UTF-8");
       try {
           request.setCharacterEncoding("UTF-8");
           String email = request.getParameter("email");
           Date d = new Date();
           SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");// 把日期转换成需要的格式
           String sdate = sdf.format(d);
           Date udate = null;
           try {
               udate = sdf.parse(sdate);
           } catch (ParseException e1) {
               // TODO Auto-generated catch block
               e1.printStackTrace();
           }

           String uphoto = request.getParameter("uphoto");
           String userName = new String(request.getParameter("username")
                   .getBytes("ISO-8859-1"), "utf-8");
           String password1 = request.getParameter("password1");
           String password2 = request.getParameter("password2");
           if (password1.equals(password2)) {
               UserVo uo = new UserVo();
               UserDao2 dao2 = new UserDao2();
               // System.out.println(userName);
               // System.out.println(password1);
               // System.out.println(password2);
               // System.out.println(email);
               // System.out.println(uphoto);

               uo.setUserName(userName);
               uo.setUserpwd(password1);
               uo.setEmail(email);
               uo.setuPhoto(uphoto);
               uo.setuDate(udate);
               boolean b = false;

               if (dao2.register(uo)) {
                   try {
                       response.sendRedirect("RegisterS.html");
                   } catch (IOException e) {
                       // TODO Auto-generated catch block
                       e.printStackTrace();
                   }
               } else {
                   throw new RuntimeException("Register erro");
               }

           }
       } catch (UnsupportedEncodingException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }

}

   // 删除数据
   private void delete(HttpServletRequest request, HttpServletResponse response)
           throws IOException {
       System.out.println("删除数据中");
       request.setCharacterEncoding("UTF-8");
       int uid = Integer.parseInt(request.getParameter("userid"));
       UserDao2 dao = new UserDao2();
       UserVo uo = new UserVo();
       uo.setUserId(uid);

if (dao.delete(uo)) {

response.sendRedirect("Select.jsp");
}

}

   // 修改数据
   private void update(HttpServletRequest request, HttpServletResponse response)
           throws IOException {
       System.out.println("修改数据中");
       request.setCharacterEncoding("UTF-8");
       String userId1 = request.getParameter("userid");
       int userId = Integer.parseInt(userId1);
       UserVo uo = new UserVo();
       UserDao2 dao = new UserDao2();
       uo.setUserId(userId);
       uo.setUserName(request.getParameter("username"));
       uo.setUserpwd(request.getParameter("userpwd"));
       uo.setEmail(request.getParameter("email"));
       if (dao.upDate(uo)) {
           response.sendRedirect("Select.jsp");
       }

}

   // 查询数据
   private void select(HttpServletRequest request, HttpServletResponse response)
           throws IOException {
       System.out.println("查询数据中");
       response.sendRedirect("Select.jsp");

}

Login.html代码

package org.jsoft.servlet;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.jsoft.dao.UserDao2;
import org.jsoft.vo.UserVo;

/**
* Servlet implementation class Notes
*/
public class NotesServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

   /**
   * @see HttpServlet#HttpServlet()
   */
   public NotesServlet() {
       super();
       // TODO Auto-generated constructor stub
   }

System.out.println("doGet");
doPost(request, response);

}

           }
       } catch (UnsupportedEncodingException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }

}

if (dao.delete(uo)) {

response.sendRedirect("Select.jsp");
}

}

Register.html代码

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
   <!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>用户注册</title>
</head>
<body>
   <center>
       <h2>用户注册</h2>
   </center>

</form>

   <p align="center">
       <a href="Login.html"
           style="color: blue; text-decoration: none; hover: red;">返回登陆界面</a>
   </p>

</body>
</html>
</body>
</html>

Select.jsp代码

<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%@ page import="org.jsoft.dao.*"%>
<%@ page import="org.jsoft.conn.*"%>
<%@ page import="org.jsoft.vo.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
   pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>客户信息查询</title>
</head>
<body>
   <%
       request.setCharacterEncoding("UTF-8");

   %>
   <table border="1" cellspacing="0" align="center">
       <tr>
           <td>编号</td>
           <td>用户名</td>
           <td>密码</td>
           <td>email</td>
           <td>注册日期</td>
           <td>上传相片</td>
       </tr>
       <tr>
           <%
               UserDao2 dao = new UserDao2();
               List<UserVo> l = new ArrayList<UserVo>();
               l = dao.getUser();
           %>
           <%
               for (UserVo uo : l) {
           %>

           <td><%=uo.getUserId()%></td>
           <td><%=uo.getUserName()%></td>
           <td><%=uo.getUserpwd()%></td>
           <td><%=uo.getEmail()%></td>
           <td><%=uo.getuDate()%></td>
           <td><img src="<%=uo.getuPhoto()%>" /></td>
           <td><a href="Servlet?action=delete&userid=<%=uo.getUserId()%>">删除</a></td>
           <td><a
               href="Update.jsp?action=update&userid=<%=uo.getUserId()%>&username=<%=uo.getUserName()%>&email=<%=uo.getEmail()%>&userpwd=<%=uo.getUserpwd()%>&uphoto=<%=uo.getuPhoto()%>">修改</a></td>

       </tr>
       <%
           }
       %>

</table>

   <p align="center">
       <a href="Login.html"
           style="color: blue; text-decoration: none; hover: red;">返回登陆界面</a>
   </p>

</body>
</html>

Update.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
   pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>客户信息修改</title>
</head>
<body>
   <%
       request.setCharacterEncoding("UTF-8");
       String username = new String(request.getParameter("username")
               .getBytes("ISO-8859-1"), "UTF-8");
       String uphoto = new String(request.getParameter("uphoto").getBytes(
               "ISO-8859-1"), "UTF-8");
       //处理传输中出现乱码的情况
   %>

   <form action="NotesServlet?action=update&userid=<%=request.getParameter("userid")%>"
       method="post">
       <table>

               <td>密码</td>
               <td>email</td>
               <td>图片</td>

</tr>

           <tr>
               <td><input type="text" name="userid"
                   value="<%=request.getParameter("userid")%>" disabled="disabled"></td>
               <td><input type="text" name="username" value="<%=username%>"></td>
               <td><input type="text" name="userpwd"
                   value="<%=request.getParameter("userpwd")%>"></td>
               <td><input type="text" name="email"
                   value="<%=request.getParameter("email")%>"></td>
               <td><img src="<%=uphoto%>"></td>

       </table>
   </form>
   <%

   %>>

</body>
</html>

实现效果

增加效果

即为注册

查询效果

删除效果

修改效果

修改前

修改后

修改用户为rank

转载于:https://my.oschina.net/u/3715016/blog/1650202

chichaka0663

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
java notes表CURD到Servlet MVC

NotesServlet.java代码 package org.jsoft.servlet; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.text.ParseEx...
复制链接

扫一扫