用户的增删改查

实体类

public class Users {
    private int id;
    private String username;
    private String userpassword;
    private String sex;
    private String email;
    private String phone;
    private String qq;
    private String entranceyear;
    private String usersubject;

    public Users() {
    }

    @Override
    public String toString() {
        return "Users{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", userpassword='" + userpassword + '\'' +
                ", sex='" + sex + '\'' +
                ", email='" + email + '\'' +
                ", phone='" + phone + '\'' +
                ", qq='" + qq + '\'' +
                ", entranceyear='" + entranceyear + '\'' +
                ", usersubject='" + usersubject + '\'' +
                ", introduce='" + introduce + '\'' +
                '}';
    }

    public Users(int id, String username, String userpassword, String sex, String email, String phone, String qq, String entranceyear, String usersubject, String introduce) {
        this.id = id;
        this.username = username;
        this.userpassword = userpassword;
        this.sex = sex;
        this.email = email;
        this.phone = phone;
        this.qq = qq;
        this.entranceyear = entranceyear;
        this.usersubject = usersubject;
        this.introduce = introduce;
    }

    private String introduce;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getUserpassword() {
        return userpassword;
    }

    public void setUserpassword(String userpassword) {
        this.userpassword = userpassword;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getQq() {
        return qq;
    }

    public void setQq(String qq) {
        this.qq = qq;
    }

    public String getEntranceyear() {
        return entranceyear;
    }

    public void setEntranceyear(String entranceyear) {
        this.entranceyear = entranceyear;
    }

    public String getUsersubject() {
        return usersubject;
    }

    public void setUsersubject(String usersubject) {
        this.usersubject = usersubject;
    }

    public String getIntroduce() {
        return introduce;
    }

    public void setIntroduce(String introduce) {
        this.introduce = introduce;
    }
}

实现方法

import java.lang.reflect.Field;
import java.sql.*;

public class Test1 {
    private static Connection conn = null;
    private static PreparedStatement pst = null;

    public static void SelectUser(Users user) {
        try {
            conn = DbConn.GetConnection();
            String sql = "select * from users where username=?";
            pst = conn.prepareStatement(sql);
            pst.setString(1, user.getUsername());
            ResultSet result = null;
            result = pst.executeQuery();
            while (result.next()) {
                System.out.println(result.getString("username"));
                System.out.println(result.getString("userpassword"));
                System.out.println(result.getString("sex"));
                System.out.println(result.getString("email"));
                System.out.println(result.getString("phone"));
                System.out.println(result.getString("qq"));
                System.out.println(result.getString("entranceyear"));
                System.out.println(result.getString("usersubject"));
                System.out.println(result.getString("introduce"));

            }
            result.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void UpdateUser(Users user) {
        try {
            conn = DbConn.GetConnection();
            String sql = "update users set userpassword=? , phone=? where username=?";
            pst = conn.prepareStatement(sql);
            pst.setString(1, user.getUserpassword());
            pst.setString(2, user.getPhone());
            pst.setString(3, user.getUsername());
            int count = pst.executeUpdate();
            System.out.println(count);
            pst.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public static void InsertUser(Users user) {
        try {
            conn = DbConn.GetConnection();
            //String sql = "insert into users (username,userpassword,sex,email,phone,qq,entranceyear,usersubject,introduce) values(?,?,?,?,?,?,?,?,?)";
            String sql1 = "insert into " + user.getClass().getSimpleName().toLowerCase() + "(";
            String sql2 = ") values(";
            Field[] fields = user.getClass().getDeclaredFields();
            for (int i = 1; i < fields.length; i++) {
                fields[i].setAccessible(true);
                if (i == 1) {
                    sql1 = sql1 + fields[i];
                    sql2 = sql2 + "?";
                } else {
                    sql1 = sql1 + "," + fields[i];
                    sql2 = sql2 + ",?";
                }
            }
            String sql = sql1 + sql2 + ")";
            System.out.println(sql);
            pst = conn.prepareStatement(sql);
            pst.setString(1, user.getUsername());
            pst.setString(2, user.getUserpassword());
            pst.setString(3, user.getSex());
            pst.setString(4, user.getEmail());
            pst.setString(5, user.getPhone());
            pst.setString(6, user.getQq());
            pst.setString(7, user.getEntranceyear());
            pst.setString(8, user.getUsersubject());
            pst.setString(9, user.getIntroduce());
            int i = pst.executeUpdate();
            System.out.println(i);
            pst.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    public static void DeleteUser(Users user) {
        try {
            conn = DbConn.GetConnection();
            String sql = "delete from users where username=?";
            pst = conn.prepareStatement(sql);
            pst.setString(1, user.getUsername());
            int i = pst.executeUpdate();
            System.out.println(i);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        Test1 test1 = new Test1();
        Users user = new Users();
        //增
        user.setUsername("asd111111");
        user.setUserpassword("789789");
        user.setSex("男");
        user.setEmail("123456789@qq.com");
        user.setPhone("1234654564131");
        user.setQq("123456132");
        user.setEntranceyear("2002");
        user.setUsersubject("Java程序设计, 数据库原理");
        user.setIntroduce("dasfsadfsacsa");
        test1.InsertUser(user);
        //查
        /*user.setUsername("fkjhsajk");
        test1.SelectUser(user);*/
        //改
        /*user.setUsername("fkjhsajk");
        user.setUserpassword("852963");
        user.setPhone("75239521");
        test1.UpdateUser(user);*/

        //删
        /*user.setUsername("fkjhsajk");
        test1.DeleteUser(user);*/
    }
}