python连接数据库

在python中terminal输入pip install pymysql ,下载pymysql，如果失败，进行环境变量配置

 

在python中的 terminal输入pip list 显示出mysql就显示已经成功

然后开始编写：

import pymysql

class myData(object):
 #    连接数据库1.地址2.用户3.密码4.db数据库名5.端口号6.编码格式
       db = pymysql.connect(host="127.0.0.1",user= "root",password="123456",db="ljgdata",port=3306,charset="utf8")
       # 建立游标，使用结束关闭游标
       cur = db.cursor()

       #  增  score 表名
       # sql="insert into score(stu_id,c_name,grade)values('%d','%s','%d')"
       # cur.execute(sql %(999,"杨勇勇",99))
       # db.commit()

#       删
#        sqld="delete from score where grade = %d"
#        cur.execute(sqld %(99))
#        db.commit()

#      改
#        sqlu = "update score set c_name='%s' where id=%d"
#        cur.execute(sqlu %('杨勇勇',2))
#        db.commit()

#     查
       sqls = "select * from score"
       cur.execute(sqls)
       rest = cur.fetchall()
       # print(rest)
       for i in rest:
             print("ID是&d",i[0])
             print("ST_UID是&d",i[1])
             print("名字是&s",i[2])
             print("grade是&d",i[3])
       db.commit()

       cur.close()
       db.close()

 

-------------------------------------------------------------------------------------------通过导出数据库并且为xml格式----------------------------

1.
# dom 解析：文档对象模型  以整片文字加载进来进行解析
# sax 解析：一边加载一遍解析
from xml.dom import minidom #导包 dom 解析

class read():
    def red(self):
       root = minidom.parse("student.xml")
       records = root.getElementsByTagName("RECORDS")[0]
       record0 = records.getElementsByTagName("RECORD")[0]
       rd_name = record0.getElementsByTagName("name")[0].firstChild.data
       rd_sex = record0.getElementsByTagName("sex")[0].firstChild.data
       rd_birth = record0.getElementsByTagName("birth")[0].firstChild.data
       rd_department = record0.getElementsByTagName("department")[0].firstChild.data
       rd_address = record0.getElementsByTagName("address")[0].firstChild.data

       return rd_name,rd_address,rd_birth,rd_department,rd_sex

2.

import unittest
from task.read import read   #引入其他类

class text(unittest.TestCase):
    def setUp(self):
        print("开始测试")
    def tearDown(self):
        print("测试结束")

    def test1(self):   #  测试用例的其中一个
         rd = read()
         res = rd.red()
         print(res)

# if __name__ == '__main__':
#     text.test1()

-------------------------------------------------------------------------------------------通过导出数据库并且为csv格式----------------------------

1.将数据库导出，选择为csv格式，复制到python中，导入csv包，进行显示输出

import csv

class rdcsv():
   #  如果出现首行乱码时，将编码改为utf-8-sig
   red = csv.reader(open("student.csv","r",encoding="utf-8"))
   for x in red:
       print(x)