前提条件
需要安装mysql,并且有mysql-connector-java-8.0.22.jar
,如果没有的话,可以去mysql官网下载,官网地址https://dev.mysql.com/downloads/connector/j/
之后进行导入jar包
建立一个数据表
连接mysql数据库基本操作
package test;
import java.sql.*;
public class JDBC {
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/network?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
static final String USER = "root";
static final String PASS = "123456";
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection conn=null;
Statement stmt=null;
// 注册jdbc驱动
Class.forName(JDBC_DRIVER);
//打开链接
System.out.println("连接到数据库...");
conn= DriverManager.getConnection(DB_URL,USER,PASS);
//执行查询
System.out.println("实例化Statement对象...");
stmt=conn.createStatement();
String sql;
sql="select * from machine";
ResultSet rs= stmt.executeQuery(sql);
//展开结果集数据库
while (rs.next()){
int id=rs.getInt("id");
String name=rs.getString("name");
System.out.print("ID: "+id);
System.out.println(",NAME: "+name);
}
rs.close();
stmt.close();
conn.close();
System.out.println("GoodBye");
}
}