我必须根据给出的name才能知道表名是什么,我现在是做了两步操作,第一步把表名取出来,第二步是做循环去这些表里取数, String sql="select tablename from mappingtable where name='a'"; String sql1="select * from tmptable "; rs=stmt.executeQuery(sql); while(rs.next()){ sql1+="union all select * from "+rs.getString("tablename"); } stmt.executeQuery(sql1); 大概就是这样的过程,有什么简单方法吗?
String sql="select tablename from mappingtable where name='a'";
String sql1="select * from tmptable ";
rs=stmt.executeQuery(sql);
while(rs.next()){
sql1+="union all select * from "+rs.getString("tablename");
}
stmt.executeQuery(sql1);
大概就是这样的过程,有什么简单方法吗?