java版本14.0、mysql版本5.7、jdbc版本8.0
package testM;
import java.sql.*;
public class test5 {
//定义MySQL的数据库驱动程序
public static final String DBDRIVER = "com.mysql.cj.jdbc.Driver";
//定义MySQL数据库的连接地址
public static final String DBURL = "jdbc:mysql://localhost:3307/shop";
//MySQL数据库的连接用户名
public static final String DBUSER = "root";
//MySQL数据库的连接密码
public static final String DBPASS = "root";
public static void main(String[] args) throws SQLException {
Connection con = null;
Statement stmt = null;
try {
//加载驱动程序
Class.forName(DBDRIVER);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
//连接MySQL数据库时,要写上连接的用户名和密码
con = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
}
catch (SQLException e) {
e.printStackTrace();
}
//打印链接
System.out.println(con);
// 执行查询
System.out.println(" 实例化Statement对象...");
stmt = con.createStatement();
String sql;
sql = "SELECT id, name FROM item";
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.print("name: " + name);
System.out.print("\n");
}
try {
//关闭数据库
con.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}