import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MySQLAccess {
public static void main(String[] args) {
// 数据库连接信息
String url = "jdbc:mysql://localhost:3306/your_database";
String user = "your_username";
String password = "your_password";
// 注册JDBC驱动
try {
Class.forName("com.mysql.cj.jdbc.Driver");
// 打开连接
System.out.println("连接数据库...");
Connection conn = DriverManager.getConnection(url, user, password);
// 执行查询
System.out.println("查询数据库...");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");
// 展开结果集数据库
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.println();
}
// 完成后关闭
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
java读写mysql数据库
最新推荐文章于 2024-06-01 16:55:03 发布