sqlite JAVA DEMO

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 block
			e.printStackTrace();
		}
   }

}