파이썬이랑 DB연동하기 23.04.21
import pymysql #변수선언# con,cur=None,None data1,data2,data3="","","" sql='' con = pymysql.connect( host="127.0.0.1", user="root", port=3306, password="1234", db="shopdb", charset='utf8') cur = con.cursor() while True : data1 = input("memberID => ") if data1 == '': break data2 = input("memberName => ") data3 = input("memberAddress => ") sql = "INSERT INTO memberTbl VALUES ('"+data1+"','"+data2+"','..
2023. 4. 21.
[리눅스] UTM9 - Firewall 23.04.14
2023.04.12 - [네트워크 수업/리눅스] - [리눅스] 방화벽 UTM9 23.04.12 UTMPermalink 1. in -> out - 모든 트래픽 허용 2. in -> dmz - DNS, HTTP, HTTPs, POP3, SMTP, IMAP, FTP 3. dmz -> in - 모두 차단 4. dmz -> out - DNS, SMTP 5. out -> in - 모두 차단 6. out -> dmz - DNS, HTTP, HTTPs, SMTP, FTP Network Protection -> Firewall 1. Sources(Internal) + Services(Any) + Destinations(Any) 2. Sources(Internal) + Services(DNS, FTP, HTTP, HTTP..
2023. 4. 14.