Question

SQLite插入数据

添加数据的服务代码是这么写的
/**
* 添加记录
* @param person
*/
public void sava(Person person){
SQLiteDatabase db=dbOpenHelper.getWritableDatabase();
db.execSQL("insert into person(name,phone)values(?,?)",
new Object[]{person.getName(),person.getPhone()});
db.close();
}
那这里要插入数据代码该怎么写？

protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_xq1);
listView=(ListView) findViewById(R.id.listView);
mgr=new PersonService(this);
}
public void save(Person person){
//插入数据的代码

}

Answer 1

/**
* 注释部分就有插入的操作
*/
package sqlIte;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
* @author Administrator
*
*/
public class Test {

/**
* @author : haoming
* @date : 2012-11-28上午10:02:36
* @111 sqlIte.SqlIteTest.java.main
* @returnType : void
* @desc :
*/
public static void main(String[] args) {
Connection conn = null;
Statement stat = null;
ResultSet rs=null;
try {
Class.forName("org.sqlite.JDBC");
conn = DriverManager.getConnection("jdbc:sqlite:test.db");
conn.setAutoCommit(false);
stat = conn.createStatement();
// stat.executeUpdate("create table people (name, occupation);");
// stat.executeUpdate("insert into people values ('Gandhi', 'politics');");
// stat.executeUpdate("insert into people values ('Turing', 'computers');");
// stat.executeUpdate("insert into people values ('Wittgenstein', 'smartypants');");
conn.commit();
rs = stat.executeQuery("pragma table_info(people)");
while(rs.next()){
System.out.println(rs.getString("cid")+"~"+rs.getString("name")+"~"+rs.getString("type")+"~"+rs.getString("notnull")+"~"+rs.getString("dflt_value")+"~"+rs.getString("pk"));
}
rs = stat.executeQuery("select * from people;");
while (rs.next()) {
System.out.println("name = " + rs.getString("name"));
System.out.println("occupation = " + rs.getString("occupation"));
}
rs.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}