Python Db-api

Python has developed a unified API (application Programming Interface, application programming Interface) for database access:D B-api.

The implementation of MySQL is called Mysqldb,oracle implementation for OracleDB.

Each module contains a connect () method, which returns a Db-api connection object.

API for Connection objects: The following example uses the username/password to connect to the MySQL database test on localhost (localhost).

>>> Import MySQLdb

>>> conn = mysqldb.connect (host= ' localhost ', user= ' root ', passwd= ' 123456 ', db= ' teSt ');

Close the connection after completing the appropriate action:

>>> Conn.close ();

Python Db-api