databasefiller Code

import java.sql.*;
import java.util.ArrayList;

//import javx.sql.*;
public class MyDataAccess {
	
	private static String dbUrl = "jdbc:mysql://localhost/pcmso";
	private static String dbClass = "com.mysql.jdbc.Driver";
	private static Connection con = null;
	private static Statement stmt = null;
	
	//public static ArrayList<String> erros = new ArrayList<String>();
	
	
	public static void open(){
		
		try {
			Class.forName(dbClass);
			con = DriverManager.getConnection (dbUrl,"root","uis");
			stmt = con.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
	public static void close(){
		
		try {
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static int ExecuteInsert(String query) throws Exception{
		
		if(query == null) return 0;
	
		try {
			stmt.executeUpdate(query, Statement.RETURN_GENERATED_KEYS);
			ResultSet keyset = stmt.getGeneratedKeys();
			
			if (keyset.next()){
				return keyset.getInt(1);
			}
			
		}
		catch (Exception e) {
			
			System.out.println(query);
			
			e.printStackTrace();
			throw new Exception(e.getMessage());
			
			//e.printStackTrace();
		}
		
		return -1;
		
	}
	
	/**
	 * Vai ajudar a calcular a quantidade necessária de inserts no banco de dados..
	 * @param size
	 */
	public static int CalculaTamanho(int size){
		
		
		return 0;
	}
	

}