java程序可视化数据库_java – 可视化sqlite数据库schemaspy

我想要可视化sqlite数据库.有几页讨论这个,但这些解决方案都没有为我工作

Good tool to visualize database schema或

easy visualisation using sqlfairy或

SchemaDisplay.似乎问题出在SQLite.JDBCDriver上.这是关于

java and sqlite的讨论,但我无法弄清楚.我所做的是将sqlite-jdbc-3.7.2.jar重命名为sqlite.jar,希望这有所帮助,但你可以看到运气不好.

[pista@HP-PC schemaspy]$ls -l

total 7084

drwxrwxr-x 3 pista pista 4096 Dec 12 22:34 javasqlite

drwxrwxr-x 2 pista pista 4096 Dec 12 22:05 lib

drwxrwxr-x 14 pista pista 4096 Dec 12 22:15 mendeley

drwxrwxr-x 2 pista pista 4096 Dec 12 22:13 out

drwxrwxr-x 2 pista pista 4096 Dec 12 22:05 properties

-rw-rw-r-- 1 pista pista 2655 Feb 22 2009 README.TXT

-rw-rw-r-- 1 pista pista 248945 Aug 16 2010 schemaSpy_5.0.0.jar

-rw-rw-r-- 1 pista pista 161441 Dec 12 22:04 schemaSpyGUI20090302.zip

-rw-rw-r-- 1 pista pista 26 Nov 4 2007 schemaSpyGUI.bat

-rw-rw-r-- 1 pista pista 102299 Mar 2 2009 schemaSpyGUI.jar

-rw-rw-r-- 1 pista pista 86 Nov 18 2007 schemaSpyGUI.sh

-rw-rw-r-- 1 pista pista 284954 Dec 12 22:25 sqlite-dll-win32-x86-3070701.zip

-rw-rw-r-- 1 pista pista 3201128 Dec 12 22:28 sqlite.jar

-rw-rw-r-- 1 pista pista 3201128 Aug 27 2010 sqlite-jdbc-3.7.2.jar

drwxrwxr-x 3 pista pista 4096 Dec 12 22:05 src

drwxrwxr-x 2 pista pista 4096 Dec 12 22:31 xerial

drwxrwxr-x 7 pista pista 4096 Dec 12 22:31 xerial-sqlite-jdbc-e0fd4e05a97e

[pista@HP-PC schemaspy]$java -jar schemaSpy_5.0.0.jar -t sqlite -u pista -o out/ -db mendeley/[e-mail]@www.mendeley.com.sqlite

Using database properties:

[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/sqlite.properties

java.lang.ClassNotFoundException: SQLite.JDBCDriver

Failed to load driver 'SQLite.JDBCDriver'from: [file:/home/pista/schemaspy/sqlite.jar]

Use the -dp option to specify the location of the database

drivers for your database (usually in a .jar or .zip/.Z).

我做错了,这是一个好方法吗？