Java操作SQLite数据库-马育民老师

```
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)
  {
	Connection connection = null;
	try
	{
	  Class.forName("org.sqlite.JDBC");
	  // 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.getMessage());
	  }
	}
  }
}
```

原文出处：/show_1IX6d1qpImZ3.html