daoGetMultiData

Related DAO Code

        List<List<LookupPair>> map = new ArrayList<List<LookupPair>>();
        StringBuilder catAndClause = new StringBuilder();
        if(category != null)
        {
            int i=0;
            for(LookupPair lp : category)
            {
                if(!lp.right.equals("") && !lp.left.isEmpty())
                    catAndClause.append(" and ").append(lp.left).append(" = '").append(lp.right).append("'");
            }
        }
        connect();
        useApp(application);
        field = field.replace("Multi", "");
        StringBuilder sql = new StringBuilder("select * from lkup_").append(field).append(" where ")
                .append(field).append("Order > -1 ").append(catAndClause).append(" order by ").append(field).append("Order");
        ResultSet rs=st.executeQuery(sql.toString());
        ResultSetMetaData rsmd = rs.getMetaData();
        while(rs.next())
        {
            List<LookupPair> multiData = new ArrayList<LookupPair>(rsmd.getColumnCount());
            for(int i=1;i<=rsmd.getColumnCount();i++)
            {
                multiData.add(new LookupPair(rsmd.getColumnLabel(i),rs.getString(i)));
            }
            map.add(multiData);
        }
        rs.close();
        disconnect();
        return map;