linux下连接oracle数据库.docxVIP

PAGE PAGE # 24. PAGE 24. PAGE # 源代码 C++代码 #i nclude iostream #in elude stri ng #i nclude occi.h using n amespace oracle::occi; using n amespace std; 6. int mai n() { stri ng usr=sys; stri ng pwd=orcl; string SID=ORCL; // 注意大小写 string date; 13. Environment *en v=E nviro nmen t::createE nvironmen t(E nvir onmen t::OBJECT); Conn ecti on *conn= en v-createC onn ecti on( usr,pwd,SID);//all stri ngs if(co nn) coutsuccess createC onnection !e ndl; else coutfailure createC onnection !e ndl; 20. Stateme nt *stmt = conn-createStateme nt(); stri ng sSQL = select to_char(sysdate,yyyy-mm-dd hh24:m