5、利用Statement对象和Result对象实现按出版社名称精确查询出版社功能(精确查询是指查询的目标和查询条件中值完全相同的数据)。
时间: 2024-03-23 11:40:49 浏览: 45
可以使用如下的Java代码来实现按出版社名称精确查询出版社功能:
```java
import java.sql.*;
public class PublisherQuery {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String user = "root";
String password = "123456";
try (Connection conn = DriverManager.getConnection(url, user, password)) {
String query = "SELECT * FROM publishers WHERE name = ?";
String publisherName = "ABC出版社";
PreparedStatement ps = conn.prepareStatement(query);
ps.setString(1, publisherName);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
String address = rs.getString("address");
String phone = rs.getString("phone");
System.out.println("ID: " + id + ", Name: " + name + ", Address: " + address + ", Phone: " + phone);
}
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
}
```
上述代码中,使用了PreparedStatement对象来执行SQL查询语句,其中`?`表示占位符,可以通过调用`setString()`方法设置具体的查询条件。执行查询后,可以通过ResultSet对象依次获取每一行的查询结果,并输出到控制台上。