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

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

java/** * 查询语句生成器 * @param columns 列名列表 * @param c 实体类 * @return 生成的基础查询SQL */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 + , ); } sb.delete(sb.length() - 2, sb.length()); // 移除最后的逗号和空格 sb.append( from ); sb.append(c.getSimpleName()); return sb.toString();}

gistfile1.txt

/**查询语句生成器*/ 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(); }