sqlite各种加密方式demo

package com.sqlite.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import org.junit.Test; public class SqliteWillenaSQLCipher { /** * SQLCipher-v4加密方式创建Sqlite数据库 * @title: createSqliteDb * @author zchen * @throws Exception * @date 2022年8月31日 下午2:10:30 */ @Test public void createSqliteV4Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager.getConnection("jdbc:sqlite:sqlite-sqlcipher.db?cipher=sqlcipher&legacy=4&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); // 创建表 StringBuffer createTableSql = new StringBuffer("create table TB_TEST ("); createTableSql.append("id INTEGER, name NTEXT,"); createTableSql.append("typeId INTEGER, logoUrl text"); createTableSql.append(");"); stat.executeUpdate(createTableSql.toString()); stat.executeUpdate("INSERT INTO TB_TEST(id,name,typeId,logoUrl) VALUES (1111,'sqlite-sqlcipher',123,'adkflaskd')"); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } /** * SQLCipher-v4加密方式读取Sqlite数据库 * @title: selectSqliteDb * @author zchen * @throws Exception * @date 2022年8月31日 下午2:11:25 */ @Test public void selectSqliteV4Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager .getConnection("jdbc:sqlite::resource:config/dbfile/sqlite-sqlcipher.db?cipher=sqlcipher&legacy=4&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)+"--"+rs.getObject(2)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } /** * SQLCipher-v3加密方式创建Sqlite数据库 * @title: createSqliteDb * @author zchen * @throws Exception * @date 2022年8月31日 下午2:10:30 */ @Test public void createSqliteV3Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager.getConnection("jdbc:sqlite:sqlite-sqlcipherv3.db?cipher=sqlcipher&legacy=3&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); // 创建表 StringBuffer createTableSql = new StringBuffer("create table TB_TEST ("); createTableSql.append("id INTEGER, name NTEXT,"); createTableSql.append("typeId INTEGER, logoUrl text"); createTableSql.append(");"); stat.executeUpdate(createTableSql.toString()); stat.executeUpdate("INSERT INTO TB_TEST(id,name,typeId,logoUrl) VALUES (1111,'sqlite-sqlcipherv3',123,'adkflaskd')"); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } /** * SQLCipher-v3加密方式读取Sqlite数据库 * @title: selectSqliteDb * @author zchen * @throws Exception * @date 2022年8月31日 下午2:11:25 */ @Test public void selectSqliteV3Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager .getConnection("jdbc:sqlite::resource:config/dbfile/sqlite-sqlcipherv3.db?cipher=sqlcipher&legacy=3&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)+"--"+rs.getObject(2)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } /** * SQLCipher256加密方式创建Sqlite数据库 * @title: sqlite-sqlcipher256 * @author zchen * @throws Exception * @date 2022年8月31日 下午5:50:02 */ @Test public void createSqliteSqlcipher256Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager.getConnection("jdbc:sqlite:sqlite-sqlcipher256.db?cipher=sqlcipher&legacy=0&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); // 创建表 StringBuffer createTableSql = new StringBuffer("create table TB_TEST ("); createTableSql.append("id INTEGER, name NTEXT,"); createTableSql.append("typeId INTEGER, logoUrl text"); createTableSql.append(");"); stat.executeUpdate(createTableSql.toString()); stat.executeUpdate("INSERT INTO TB_TEST(id,name,typeId,logoUrl) VALUES (1111,'sqlite-sqlcipher256',123,'adkflaskd')"); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } /** * SQLCipher256加密方式创建Sqlite数据库 * @title: sqlite-sqlcipher256 * @author zchen * @throws Exception * @date 2022年8月31日 下午5:50:02 */ @Test public void selectSqliteSqlcipher256Db() throws Exception { try { Class.forName("org.sqlite.JDBC"); Connection connection = DriverManager .getConnection("jdbc:sqlite::resource:config/dbfile/sqlite-sqlcipher256.db?cipher=sqlcipher&legacy=0&kdf_iter=256000&key=123"); Statement stat = connection.createStatement(); ResultSet rs = stat.executeQuery("select * from TB_TEST"); while (rs.next()) { System.out.println(rs.getObject(1)+"--"+rs.getObject(2)); } rs.close(); stat.close(); connection.close(); } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); System.exit(0); } System.out.println("Opened database successfully"); } }