前端后台的curd
来源：互联网 发布：韶关市网络问政平台 编辑：程序博客网 时间：2024/06/03 19:29
package com.oracle.vo;public class User {private int userno;private String userName;private String password;private String RealName;public int getUserno() {return userno;}public void setUserno(int userno) {this.userno = userno;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getRealName() {return RealName;}public void setRealName(String realName) {RealName = realName;}@Overridepublic String toString() {return "User [userno=" + userno + ", userName=" + userName + ", password="+ password + ", RealName=" + RealName + "]";}public User() {super();}public User(String userName, String password, String realName) {super();this.userName = userName;this.password = password;RealName = realName;}}package com.oracle.dao;import java.util.List;import com.oracle.vo.User;public interface UserDao {public void save(User user);public void update(User user);public void delete(int userno);public List<User> getAll();public User getUserById(Integer userno);}package com.oracle.dao;import java.util.List;import com.oracle.jdbc.util.Dao;import com.oracle.vo.User;public class UserDaoImpl implements UserDao{@Overridepublic void save(User user) {Dao.executeSql("insert into tb_user values(null,?,?,?)", user.getUserName(),user.getPassword(),user.getRealName());}@Overridepublic void update(User user) {Dao.executeSql("update tb_user set userName=?,password=?,realName=? where userno=?",user.getUserName(),user.getPassword(),user.getRealName(),user.getUserno());}@Overridepublic void delete(int userno) {Dao.executeSql("delete from tb_user where userno=?", userno);}@Overridepublic List<User> getAll() {return Dao.query("select * from tb_user", User.class);}@Overridepublic User getUserById(Integer userno) { List<User> list=Dao.query("select * from tb_user where userno=?", User.class, userno);if(list.isEmpty()){return null;} return list.get(0);}}package com.oracle.dao;import java.util.List;import com.oracle.vo.User;public class Test {public static void main(String[] args) {User u=new User("wodema","oj","fd");List<User> list=new UserDaoImpl().getAll();for(User uu:list){System.out.println(uu);}}}<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>MyHtml.html</title> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="this is my page"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <!--<link rel="stylesheet" type="text/css" href="./styles.css">--> </head> <body> This is my HTML page. <br><form method="post" action="addUser">userName:<input type="text" name="userName"/><br/>password:<input type="password" name="password"/><br/>realName:<input type="text" name="realName"/><br/><input type="submit" value="提交"/></form> </body></html>
package com.oracle.sevlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.oracle.dao.UserDao;import com.oracle.dao.UserDaoImpl;import com.oracle.vo.User;public class AddUserServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("UTF-8");String userName=request.getParameter("userName");String password=request.getParameter("password");String realName=request.getParameter("realName");User user=new User(userName,password,realName);//向数据库中插入新用户UserDao dao=new UserDaoImpl();dao.save(user);//返回到列表页：response.sendRedirect("listUser");}}package com.oracle.sevlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.oracle.dao.UserDao;import com.oracle.dao.UserDaoImpl;import com.oracle.vo.User;public class BianUserServlet extends HttpServlet {/** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}/** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {//根据用户的no来获取用户数据，并将结果显示客户端 Integer userno=Integer.valueOf(request.getParameter("userno")); //根据userno获得数据 UserDao dao=new UserDaoImpl(); User user=dao.getUserById(userno);response.setContentType("text/html;charset=UTF-8");PrintWriter out = response.getWriter();out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");out.println("<HTML>");out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");out.println(" <BODY>");out.println("<form action='updateUser' method='post'>");out.println("<input type='hidden' name='userno' value='"+user.getUserno()+"'/><br/>");out.println("userName:<input type='text' name='userName' value='"+user.getUserName()+"'/><br/>");out.println("password:<input type='password' name='password' value='"+user.getPassword()+"'/><br/>");out.println("realName:<input type='text' name='realName' value='"+user.getRealName()+"'/><br/>");out.println("<input type='submit' value='修改'/>");out.println("</form>");out.println(" </BODY>");out.println("</HTML>");out.flush();out.close();}}package com.oracle.sevlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.oracle.dao.UserDao;import com.oracle.dao.UserDaoImpl;public class DeleteUserServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {//获得usernoInteger userno=Integer.valueOf(request.getParameter("userno"));UserDao dao=new UserDaoImpl();dao.delete(userno);//重定向response.sendRedirect("listUser");}}package com.oracle.sevlet;import java.io.IOException;import java.io.PrintWriter;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.oracle.dao.UserDao;import com.oracle.dao.UserDaoImpl;import com.oracle.vo.User;public class ListUserServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType("text/html;charset=UTF-8");PrintWriter out = response.getWriter();out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");out.println("<HTML>");out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");out.println(" <BODY>");out.print("用户列表<br/>");UserDao dao=new UserDaoImpl();List<User> list=dao.getAll();out.println("<table width='90%' border='1'>");out.println("<tr>");out.println("<td>用户编号</td><td>姓名</td><td>密码</td><td>真实姓名</td><td>操作</td>");out.println("</tr>");for(User u:list){out.println("<tr>");out.println("<td>");out.println(u.getUserno());out.println("</td>");out.println("<td>");out.println(u.getUserName());out.println("</td>");out.println("<td>");out.println(u.getPassword());out.println("</td>");out.println("<td>");out.println(u.getRealName());out.println("</td>");out.println("<td>");out.println("<a href='deleteUser?userno="+u.getUserno()+"'>删除</a>");out.println("<a href='bian?userno="+u.getUserno()+"'>编辑</a>");out.println("</td>");out.println("</tr>");}out.println("</table>");out.println("<a href='addUser.html'>新增用户</a>");out.println(" </BODY>");out.println("</HTML>");out.flush();out.close();}}package com.oracle.sevlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.oracle.dao.UserDao;import com.oracle.dao.UserDaoImpl;import com.oracle.vo.User;public class UpdateUserServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("UTF-8");Integer userno=Integer.valueOf(request.getParameter("userno"));String userName=request.getParameter("userName");String password=request.getParameter("password");String realName=request.getParameter("realName");User user=new User(userName,password,realName);user.setUserno(userno);UserDao dao=new UserDaoImpl();dao.update(user);response.sendRedirect("listUser");}}<servlet-mapping> <servlet-name>Loginservlet</servlet-name> <url-pattern>/login</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>LifeServlet</servlet-name> <url-pattern>/life</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>ListUserServlet</servlet-name> <url-pattern>/listUser</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>AddUserServlet</servlet-name> <url-pattern>/addUser</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>DeleteUserServlet</servlet-name> <url-pattern>/deleteUser</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>ViewUserServlet</servlet-name> <url-pattern>/editUser</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>UpdateUserServlet</servlet-name> <url-pattern>/updateUser</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>BianUserServlet</servlet-name> <url-pattern>/bian</url-pattern> </servlet-mapping>
阅读全文
0 0
- 前端后台的curd
- 前端与后台的交互
- 前端调用后台的数据
- 后台与前端的联系
- 前端、后台和连接前端后台的网络数据传输
- 使用laravel搭建CURD后台页面
- 后台管理员操作详情CURD记录
- laravel一分钟搭建CURD后台页面
- php mongoDB 的curd
- php mongoDB 的curd
- oracle视图的curd
- MVC5的CURD自用
- mongoDB的CURD操作
- Oracle视图的curd
- ibatis的CURD
- ThinkPHP的CURD
- ibatis的CURD
- thinkphp_3.1.2的CURD
- CAS SSO 单点登录 第二篇
- memset函数使用指南
- Java 线程池 Executor框架（2）FutureTask
- ffmpeg关于timebase的理解
- 回顾总结-----第九届中国云计算大会，量子计算机为最大亮点
- 前端后台的curd
- Java 8 Streams map 示例
- 阿里巴巴SOA服务化治理方案的核心框架-Dubbo
- SQL Server 如何启用sa账户
- ubuntu 下 完全卸载vim
- sql-function
- java炒冷饭系列01 方法的重载
- bzoj3713
- 父亲写的散文诗（李健）
