JDBC链接MySQL的三种方式

最新推荐文章于 2022-10-31 20:12:55 发布

WALKING_CODE

最新推荐文章于 2022-10-31 20:12:55 发布

阅读量136

点赞数

分类专栏： java学习文章标签： java

本文链接：https://blog.csdn.net/CSDNSQ2016/article/details/112553286

版权

java学习专栏收录该内容

21 篇文章 0 订阅

订阅专栏

1、第一种链接方式

public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.cj.jdbc.Driver");

        String url="jdbc:mysql://localhost:3306/test1?serverTimezone=UTC";
        String user="root";
        String password="root";
        Connection conn=DriverManager.getConnection(url,user,password);

        Statement stmt = conn.createStatement();
        ResultSet resultSet = stmt.executeQuery("select * from user;");
        while (resultSet.next()) {
            System.out.println(resultSet.getObject(1));
            System.out.println(resultSet.getObject(2));
            System.out.println(resultSet.getObject(3));
            System.out.println(resultSet.getObject(4));
            System.out.println(resultSet.getObject(5));
        }
        resultSet.close();
        stmt.close();
        conn.close();
    }

2、第二种链接方式

public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.cj.jdbc.Driver");

       String url="jdbc:mysql://localhost:3306/test1?serverTimezone=UTC&user=root&password=root";
       Connection conn = DriverManager.getConnection(url);

        Statement stmt = conn.createStatement();
        ResultSet resultSet = stmt.executeQuery("select * from user;");
        while (resultSet.next()) {
            System.out.println(resultSet.getObject(1));
            System.out.println(resultSet.getObject(2));
            System.out.println(resultSet.getObject(3));
            System.out.println(resultSet.getObject(4));
            System.out.println(resultSet.getObject(5));
        }
        resultSet.close();
        stmt.close();
        conn.close();
    }

3、第三种链接方式

public static void main(String[] args) throws SQLException, ClassNotFoundException {
            Class.forName("com.mysql.cj.jdbc.Driver");
    
            String url = "jdbc:mysql://localhost:3306/test1?serverTimezone=UTC";
            Properties info = new Properties();
            info.setProperty("user", "root");
            info.setProperty("password", "root");
            Connection conn = DriverManager.getConnection(url, info);
    
            Statement stmt = conn.createStatement();
            ResultSet resultSet = stmt.executeQuery("select * from user;");
            while (resultSet.next()) {
                System.out.println(resultSet.getObject(1));
                System.out.println(resultSet.getObject(2));
                System.out.println(resultSet.getObject(3));
                System.out.println(resultSet.getObject(4));
                System.out.println(resultSet.getObject(5));
            }
            resultSet.close();
            stmt.close();
            conn.close();
        }