jython mysql_用jython 访问mysql数据库

安装(需要已经安装了jdk/jre?)

java -jar jython_installer-2.2.1.jar 安装到C:/jython2.2.1

将zxJDBC.jar解压缩到c:/tmp

将mm.mysql-2.0.4-bin.jar复制到c:/tmp

C:/jython2.2.1>set CLASSPATH=c:/tmp/mm.mysql-2.0.4-bin.jar;c:/tmp/zxJDBC.jar;%CLASSPATH%

启动mysql服务器

C:/mysql51>cd bin

C:/mysql51/bin>mysqld --console

并建立数据库

C:/mysql51/bin>mysql -u root

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 1

Server version: 5.1.14-beta-community MySQL Community Server (GPL)

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> show databases

-> ;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

+--------------------+