在Java下连接SQLite数据库.doc

在Java下连接SQLite数据库 一、下载SQLite数据库的JDBC：/sqlitejdbc/ 二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下，并且将其添加到ClassPath系统环境变量中。一定要保证在类路径ClassPath中有该jar包，并且保证在JAVA库路径JAVA Library Path中有本地库Native Library（\workspace\Web应用\WebRoot\WEB-INF\lib\下最好也要加入该jar包）。SQLite.JDBCDriver作为JDBC的驱动程序类名。连接JDBC的URL格式为jdbc:sqlite:/path。这里的path为指定到SQLite数据库文件的路径，例如： jdbc:sqlite://dirA/dirB/dbfile jdbc:sqlite://DRIVE:/dirA/dirB/dbfile jdbc:sqlite://COMPUTERNAME/shareA/dirB/dbfile 三、下面是使用SQLite的两段代码以供参考： 代码段1： ?1?import?java.sql.*;?2?import?org.sqlite.JDBC;?3??4?public?class?SQLiteTest? ?5 public?static?void?main String[]?args 6 try? ?7 //?The?SQLite? 3.3.8 ?Database?File?8 //?This?database?has?one?table? pmp_countries ?with?3?columns? country_id,?country_code,?country_name ?9 //?It?has?like?237?records?of?all?the?countries?I?could?think?of.10 String?fileName? ?c:/pmp.db;11 //?Driver?to?Use12 //?/sqlitejdbc/index.html13 Class.forName org.sqlite.JDBC ;14 //?Create?Connection?Object?to?SQLite?Database15 //?If?you?want?to?only?create?a?database?in?memory,?exclude?the?+fileName16 Connection?conn? ?DriverManager.getConnection jdbc:sqlite:+fileName ;17 //?Create?a?Statement?object?for?the?database?connection,?dunno?what?this?stuff?does?though.18 Statement?stmt? ?conn.createStatement ;19 //?Create?a?result?set?object?for?the?statement20 ResultSet?rs? ?stmt.executeQuery SELECT?*?FROM?pmp_countries?ORDER?BY?country_name?ASC ;21 //?Iterate?the?result?set,?printing?each?column22 //?if?the?column?was?an?int,?we?could?do?rs.getInt column?name?here ?as?well,?etc.23 while? rs.next 24 String?id rs.getString country_id ;???//?Column?125 String?code? ?rs.getString country_code ;?//?Column?226 String?name? ?rs.getString country_name ;?//?Column?327 System.out.println ID:?+id+?Code:?+code+?Name:?+name ;28?29 30 //?Close?the?connection31 conn.close ;32 33 catch? Exception?e ? 34 //?Print?some?generic?debug?info35 System.out.println e.getMessage ;36 System.out.println e.toString ;37 38 39?