	public void writeShows(PodioShow... pshow) throws SQLException {
		Connection c = DBConnector.getInstance().getConnection();
		PreparedStatement ps = c.prepareStatement("INSERT INTO shows VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
		for (PodioShow p : pshow) {
			pshow.setInt(1, pshow.getShowID());
			pshow.setInt(2, pshow.getBandID());
			pshow.setDate(3, pshow.getDate());
			pshow.setInt(4, pshow.getState());
			pshow.setDouble(5, pshow.getFee());
			pshow.setString(6, pshow.getFeeCurrency());
			pshow.setDouble(7, pshow.getProvision());
			pshow.setString(8, pshow.getProvisionCurrency());
			pshow.setInt(9, pshow.getProductionType());
			pshow.setInt(10, pshow.getProfitSplit());
			pshow.setInt(11, pshow.getTicketPrice());
			pshow.setDouble(12, pshow.getKodaPct());
			pshow.setDouble(13, pshow.getVAT());
			pshow.setInt(14, pshow.getTicketsSold());
			pshow.setString(15, pshow.getComment());
			pshow.setTimestamp(16, pshow.getLastEdit());
			ps.executeUpdate();
		}
	}

	public void writeShows(PodioShow... pshow) throws SQLException {
		Connection c = DBConnector.getInstance().getConnection();
		PreparedStatement ps = c.prepareStatement("INSERT INTO shows VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
		for (PodioShow p : pshow) {
			ps.setInt(1, p.getShowID());
			ps.setInt(2, p.getBandID());
			ps.setDate(3, p.getDate());
			ps.setInt(4, p.getState());
			ps.setDouble(5, p.getFee());
			ps.setString(6, p.getFeeCurrency());
			ps.setDouble(7, p.getProvision());
			ps.setString(8, p.getProvisionCurrency());
			ps.setInt(9, p.getProductionType());
			ps.setInt(10, p.getProfitSplit());
			ps.setInt(11, p.getTicketPrice());
			ps.setDouble(12, p.getKodaPct());
			ps.setDouble(13, p.getVAT());
			ps.setInt(14, p.getTicketsSold());
			ps.setString(15, p.getComments());
			ps.setTimestamp(16, p.getLastEdit());
			ps.executeUpdate();
		}
	}
