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);
}
}
}