JDBC连接MySQL

驱动依赖

<dependency>
<groupId>mysqlgroupId>
<artifactId>mysql-connector-javaartifactId>
<version>8.0.26version>
dependency>


JDBC

Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://172.26.250.49:3306/information_schema?useUnicode=true&characterEncoding=ut
String username = "root";
String password = "root1234";
//在表tables中，从第1开始，回去10条数据
String sql = "select * from information_schema.tables limit 0,10";
//获取连接
Connection connection = DriverManager.getConnection(url, username, password);
//执行SQL
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
//遍历结果
while (resultSet.next()) {
String col1 = resultSet.getString(1);
String col2 = resultSet.getString(2);
String col3 = resultSet.getString(3);
System.out.println(col1 + "\t" + col2 + "\t" + col3 + "\t");
}


原文链接：https://www.cnblogs.com/wwp666/p/15977195.html