增删改
public int executeUpdate(String sql,Object[] params){
int update = 0
;
try {
pstm =
connection.prepareStatement(sql);
for(
int i=0;i<params.length;i++
){
pstm.setObject(i+1
, params[i]);
}
update =
pstm.executeUpdate();
//oracle更新操作要commit不然事务堵塞执行不成功
connection.commit();
} catch (SQLException e) {
e.printStackTrace();
}
return update;
}
对oracle数据库进行增删改更新操作,executeUpdate()执行卡住了
标签: