- PreparedStatement 就是带有占位符的SQL 语句
- 数据库对他们事先进行编译,因此,客户端需要做的只是传送展位符位置所需要的数据。
- 而普通Statement的SQL语句,叧有在程序运行时才对他们进行编译
- 因此PreparedStatement运行的速度更快。
示例1:
PreparedStatement stmt = connection.prepareStatement(
"insert into test values(‘?,?')");
stmt.setString(1,”first value”);
stmt.setString(2,”second value”);
stmt.executeUpdate();
stmt.setString(2,”new record, with different second value”);
stmt.executeUpdate();
PreparedStatement stmt = connection.prepareStatement(
"insert into test values(‘?,?')");
stmt.setString(1,”first value”);
stmt.setString(2,”second value”);
stmt.executeUpdate();
stmt.setString(2,”new record, with different second value”);
stmt.executeUpdate();