基于JDBC Java程序连接postgresql在StudentInfo表中插入一条记录,并将表中的记录在控制台中输出,使用PreparedStatement实现。

好的，以下是基于JDBC Java程序连接postgresql在StudentInfo表中插入一条记录,并将表中的记录在控制台中输出的代码，使用PreparedStatement实现：

import java.sql.*;

public class JDBCExample {
  static final String JDBC_DRIVER = "org.postgresql.Driver";
  static final String DB_URL = "jdbc:postgresql://localhost:5432/mydatabase";
  static final String USER = "username";
  static final String PASS = "password";

  public static void main(String[] args) {
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {
      // 注册 JDBC 驱动器
      Class.forName(JDBC_DRIVER);

      // 打开一个连接
      System.out.println("Connecting to database...");
      conn = DriverManager.getConnection(DB_URL, USER, PASS);

      // 插入一条记录
      System.out.println("Inserting a new record into StudentInfo table...");
      String sql = "INSERT INTO StudentInfo (name, age, gender) VALUES (?, ?, ?)";
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, "Tom");
      pstmt.setInt(2, 19);
      pstmt.setString(3, "male");
      pstmt.executeUpdate();

      // 查询表中的记录并输出到控制台
      System.out.println("Fetching records from StudentInfo table...");
      sql = "SELECT * FROM StudentInfo";
      pstmt = conn.prepareStatement(sql);
      rs = pstmt.executeQuery();

      while (rs.next()) {
        int id = rs.getInt("id");
        String name = rs.getString("name");
        int age = rs.getInt("age");
        String gender = rs.getString("gender");

        System.out.println("id: " + id + ", name: " + name + ", age: " + age + ", gender: " + gender);
      }
    } catch (SQLException se) {
      // 处理 JDBC 错误
      se.printStackTrace();
    } catch (Exception e) {
      // 处理 Class.forName 错误
      e.printStackTrace();
    } finally {
      // 关闭资源
      try {
        if (rs != null) rs.close();
        if (pstmt != null) pstmt.close();
        if (conn != null) conn.close();
      } catch (SQLException se) {
        se.printStackTrace();
      }
    }
  }
}

请注意，这里的`mydatabase`、`username`、`password`、`StudentInfo`等变量需要根据你的实际情况进行修改。