<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                ## 增加 * 創建testInsert.py文件,向學生表中插入一條數據 * 下面是python2 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("insert into students(sname) values('張良')") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 修改 * 創建testUpdate.py文件,修改學生表的一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("update students set sname='劉邦' where id=6") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 刪除 * 創建testDelete.py文件,刪除學生表的一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() count=cs1.execute("delete from students where id=6") print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## sql語句參數化 * 創建testInsertParam.py文件,向學生表中插入一條數據 ~~~ #encoding=utf-8 import MySQLdb try: conn=MySQLdb.connect(host='localhost',port=3306,db='test1',user='root',passwd='mysql',charset='utf8') cs1=conn.cursor() sname=raw_input("請輸入學生姓名:") params=[sname] count=cs1.execute('insert into students(sname) values(%s)',params) print count conn.commit() cs1.close() conn.close() except Exception,e: print e.message ~~~ ## 其它語句 * cursor對象的execute()方法,也可以用于執行create table等語句 * 建議在開發之初,就創建好數據庫表結構,不要在這里執行 ## python3代碼 ~~~ #!/usr/bin/env python # -*- coding: utf-8 -*- ''' @Time : 5/14/18 11:17 PM @Author : haibo @File : Connection.py ''' from pymysql import * try: conn = connect(host="localhost", port=3306, user="root", passwd="haibo", db="python3", charset="utf8") cur1 = conn.cursor() # sql = "insert into student(name,birthday) values('李XX','1997-8-7')" # sql = "update student set name ='lihui' where id=7" sql = "delete from student where id=7" cur1.execute(sql) conn.commit() cur1.close() conn.close() except Exception as e: print(e.message) ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看