<select id="SelectAllPerson2" resultMap="SelectAllResult">
select
PER_ID AS Id,
PER_FIRST_NAME AS FirstName,
PER_LAST_NAME AS LastName,
PER_BIRTH_DATE AS BirthDate,
PER_WEIGHT_KG AS WeightInKilograms,
PER_HEIGHT_M AS HeightInMeters
from PERSON
</select>
#region 获取数据方法:
public IList<Person> GetAllPersonMy()
{
return SqlMap.QueryForList<Person>("SelectAllPerson", null);
//返回的类 类型的,将会根据resultMap中的class将查找到的数据库字段转换为Person的属性
}
public DataTable GetAllPerson2()
{
int recCount = 0;
DataTable dt = MyBatis.QueryForDataTable("SelectAllPerson");
//由于这里返回的是DataTable,他将直接返回数据库中的字段名称,所以在绑定数据时候可能会出错,因为查找的与绑定不一致,这里可以采用SelectAllPerson2,自己匹配返回的字段名称 return dt;
}
#endregion
数据绑定实体类:public class Person : Entity
{
private int id;
private string firstName;
private string lastName;
private DateTime? birthDate;
private double? weightInKilograms;
private double? heightInMeters;
public Person() { }
public int Id
{
get { return id; }
set { id = value; }
}
public string FirstName
{
get { return firstName; }
set { firstName = value; }
}
public string LastName
{
get { return lastName; }
set { lastName = value; }
}
public DateTime? BirthDate
{
get { return birthDate; }
set { birthDate = value; }
}
public double? WeightInKilograms
{
get { return weightInKilograms; }
set { weightInKilograms = value; }
}
public double? HeightInMeters
{
get { return heightInMeters; }
set { heightInMeters = value; }
}
}