Java--SQLite 查询 select 查询结果

首先下载Sqlite JDBC驱动程序

网站

https://bitbucket.org/xerial/sqlite-jdbc/downloads/

添加到java 工程lib 库里

package SqliteJDBC;

import java.sql.*;


public class SqliteJDBC {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
	    Connection c = null;
	    try {
	      Class.forName("org.sqlite.JDBC");
	      c = DriverManager.getConnection("jdbc:sqlite:test.db");
	      Statement stmt = null;
	      c.setAutoCommit(false);
	      
	      stmt = c.createStatement();
	      ResultSet rs = stmt.executeQuery( "SELECT * FROM mytable;" );
	      while ( rs.next() ) {
	         int id = rs.getInt("id");
	         String  name = rs.getString("name");
	         int age  = rs.getInt("age");

	         System.out.println( "ID = " + id );
	         System.out.println( "NAME