[Mobile GIS] Using SQLite (1)

First paste the introduction of Baidu Encyclopedia:

SQLite is a lightweight database and a relational database management system that complies with acid [1]. It is contained in a relatively small C library, unlike common customer-Server Examples, the SQLite engine is not an independent process for the program to communicate with, but a major part of the program. Therefore, the main communication protocol is direct API calls in programming languages. This plays a positive role in total consumption, latency, and overall simplicity. The entire database (definition, table, index, and data itself) is stored in a single file on the host. Its simple design is completed by locking the entire data file at the beginning of a transaction.

In the end, SQLite databases are characterized:

1. Small. It not only occupies a small amount of space, but also has high efficiency and small memory usage.

2. Convenient. SQLite data is generated as a single file. This file contains everything in the database. You can copy everything from a USB flash drive.

3. cross-platform. Because it is written in C and open-source, all windows Linux MACOs and other operating systems are supported.

4. Common SQL statements are supported. If you have used MySQL sqlserver or Oracle, it is very easy to use SQLite. It supports some basic SQL statements and transactions.

5. No security authentication is available. After sqltite generates a database file, anyone can view the table information in it. It does not need to enter the user name or password. This is a disadvantage and advantage. It is inconvenient if too much verification is done.

 

How can I download SQLite JDBC for common Java operations? After reading the following example, you will understand:

 

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Sample{  public static void main(String[] args) throws ClassNotFoundException  {    // load the sqlite-JDBC driver using the current class loader    Class.forName("org.sqlite.JDBC");    Connection connection = null;    try    {      // create a database connection      connection = DriverManager.getConnection("jdbc:sqlite:sample.db");      Statement statement = connection.createStatement();      statement.setQueryTimeout(30);  // set timeout to 30 sec.      statement.executeUpdate("drop table if exists person");      statement.executeUpdate("create table person (id integer, name string)");      statement.executeUpdate("insert into person values(1, 'leo')");      statement.executeUpdate("insert into person values(2, 'yui')");      ResultSet rs = statement.executeQuery("select * from person");      while(rs.next())      {        // read the result set        System.out.println("name = " + rs.getString("name"));        System.out.println("id = " + rs.getInt("id"));      }    }    catch(SQLException e)    {      // if the error message is "out of memory",       // it probably means no database file is found      System.err.println(e.getMessage());    }    finally    {      try      {        if(connection != null)          connection.close();      }      catch(SQLException e)      {        // connection close failed.        System.err.println(e);      }    }  }}