oracle jdbc commit,java – JDBC和Oracle conn.commit和conn.setAutocommit无法正常工作

我已经创建了一个DBManager类,如下所示

public class DBManager {

public static String DRIVER = "oracle.jdbc.driver.OracleDriver";

public static String URL = "jdbc:oracle:thin:@//localhost:1521/DB";

public static String USERNAME = "afsweb";

public static String PASSWORD = "afsweb";

public static String DOCDBUSERNAME = "docdb";

public static String DOCDBPASSWORD = "docdb";

public static int PORT = 1521;

//static Logger log = Logger.getLogger(ExcelDBManager.class.getName());

public static Connection getConnection(String url ,String username, String password){

try {

Class.forName(DRIVER);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

Connection con = null;

try {

con = DriverManager.getConnection(url,username,password);

con.setAutoCommit(false);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return con;

}

我有方法截断表中的行

public static void truncate() throws SQLException{

conn = DBManager.getConnection(DBManager.URL, DBManager.USERNAME, DBManager.PASSWORD);

System.out.println(conn.getAutoCommit() +"");

Statement pstmnt = null;

ResultSet rs = null;

try{

pstmnt = conn.createStatement();

pstmnt.executeQuery("truncate table bd_vehicles_temp_1");

System.out.println("Query Executed");

}

catch(SQLException e){

e.printStackTrace();

}

finally{

try{

if(rs !=null){

rs.close();

}

if(pstmnt != null){

pstmnt.close();

}

if(conn != null){

conn.close();

}

}

catch(SQLException e)

{

e.printStackTrace();

}

}

}

现在我还没有在truncate()方法中编写conn.commit.我也将setAutocommit设为false.即便如此,这些变化也反映在数据库中.

在执行上述方法时,我输出为

false

Query Executed

这意味着我的连接自动提交模式为false.截断方法所做的更改仍反映在数据库中.可能的原因是什么？我正在使用Oracle数据库.

提前致谢 ！