IronPython操作数据库

IronPython操作数据库

# -*- coding: utf-8 -*-
import clr
clr.AddReference('System.Data' )
from System .Data import *

conn = SqlClient.SqlConnection("server=42.96.190.81,2433;database=QQRobot;uid=sa;pwd=xinyang0822_xin;pooling=true;Enlist=true;connection lifetime=300;min pool size = 0;max pool size=512;packet size=1000")
conn.Open()

cmd = SqlClient.SqlCommand("select * from AIData where Id=1", conn)
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

while reader.Read():
    print reader[0]

reader.Close()
conn.Close()