import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class TestTransation { public static void main(String[] args) {
Connection conn = null;
PreparedStatement pre = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@218.195.250.100:1521:orcl","scott","triger");
conn.setAutoCommit(false);
pre = conn.prepareStatement("insert into dept2 values (?,?,?)");
pre.setInt(1, 66);
pre.setString(2, "Game");
pre.setString(3, "hk");
pre.addBatch();
pre.setInt(1, 67);
pre.setString(2, "finance");
pre.setString(3, "shanghai");
pre.addBatch();
pre.executeBatch();
conn.commit();
conn.setAutoCommit(true);
}catch(SQLException e){
e.printStackTrace();
try {
if(conn!=null){
conn.rollback();
conn.setAutoCommit(true);
}
} catch (SQLException e1) {
e1.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
try {
if(pre != null)
pre.close();
if(conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}}
运行后报错 java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (SCOTT.DEPT2_PK) at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at TestTransation.main(TestTransation.java:27)
麻烦 能帮忙看看,,,
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class TestTransation { public static void main(String[] args) {
Connection conn = null;
PreparedStatement pre = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@218.195.250.100:1521:orcl","scott","triger");
conn.setAutoCommit(false);
pre = conn.prepareStatement("insert into dept2 values (?,?,?)");
pre.setInt(1, 66);
pre.setString(2, "Game");
pre.setString(3, "hk");
pre.addBatch();
pre.setInt(1, 67);
pre.setString(2, "finance");
pre.setString(3, "shanghai");
pre.addBatch();
pre.executeBatch();
conn.commit();
conn.setAutoCommit(true);
}catch(SQLException e){
e.printStackTrace();
try {
if(conn!=null){
conn.rollback();
conn.setAutoCommit(true);
}
} catch (SQLException e1) {
e1.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally{
try {
if(pre != null)
pre.close();
if(conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}}
运行后报错 java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (SCOTT.DEPT2_PK) at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at TestTransation.main(TestTransation.java:27)
麻烦 能帮忙看看,,,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货