python import psycopg2 conn = psycopg2.connect(database="mydb", host="localhost", port="5432") cur = conn.cursor() cur.execute("CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(50), age INTEGER)") cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Alice", 28)) cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Bob", 32)) cur.execute("INSERT INTO users (name, age) VALUES (%s, %s)", ("Charlie", 25)) conn.commit() cur.execute("SELECT * FROM users") rows = cur.fetchall() for row in rows: print("Id:", row[0]) print("Name:", row[1]) print("Age:", row[2]) cur.close() conn.close()


上一篇:
下一篇:
切换中文