servlet吧 关注:1,440贴子:1,219
  • 0回复贴,共1

mysql7表查询出来的结果有7个相同的字段,怎么获取出对于的实体?

只看楼主收藏回复

sql语句如下:
String sql = "select * from t_video as v inner join t_section as s on v.SectionId=s.id inner join t_course as c on s.CourseId=c.Id inner join t_videotype as vt on v.type=vt.id inner join t_sectiontype as st on s.type=st.Id inner join t_coursetype as ct on c.type=ct.Id inner join t_user as u on s.AnthorId=u.id where v.AnthorId = ? limit ?,?";
通过java代码枚举结果集的字段:
ResultSetMetaData rd = rs.getMetaData();
for (int i = 1; i <= rd.getColumnCount(); i++) {
System.out.println("字段名:" + rd.getColumnName(i));
}
打印出的字段如下:
字段名:Id
字段名:AddTime
字段名:Name
字段名:Pic
字段名:CourseId
字段名:SectionId
字段名:Url
字段名:AnthorId
字段名:CommentSum
字段名:Introduction
字段名:SeeSum
字段名:DownSum
字段名:KnowledgeId
字段名:Type
字段名:Id
字段名:AddTime
字段名:CourseId
字段名:Name
字段名:Introduction
字段名:Anthorid
字段名:Type
字段名:Id
字段名:AddTime
字段名:Name
字段名:Introduction
字段名:Type
字段名:AnthorId
字段名:Id
字段名:AddTime
字段名:Name
字段名:Id
字段名:AddTime
字段名:Name
字段名:Id
字段名:AddTime
字段名:Name
字段名:Id
字段名:AddTime
字段名:UserName
字段名:Password
字段名:Accesstoken
字段名:BindEmail
字段名:Email
字段名:Age
字段名:Sex
字段名:Phone
字段名:RoleId
字段名:SchoolId
字段名:CollegeId
字段名:MajorId
字段名:FavourId
字段名:Imei
字段名:QQAuthor
字段名:SinaAuthor
字段名:IdentityCard
字段名:TLevel
字段名:TrueName
字段名:Nick
字段名:Address
字段名:UserHead
字段名:LoginTime
字段名:RefreshTime
字段名:Introduction
字段名:state
字段名:Score
字段名:ULevel
字段名:LoginCookie
字段名:LoginFlag
返回数据中共有58个字段
但是这7张表都有Id,AddTime字段,Name字段都很多重复
如果用传统的方法:rs.getString("name"),只能获取第一个id的值,而不能获取到第二个id,要怎么获取出对应的实体类呢?
ps,我很懒,不想用rs.getString(1);的方法!


IP属地:广东1楼2014-08-16 10:16回复