Java代码实现：轻松查询所有优惠券

```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class CouponQuery { public static void main(String[] args) { // JDBC连接信息 String url = "jdbc:mysql://localhost:3306/database_name"; String username = "username"; String password = "password"; // 查询语句 String sql = "SELECT * FROM coupon_table"; try (Connection conn = DriverManager.getConnection(url, username, password); PreparedStatement stmt = conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery()) { while (rs.next()) { int id = rs.getInt("id"); String code = rs.getString("code"); String description = rs.getString("description"); // 输出优惠券信息 System.out.println("ID: " + id + ", Code: " + code + ", Description: " + description); } } catch (SQLException e) { e.printStackTrace(); } } } ``` ######[AI写代码神器 | 680点数解答 | 2024-06-29 15:20:32]