Sunday, February 20, 2011

Jython ийг Oracle 10g ex edition тэй холбох

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 даа нэмэхээ мартваа.

1 comment: