oracle绑定变量的java 代码如下:
String v_id = 'xxxxx';
//嵌入绑定变量
String v_sql = 'select name from table_a where id = ? ';
stmt = con.prepareStatement( v_sql );
stmt.setString(1, v_id ); //为绑定变量赋值
stmt.executeQuery();
String v_id = 'xxxxx';
//嵌入绑定变量
String v_sql = 'select name from table_a where id = ? ';
stmt = con.prepareStatement( v_sql );
stmt.setString(1, v_id ); //为绑定变量赋值
stmt.executeQuery();
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28258625/viewspace-1428282/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28258625/viewspace-1428282/