17,082
社区成员
发帖
与我相关
我的任务
分享
StringBuffer sqlBuf = new StringBuffer();
sqlBuf.setLength(0);
sqlBuf.append(" SELECT DISP_INF ");
sqlBuf.append(" FROM M_INFO ");
sqlBuf.append(" WHERE DEL_FLG = '0' ");
sqlBuf.append(" AND TO_DATE(DISP_STRT_DT) <= SYSDATE ");
sqlBuf.append(" AND TO_DATE(DISP_CPLT_DT) >= SYSDATE ");
LoginDispRecord record = null;
PreparedStatement pstmt1 = getConn().prepareStatement(sqlBuf.toString());
ResultSet rset = null;
try {
rset = pstmt1.executeQuery(); 这里出错,被catch到错误
while (rset.next()) {
record = new LoginDispRecord();
record.setTextNews(rset.getString("DISP_INF"));
newsData.add(record);
}
} catch (SQLException e) {
if (getLog().isErrorEnabled()) {
getLog().error("<<<SQLException>>> " + e.getMessage());
}
throw e;
}
SELECT DISP_INF,TO_DATE(DISP_STRT_DT)
FROM M_INFO
WHERE DEL_FLG = '0'
AND TO_DATE(DISP_STRT_DT) <= SYSDATE
AND TO_DATE(DISP_CPLT_DT) >= SYSDATE
TO_DATE(DISP_STRT_DT,'yy/mm/dd')
TO_DATE(DISP_STRT_DT,'yyyy-mm-dd')