4,011
社区成员
发帖
与我相关
我的任务
分享
void CODBCDlg::OnBnClickedButton5()
{
CTime tm1;
CTime tm2;
CString sqlStr;
m_time1.GetCurSel(tm1);
m_time2.GetCurSel(tm2);
c_time1 = tm1.Format(_T("%Y-%m-%d"));
c_time2 = tm2.Format(_T("%Y-%m-%d"));
UpdateData(TRUE);
switch (num_radio){
case 0:
List_All(_T("select * from score order by id"));
break;
case 1:
List_All(_T("select * from score order by name"));
break;
case 2:
sqlStr.Format(_T("select * from table where rq between to_date(\"%s\",\"yyyy-mm-dd\") and to_date(\"%s\",\"yyyy-mm-dd\")"), (LPCTSTR)c_time1, (LPCTSTR)c_time2);
List_All((LPCTSTR)sqlStr);
break;
default:
break;
}
}
void CODBCDlg::OnBnClickedButton5()
{
CTime tm1;
CTime tm2;
CString sqlStr;
m_time1.GetCurSel(tm1);
m_time2.GetCurSel(tm2);
c_time1 = tm1.Format(_T("%Y-%m-%d"));
c_time2 = tm2.Format(_T("%Y-%m-%d"));
UpdateData(TRUE);
switch (num_radio){
case 0:
List_All(_T("select * from score order by id"));
break;
case 1:
List_All(_T("select * from score order by name"));
break;
case 2:
sqlStr.Format(_T("select * from table where rq between to_date('%s','yyyy-mm-dd') and to_date('%s','yyyy-mm-dd')"), (LPCTSTR)c_time1, (LPCTSTR)c_time2);
List_All((LPCTSTR)sqlStr);
break;
default:
break;
}
}
CTime tm1(2015,10,1, 0, 0, 0);
CTime tm2(2016,10,1, 0, 0, 0);
CString szSQL;
szSQL.Format(_T("SELECT * FROM score WHERE data BETWEEN TO_DATE('%s', '%s') AND TO_DATE('%s', '%s')"),
tm1.Format(_T("%Y-%m-%d")), _T("YYYY-MM-DD"),
tm2.Format(_T("%Y-%m-%d")), _T("YYYY-MM-DD"),
0);
TRACE(_T("%s\n"), szSQL);
//SELECT * FROM score WHERE data BETWEEN TO_DATE('2015-10-01', 'YYYY-MM-DD') AND TO_DATE('2016-10-01', 'YYYY-MM-DD')