123456789101112131415161718192021222324252627282930313233343536373839404142 |
- import sqlite3
- conn = sqlite3.connect('vps2021.db')
- c = conn.cursor()
- c.execute('''CREATE TABLE vps
- (ip text, port text, password text, ss_port text, info text)''')
- c.execute('''INSERT INTO vps VALUES
- ('188.188.188.188', '22', 'passwd@vps2021', '443', '0号vps示例')''')
- conn.commit()
- port = ('22',)
- c.execute('SELECT * FROM vps WHERE port=?', port)
- print(c.fetchone())
- purchases = [ ('188.188.188.188', '10122', 'passwd@vps2021', '443', '1号NAT小鸡'),
- ('188.188.188.188', '10222', 'passwd@vps2021', '443', '2号NAT小鸡'),
- ('188.188.188.188', '10322', 'passwd@vps2021', '443', '3号NAT小鸡'),
- ('188.188.188.188', '10422', 'passwd@vps2021', '443', '4号NAT小鸡'),
- ('188.188.188.188', '10522', 'passwd@vps2021', '443', '5号NAT小鸡'),
- ('188.188.188.188', '10622', 'passwd@vps2021', '443', '6号NAT小鸡'),
- ('188.188.188.188', '10722', 'passwd@vps2021', '443', '7号NAT小鸡'),
- ('188.188.188.188', '10822', 'passwd@vps2021', '443', '8号NAT小鸡'),
- ('188.188.188.188', '10922', 'passwd@vps2021', '443', '9号NAT小鸡'),
- ]
- c.executemany('INSERT INTO vps VALUES (?,?,?,?,?)', purchases)
- conn.commit()
- conn.close()
|