JDBC 连接 MySQL

驱动依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</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");
}