求助：SQLite数据库插入数据该怎么 *** 作

将请求头名称映射到一个数值数组（通过调用
servletrequestgetheaders(string)
获得）。它与头隐式对象非常类似。
表达式
${headervalues
name}
相当于
requestgetheadervalues(name)。

/
注释部分就有插入的 *** 作
/
package sqlIte;
import javasqlConnection;
import javasqlDriverManager;
import javasqlResultSet;
import javasqlSQLException;
import javasqlStatement;
/
@author Administrator

/
public class Test {
/
@author : haoming
@date : 2012-11-28上午10:02:36
@111 sqlIteSqlIteTestjavamain
@returnType : void
@desc :
/
public static void main(String[] args) {
Connection conn = null;
Statement stat = null;
ResultSet rs=null;
try {
ClassforName("orgsqliteJDBC");
conn = DriverManagergetConnection("jdbc:sqlite:testdb");
connsetAutoCommit(false);
stat = conncreateStatement();
// statexecuteUpdate("create table people (name, occupation);");
// statexecuteUpdate("insert into people values ('Gandhi', 'politics');");
// statexecuteUpdate("insert into people values ('Turing', 'computers');");
// statexecuteUpdate("insert into people values ('Wittgenstein', 'smartypants');");
conncommit();
rs = statexecuteQuery("pragma table_info(people)");
while(rsnext()){
Systemoutprintln(rsgetString("cid")+"~"+rsgetString("name")+"~"+rsgetString("type")+"~"+rsgetString("notnull")+"~"+rsgetString("dflt_value")+"~"+rsgetString("pk"));
}
rs = statexecuteQuery("select from people;");
while (rsnext()) {
Systemoutprintln("name = " + rsgetString("name"));
Systemoutprintln("occupation = " + rsgetString("occupation"));
}
rsclose();
connclose();
} catch (ClassNotFoundException e) {
eprintStackTrace();
} catch (SQLException e) {
eprintStackTrace();
}
}
}

---