Method get soldier by name

gistfile1.txt

	public SoldierDBItem getSoldierByName(String name) throws
			SQLException {

		QueryBuilder<SoldierDBItem, Integer> qb = getSoldierDao().queryBuilder();

		Where where = qb.where();

		where.eq(SoldierDBItem.COLUMN_NAME, name);
		
		SoldierDBItem soldierDBItem = qb.queryForFirst();

		return soldierDBItem;
	}