gistfile1.txt

String commoditiesSql = "INSERT INTO `commodities` (`diamond`, `gold`, `iron` , `utime`)"
				+ "VALUES (" + stockhouse.diamondPrice +", " + stockhouse.goldPrice + ", " + stockhouse.ironPrice +", " + Database.getUnxTime() + ")";
		
		Statement s = null;
		
		try{
			s = Database.createStatement();
			s.executeQuery(commoditiesSql);
		}catch(Exception e){
			Database.connectToDB("localhost", 3306, "rainbow", "rainbow_user", "jycalhR9YYEQfnf6s5Vb");
		}finally{
			if(s!=null){
				try {
					s.close();
				} catch (SQLException e) {
					Database.connectToDB("localhost", 3306, "rainbow", "rainbow_user", "jycalhR9YYEQfnf6s5Vb");
					e.printStackTrace();
					//pull();
				}
			}
		}