排序
Python_模拟银行对接mysql_24.6.14
1.创建数据库和数据表 import pymysql CREATE_SCHEMA_SQL = 'CREATE SCHEMA bank' CREATE_TABLE_SQL = '''CREATE TABLE account( account_id varchar(20) not null, account_passwd char(6) not...
5.17练习python
1 import socket host = socket.gethostname() port=8081 serversock=socket.socket(socket.AF_INET,socket.SOCK_STREAM) serversock.bind((host,port)) serversock.listen(5) print('等待客户...
python_练习_mysql_24.6.6
import pymysql db = pymysql.connect( host='localhost', user='root', password='123456789', db='world' ) cursor = db.cursor() sql = '''CREATE TABLE zhangsan ( sno CHAR(10) PRIMARY KE...
python作业加注释6月6日
import pymysql my = pymysql.connect( host='127.0.0.1', user='root', password='123456789', db='world' ) cur = my.cursor() cur.execute('DROP TABLE IF EXISTS minyan;') sql = '''create...
Python-pymysql插入
import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() insert_many_sql = [('01', 'zwy', 'n'), ('02', 'yxj', 'n'...
Python-pymysql建表
import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() create_sql = '''create table student ( sid char(10), sna...
python_课堂作业_5.11
import re # 1.re.split()和字符串中的split()函数一样,用来切割字符串 # str.split()函数不支持正则表达式和多个切割符号 # re.split()函数可以通过正则表达式切割字符串,支持使用多个分隔...
python_小作业_24.6.20
1.定义一个Box类,有width, height, depth三个属性,init()和get_Volume()(求体积)两个方法。其中init()方法用于获得初始化属性值,width, height, depth分别为5,6,7. (1)定义get_Volume()...
python–课堂
import re #1.正则表达式的两种定义方法 #(1)字符串方法: #匹配小写字母任意次 pattern = '[a-z]*'#正则表达式 print(re.match(pattern,'he123llo123'))#匹配0到第5个字符 print(re.match(pa...

