Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "how to use Python to read and write database in SQLite5". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

SQLite supports development calls in a variety of programming languages: C, C++, PHP, Perl, Java, C #, Python, Ruby and so on.

This article first introduces the Python language to call the SQLite database, why introduce Python first? Because Python is very easy to use, we can achieve what we want with a few lines of code (of course, if we configure the python development environment first).

1 basic flow of Python read and write SQLite

Here is a list of the basic processes for Python to read and write SQLite databases:

2 programming realization

2.1 basic process

After introducing the sqlite3 dependency package, the first step is to connect to the database and call the connect method:

FileDB = 'test4.db' # database file conn = sqlite3.connect (fileDB) # Connect to the database

Then you need to create a cursor:

Cur = conn.cursor () # create a cursor

At this point, you can execute the sql statement through the execute method, such as the query statement:

Sql = 'select * from SCORE' # SQLite statement (query data) cur.execute (sql)

We can also print out the queried data:

Print (cur.fetchall ()) # print all data

Finally close the connection

Conn.close () # close connection 2.2 data insertion

After using the python program to connect to the database, you can also insert the data into the database through the program, just continue to use the execute method to execute the sql statement.

2.2.1 insert a single piece of data

There are two ways to insert a single piece of data

# insert a single piece of data data = "7 insert into SCORE values 70, 81J 88" cur.execute ('insert into SCORE values (% s)'% data) # 1cur.execute ("insert into SCORE values (?)", (8,81,85,83)) # insert multiple data in mode 22.2.2

When multiple pieces of data are inserted together, use the executemany method:

# insert multiple data cur.executemany ('insert into SCORE values (,)', [(9, 85, 88, 86), (10, 88, 83, 90)]) 2.2.3 save data

Finally, you need to call commit to save the changes to the database:

# submit (save) conn.commit () 3 test

3.1 run the python program

Write python program, insert some data for testing.

Execute the python program and the result is as follows:

3.2 Command Line View validation

Using the command line to view the database, you can find that several pieces of data have been added to the database, indicating that the contents of the database have been successfully modified through the python program.

4 attached: complete procedure

The complete python program is as follows:

Import sqlite3fileDB = 'test4.db' # database file sql =' select * from SCORE' # SQLite statement (query data) # Connect database conn = sqlite3.connect (fileDB) # execute sql statement cur = conn.cursor () # create cursor cur.execute (sql) # print print (cur.fetchone ()) # print 1st data print (cur.fetchmany (2)) # print 2 more data print (cur.fetchall ()) # then print all the data # insert a single piece of data data = "7 insert into SCORE values (% s)'% data) # way 1cur.execute (" insert into SCORE values (? ), (8, 81, 85, 83) # insert multiple data cur.executemany ('insert into SCORE values (?)', [(9, 85, 88, 86), (10, 88, 83) 90)]) # print cur.execute (sql) print ('-') print (cur.fetchall ()) # submit (save) conn.commit () # close connection conn.close () "how to use Python in SQLite5 to read and write database" ends here Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.