BiTel

public String getListParamValue(int cid, int pid)
  {
    String result = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try
    {
      StringBuilder query = new StringBuilder(100);
      query.append("SELECT cp.pid, if(cp.val<1,cp.custom_value,vls.title) FROM ");
      query.append("contract_parameter_type_7");
      query.append(" as cp LEFT JOIN ");
      query.append("contract_parameter_type_7");
      query.append("_values as vls ON vls.id=cp.val WHERE cid=? AND cp.pid=?");
      ps = this.con.prepareStatement(query.toString());
      ps.setInt(1, cid);
      ps.setInt(2, pid);
      rs = ps.executeQuery();
      if (rs.next())
      {
        result = rs.getString(1);
      }
      rs.close();
      ps.close();
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return result;
  }

if (rs.next())
      {
        result = rs.getString(1);
      }

cp.pid

public String getListParamValue(int cid, [b]int pid[/b])

int cid = 1;
int paramId = 1;
Connection con  = connectionSet.getConnection();
ContractParameterManager cpm = new ContractParameterManager( con );
String val = cpm.getListParamValue(cid, managerPid);