本文共 909 字，大约阅读时间需要 3 分钟。

maven依赖：

<dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.36</version>        </dependency>

示例代码：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class MysqlJDBCTest {    public static void main(String[] args)throws Exception {        Class.forName("com.mysql.jdbc.Driver");        String url = "jdbc:mysql://127.0.0.1:3306/test";        String username = "root";        String password="123456";        Connection connection = DriverManager.getConnection(url,username,password);        String sql = "select count(1) from test ";        Statement statement = connection.prepareStatement(sql);        ResultSet rs = statement.executeQuery(sql);        while(rs.next()){            int result = rs.getInt(1);            System.out.println(result);        }    }}