JDBC编程
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcExample {
public static void main(String[] args) {
String dbUrl = "jdbc:mysql://localhost:3306/mydatabase";
String username = "username";
String password = "password";
String sqlQuery = "SELECT id, name, email FROM users";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection connection = DriverManager.getConnection(dbUrl, username, password);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sqlQuery);
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
String email = resultSet.getString("email");
System.out.println("ID: " + id + ", Name: " + name + ", Email: " + email);
}
resultSet.close();
statement.close();
connection.close();
} catch (ClassNotFoundException e) {
System.err.println("JDBC驱动程序未找到,请确保驱动程序已添加到类路径中。");
e.printStackTrace();
} catch (SQLException e) {
System.err.println("数据库连接或查询操作出现异常。");
e.printStackTrace();
}
}
}
- 加载JDBC驱动
- 创建数据库连接对象
- 创建Starement对象,用于执行sql
- 获取结果集
- 遍历结果集
- 关闭资源,从下往上