java 执行多条mysql_java执行多条SQL语句

package net.xsoftlab.dict;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class Batch {

/** 判断数据库是否支持批处理 */

public static boolean supportBatch(Connection con) {

try {

// 得到数据库的元数据

DatabaseMetaData md = con.getMetaData();

return md.supportsBatchUpdates();

} catch (SQLException e) {

e.printStackTrace();

}

return false;

}

/** 执行一批SQL语句 */

public static int[] goBatch(Connection con, String[] sqls) throws Exception {

if (sqls == null) {

return null;

}

Statement sm = null;

try {

sm = con.createStatement();

for