使用例子
public class DatabaseMetadataTest {
public static void main(String[] args) {
String url="jdbc:mysql://127.0.0.1:3306/test?user=vddl&password=vddl";
try{
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
Connection con = DriverManager.getConnection(url);45
if(con instanceof ConnectionPropertiesImpl) {
((ConnectionPropertiesImpl) con).setContinueBatchOnError(false); //默认是true
}
DatabaseMetaData metaData = con.getMetaData();
Statement statement = con.createStatement();
statement.addBatch("insert into student(NO,name) values(6,'test6')");
statement.addBatch("insert into student(NO,name) values(4,'test4')");
statement.addBatch("insert into student(NO,name) values(5,'test5')");
statement.executeBatch();
System.out.println("supportsBatchUpdates : " + metaData.supportsBatchUpdates());
} catch (SQLException e) {
e.printStackTrace();
}
}
}
如果设置了 ((ConnectionPropertiesImpl) con).setContinueBatchOnError(false),则batch批处理中间任何一个语句执行异常ÿ