实例

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package connectmysql;
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.sql.rowset.*;
/**
 *
 * @author 91152
 */
public class ConnectMysql {

    static String driver;
    static String url;
    static String user;
    static String pass;

    public void getParam(String param) throws Exception{
        Properties prop = new Properties();
        prop.load(new FileReader(param));
        driver = prop.getProperty("driver");
        url = prop.getProperty("url");
        user = prop.getProperty("user");
        pass = prop.getProperty("pass");
    }
    
    public void createTable(String[] sqls){
        
        try{
            Class.forName(driver);
        }
        catch(ClassNotFoundException cn){
                cn.printStackTrace();
                }
        try(
            
            Connection conn = DriverManager.getConnection(url,user,pass))
            {
            conn.setAutoCommit(false);
            try(
                Statement stmt = conn.createStatement())
            {
                for (String sql : sqls){
                    stmt.executeUpdate(sql);
                }
            }
            conn.commit();
                    }
        
        catch(SQLException sl){
            sl.printStackTrace();
        }}
        
          
    
    public static void main(String[] args) throws Exception {
        ConnectMysql ja = new ConnectMysql();
        ja.getParam("mysql.ini");
        String[] sqls = new String[]{
            "insert into student_table values(null , 'aaa' ,1)",
            "insert into student_table values(null , 'bbb' ,1)",
            "insert into student_table values(null , 'ccc' ,1)",
        };
        ja.createTable(sqls);
        
    
    
}}