SQL语句正确,但在Java项目中运行,ResultSet rs的next()返回是false.
如何解决?
sqlBuf.append("select * from (");
sqlBuf.append("select apply.EXAM_TIME as check_time,apply.MONEY as money,apply.STATE as state,");
sqlBuf.append("applicate.APPLYER as applyer_name,");
sqlBuf.append("apply_remark.REMARK as remark,");
sqlBuf.append("company.NM as company_name,");
sqlBuf.append("exammer.WK as work_place ");
sqlBuf.append("FROM ");
sqlBuf.append("applicate,apply,apply_remark,company,exammer ");
sqlBuf.append("where apply.APPLICATE_ID = applicate.ID ");
sqlBuf.append("and apply.COMPANY_ID = company.ID ");
sqlBuf.append("and apply.EXAMINER_ID = exammer.ID ");
sqlBuf.append("and apply.ID = apply_remark.APPLY_ID");
sqlBuf.append(") A where A.applyer_name like '%");
sqlBuf.append(applyer);
sqlBuf.append("%' and ");
sqlBuf.append("A.company_name like '%");
sqlBuf.append(company);
sqlBuf.append("%'");
String sql = sqlBuf.toString();
sql = "SELECT
*
FROM
(
SELECT
apply.EXAM_TIME AS check_time,
apply.MONEY AS money,
apply.STATE AS state,
applicate.APPLYER AS applyer_name,
apply_remark.REMARK AS remark,
company.NM AS company_name,
exammer.WK AS work_place
FROM
applicate,
apply,
apply_remark,
company,
exammer
WHERE
apply.APPLICATE_ID = applicate.ID
AND apply.COMPANY_ID = company.ID
AND apply.EXAMINER_ID = exammer.ID
AND apply.ID = apply_remark.APPLY_ID
) AS A,
applicate,
apply
WHERE
A.applyer_name LIKE '%范%'
AND A.company_name LIKE '%长%'"