linuxsqlite-devel使用

非常轻量级都没有服务器进程mysql必须要有mysqld.service

sqlite

在任何时刻只允许一个写入操作执行其他写入操作需要排队数据库就是一个文件这个文件可以在任意位置任意后缀名建议用.db

.sqlite

dependencygroupIdorg.xerial/groupIdartifactIdsqlite-jdbc/artifactIdversion3.8.11.2/version/dependency2工具类

SqlLiteHelper

sample.common.utils.LogUtil;import

import

LogUtil.installFormatter(Logger.getLogger(SqlLiteHelper.class.getSimpleName()));/***

每次创建都将建立一个连接*

getConnection(dbFilePath);}public

Connection

null;Class.forName(org.sqlite.JDBC);conn

DriverManager.getConnection(jdbc:sqlite:

dbFilePath);return

getConnection(dbFilePath);return

connection;}private

getConnection().createStatement();return

executeQuery(String

getStatement().executeQuery(sql);T

rse.extractData(resultSet);return

rs;}

{destroyed();}}/**返回对象集合**/public

ListT

getStatement().executeQuery(sql);while

(resultSet.next())

{rsList.add(rm.mapRow(resultSet,

finally

getStatement().executeQuery(sql);while

(resultSet.next())

t.getClass().getDeclaredFields())

{field.setAccessible(true);field.set(t,resultSet.getObject(field.getName()));}rsList.add(t);}}

finally

getStatement().executeQuery(sql);T

(Field

t.getClass().getDeclaredFields())

---

连接断开了field.set(t,resultSet.getObject(field.getName()));}return

t;}

getStatement().executeQuery(sql);if(resultSet.next()){return

finally

getStatement().executeUpdate(sql);return

c;}

{destroyed();}}/**执行多个更新**/public

void

{getStatement().executeUpdate(sql);}}

finally

{getStatement().executeUpdate(sql);}}

finally

{destroyed();}}/**数据插入更新**/public

int

StringBuffer();sql.append(INSERT

INTO

);sql.append(tableName);sql.append(

);for

{sql.append(key);sql.append(,);}sql.delete(sql.length()-1,sql.length());sql.append()

VALUES

{sql.append();sql.append(param.get(key));sql.append(,);}sql.delete(sql.length()-1,sql.length());sql.append(););int

getStatement().executeUpdate(sql.toString());return

c;}

{destroyed();}}/**数据库资源关闭和释放**/public

void

{logger.info(Sqlite数据库关闭时异常e.getMessage());}}}

结果集实现

sqlLiteHelper.executeUpdate(createCard);

建表2.

https://www.sqlite.org/download.html

yum

----------------------------------------------------------

main

/usr/local/tynoo/trdp/trdp.dbsqlite

.tables

https://www.sqlite.net.cn/datatype3.html

如何存储日期和时间

它的备份本质上是这个sqlite_database.db这个文件的备份尤其是在单用户或低并发场景下SQLite

1文件