/* import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
//import SQLite.JDBCDriver;
//import org.sqlite.SQLiteConfig; */

import java.sql.*;

/* Possible format for JDBC SQLite Server URL:

     jdbc:sqlite://dirA/dirB/dbfile
     jdbc:sqlite:/DRIVE:/dirA/dirB/dbfile
     jdbc:sqlite:///COMPUTERNAME/shareA/dirB/dbfile */

public class jsqlite
{
     public void showData(Connection conn) throws Exception
     {
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from users");
      while(rs.next()) {
       int id = rs.getInt(1);
       //String id = rs.getString(1);
       String name = rs.getString(2);
       System.out.printf("rec(%d) = %s\n", id, name);
      }
     }
         
     public static void main(String[] args) throws Exception
     {
      try {
       //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       //Class.forName("SQLite.JDBCDriver");
       Class.forName("org.sqlite.JDBC");     

//   String url="jdbc:sqlite://home/pasquale/test.db";       
       String url = "jdbc:sqlite:test.db";      
     //  String url = "jdbc:msql://200.210.220.1:1114/Demo";

       //  Connection conn = DriverManager.getConnection(url, user, password);
     //  Connection conn = DriverManager.getConnection("test.db");
//   Connection conn = DriverManager.getConnection(url);
       Connection conn = DriverManager.getConnection(url, "test", "test");
           
       Statement stmt = conn.createStatement();
       ResultSet rs = stmt.executeQuery("select * from users where name='name'");
       while(rs.next()) {
        int id = rs.getInt(1);
        //String id = rs.getString(1);
        String name = rs.getString(2);
        System.out.printf("rec(%d) = %s\n", id, name);
       }
           
       int result = stmt.executeUpdate("update users set name='Name' where id='1'");
       if(result == 1)
        System.out.println("value updated");
       else
        System.out.println("value NOT updated");
           
       int idvalue = 2;
       String namevalue = "NamE";
       // insert into users (id, name) values(1,'test');"
       PreparedStatement stmnt = conn.prepareStatement("insert into users(id, name) values(?,?)");
       stmnt.setInt(1, idvalue);
       stmnt.setString(2, namevalue);
       stmnt.executeUpdate();
         
       CallableStatement cs = conn.prepareCall("{ call ListAllUsers }");
       rs = cs.executeQuery();
           
       conn.close();
          
      } catch (Exception e) {
           
                System.err.println("Got an exception! ");     
                System.err.println(e.getMessage());     
            }     

     }

/*    // v2
     public static void main(String[] args) throws Exception
     {
      Connection conn = null;
      SQLite.Database db = null;
      try {
       Class.forName("SQLite.JDBCDriver").newInstance();
       conn = DriverManager.getConnection("jdbc:sqlite:/blabla");
       java.lang.reflect.Method m =
        conn.getClass().getMethod("getSQLiteDatabase", null);
       db = (SQLite.Database) m.invoke(conn, null);
      } catch (Exception e) {
      }
     } */

}

/*  public class jsqlite {
     public static void main(String[] args) throws Exception {
          Class.forName("org.sqlite.JDBC");
          Connection conn =
            DriverManager.getConnection("jdbc:sqlite:test.db");
          Statement stat = conn.createStatement();
          stat.executeUpdate("drop table if exists people;");
          stat.executeUpdate("create table people (name, occupation);");
          PreparedStatement prep = conn.prepareStatement(
            "insert into people values (?, ?);");

          prep.setString(1, "Gandhi");
          prep.setString(2, "politics");
          prep.addBatch();
          prep.setString(1, "Turing");
          prep.setString(2, "computers");
          prep.addBatch();
          prep.setString(1, "Wittgenstein");
          prep.setString(2, "smartypants");
          prep.addBatch();

          conn.setAutoCommit(false);
          prep.executeBatch();
          conn.setAutoCommit(true);

          ResultSet rs = stat.executeQuery("select * from people;");
          while (rs.next()) {
            System.out.println("name = " + rs.getString("name"));
            System.out.println("job = " + rs.getString("occupation"));
          }
          rs.close();
          conn.close();
     }

} // */