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

This article will explain in detail how to use Sqlit's small install-free database. The content of the article is of high quality. Therefore, Xiaobian shares it with you as a reference. I hope that after reading this article, you will have a certain understanding of relevant knowledge.

SQLite, a small database, do not install without configuration, can be used as a text, but can be used like mysql.

1 installation: download address https://www.sqlite.org/download.html, windows download sqlite-dll-win64-x64-3290000.zip and sqlite-tools-win32-x86-3290000.zip two files. Download and unzip it into a folder. Configure the folder address to the environment variable, open the command window and enter sqlite3

As shown in the figure, it means that the installation is successful. Enter.quit to exit. The sqlite command begins with ". "Beginning.

2 Create a new library. Type sqlite3 ***.db without entering sqlite and create a database with the name *** in the directory (I don't know if you have to use the extension db). In fact, you can create a file anywhere as a container without command.

3 Use navicat link, select sqlite3, no account and password required. You can create new tables or fields like mysql (command mode, not to study).

4 Used in springboot:

addition dependency

org.xerial sqlite-jdbc 3.21.0.1

Create a new file directly under recourse called database.db. A container used for storage.

application.properties Add

spring.datasource.url=jdbc:sqlite::resource:database.dbspring.datasource.driver-class-name=org.sqlite.JDBC

The first line points to the address of the newly created file. The second row is the configuration driver. No account or password required.

The rest is exactly the same as mysql, with subtle grammatical differences that the framework will help you with such as mybatisplus.

About how to use Sqlit small free installation database to share here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.