建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
Jython訪問MySQL詳細(xì)步驟
Jython訪問MySQL的準(zhǔn)備工作如下：
成都創(chuàng)新互聯(lián)長期為成百上千客戶提供的網(wǎng)站建設(shè)服務(wù)，團(tuán)隊(duì)從業(yè)經(jīng)驗(yàn)10年，關(guān)注不同地域、不同群體，并針對不同對象提供差異化的產(chǎn)品和服務(wù)；打造開放共贏平臺，與合作伙伴共同營造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為洛川企業(yè)提供專業(yè)的網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)，洛川網(wǎng)站改版等技術(shù)服務(wù)。擁有十余年豐富建站經(jīng)驗(yàn)和眾多成功案例,為您定制開發(fā)。
下載Jython，JDBC和MySQL。
安裝（需要已經(jīng)安裝了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復(fù)制到c:\tmp
C:\jython2.2.1>set CLASSPATH=c:\tmp\mm.mysql-2.0.4-bin.jar;c:\tmp\zxJDBC.jar;%CLASSPATH%
啟動(dòng)mysql服務(wù)器
- C:\mysql51>cd bin
- C:\mysql51\bin>mysqld --console
并建立數(shù)據(jù)庫
- 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 |
- +--------------------+
- 2 rows in set (0.00 sec)
- mysql> create database test;
- Query OK, 1 row affected (0.01 sec)
- mysql> use test
- Database changed
- mysql> create table a1(c1 varchar(30));
- Query OK, 0 rows affected (0.02 sec)
- mysql> insert into a1 values ('Hello World');
- Query OK, 1 row affected (0.00 sec)
進(jìn)入Jython訪問MySQL
- C:\jython2.2.1>jython
- Jython 2.2.1 on java1.6.0
- Type "copyright", "credits" or "license" for more information.
- >>> from com.ziclix.python.sql import zxJDBC
- >>> mysqlConn = zxJDBC.connect("jdbc:mysql://localhost/test",
- ... "root", "",
- ... "org.gjt.mm.mysql.Driver")
- >>> cursor = mysqlConn.cursor()
- >>> cursor.execute("SELECT * FROM a1");
- >>> cursor.fetchone()
- ('Hello World',)
- >>> cursor.fetchall()
- []
- >>> cursor.description
- [('c1', 12, 30, None, None, None, 1)]
- >>>
需要用jython自己封裝的dbexts庫
最后編輯一個(gè)名為dbexts.ini的文件保存到c:\jython2.2.1\lib
- [default]
- name=mysqltest
- [jdbc]
- name=mysqltest
- url=jdbc:mysql://localhost/test
- user=root
- pwd=
- driver=org.gjt.mm.mysql.Driver
進(jìn)入jython
- >>> from dbexts import dbexts
- >>> mysqlcon = dbexts("mysqltest", "c:\jython2.2.1\lib\dbexts.ini
- >>> mysqlcon.table()
- TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS
- -----------------------------------------------------------
- | | a1 | TABLE |
- 1 row affected
- >>> mysqlcon.table('a1')
- TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE |
- S | NUM_PREC_RADIX | NULLABLE | REMARKS | COLUMN_DEF | SQL_DATA_
- SITION | IS_NULLABLE
- ----------------------------------------------------------------
- ----------------------------------------------------------------
- --------------------
- | | a1 | c1 | 12 |
- | 10 | 1 | | | 0
- | YES
- 1 row affected
- >>> mysqlcon.isql("SELECT * FROM a1")
- C1
- -----------
- Hello World
- 1 row affected
- DML
- >>> mysqlcon.isql("insert into a1 values('insert by dbexts')")
- >>> mysqlcon.isql("SELECT * FROM a1")
- C1
- ----------------
- Hello World
- insert by dbexts
- 2 rows affected
Jython訪問MySQL的設(shè)置到此就完成了。
網(wǎng)頁名稱：Jython訪問MySQL詳細(xì)步驟
鏈接URL：http://www.5511xx.com/article/cojggji.html
