java - Java MySQL INSERT(使用PreparedStatement)

Question

我有一个小问题要问你们。

我尝试将用户添加到数据库。

用户具有以下字段:id、姓名、姓氏等。

方法

public static String insertUsertoDatabase(Connection con, User userToAdd)

做这样的事情

 // the mysql insert statement
        String query = " insert into User (id,log,pass)"
                + " values (?, ?, ?)";

        // create the mysql insert preparedstatement
        PreparedStatement preparedStmt = con.prepareStatement(query);
        preparedStmt.setInt(1, 1);
        preparedStmt.setString(2, "h");
        preparedStmt.setString(3, "l");

setUser方法

    public String setUser(User userToBase) {
    return insertUsertoDatabase(con, userToBase);
}

和main.java

User us1 = new User("9", "h", "l");
db.setUser(us1); //insert to database User u1

如何将 User 构造函数中的值放入 preparedStmt ？

我有一个这样的构造函数:

public class User(id, login, pass) {
      this.id = id;
      etc.

}

但我想知道如何从构造函数发送数据

User us1 = new User("9", "h", "l");

我的方法

public static String insertUsertoDatabase(Connection con, User userToAdd)



    preparedStmt.setInt(1, 9);           <-------------    from User constructor
    preparedStmt.setString(2, "h");
    preparedStmt.setString(3, "l");

Answer 1

您可能需要类似的东西:

// TODO: use meaningful names
private String pim;
private String pam;
private String poom;

public User(String pim, String pam, String poom) {
    this.pim = pim;
    this.pam = pam;
    this.poom = poom;
}

public String getPim() {
    return this.pim;
}

// ...

然后:

User usr1 = new User("9", "h", "l");
usr1.getPim() // = "9"
// ...

关于 constructors 的一些阅读