public static void main (String[] args) throws Exception{
List<String> glzd = new ArrayList<>();//关联字段
glzd.add("idCard");
glzd.add("phone");
List<String> tables = new ArrayList<>();//表
tables.add("A");
tables.add("B");
tables.add("C");
tables.add("D");
tables.add("E");
List<String> list = new ArrayList<>();//拼装表和字段
for (String t:tables) {
for (String zd:glzd){
list.add(t+"."+zd);
}
}
System.out.println("表字段------:"+list);
StringBuilder sql = new StringBuilder();
for (String bzd:list) {
for (String t:tables){
if(!t.equals(bzd.substring(0,bzd.indexOf(".")