1.连接数据库:
otl_connect db;
otl_connect::otl_initialize();
db.rlogon("ds/ds@XE") ;
2:相关sql语句:
const char* sqlInsert = "insert into \"sysname\"(\"sys_id\",\"sysname\",\"adder\",\"relation_table_type\",\"relation_table\",\"remark\") \
values(:id<int>,:sysName<char[200]>,:adder<char[200]>,:rtt<char[200]>,:rt<char[200]>,:rm<char[200]>)" ;
const char* sqlModify = "update \"sysname\" set \"sysname\" = :sysname<char[200]>, \
\"adder\" = :adder<char[200]>,\"relation_table_type\" = :rtt<char[200]>,\"relation_table\" = :rt<char[200]>,\"remark\" = :rm<char[200]> \
where \"sys_id\" = :id<int>";
const char* sqlDel ="delete from \"sysname\" where \"sys_id\" = :id<int>";
3:定义otl_stream对象:
try{
otl_stream insert(10,sqlInsert,db);
otl_stream modify(10,sqlModify,db);
otl_stream del(10,sqlDel,db);
}catch(otl_exception* p){
MessageBox(CString(p->msg));
}