62,046
社区成员
发帖
与我相关
我的任务
分享
public class Person
{
public Person()
{
}
private int _personid;
private string _personname;
private string _personaddress;
private DateTime _createdate;
public int PersonID
{
get { return _personid; }
set { _personid = value; }
}
public string PersonName
{
get { return _personname; }
set { _personname = value; }
}
public string PersonAddress
{
get { return _personaddress; }
set { _personaddress = value; }
}
public DateTime CreateDate
{
get { return _createdate; }
set { _createdate = value; }
}
}
public class Person_class
{
public Person_class()
{
}
private int _id;
private string _name;
public int id
{
get { return _id; }
set { _id = value; }
}
public string name
{
get { return _name; }
set { _name = value; }
}
}
person_class.xml
<select id="Selectjoinperson_class" resultClass="HashMap">
select top 100 * from Person A left join Person_class B on A.classid=B.id
</select>