How to operate Database in Python

This article will explain in detail how to operate the database in Python. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Basic process of database operation

Database connection object Connection

# connecting to sqlite database

Conn = sqlite3.connect ('database')

# important methods under Connection object

# get Cursor cursor object

Conn.cursor ()

# commit database transactions

Conn.commit ()

# rollback database transactions

Conn.rollback ()

# close database connection

Conn.close ()

# example demonstrates import sqlite3 try: # establishing a database connection conn = sqlite3.connect ('test.db') # creating a cursor object cursor = conn.cursor () # performing a sql insert operation sql =' INSERT INTO user (name, age) VALUES (?,?)' Cursor.execute (sql, ("Jack", 18)) # commit database transaction conn.commit () except sqlite3.Error as e: # rollback database transaction conn.rollback () finally: # close cursor if cursor: cursor.close () # close database connection if conn: conn.close ()

Cursor object Cursor

# important methods under Cursor object

Execute a sql statement, where sql is a sql statement and params is a sequence or dictionary type

Execute (sql [, params])

Return all data from the result set

Fetchall ()

Operation demonstration

On how to operate the database in Python to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.