获取连接对象的三种方式

方式一

      @Test
public void test1(){
                try {
                        //1.注册驱动--
                        Class.forName("com.mysql.cj.jdbc.Driver");
                        //2. DriverManager获取连接数据库对象
                        String url = "jdbc:mysql://localhost:3306/db3?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";
                        Connection con = DriverManager.getConnection(url, "root", "123456");
                        System.out.println(con);
                } catch (Exception e) {
                        e.printStackTrace();
                }
        }

方式2

  @Test
        public void test2(){
                try {
                        //1.注册驱动--
                        Class.forName("com.mysql.jdbc.Driver");
                        //2. DriverManager获取连接数据库对象
                        String url="localhost";
                        Properties p = new Properties();
                        p.setProperty("user","root");
                        p.setProperty("passwork","123456");
                        Connection con = DriverManager.getConnection(url, p);
                        System.out.println(con);
                } catch (ClassNotFoundException | SQLException e) {
                        e.printStackTrace();
                }
        }

方式3
jdbc.properties

user=root
password=123456

@Test
        public void test3(){
                try {
                        //1.注册驱动--
                        Class.forName("com.mysql.jdbc.Driver");
                        //2. DriverManager获取连接数据库对象
                        String url="localhost";
                      //使用类加载器jdbc.properties
                        InputStream is = Hello1.class.getClassLoader().getResourceAsStream("scr/jdbc.properties");
                        Properties p = new Properties();
                        p.load(is);
                        Connection con = DriverManager.getConnection(url, p);
                        System.out.println(con);
                } catch (ClassNotFoundException | IOException | SQLException e) {
                        e.printStackTrace();
                }
        }