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; } }