SQLite

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){ try{ //连接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