- 论坛徽章:
- 0
|
上面的我可能说的不对
这个是jdk文档中关于类 PreparedStatement 的说明,希望对你有帮助
- An object that represents a precompiled SQL statement.
- A SQL statement is precompiled and stored in a PreparedStatement object. [color=Red]This object can then be used to efficiently execute this statement multiple times. [/color]
- Note: The setter methods (setShort, setString, and so on) for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type INTEGER, then the method setInt should be used.
- If arbitrary parameter type conversions are required, the method setObject should be used with a target SQL type.
- In the following example of setting a parameter, con represents an active connection:
- PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
- SET SALARY = ? WHERE ID = ?");
- pstmt.setBigDecimal(1, 153833.00)
- pstmt.setInt(2, 110592)
复制代码
[ 本帖最后由 白色乌鸦 于 2005-12-1 20:21 编辑 ] |
|