ImplUser :
import com.ndky.devil.dao.UserDao; import com.ndky.devil.entity.User; import com.ndky.devil.until.JdbcConfig; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import java.util.List; public class ImplUser implements UserDao { private JdbcTemplate jt=new JdbcTemplate(JdbcConfig.getDs()); @Override public List<User> QueryUser() { String sql= "select * from user"; return jt.query(sql,new BeanPropertyRowMapper<User>(User.class)); } @Override public void AddUser(User user) { String sql="insert into user values(null,?,?,?,?,?,?)"; jt.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail()); } @Override public void UpdateUser(User user) { String sql="update user set name=?,gender=?,age=?,address=?,qq=?,email=? where id=?"; jt.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail(),user.getId()); } @Override public void DeleteUser(int id) { String sql="delete from user where id=?"; jt.update(sql,id); } @Override public User SelectUserById(int id) { String sql= "select * from user where id=?"; return jt.query(sql,new BeanPropertyRowMapper<User>(User.class),id).get(0); } }UserDao :
public interface UserDao { List<User> QueryUser(); void AddUser(User user); void UpdateUser(User user); void DeleteUser(int id); User SelectUserById(int id); }User :
public class User { private Integer id; private String name; private String gender; private int age; private String address; private String qq; private String email; public User() { } public User(Integer id, String name, String gender, int age, String address, String qq, String email) { this.id = id; this.name = name; this.gender = gender; this.age = age; this.address = address; this.qq = qq; this.email = email; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + name + '\'' + ", sex='" + gender + '\'' + ", age=" + age + ", address='" + address + '\'' + ", qq='" + qq + '\'' + ", email='" + email + '\'' + '}'; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getQq() { return qq; } public void setQq(String qq) { this.qq = qq; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } }AddUserServlet :
import com.ndky.devil.dao.imple.ImplUser; import com.ndky.devil.entity.User; 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 java.io.IOException; @WebServlet("/addUserServlet") public class AddUserServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { super.doGet(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String name=req.getParameter("name"); String gender=req.getParameter("gender"); int age=Integer.parseInt(req.getParameter("age")); String address=req.getParameter("address"); String qq=req.getParameter("qq"); String email=req.getParameter("email"); User user=new User(null,name,gender,age,address,qq,email); System.out.println(user); ImplUser impluser=new ImplUser(); impluser.AddUser(user); resp.sendRedirect("findUserByPageServlet"); } }DelSelectedServlet :
import com.ndky.devil.dao.imple.ImplUser; 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 java.io.IOException; @WebServlet("/delSelectedServlet") public class DelSelectedServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String[] ids=req.getParameterValues("uid"); ImplUser impluser=new ImplUser(); for (String s : ids) { int id=Integer.parseInt(s); impluser.DeleteUser(id); } resp.sendRedirect("findUserByPageServlet"); } }DelUserServlet :
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 java.io.IOException; @WebServlet("/DelUserServlet") public class DelUserServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); int id=Integer.parseInt(req.getParameter("id")); ImplUser impluser=new ImplUser(); impluser.DeleteUser(id); resp.sendRedirect("findUserByPageServlet"); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { } }FindUserByPageServlet :
import com.ndky.devil.dao.imple.ImplUser; import com.ndky.devil.entity.User; 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 java.io.IOException; import java.util.List; @WebServlet("/findUserByPageServlet") public class FindUserByPageServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { ImplUser impluser=new ImplUser(); List<User> user=impluser.QueryUser(); req.setAttribute("list",user); req.getRequestDispatcher("list.jsp").forward(req,resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { } }FindUserServlet :
import com.ndky.devil.dao.imple.ImplUser; import com.ndky.devil.entity.User; 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 java.io.IOException; @WebServlet("/findUserServlet") public class FindUserServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); int id = Integer.parseInt(req.getParameter("id")); ImplUser impluser = new ImplUser(); User user=impluser.SelectUserById(id); req.setAttribute("user",user); req.getRequestDispatcher("update.jsp").forward(req,resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { } }SelectByIdServlet :
import com.ndky.devil.dao.imple.ImplUser; 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 java.io.IOException; @WebServlet() public class SelectByIdServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { super.doGet(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); int id = Integer.parseInt(req.getParameter("id")); ImplUser impluser = new ImplUser(); impluser.SelectUserById(id); req.getRequestDispatcher("update.jsp").forward(req, resp); } }UpdateUserServlet :
import com.ndky.devil.dao.imple.ImplUser; import com.ndky.devil.entity.User; 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 java.io.IOException; @WebServlet("/updateUserServlet") public class UpdateUserServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { super.doGet(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); int id=Integer.parseInt(req.getParameter("id")); String name=req.getParameter("name"); String gender=req.getParameter("gender"); int age=Integer.parseInt(req.getParameter("age")); String address=req.getParameter("address"); String qq=req.getParameter("qq"); String email=req.getParameter("email"); User user=new User(id,name,gender,age,address,qq,email); System.out.println(user); ImplUser impluser=new ImplUser(); impluser.UpdateUser(user); req.getRequestDispatcher("list.jsp").forward(req,resp); } }