import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;  
  
public class SqliteTest {  
    public static void main(String[] args) {  
        Connection conn = null;  
        try {  
            Class.forName("org.sqlite.JDBC");  
            conn = DriverManager.getConnection("jdbc:sqlite:mydb.db");  
            Statement stmt = conn.createStatement();  
            ResultSet rs = stmt.executeQuery("select * from aa");  
            while(rs.next()){  
                String id = rs.getString(1);  
                System.out.println("用户名:" + id );  
            }  
            rs.close();  
            stmt.close();  
            conn.close();  
        } catch (ClassNotFoundException e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        } catch (SQLException e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        }  
    }  
}