if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
	select * from sqlite_master;echo "数据库连接成功！";
} else {
	die($sqliteerror);
}

if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
	$result = sqlite_array_query($db, 'select * from sqlite_master;');
	foreach ($result as $entry) {
		echo 'talbe name='.$entry['name']."n";
		echo 'sql='.$entry['sql']."n";
		echo "--------------------------------------------------------------------------------";
	sqlite_close($db);
} else {
	die($sqliteerror);
}

if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
	$result = sqlite_array_query($db, 'select name, email from user ', SQLITE_ASSOC);
	echo "user表查询结果:n";echo " n name emailn";
	foreach ($result as $entry) {
		echo ' '.$entry['name']." " $entry['email']."n";
	echo ' ';sqlite_close($db);
} else {
	die($sqliteerror);
}

sqlite_query($db, "INSERT INTO user VALUES('user".$i."'" ",'user".$i."@ hichina. com')");
sqlite_query($db, "delete from user where user=’user99’");
sqlite_query($db, 'UPDATE user SET email="lilz@ hichina .com" where name="user1"');

Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:filename");//filename为你的SQLite数据名称
// ... use the database ...
conn.close();

import java.sql.*;
import org.sqlite.JDBC;
/** 这是个非常简单的SQLite的Java程序，
 * 程序中创建数据库、创建表、然后插入数据，
 * 最后读出数据显示出来*/
public class TestSQLite{
  public static void main(String[] args){
      //连接SQLite的JDBC
      Class.forName("org.sqlite.JDBC");
      //建立一个数据库名zieckey.db的连接，如果不存在就在当前目录下创建之
      Connection conn =DriverManager.getConnection("jdbc:sqlite:zieckey.db");
      Statement stat = conn.createStatement();
      stat.executeUpdate("create table tbl1(name varchar(20), salary int);");//创建一个表，两列
      stat.executeUpdate("insert into tbl1values('ZhangSan',8000);");//插入数据
      stat.executeUpdate("insert into tbl1values('LiSi',7800);");
      stat.executeUpdate("insert into tbl1values('WangWu',5800);");
      stat.executeUpdate("insert into tbl1values('ZhaoLiu',9100);");
      ResultSet rs = stat.executeQuery("select * from tbl1;");//查询数据
      while(rs.next()){//将查询到的数据打印出来
        System.out.print("name = "+ rs.getString("name")+" ");//列属性一
        System.out.println("salary = "+ rs.getString("salary"));//列属性二
      rs.close();
      conn.close();//结束数据库的连接
    }catch(Exception e ){
      e.printStackTrace();

E:\Coding\java\test>javac TestSQLite.java
# 编译运行：
E:\Coding\java\test>java TestSQLite
name = ZhangSan salary = 8000
name = LiSi     salary = 7800
name = WangWu   salary = 5800
name = ZhaoLiu  salary = 9100

string datasource = "e:/tmp/test.db";
System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
//连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;connstr.Password = "admin";//设置密码，SQLite ADO.NET实现了数据库密码保护
conn.ConnectionString = connstr.ToString();conn.Open();
//创建表
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
string sql = "CREATE TABLE test(username varchar(20),password varchar(20))";
cmd.CommandText = sql;
cmd.Connection = conn;cmd.ExecuteNonQuery();
//插入数据
sql = "INSERT INTO test VALUES('a','b')";
cmd.CommandText = sql;cmd.ExecuteNonQuery();
//取出数据
sql = "SELECT * FROM test";
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (reader.Read()){
  sb.Append("username:").Append(reader.GetString(0)).Append("\n").Append("password:").Append(reader.GetString(1));
MessageBox.Show(sb.ToString());

#include <stdio.h> 
#include "sqlite3.h"
int main( void ){
  sqlite3 *db = NULL;
  char *zErrMsg = 0;
  int rc;
  //打开指定的数据库文件,如果不存在将创建一个同名的数据库文件
  rc = sqlite3_open("zieckey.db", &db);
  if( rc ){
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    exit(1);
  }else 
    printf("You have opened a sqlite3 database"
           " named zieckey.db successfully!\n"
           "Congratulations! Have fun ! ^-^ \n");
  sqlite3_close(db); //关闭数据库
  return 0;
}

[root@localhost temp]# gcc opendbsqlite.c -o db.out
opendbsqlite.c:11:21: sqlite3.h: 没有那个文件或目录
opendbsqlite.c: In function `main':
opendbsqlite.c:19: `sqlite3' undeclared (first use in this function)
opendbsqlite.c:19: (Each undeclared identifier is reported only once
opendbsqlite.c:19: for each function it appears in.)
opendbsqlite.c:19: `db' undeclared (first use in this function)

[root@localhost temp]# gcc opendbsqlite.c -o db.out
/tmp/ccTkItnN.o(.text+0x2b): In function `main':
: undefined reference to `sqlite3_open'
/tmp/ccTkItnN.o(.text+0x45): In function `main':
: undefined reference to `sqlite3_errmsg'
/tmp/ccTkItnN.o(.text+0x67): In function `main':
: undefined reference to `sqlite3_close'
/tmp/ccTkItnN.o(.text+0x8f): In function `main':
: undefined reference to `sqlite3_close'
collect2: ld returned 1 exit status