当我在phpMyAdmin中运行下面的查询时,它可以工作(我删除了引号和+
,并用46
替换了?
);但是,当我在服务器端将其作为我的GWT Java的一部分运行时,会收到错误消息SQLException in getManagementOverview: java.sql.exception: Column ' group2.grp_sub_section' not found
在日志中。
String selectQry = ("SELECT group2.grp_sub_section, group2.grp_section, group2.grp_name, group2.grp_district, group2.grp_region, group2.grp_state, " +
"at_cub_awards.ca_id caid, at_cub_awards.ca_awarded_date awarded, " +
"at_award.aw_award_type type, at_award.aw_award_name name " +
"FROM at_group group2, at_group group1, at_account_group, at_cub_details, at_cub_awards, at_award " +
"WHERE at_account_group.acc_id = ? " +
"AND at_account_group.grp_id = group1.grp_id " +
"AND group1.grp_district = group2.grp_district " +
"AND group2.grp_section = 'Cub' " +
"AND group2.grp_id = at_cub_details.grp_id " +
"AND at_cub_details.cd_id = at_cub_awards.cd_id " +
"AND at_cub_awards.ca_awarded_date IS NOT NULL " +
"AND at_cub_awards.aw_id = at_award.aw_id " +
"AND at_award.aw_award_section = 'Cub' " +
"ORDER BY group2.grp_state, group2.grp_region, group2.grp_district, group2.grp_name, group2.grp_section, group2.grp_sub_section, name;");
按照下面的要求,我添加了我的任务行,因此该课程已完成:
while (result.next()) {
ManagementOverview managementOverview = new ManagementOverview(
result.getString("group2.grp_state"),
result.getString("group2.grp_region"),
result.getString("group2.grp_district"),
result.getString("group2.grp_name"),
result.getString("group2.grp_section"),
result.getString(" group2.grp_sub_section"),
result.getString("caid"),
result.getDate("awarded"),
result.getString("type"),
result.getString("name"));
managementOverviewList.add(managementOverview);
}
最佳答案
抱歉,问题是result.getString(" group2.grp_sub_section"),
应该是result.getString("group2.grp_sub_section"),
,即group2之前没有空格。