Jython プログラム mytest.jy
#! /usr/local/jython2.5.1/jython
# -*- coding: utf-8 -*-
import com.ziclix.python.sql as sql
if __name__ == "__main__":
db = sql.zxJDBC.connect(
"jdbc:mysql://localhost/データベース名",
"ユーザ名",
"パスワード",
"org.gjt.mm.mysql.Driver")
cursor = db.cursor()
cursor.execute("SELECT * FROM hoge")
rows = cursor.fetchall()
for row in rows:
for column in row:
print column, '|',
print
cursor.close()
db.close()
実行シェル mytest.sh
#!/bin/sh JAVA_HOME=/usr/local/jdk1.6.0_24/bin/java JRE_HOME=$JAVA_HOME/jre LANG=ja_JP.UTF-8 MYSQL_LIB=hoge/lib export CLASSPATH=$CLASSPATH:$MYSQL_LIB/mysql-connector-java-5.0.8-bin.jar jython mytest.jy
実行
$ mytest.sh
