JDBC mysql 问题

与oracle不同是 在加载驱动的时候要用
Class.forName(driverName).newInstance();
其中的driverName用
driverName = "com.mysql.jdbc.Driver";
获取链接的时候用
Connection conn = DriverManager.getConnection(url);
其中的url用
private static String url = "jdbc:mysql://ip地址:端口/数据库名称?user=用户名&password=密码&useUnicode=true&characterEncoding=utf-8";

JDBC工具类举例：

package util;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/*
 * JdbcUtil工具类
 * 封装jdbc中重复的内容
 * 1.加载驱动
 * 2.创建连接
 * 3.关闭资源
 */
public class JdbcUtil {
    private static String driverName=null;
    private static String userName=null;
    private static String password=null;
    private static String url=null;
    private JdbcUtil(){}
    
    
    static {
        try {
            Properties prop=new Properties();
            prop.load(JdbcUtil.class.getClassLoader().
                    getResourceAsStream("db.properties"));
            driverName=prop.getProperty("driverName");
            url=prop.getProperty("url");
            userName=prop.getProperty("userName");
            password=prop.getProperty("password");
            //加载驱动
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            throw new RuntimeException(e);
            
        } catch (IOException e) {
            e.printStackTrace();
            throw new RuntimeException(e);
        }
    }
    
    //建立连接
    public static  Connection getConnection() throws SQLException{
        Connection conn=DriverManager.
                   getConnection(url,userName,password);
        return conn;
    }
    
    //关闭连接
    public static void close(ResultSet rs, Statement stmt,Connection conn){
        
            try {
                if(rs!=null){
                rs.close();
                }
            } catch (SQLException e) {
               e.printStackTrace();
               throw new RuntimeException(e);
            }finally{
                
                    try {
                        if(stmt!=null){
                        stmt.close();
                        }
                    } catch (SQLException e) {
                        e.printStackTrace();
                        throw new RuntimeException(e);
                    }finally{
                        try {
                            if(conn!=null){
                             conn.close();
                            }
                        } catch (SQLException e) {
                            e.printStackTrace();
                            throw new RuntimeException(e);
                        }
                    }
            }
    }
    
    public static void main(String[] args) throws SQLException {
        Connection conn=JdbcUtil.getConnection();
        System.out.println(conn);
    }

}