1.使用mysql数据库建表
2.导入mysql的jar包
3.使用java语言连接数据库并读取数据
public class JdbcTest {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/testdb";
String user = "root";
String password = "123456";
try {
Class.forName(driver);
//2、链接数据库
Connection con = DriverManager.getConnection(url, user, password);
if (!con.isClosed()) {//判断数据库是否链接成功
System.out.println("已成功链接数据库!");
//3、创建Statement对象
Statement st = con.createStatement();
//4、执行sql语句
String sql = "select *from user";//