JDBC中事务的问题之三
我执行完以下代码就出现这个错:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a
cloned connection while in manual transaction mode.
mysql.getConnection().setAutoCommit(false);
mysql.prepareStatement(SQLS.INSERT_USERS);
mysql.setString(1,this.truename);
mysql.setString(2,this.sex);
mysql.setString(3,this.address);
mysql.setString(4,this.postalcode);
mysql.setString(5,this.identity_card);
mysql.setString(6,this.phone);
mysql.setString(7,this.email);
mysql.setString(8,this.userip);
mysql.executeUpdate();
mysql.prepareStatement(SQLS.INSERT_PASSWORD);
mysql.setString(1,this.username);
mysql.setString(2,this.password);
mysql.executeUpdate();
mysql.getConnection().commit();
事务中好像只能执行一次mysql.executeUpdate();这样的语句
我单独执行
mysql.prepareStatement(SQLS.INSERT_PASSWORD);
mysql.setString(1,this.username);
mysql.setString(2,this.password);
mysql.executeUpdate();
或
mysql.prepareStatement(SQLS.INSERT_USERS);
mysql.setString(1,this.truename);
mysql.setString(2,this.sex);
mysql.setString(3,this.address);
mysql.setString(4,this.postalcode);
mysql.setString(5,this.identity_card);
mysql.setString(6,this.phone);
mysql.setString(7,this.email);
mysql.setString(8,this.userip);
mysql.executeUpdate();
都可以插入数据,但合在一起就不行了,是怎么回事呢,这样我想实现一个删除一个修改就不行了。
有什么解决方法吗?