Shulou(Shulou.com)06/01 Report--

Installation of necessary components

Windows support components of activepython python [python components are included in unix-like systems] download [Baidu activepython]

Oracle_client oracle database link component [cannot link database if not installed]

Cx_Oracle python's oracle link support component [download address] http://sourceforge.jp/projects/sfnet_cx-oracle/releases/

Installation process

Installing activepython and oracle_client is the next step

Install cx_Oracle

1. Check the version number of python

If activepython is installed properly, typing python on the command line will show the style shown above. You can see that the version number of python is

3.3.2.0. Then download the corresponding 32-bit cx_Oracle.

Download and click next to install

Test if cx_Oracle is available

If the input import cx_Oracle is normal, the installation is successful. If prompted that the dll file cannot be found, copy the dll file under ORACLE_HOME/bin to the installation directory of python.

Start code testing

Develop a script to query salary based on scott object

From pip.backwardcompat import raw_input__author__ = 'stone'# introduces oracle support package import cx_Oracle# link database conn=cx_Oracle.connect (' scott/tiger@172.15.36.225/orcl') cur=conn.cursor () # execute statement cur.prepare ('select * from emp where empno = to_number (: id)') # fetch the entered employee number empnum=input ("Please data your job number:") # pass binding variables to the corresponding statement cur.execute (None {'id': empnum}) # put all selected lines into resres = cur.fetchall () # iteratively print out the content of the query for rin res: print ("name:" + str (r [1]) + "Job number:" + str (r [0]) + "salary:" + str (r [5]) + "monthly bonus:" + str (r [6]) + ") cur.close () conn.close ()

Go to the corresponding directory, data python Querysal.py, and you can get the information you want to see.

The above is just a simple query of the salary function, which does not include any error control content. Will be perfected later

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.