sqlite JAVA DEMO

zhiming_817

JDBC驱动下载地址：http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056.jar
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/** * sqlite 测试程序 * **/public class SqliteTest {/** * @param args */public static void main(String[] args) {Connection conn=null;try {Class.forName("org.sqlite.JDBC");//conn = DriverManager.getConnection("jdbc:sqlite:"+fileName);conn = DriverManager.getConnection("jdbc:sqlite:D:/hello.db");Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM user");while (rs.next()) {            String id   = rs.getString(1);               String code = rs.getString(2);             System.out.println("用户名: "+id+" 密码: "+code);        }conn.close();} catch (SQLException e) {}catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}   }}