jdbc方式访问mysql需要导入mysql-connector-java-5.1.32.jar的这样的一个jar包。
如果构建的是maven项目,pom文件里可以通过下面的方式添加该依赖。
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.32</version>
</dependency>
具体简单例子的代码如下:
public static void testDQL() throws Exception{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";//用户名
String pwd = "root";//密码
Class.forName(driver);//1、注册驱动
Connection conn = DriverManager.getConnection(url, user, pwd);//2、获取连接
String sql = "select * from student;";
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("id:"+id+"----"+"name:"+name);
}
conn.close(); //3、关闭连接
}