All pastes #2135125 Raw Edit

Something

public text v1 · immutable
#2135125 ·published 2012-04-11 21:08 UTC
rendered paste body
    protected void loadFromInventory() 
    {
        QueueCode = new TreeMap();
        Statement stmt = null;
        ResultSet data = null;
        
        List dataSQL = ((GeneralTable)jTblSQL.getModel()).getListData();
        
        for(int i=0; i<dataSQL.size(); i++) 
        {
            List row = (List)dataSQL.get(i);
            QueueCode.put(row.get(0), row);
        }
        
        try 
        {
            stmt = InventoryConn.createStatement();

            String key, desc ;
            if(SqlName.equals("Entrepot"))
            {
                key ="NEntrepot";
                desc ="Nom";
            }
            else if(SqlName.equals("Longueur"))
            {
                key ="NLongueur";
                desc ="Description";
            }            
            else if(SqlName.equals("Largeur"))
            {
                key ="NLargeur";
                desc ="Description";
            }               
            else
            {
                key ="Code";
                desc ="Description";              
            }
            
            String sql = "Select " + key + ", " + desc + " from " + SqlName + "s " + "where actif=1 order by 1";                
            data = stmt.executeQuery(sql);
            
            while(data.next())
            {
                Object code = data.getObject(key);
                if(!QueueCode.containsKey(code)) 
                {
                    ArrayList row = new ArrayList();
                    row.add(code);
                    row.add(data.getString(desc));
                    dataSQL.add(row);
                }
            }
        } 
        catch (SQLException e) 
        {
            e.printStackTrace(System.err);
        }
        finally 
        {
            if(data != null) 
            {
                try 
                {
                    data.close();
                }
                catch (SQLException e)
                {
                }
            }
            
            if(stmt != null) 
            {
                try 
                {
                    stmt.close();
                }
                catch (SQLException e) 
                {
                }
            }
        }       
    }