python mysql测试连接_python连接数据库测试

#!/usr/bin/python

#coding=utf-8

import cx_Oracle

import sys

import urllib

import os

def connectDB(dbname='sms'):

if dbname == 'sms':

connstr='system/oracle@192.168.56.21:1521/sms'

db=cx_Oracle.connect(connstr)

return db

def sqlSelect(sql,db):

#include:select

cr=db.cursor()

cr.execute(sql)

rs=cr.fetchall()

cr.close

return rs

def sqlDML(sql,db):

#include:inesrt,update,deleter

cr=db.cursor()

cr.execute(sql)

cr.close()

db.commit

def sqlDDL(sql,db):

#include:create

cr=db.cursor()

cr.execute(sql)

cr.close

if __name__=='__main__':

print "This is a test python program,write by lsq!\n"

#connect to database

db=connectDB()

#create table:

sql="create table test as select rownum id,lpad(rownum,10,'x') comm from dual connect by level<=100"

sqlDDL(sql,db)

#insert data to table test

sql="insert into test select rownum,lpad(rownum,10,'x') from dual connect by level<=100"

sqlDML(sql,db)

#select th result:

print "this is the first time select the data from test"

sql='select * from test'

rs=sqlSelect(sql,db)

for x in rs:

print x

oracle@bjmbsdb01[/home/oracle]python testdb.py

This is a test python program,write by lsq!

this is the first time select the data from test

(1, 'xxxxxxx