67,513
社区成员
发帖
与我相关
我的任务
分享
//该方法是用来对数据库执行简单操作的
//DataAccessBean是我自定义的一个类
public boolean updateDBTable(String SQL) throws
ServiceLocatorException, DataAccessException, SQLException {
int flag=0;
try{
DataAccessBean dab = new DataAccessBean();
conn = dab.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
flag = stmt.executeUpdate(SQL);
..............
ServiceLocatorException, DataAccessException, SQLException {
int flag=0;
int i=0;
int jj=0;
try{
DataAccessBean dab = new DataAccessBean();
conn = dab.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
// 禁止自动提交
conn.setAutoCommit(false);
for (i=0;i<SQL.length && SQL[i]!=null;i++){
System.out.println("执行for循环ing............") ;
System.out.println(SQL[i]) ;
stmt.executeUpdate(SQL[i]);
System.out.println("预执行") ;
}
flag=1;//执行标记,如果flag=1说明已经执行完毕,可以commit
System.out.println("执行完for循环了") ;
}
finally
{
for (jj=0;jj<SQL.length ;jj++){
SQL[jj]=null;
}
try
{
cleanup(null, null, null, dab);
}
catch(Exception e) {
conn.rollback() ;
}
}
if (flag==1){
conn.commit() ;
System.out.println("commit了") ;
return true;
}
else
{
return false;
}
}