高分求购：对数据库（oracel）的连接、添加、编辑、等操作的javaBean源程序

Question

1)ORACLE连接
Connection connection = null;
try {
    
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    connection=DriverManager.getConnection("jdbc:oracle:oci8:@appdb","test","test123");
    

}catch (Exception e) {
    e.printStackTrace();
}2)查询
          Statement statement= connection.createStatement();
          String sql ="SELECT count(0) FROM QUESTION";
          ResultSet resultSetCnt = statement.executeQuery(sql);
3)插入
          Statement statement= connection.createStatement();
          String sql ="insert into QUESTION values(1,'2','ok')";
          statement.executeUpdate(sql);4)删除5)关闭
          connection.close();
          statement.close();
          resultSet.close();快点结帐给我啦