com.mysql.jdbc.Driver和org.gjt.mm.mysql.Driver区别

来源:互联网 发布:错过淘宝微信 编辑:程序博客网 时间:2024/05/22 14:47
package com.dada.conn;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class TestMysql {    public static void main(String[] args) throws Exception {        //实际上两种加载驱动的方式都是一样的,最后(源码里面)都是调用的com.mysql.jdbc.Driver驱动        //之所以还存在加载org.gjt.mm.mysql.Driver驱动,原因是为了向下兼容,其实这个类里面就只是        //返回了一个对于com.mysql.jdbc.Driver一个引用而已        // getConnByJdbcDriver();        getConnByOrgDriver();        PreparedStatement psmt = conn.prepareStatement("select * from student");        ResultSet rs = psmt.executeQuery();        while (rs.next()) {            System.out.println("编号:" + rs.getInt(1) + "\t" + "姓名:"                    + rs.getString(2));        }    }    private static Connection conn;    /**通过加载com.mysql.jdbc.Driver驱动类来获取连接     * @throws Exception     */    public static void getConnByJdbcDriver() throws Exception {        String url = "jdbc:mysql://localhost/dadasport?user=root&password=hdx&characterEncoding=utf-8";        // 加载驱动        Class clazz = Class.forName("com.mysql.jdbc.Driver");        System.out.println("驱动名称" + clazz.getName());        // 建立连接        conn = DriverManager.getConnection(url);    }    /**通过加载org.gjt.mm.mysql.Driver驱动类来获取连接     * @throws Exception     */    public static void getConnByOrgDriver() throws Exception {        String url = "jdbc:mysql://localhost/dadasport?user=root&password=hdx&characterEncoding=utf-8";        // 加载驱动        Class clazz = Class.forName("org.gjt.mm.mysql.Driver");        System.out.println("驱动名称" + clazz.getName());        // 建立连接        conn = DriverManager.getConnection(url);    }}
0 0
原创粉丝点击