请问用odbc接access数据库，以下的写法是否有问题？或者是否有根恰当写法？

CRecordSet的派生类 m_RouteDB;
............................
1.写数据库：
try
{
m_RouteDB.Open(CRecordset::dynaset, "SELECT * FROM tlk_RouteBrdcst");
m_RouteDB.AddNew();
m_RouteDB.m_t = m_nstep;
m_RouteDB.m_callsign = callsign;
m_RouteDB.m_comutime = comu_time;
m_RouteDB.m_endtime = end_time;
m_RouteDB.Update();
m_RouteDB.Close();
          }
catch(CDBException* e)
{
AfxMessageBox(e->m_strError);
return;
}2.读数据库:
记录用数据结构：swInfoClsn；
try
{
m_RouteDB.m_strFilter.Format("t = %d", nstep * 10); if ( m_RouteDB.IsOpen() )
{
    m_RouteDB.Close();
} m_RouteDB.Open(); if ( m_RouteDB.IsBOF() )
{
        CString s;
        s.Format("GetDB_PlanTrack(): Err00→No Valid Value in DB at: %d", nstep);
AfxMessageBox(s);
return;
}
else
{
m_RouteDB.MoveFirst();
} while( !m_RouteDB.IsEOF() )
{
swInfoClsn.callsign = m_RouteDB.m_callsign;
swInfoClsn.comutime = m_RouteDB.m_comutime;
swInfoClsn.endtime  = m_RouteDB.m_endtime;
m_RouteDB.MoveNext();
} m_RouteDB.Close(); }
catch(CDBException* e)
{
AfxMessageBox(e->m_strError);
return;
}