java 调用postgresql 函数_从Java调用PostgreSQL中的存储过程

我编写了一个我想用Java调用的存储过程。但我不认为它能够对我通过的查询做任何事情。以下是我的java代码：

String QUERY_LOCATION = "select (license_plate) as test from carInst( (select category_name from reservation where rid = ?) , (select lname from reservation where rid = ?))";

//PreparedStatement check_location = null;

PreparedStatement check_location = connection.prepareStatement(QUERY_LOCATION);

check_location.setInt(1, rid);

check_location.setInt(2, rid);

rs = check_location.executeQuery();

if (rs.next()) {

System.out.print("Car found: "+rs.getString("test")+"\n");

license_plate = rs.getString("test");

update_reservation.setString(5, license_plate);

bool = false;

} else {

System.out

.print("There is no car available\n");

}

以下是我用PL / pgSQL(Postgr