import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import javax.xml.transform.Result;

public class TestJava {
private final String url = "jdbc:postgresql://localhost:5433/dvdrental";
private final String user = "postgres";
private final String password = "makary123";

public Connection connect() throws SQLException {
 return DriverManager.getConnection(url, user, password);
 }
public void callPro(int id) {
	int inv_id = id;
	int cust_id = 0;
	String name = "";
	try {
		Connection conn = connect();
		CallableStatement cstmt = conn.prepareCall("{? = call film_in_stock(?)}");
		cstmt.setInt(2, inv_id);
		cstmt.registerOutParameter(1, Types.VARCHAR);
		cstmt.execute("SELECT inventory_id\r\n" +
				"     FROM inventory\r\n" +
				"     WHERE film_id = 1\r\n" +
				"     AND store_id = 2\r\n" +
				"     AND inventory_in_stock(inventory_id");
		name = cstmt.getString(1);
		System.out.println(name);
	}catch (SQLException e) {
		System.out.println(e.getMessage());
	}
}
public TestJava() {
	// TODO Auto-generated constructor stub
}
public static void main(String[] args) {
	// TODO Auto-generated method stub
	TestJava t = new TestJava();
	t.callPro(1);
}
}