JDBC连接MySQL的三种方式

浏览数：26 / 时间：2015年06月12日

方式一

try {
            Driver driver = new com.mysql.jdbc.Driver();
            String url = "jdbc:mysql://10.180.48.19:3306/hsp_db";
            Properties info = new Properties();
            info.setProperty("user", "root");
            info.setProperty("password", "hillstone");
            Connection conn = driver.connect(url, info);
            System.out.println(conn);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

方式二

try {
            Driver driver = new com.mysql.jdbc.Driver();
            DriverManager.registerDriver(driver);
            String url = "jdbc:mysql://10.180.48.19:3306/hsp_db";
            Properties info = new Properties();
            info.setProperty("user", "root");
            info.setProperty("password", "hillstone");
            Connection conn = DriverManager.getConnection(url, info);
            System.out.println(conn);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

方式三（推荐）

try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://10.180.48.19:3306/hsp_db";
            Properties info = new Properties();
            info.setProperty("user", "root");
            info.setProperty("password", "hillstone");
            Connection conn = DriverManager.getConnection(url, info);
            System.out.println(conn);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }