All pastes #257288 Raw Edit

Someone

public java v1 · immutable
#257288 ·published 2006-11-25 04:25 UTC
rendered paste body
  public static Hashtable getComponentMaterials( String component_in )  {    Hashtable materials = new Hashtable();    init();    if(_dbase == null)    {    	return null;    }        try    {      Statement st = _dbase.createStatement();      ResultSet rs;      rs = st.executeQuery("SELECT name, tritanium, pyre, isogen, noxcium, mexallon, megacyte, other FROM components WHERE name == '"+component_in+"' ;");            materials.put( "tritanium", new Integer(rs.getInt("tritanium")) );      materials.put( "pyre", new Integer(rs.getInt("pyre") ));      materials.put( "isogen", new Integer(rs.getInt("isogen") ));      materials.put( "noxcium", new Integer(rs.getInt("noxcium") ));      materials.put( "mexallon", new Integer(rs.getInt("mexallon") ));      materials.put( "megacyte", new Integer(rs.getInt("megacyte") ));      materials.put( "other", new Integer(rs.getInt("other") ));            st.close();            return materials;    }        catch (Throwable t)    {      System.out.println(t);      t.printStackTrace();      return null;    }    }