Commit2ef63ee

authored

Add files via upload

1 parent9aab5df commit2ef63eeCopy full SHA for 2ef63ee

File tree

+82

-0

lines changed

+82

-0

lines changed

Lines changed: 27 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,27 @@`
	`1`	`+importsys,glob`
	`2`	`+importmysql.connector`
	`3`	`+conn=mysql.connector.connect(`
	`4`	`+host="127.0.0.1",`
	`5`	`+user="user",passwd="passwd",`
	`6`	`+database="vps2022",buffered=True )`
	`7`	`+c=conn.cursor()`
	`8`	`+`
	`9`	`+files= []`
	`10`	`+forfinsys.argv[1:]:`
	`11`	`+files=files+glob.glob(f)`
	`12`	`+`
	`13`	`+defreadfile(file):`
	`14`	`+f=open(file,'r')`
	`15`	`+str=f.read();f.close()`
	`16`	`+returnstr`
	`17`	`+`
	`18`	`+forfileinfiles:`
	`19`	`+file_str=readfile(file)`
	`20`	`+row=(file,file_str)`
	`21`	`+`
	`22`	`+c.execute("DELETE FROM text WHERE name=%s ", (file,) )`
	`23`	`+c.execute('INSERT INTO text VALUES (%s,%s)',row)`
	`24`	`+print("FontName: "+file+" ....OK")`
	`25`	`+`
	`26`	`+conn.commit()`
	`27`	`+conn.close()`

Lines changed: 33 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,33 @@`
	`1`	`+importmysql.connector`
	`2`	`+conn=mysql.connector.connect(`
	`3`	`+host="127.0.0.1",`
	`4`	`+user="user",passwd="passwd",`
	`5`	`+database="vps2022",buffered=True )`
	`6`	`+c=conn.cursor()`
	`7`	`+`
	`8`	`+sql='SELECT name FROM text'`
	`9`	`+c.execute(sql)`
	`10`	`+names=c.fetchall()`
	`11`	`+`
	`12`	`+# 显示所有文件名，以供下载`
	`13`	`+foriinrange(len(names)):`
	`14`	`+print(names[i][0],end=' ')`
	`15`	`+`
	`16`	`+print('\n:: 选择一个文件下载，输入文件名: ',end='')`
	`17`	`+name=input().strip()`
	`18`	`+`
	`19`	`+sql='SELECT * FROM text WHERE name="'+name+'"'`
	`20`	`+c.execute(sql)`
	`21`	`+text=c.fetchall()`
	`22`	`+`
	`23`	`+defmakefile(file,str):`
	`24`	`+f=open(file,'w')`
	`25`	`+f.write(str);f.close()`
	`26`	`+`
	`27`	`+foriinrange(len(text)):`
	`28`	`+file=text[i][0]`
	`29`	`+file_str=text[i][1]`
	`30`	`+makefile(file,file_str)`
	`31`	`+print('FontName:',file,"\t保存完成!")`
	`32`	`+`
	`33`	`+conn.close()`

Lines changed: 22 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,22 @@`
	`1`	`+importmysql.connector`
	`2`	`+conn=mysql.connector.connect(`
	`3`	`+host="127.0.0.1",`
	`4`	`+user="user",passwd="passwd",`
	`5`	`+database="vps2022",buffered=True )`
	`6`	`+c=conn.cursor()`
	`7`	`+`
	`8`	`+sql='SELECT * FROM text ORDER BY name'`
	`9`	`+c.execute(sql)`
	`10`	`+text=c.fetchall()`
	`11`	`+`
	`12`	`+defmakefile(file,str):`
	`13`	`+f=open(file,'w')`
	`14`	`+f.write(str);f.close()`
	`15`	`+`
	`16`	`+foriinrange(len(text)):`
	`17`	`+file=text[i][0]`
	`18`	`+file_str=text[i][1]`
	`19`	`+makefile(file,file_str)`
	`20`	`+print(file,"\t��!")`
	`21`	`+`
	`22`	`+conn.close()`

Comments

(0)