public List<Unit> getUnits() {
		List<Unit> result = new ArrayList<Unit>();
		String queryString = "SELECT ID, NAME, CODE FROM UNIT;";
		try {
			st = getConnection().createStatement();
			rs = st.executeQuery(queryString);
			while (rs.next()) {
				Unit newUnit = new Unit();
				newUnit.setId(rs.getLong(1));
				newUnit.setName(rs.getString(2));
				newUnit.setCode(rs.getString(3));
				result.add(newUnit);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			closeResources();
		}
		return result;
	}