Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&user=root&password=root");
3、获取Statement对象
Statement statement = con.createStatement();
4、执行sql
ResultSet resultSet = statement.executeQuery("select * from test"); while(resultSet.next()){ System.out.println(resultSet.getString(3)); }
//1、加载驱动Class.forName("com.mysql.cj.jdbc.Driver");//2、获取数据库连接Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&user=root&password=root")