用户管理系统

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);
    }
}