| 12345678910111213141516171819202122232425 |
- '''
- Created on 2018年12月19日
- @author: User
- '''
- import psycopg2
- from DBUtils.PooledDB import PooledDB
- #使用连接池访问数据库
- pool = None
- def getConnection():
- global pool
- if pool is None:
- pool = PooledDB(psycopg2, 10,dbname="BiddingKG", host="192.168.2.101",user="postgres",password="postgres",port="5432")
- return pool.connection()
- if __name__=="__main__":
- conn = getConnection()
- cursor = conn.cursor()
- cursor.execute(" select 1")
- print(cursor.fetchall()[0][0])
|
