python中使用PyMysql操作Mysql数据库用例

import pymysql

import pymysql.cursors

 

"""

连接mysql数据库

"""

conn=pymysql.connect(host='192.168.199.133',port=3306,user='root',passwd='123456',

db='simondb');

"""

获得游标操作对象

"""

cursor=conn.cursor();

"""

插入数据

"""

count=cursor.execute("insert into user_info(username,password) value('simonMeng','e10adc3949ba59abbe56e057f20f883e')");

if count>0:

print("data Add SuccessFully!!!!!!")

"""

查询数据

"""

count =cursor.execute("select * from user_info");

if count>0:

"""

打印数据

"""

result=cursor.fetchall();

for obj in result:

print(obj[0],obj[1],obj[2]);

else:

print("data insert error!!!!!!!");

"""

关闭数据库的游标和连接

"""

cursor.close();

conn.close();