List list = new ArrayList(); while(re.next()){ String id = rs.getString(0); String name = rs.getString(1); Person person = new Person(id,name); list.add(person) } return list
查询的时候将四个表连接起来,不就是相当于建了一个视图view,然后再select * from view,相当于把四张表关联后作为一个新实体。其实吧,还是要自己建类
查询语句用的表别名select a.xx,b.cc,c.ee from A as a,B as b,C as c
List list = new ArrayList();
while(re.next()){
String id = rs.getString(0);
String name = rs.getString(1);
Person person = new Person(id,name);
list.add(person)
}
return list
你这个查询不需要where 条件约束的么 =。= 你直接在数据库试试呢 看有没有查询结果