JDBC batch processing and parameter bindings. java

public static void Main (string[] args) ... {
Class.forName ("Sqldriver");
Connection conn = drivermanager.getconnection (Url,user,pass)

No parameters, adding case
Statement stmt = Conn.createstatement ();
Stmt.addbatch ("INSERT into authors (Firstname,lastname) VALUES (' Fegor ', ' hack ')");
Stmt.addbatch ("INSERT into authors (Firstname,lastname) VALUES (' fegors ', ' hacks ')");
Stmt.addbatch ("INSERT into authors (Firstname,lastname) VALUES (' FEGORSR ', ' HACKSR ')");
Stmt.executebatch ();
Stmt.close ();
Conn.close ();

Take a parameter, add a case
PreparedStatement ps=conn.preparestatement ("insert into authors (Firstname,lastname) VALUES (?,?)");

Ps.setstring (1, "nihao1");//Set parameters
Ps.setstring (2, "wohao1");
Ps.addbatch (); To add a statement to a batch queue

Ps.setstring (1, "Nihao2");
Ps.setstring (2, "Wohao2");
Ps.addbatch ();

Ps.setstring (1, "Nihao3");
Ps.setstring (2, "Wohao3");
Ps.addbatch ();

Ps.executebatch (); Perform batch processing

Ps.close (); Last off
Conn.close ();
}
Summarize:
1.stmt=conn.createstatement () There is nothing in the parentheses behind it ...
2.pstmt=conn.preparestament ("INSERT into authors (Firstname,lastname) VALUES (?,?)")
There must be a SQL statement behind this, and the parameters inside are used. expressed.
Then use Pstmt.setstring (1, "Fegor") to set its value, 1 indicates the position of the 1th question mark, "Fegor", which indicates the value we want to add
Finally, use Pstmt.executeupdate () to execute.