yunoの日記： jythonでPostgreSql

よそに書いてみたけどjythonでPostgreSqlに接続してみたのでメモ。

スクリプトでjdbcドライバが使えるのはらくちんでいい感じ♪

from java.lang import *
from java.sql import *
Class.forName("org.postgresql.Driver").newInstance()
con = DriverManager.getConnection( 'jdbc:postgresql:sample','id','pass')
stmt = con.createStatement()
sql='select key,data1,data2,data3 from user_id'
rs = stmt.executeQuery(sql)
 
empList=[]
while (rs.next()):
    row={}
    row['key']=rs.getString(1)
    row['data1']=rs.getString(2)
    row['data2']=rs.getDouble(3)
    row['data3']=rs.getDouble(3)
    empList.append(row)
 
rs.close()
stmt.close()
con.close()
 
print 'key data1 data2 data3'
 
# print the result
for e in empList:
    print e['key'],e['data1'],e['data2'],e['data3']

参考：
Learn how to write DB2 JDBC tools in Jython
ほとんどここのマネ。

8.1 Build 405(8.1-405 JDBC 3)