- 浏览: 257711 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
no_studio:
期待实现SqlServer
发布异种数据库导入工具jmyetl-1.0.2 -
babydeed:
不错 再接再厉
发布异种数据库导入工具jmyetl-1.0.2 -
iihero:
niwtsew 写道贴个俺自己写的linux下的版本,其实没必 ...
命令行快速找出class文件所在的jar包 -
niwtsew:
说错,是strings不是string
命令行快速找出class文件所在的jar包 -
niwtsew:
贴个俺自己写的linux下的版本,其实没必要用7z,直接jar ...
命令行快速找出class文件所在的jar包
好久没有光顾sqlite了,没想到已经到了3.7.8了。
以前手动下载,并且建工程,编译,挺浪费时间的。干脆用wget, 7z, 结合批处理,整理成一个可以下载并编译成dll和exe的脚本。
运行脚本之前,请先将vs2008的vcvar运行一下,得到vc的编译环境。
内容如下:
以下是我的执行结果:
以前手动下载,并且建工程,编译,挺浪费时间的。干脆用wget, 7z, 结合批处理,整理成一个可以下载并编译成dll和exe的脚本。
运行脚本之前,请先将vs2008的vcvar运行一下,得到vc的编译环境。
内容如下:
@echo off set version=%1 set os_cpu=win32-x86 rem rem from sqlite3.7.4, rem sqlite3-product-version.zip rem sqlite3-product-version.tar.gz rem sqlite3-product-os-cpu-version.zip rem sqlite3-product-date.zip @rem sqlite-build 3070500 3070400 3070800 if not exist "sqlite-amalgamation-%version%.zip" ( echo fetching sqlite-amalgamation-%version%.zip ... wget http://www.sqlite.org/sqlite-amalgamation-%version%.zip if not exist "sqlite-amalgamation-%version%.zip" ( echo download sqlite-amalgamation-%version%.zip error! goto EOF ) ) 7z x -y -o.\sqlite-amalgamation-%version% "sqlite-amalgamation-%version%.zip" if exist ".\sqlite-amalgamation-%version%\sqlite-amalgamation-%version%" ( move .\sqlite-amalgamation-%version%\sqlite-amalgamation-%version%\* .\sqlite-amalgamation-%version%\ ) if not exist ".\sqlite-amalgamation-%version%\shell.c" ( echo copy shell.c from another location ... if not exist ".\sqlite-source-%version%.zip" ( echo fetching sqlite-source-%version%.zip ... wget http://www.sqlite.org/sqlite-source-%version%.zip ) 7z x -y -o.\sqlite-source-%version% "sqlite-source-%version%.zip" copy /y .\sqlite-source-%version%\shell.c .\sqlite-amalgamation-%version%\ rd /s /q sqlite-source-%version% echo copy shell.c from another location ... if not exist ".\sqlite-src-%version%.zip" ( echo fetching sqlite-src-%version%.zip ... wget http://www.sqlite.org/sqlite-src-%version%.zip ) 7z x -y -o.\ "sqlite-src-%version%.zip" copy /y .\sqlite-src-%version%\shell.c .\sqlite-amalgamation-%version%\ rd /s /q sqlite-src-%version% ) if not exist ".\sqlite-amalgamation-%version%\sqlite3.def" ( if not exist "sqlitedll-%version%.zip" ( echo fetching sqlitedll-%version%.zip ... wget http://www.sqlite.org/sqlitedll-%version%.zip ) 7z x -y -o.\sqlitedll-%version% "sqlitedll-%version%.zip" copy /y .\sqlitedll-%version%\sqlite3.def .\sqlite-amalgamation-%version%\ rd /s /q sqlitedll-%version% echo try another dll zip if not exist "sqlite-dll-%os_cpu%-%version%.zip" ( echo fetching sqlite-dll-%os_cpu%-%version%.zip ... wget http://www.sqlite.org/sqlite-dll-%os_cpu%-%version%.zip ) 7z x -y -o.\sqlite-dll-%os_cpu%-%version% "sqlite-dll-%os_cpu%-%version%.zip" copy /y .\sqlite-dll-%os_cpu%-%version%\sqlite3.def .\sqlite-amalgamation-%version%\ rd /s /q sqlite-dll-%os_cpu%-%version% ) cd /d sqlite-amalgamation-%version% echo begin building sqlite-amalgamation-%version% cl -Gs -GX -D_WIN32 -nologo -Zi -DOS_WIN=1 -DSQLITE_DEBUG=1 -DWIN32=1 -DTHREADSAFE=1 -DSQLITE_OS_WIN=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_SOUNDEX=1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -I. shell.c sqlite3.c -o sqlite3.exe echo sqlite3.exe build finished ...... cl /nologo /MLd /W3 /Gm /GX /ZI /Od /D "WIN32" /D "_DEBUG" /D "_WINDOWS" /D "_MBCS" /D "_USRDLL" /D "SQLITE3_EXPORTS" /D THREADSAFE=1 /D SQLITE_OS_WIN=1 /D SQLITE_ENABLE_COLUMN_METADATA=1 /D SQLITE_SOUNDEX=1 /D QLITE_OMIT_LOAD_EXTENSION=1 /D SQLITE_ENABLE_RTREE=1 /YX /Fp"sqlite3.pch" /FD /GZ /c /debug sqlite3.c rem lib -out:"sqlite3.lib" sqlite3.obj link.exe kernel32.lib user32.lib /nologo /dll /incremental:yes /debug /machine:I386 /pdb:"sqlite3.pdb" /def:"sqlite3.def" /out:"sqlite3.dll" /implib:"sqlite3.lib" /pdbtype:sept sqlite3.obj echo sqlite3.dll build finished ...... echo end building sqlite-amalgamation-%version% echo ----------------------------------------------- cd /d .. :EOF @echo on
以下是我的执行结果:
引用
fetching sqlite-amalgamation-3070800.zip ...
--2011-09-20 08:48:30-- http://www.sqlite.org/sqlite-amalgamation-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1329197 (1.3M) [application/zip]
Saving to: `sqlite-amalgamation-3070800.zip'
100%[==========================================================>] 1,329,197 119K/s in 11s
2011-09-20 08:48:41 (120 KB/s) - `sqlite-amalgamation-3070800.zip' saved [1329197/1329197]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-amalgamation-3070800.zip
Extracting sqlite-amalgamation-3070800
Extracting sqlite-amalgamation-3070800\shell.c
Extracting sqlite-amalgamation-3070800\sqlite3.c
Extracting sqlite-amalgamation-3070800\sqlite3.h
Extracting sqlite-amalgamation-3070800\sqlite3ext.h
Everything is Ok
Folders: 1
Files: 4
Size: 5059684
Compressed: 1329197
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\shell.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.h
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3ext.h
fetching sqlitedll-3070800.zip ...
--2011-09-20 08:48:46-- http://www.sqlite.org/sqlitedll-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2011-09-20 08:48:47 ERROR 404: Not Found.
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Error:
cannot find archive
The system cannot find the path specified.
The system cannot find the file specified.
try another dll zip
fetching sqlite-dll-win32-x86-3070800.zip ...
--2011-09-20 08:48:47-- http://www.sqlite.org/sqlite-dll-win32-x86-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 289182 (282K) [application/zip]
Saving to: `sqlite-dll-win32-x86-3070800.zip'
100%[==========================================================>] 289,182 127K/s in 2.2s
2011-09-20 08:48:51 (127 KB/s) - `sqlite-dll-win32-x86-3070800.zip' saved [289182/289182]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-dll-win32-x86-3070800.zip
Extracting sqlite3.def
Extracting sqlite3.dll
Everything is Ok
Files: 2
Size: 575107
Compressed: 289182
1 file(s) copied.
begin building sqlite-amalgamation-3070800
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'o' has been deprecated and will be removed in a future release
shell.c
sqlite3.c
Generating Code...
sqlite3.exe build finished ......
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'GZ' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'RTC1' instead of 'GZ'
cl : Command line warning D9002 : ignoring unknown option '/MLd'
cl : Command line warning D9002 : ignoring unknown option '/YX'
cl : Command line warning D9002 : ignoring unknown option '/debug'
sqlite3.c
LINK : warning LNK4044: unrecognized option '/pdbtype:sept'; ignored
LINK : sqlite3.dll not found or not built by the last incremental link; performing full link
Creating library sqlite3.lib and object sqlite3.exp
sqlite3.dll build finished ......
end building sqlite-amalgamation-3070800
-----------------------------------------------
--2011-09-20 08:48:30-- http://www.sqlite.org/sqlite-amalgamation-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1329197 (1.3M) [application/zip]
Saving to: `sqlite-amalgamation-3070800.zip'
100%[==========================================================>] 1,329,197 119K/s in 11s
2011-09-20 08:48:41 (120 KB/s) - `sqlite-amalgamation-3070800.zip' saved [1329197/1329197]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-amalgamation-3070800.zip
Extracting sqlite-amalgamation-3070800
Extracting sqlite-amalgamation-3070800\shell.c
Extracting sqlite-amalgamation-3070800\sqlite3.c
Extracting sqlite-amalgamation-3070800\sqlite3.h
Extracting sqlite-amalgamation-3070800\sqlite3ext.h
Everything is Ok
Folders: 1
Files: 4
Size: 5059684
Compressed: 1329197
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\shell.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.h
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3ext.h
fetching sqlitedll-3070800.zip ...
--2011-09-20 08:48:46-- http://www.sqlite.org/sqlitedll-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2011-09-20 08:48:47 ERROR 404: Not Found.
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Error:
cannot find archive
The system cannot find the path specified.
The system cannot find the file specified.
try another dll zip
fetching sqlite-dll-win32-x86-3070800.zip ...
--2011-09-20 08:48:47-- http://www.sqlite.org/sqlite-dll-win32-x86-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 289182 (282K) [application/zip]
Saving to: `sqlite-dll-win32-x86-3070800.zip'
100%[==========================================================>] 289,182 127K/s in 2.2s
2011-09-20 08:48:51 (127 KB/s) - `sqlite-dll-win32-x86-3070800.zip' saved [289182/289182]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-dll-win32-x86-3070800.zip
Extracting sqlite3.def
Extracting sqlite3.dll
Everything is Ok
Files: 2
Size: 575107
Compressed: 289182
1 file(s) copied.
begin building sqlite-amalgamation-3070800
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'o' has been deprecated and will be removed in a future release
shell.c
sqlite3.c
Generating Code...
sqlite3.exe build finished ......
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'GZ' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'RTC1' instead of 'GZ'
cl : Command line warning D9002 : ignoring unknown option '/MLd'
cl : Command line warning D9002 : ignoring unknown option '/YX'
cl : Command line warning D9002 : ignoring unknown option '/debug'
sqlite3.c
LINK : warning LNK4044: unrecognized option '/pdbtype:sept'; ignored
LINK : sqlite3.dll not found or not built by the last incremental link; performing full link
Creating library sqlite3.lib and object sqlite3.exp
sqlite3.dll build finished ......
end building sqlite-amalgamation-3070800
-----------------------------------------------
发表评论
-
发布异种数据库导入工具jmyetl-1.0.2
2012-06-11 05:14 1727利用空闲时间,折腾了一个,界面不太擅长,比较简陋,但是相信大家 ... -
各种数据库临时表的使用区别总结
2012-05-24 08:22 2448[size=large]虽然SQL92, 99, 2003, ... -
再谈DOS批处理下格式化日期字符串的方法(详解)
2012-03-31 19:46 1779谈到日期字符串的输出 ... -
常用的数据库连接串(JDBC篇)
2011-12-23 06:58 0看到网上传来传去的jdbc url连接串总结,好多都是粘来粘去 ... -
也谈谈网上注册用户的密码设置问题
2011-12-22 11:16 1815看到首页上的" 关于 ... -
SQLite Blob读写的局限性
2011-11-25 13:28 3758在使用SQLite在Windows Mobile上的大容量BL ... -
windows平台下文本编辑器使用体会与总结
2011-10-29 20:14 1622自工作以来,用过许多 ... -
SQLite指南(6)-处理database is locked的方法
2011-10-29 13:18 4260解决方法有: 1。使用进程或线程间的同步机制以避免同时操作;如 ... -
7zip命令行用法
2011-10-14 10:54 38077zip功能很强大,你只要两个文件: 7z.exe以及7z.d ... -
SQLite指南(5) - PRAGMA命令用法(完整)
2011-10-11 14:55 22903如若转载,请加上本文 ... -
"乔帮主“真正的离开了
2011-10-07 20:39 937Steve Jobs (1955.2.24-2011.10.6 ... -
格式化DOS下时间输出
2011-09-29 09:16 1613dos下由于时间格式不同,使用的echo时间的形式也可能不同, ... -
SQLite指南(4) - FAQ列表(important)
2011-09-30 07:53 3502如若转载,请加上本文链接,以示尊重个人劳动,谢谢。 本文严格 ... -
SQLite指南(4) - 最新SQLite FAQ列表
2011-09-28 07:30 1如若转载,请带上本文链接,以示尊重个人劳动。 -
SQLite指南(3) - 5分钟了解熟悉SQLite
2011-09-28 07:18 1791在没有大量阅读SQLite在线文档并且不了解相关配置之前,几分 ... -
SQLite指南(2) -- 帮助及编译SQLite
2011-09-27 14:04 1762关于SQLite的帮助,直接上http://www.sqlit ... -
SQLite指南(1) -- SQLite的特性
2011-09-27 13:34 1959使用SQLite也有一段时日 ... -
DBeaver数据库管理工具连接Sybase数据库使用体验
2011-09-26 20:12 7248从http://dbeaver.jkiss.org/下 ... -
看来nodejs要火了
2011-09-25 07:03 1198有幸从http://nodejs.org下了一份nodejs, ... -
为Sybase ASE15.x编译安装python-sybase模块
2011-09-21 23:07 1497如果你有陈旧的vs2003编译器,那么这篇短文或者意义不是很大 ...
相关推荐
除了基本的连接功能,SQLiteJDBC驱动还支持预编译的SQL语句(PreparedStatement)、批处理操作、存储过程调用等高级特性。由于SQLite本身对SQL标准的支持程度很高,因此使用SQLiteJDBC驱动可以实现大部分常见的...
4. Mingw-32/64:MinGW(Minimalist GNU for Windows)是一个可自由使用且开放源代码的软件开发工具包,它包含了GCC(GNU Compiler Collection)等工具,可以用来编译Windows下的32位和64位程序。 编译步骤如下: ...
7. 自动化脚本:支持创建和执行批处理脚本,方便批量操作。 使用这个工具,Delphi开发者能够更高效地管理SQLite数据库,无论是进行简单的数据查询还是复杂的数据库维护任务,都能得心应手。同时,由于它集成在...
1. **build.bat**:这是一个批处理脚本,通常用于Windows环境下的构建过程。它可能包含了编译和链接SQLite源代码的命令,通过调用编译器如MSVC或MinGW来创建可执行文件或者动态/静态库。 2. **FindSQLiteCpp.cmake*...
在Windows平台上,构建带有加密支持的SQLite3可能会涉及到复杂的编译过程,但SQLite3-Encryption项目提供了一种简化的方法,使得这一过程变得快速且简单,无论是通过DLL、静态库(SLL)还是Shell脚本。 本文将深入...
本项目是一款基于Python的Excel数据指标分析折线图设计源码,整合了102个文件,涵盖28个JavaScript脚本、21个CSS样式表、13个Python源代码文件、13个Python编译文件、5个PNG图像文件、5个HTML文档、4个JavaScript...
本篇文章将深入探讨SQLite3的使用大全,包括如何操作SQLite3数据库、如何使用sqlite3.dll动态链接库、如何注册bat脚本以及如何配置ODBC驱动。 首先,我们来看看SQLite3的基本操作。SQLite3支持SQL标准,包括创建...
在Java编程环境中,SQLite是一个轻量级的、开源的关系型数据库管理系统,常用于小型应用程序或嵌入式系统中。SQLite不依赖任何服务器进程,而是直接将数据存储在文件中,因此它非常适合移动设备和资源有限的环境。...
### SQLite+中文帮助知识点梳理 #### 一、SQLite简介与应用...通过上述知识点的学习,读者能够对SQLite有一个全面而深入的理解,并掌握其基本使用方法及高级功能,为进一步开发基于SQLite的应用程序打下坚实的基础。
4. 编译脚本:用于构建和安装加密插件的批处理或shell脚本。 5. 示例程序:演示如何在QT应用中使用这个加密库的示例代码。 使用这个编译后的库,开发者可以按照以下步骤操作: 1. 将库文件添加到QT项目的依赖项中。...
6. **批处理操作**:如果需要一次性执行多个SQL语句,封装类可能会提供`executeBatch()`方法,方便批量插入或更新。 7. **异常处理**:为了保证健壮性,封装类应该妥善处理各种可能抛出的异常,比如`SQLException`...
SQLite CE(Compact Edition)是SQLite数据库引擎的一个轻量级版本,专为嵌入式设备和移动平台设计,如Windows CE。这个压缩包包含的是SQLite CE的源码,这对于开发者来说非常有价值,因为你可以深入理解其内部工作...
- **构建脚本**:可能包含用于编译和打包库的批处理文件或 Makefile,方便开发者自行编译或定制版本。 在实际开发中,使用 SqlCipher 的步骤通常如下: 1. **安装**:将 SqlCipher 库文件添加到项目中,确保运行...
ReflectorCmd.exe则是命令行版本的Reflector,适用于自动化脚本和批处理操作。 总的来说,Reflector是一款强大且全面的.NET反编译工具,它不仅提供了反编译功能,还集成了多种实用工具,以满足不同开发者的需求。在...
标题 "php-8.3.8-Win32-vs16-x64" 指的是 PHP(一种广泛使用的开源服务器端脚本语言)的版本 8.3.8,适用于 Windows 操作系统,该版本是针对 x64 架构编译的,并且使用了 Visual Studio 2019 (VS16) 的编译器进行...
1. **phar.phar.bat**:这是一个批处理文件,用于执行PHP的PHAR(PHP Archive)工具。PHAR是一种将多个PHP文件打包成单一可执行文件的方式,方便分发和部署。 2. **icudt70.dll**、**icuin70.dll**、**icuuc70.dll*...
首先,"Win32-vc15-x64"这部分信息表明该版本是用Visual C++ 2017(即VC15)编译器编译的,且适用于64位Windows操作系统。"Thread Safe"表示这是线程安全的版本,这意味着它在多线程环境中能保证数据的安全性,避免...
7. 构建脚本:为了自动化编译和打包过程,可能包含批处理脚本或shell脚本,用户只需运行这些脚本即可完成整个流程。 使用这个数据库CHM文档生成工具,开发者和文档撰写者可以方便地从数据库中提取结构信息,如表...
1. `phar.phar.bat`:这是一个批处理文件,用于执行PHP的PHAR(PHP档案)格式,它允许将多个PHP文件打包成一个单一的可执行文件。 2. `icudt65.dll`、`icuin65.dll`、`icuuc65.dll`:这些是国际部件库(ICU)的动态...
标题 "php8.1.27源码包(windows)" 提供了我们即将讨论的核心信息:这是PHP编程语言的一个特定版本(8.1.27)的源代码包,适用于Windows操作系统。源代码包通常包含了编译和构建PHP运行环境所需的所有文件,允许...