Java后端写sql查询语句别名,前端获得的字段名都是小写问题
String sql = "select a.prjapproval_id as prjApprovalId,a.modifier as modifier,········";
前端获得的字段名:prjapprovalid
我想获得的字段名:prjApprovalId
改为:
String sql = "select a.prjapproval_id as \"prjApprovalId\",a.modifier as \"modifier\",········";
给每个字段加上双引号:\"