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;
}
@Override
public 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{
@Override
public void save(User user) {
Dao.executeSql("insert into tb_user values(null,?,?,?)", user.getUserName(),user.getPassword(),user.getRealName());
}
@Override
public void update(User user) {
Dao.executeSql("update tb_user set userName=?,password=?,realName=? where userno=?",user.getUserName(),user.getPassword(),user.getRealName(),user.getUserno());
}
@Override
public void delete(int userno) {
Dao.executeSql("delete from tb_user where userno=?", userno);
}
@Override
public List<User> getAll() {
return Dao.query("select * from tb_user", User.class);
}
@Override
public 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 {
//获得userno
Integer 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>