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)
{
}
}
}
}