Anexo XII - Código para Carregar Dados em Banco MySQL
import java.io.BufferedReader;
import java.io.FileReader;
import java.sql.*;
public class BDInsertSQL{
public static void main(String args[]){
try{
//existem 25 arquivos referentes a scripts em SQL
for (int i=0; i<24; i++)
{
FileReader fw = new
FileReader("C:\\Path\\ScriptSQL\\scriptsql4.sql");
BufferedReader conexao = new BufferedReader(fw);
String saida = conexao.readLine();
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost/rajan?user=root&pa
ssword=root");
System.out.println("Conexao foi um sucesso!");
conn.setAutoCommit(true);
Statement stm = conn.createStatement();
while(saida!=null){
saida = conexao.readLine();
System.out.println("Command: "+saida+ " executed?
"+stm.execute(saida));
}
conexao.close();
conn.close();
}catch(Exception e){
System.out.println("Erro na conexao do BD");
e.printStackTrace();
}
}
}
}