from oracle.jdbc import OracleDriver
from java.sql import DriverManager
def connect(un, pw, sid, host, port):
driver = OracleDriver()
DriverManager.registerDriver(driver)
connection = "jdbc:oracle:thin:@%s:%s:%s" % (host, port, sid)
conn = DriverManager.getConnection(connection, un, pw)
return conn
def doStuff(conn):
stmt = conn.createStatement()
rset = stmt.executeQuery("SELECT * FROM userss")
while (rset.next()):
print rset.getString(1) # 1 dugeer baganiig hevlene
stmt.close()
un = 'bolortuul' #hereglechiin ner oracleliin default admin ner "system" baidag. Ene nereer nevterj orood shine
#hereglech uusgej bolno
pw = 'boloroo' #nuuts ug
sid = 'xe' # database iin ner 10g ex edition-d default database "XE" nertei baidag ba ahij database uusgeh
#bolomgui baidag
host = 'localhost'
port = '1521' # port 8080 baij bolno herev yamar neg alda garval start listener hiigeerei
conn = connect(un, pw, sid, host, port)
doStuff(conn)
Дараах кодыг ажлуулахдаа ojdbc14.jar файлаа СLASSPATH даа нэмэхээ мартваа.
ter jar file tatah url bn au?
ReplyDelete