如何编写Java工具类生成SQL查询语句？

本文共计150个文字，预计阅读时间需要1分钟。

javapublic static String getSelectSql(List columns, Class c) { StringBuffer sb=new StringBuffer(); StringBuffer whereSB=new StringBuffer(); sb.append(select ); for (String string : columns) { sb.append(string + , ); } sb.delete(sb.length() - 2, sb.length()); // Remove the last comma and space sb.append( from + c.getSimpleName()); return sb.toString();}

/**查询语句生成器*/ public static String getSelectSql(List columns,Class c){ StringBuffer sb=new StringBuffer(); StringBuffer whereSB=new StringBuffer(); sb.append("select "); for (String string : columns) { sb.append(string.replace('_', '.')); sb.append(" as \""+string+"\","); } sb.delete(sb.length()-1, sb.length()); sb.append(" from "); //生成关联表名和where条件 createTablesAndWhere(c,sb,whereSB); //去掉尾巴 sb.delete(sb.length()-1, sb.length()); sb.append(" where "+c.getSimpleName()+".id=?"); whereSB.delete(whereSB.length()-3, whereSB.length()); sb.append(whereSB); //装载数据 return sb.toString(); }