用JDBC连接OpenGauss Postgresql 实现增删改查功能的图书管理系统

package search.searchBook; import connect.connect; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Date; import java.util.Scanner; public class sBook { public static void main(String[] args) { //从键盘输入index作为搜索索引 Scanner in = new Scanner(System.in); String index = in.nextLine(); try { Connection conn = null; conn = connect.main(); ResultSet rs = null; //rs = sFromNameOrAuthor.main(conn, index); //以书名或作者名检索 //rs = sFromIdOrISBN.main(conn, index); //以书号或ISBN检索 rs = sAllBook.main(conn, index); //检索书库中全部图书 while (rs.next()) { //拆分接收到的结果集，并分别装入变量并输出 int book_id = rs.getInt("book_id"); System.out.print("book_id: " + book_id + "|"); String book_name = rs.getString("book_name"); System.out.print("book_name: " + book_name + "|"); String author = rs.getString("author"); System.out.print("author: " + author + "|"); String publisher = rs.getString("publisher"); System.out.print("publisher: " + publisher + "|"); String isbn = rs.getString("isbn"); System.out.print("isbn: " + isbn + "|"); Date p_date = rs.getDate("p_date"); System.out.print("p_date: " + p_date + "|"); String language = rs.getString("language"); System.out.print("language: " + language + "|"); int number = rs.getInt("number"); System.out.print("number: " + number + "|"); int genre_id = rs.getInt("genre_id"); System.out.print("genre_id: " + genre_id); System.out.print("\n"); } // 完成后关闭 rs.close(); } catch (SQLException e) { e.printStackTrace(); } } }