con_mysql = getConnection(“com.mysql.jdbc.Driver”, “jdbc:mysql://localhost:3306/test”, “root”,
“root”); stmt_mysql =
con_mysql.createStatement();
String query_mysql =
getQueryStringToCreateTable(tableName,
columnNameList);
stmt_mysql.executeUpdate(query_mysql);
PreparedStatement p_stmt_mysql =
con_mysql.prepareStatement
(getQueryStringToInsertValues(tableName,
columnNameList));
insertValuesAndExecuteQuery
(rs_excel,columnNameList,p_stmt_mysql);
}
catch (Exception e) {
System.err.println(e.getMessage());
}
finally {
try {
rs_excel.close();
stmt_excel.close();
stmt_mysql.close();
con_excel.close();
con_mysql.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
public static Connection
getConnection(String driver, String url, String
username, String password) throws
Exception {
Class.forName(driver);
return DriverManager.getConnection(url,
username, password);
}
public static List
getColumnNameList(ResultSet rs) throws
SQLException{
List list = new ArrayList();
ResultSetMetaData rsmd =
rs.getMetaData();
int numberOfColumns =
rsmd.getColumnCount();
for (int i = 1; i < numberOfColumns + 1;
i++) {