public Collection ejbFindEx(String NOM_TPL_CON, String DES_TPL_CON, int iOrderBy) { String strSql = "SELECT cod_TPL_CON, nom_TPL_CON, des_TPL_CON FROM TPL_CON_tab "; if (NOM_TPL_CON != null) { strSql += " WHERE UPPER(NOM_TPL_CON) LIKE ?"; } if (DES_TPL_CON != null) { if (NOM_TPL_CON != null) { strSql += " AND "; } else { strSql += " WHERE "; } strSql += " UPPER(DES_TPL_CON) LIKE ?"; } strSql += " ORDER BY " + Math.abs(iOrderBy) + (iOrderBy > 0 ? " ASC" : "DESC"); int i = 1; BMPConnection bmp = getConnection(); try { PreparedStatement ps = bmp.prepareStatement(strSql); if (NOM_TPL_CON != null) { ps.setString(i++, NOM_TPL_CON.toUpperCase()); } if (DES_TPL_CON != null) { ps.setString(i++, DES_TPL_CON.toUpperCase()); } ResultSet rs = ps.executeQuery(); java.util.ArrayList ar = new java.util.ArrayList(); while (rs.next()) { TipologiaContratti_View w = new TipologiaContratti_View(); w.lCOD_TPL_CON = rs.getLong("COD_TPL_CON"); w.strNOM_TPL_CON = rs.getString("NOM_TPL_CON"); w.strDES_TPL_CON = rs.getString("DES_TPL_CON"); ar.add(w); } return ar; } catch (Exception ex) { throw new EJBException(ex); } finally { bmp.close(); } }
public Collection ejbGetComboView() { BMPConnection bmp = getConnection(); try { PreparedStatement ps = bmp.prepareStatement( "SELECT cod_TPL_CON, nom_TPL_CON, des_TPL_CON FROM TPL_CON_tab ORDER BY nom_TPL_CON"); ResultSet rs = ps.executeQuery(); java.util.ArrayList ar = new java.util.ArrayList(); while (rs.next()) { TipologiaContratti_View w = new TipologiaContratti_View(); w.lCOD_TPL_CON = rs.getLong("COD_TPL_CON"); w.strNOM_TPL_CON = rs.getString("NOM_TPL_CON"); w.strDES_TPL_CON = rs.getString("DES_TPL_CON"); ar.add(w); } return ar; } catch (Exception ex) { throw new EJBException(ex); } finally { bmp.close(); } }
public Collection ejbGetTipologia_View() { BMPConnection bmp = getConnection(); try { PreparedStatement ps = bmp.prepareStatement( "select cod_tpl_con, nom_tpl_con, des_tpl_con from tpl_con_tab order by nom_tpl_con "); ResultSet rs = ps.executeQuery(); java.util.ArrayList al = new java.util.ArrayList(); while (rs.next()) { TipologiaContratti_View obj = new TipologiaContratti_View(); obj.lCOD_TPL_CON = rs.getLong(1); obj.strNOM_TPL_CON = rs.getString(2); obj.strDES_TPL_CON = rs.getString(3); al.add(obj); } bmp.close(); return al; } catch (Exception ex1) { throw new EJBException(ex1); } finally { bmp.close(); } }