MYSQL下JDBC的连接

//db.properties配置文件
driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/login?characterEncoding=utf-8
user=root
password=123456
//写成jbdc_util的getconnection()，releaseResource()工具类
package util;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;

public class jdbc_utils  {
    public static Connection getconnection() throws IOException, ClassNotFoundException, SQLException {
        Properties properties = new Properties();//建立Properties对象，
        properties.load(new FileInputStream(new File("db.properties")));
        String url = properties.getProperty("url");//分别取出配置文件中的内容
        String user = properties.getProperty("user");
        String password = properties.getProperty("password");
        String driverClass = properties.getProperty("driverClass");
        Class.forName(driverClass);//加载驱动
        Connection connection1= DriverManager.getConnection(url, user, password);//建立Connection连接
        return connection1;
    }
    public static void releaseResource(Connection connection, Statement statement, ResultSet resultSet){
        try {
            if(connection!=null){//当不为null时进行关闭
                connection.close();
            }
            if(statement!=null){
                statement.close();
            }
            if(resultSet!=null){
                resultSet.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}

//对数据库进行批处理操作
import util.jdbc_utils;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBC_Test02 {
    public static void main(String[] args) {
        Connection connection1 = null;
        Statement statement=null;
        try {
            connection1= jdbc_utils.getconnection();
            statement= connection1.createStatement();
//            int i= statement.executeUpdate("insert into student value (11,'哈11',80,90,100,'2012-2-2 12:08:07')");
//            System.out.println(i);
            String sq1="insert into account (id,name,password) values(3,'b1','c1')";
            String sq2="insert into account (id,name,password) values(4,'b2','c2')";
            statement.addBatch(sq1);
            statement.addBatch(sq2);
            statement.executeBatch();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            jdbc_utils.releaseResource(connection1,statement,null);
        }
    }
}