package com.example.liusipeng20220606;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
public class MainActivity extends Activity {
private SQLiteDatabase db= null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
try {
db=SQLiteDatabase.
openOrCreateDatabase("/mnt/sdcard/stu0.db", null);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
createTable(db);
insert(db,"zx","01");
insert(db,"cc","02");
insert1(db,"dd","03");
insert1(db,"ee","04");
Log.i("aa","bb");
query(db);
// Log.i("aaa",bbbbb");
// delete(db,"01");
// delete(db,"02");
// query(db);
update(db,"01","001");
Log.i("aaa","bbbbb");
query(db);
}
private void insert(SQLiteDatabase db, String sname, String snumber) {
// 实例化常用值
ContentValues cValue =new ContentValues();
//添加用户名
cValue.put("sname",sname);
//添加密码
cValue.put("snumber",snumber);
//调用insert()方法插入数据
db.insert("usertable", null, cValue);
}
private void insert1(SQLiteDatabase db, String sname ,String snumber) {
// TODO Auto-generated method stub
String sql="insert into usertable(sname,snumber) values('"+sname+"','"+snumber+"')";
db.execSQL(sql);
}
private void query(SQLiteDatabase db) {
// TODO Auto-generated method stub
Cursor cursor=db.query(false, "usertable",new String[]{"_id","sname","snumber"
}, null, null, null, null, null, null);
if(cursor.moveToFirst()){
for(int i=0;i<cursor.getColumnCount();i++){
int id =cursor.getInt(0);
String sname =cursor.getString(1);
String snumber =cursor.getString(2);
Logpackage com.example.liusipeng20220606;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
public class MainActivity extends Activity {
private SQLiteDatabase db= null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
try {
db=SQLiteDatabase.
openOrCreateDatabase("/mnt/sdcard/stu0.db", null);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
createTable(db);
insert(db,"zx","01");
insert(db,"cc","02");
insert1(db,"dd","03");
insert1(db,"ee","04");
Log.i("aa","bb");
query(db);
// Log.i("aaa","bbbbb");
// delete(db,"01");
// delete(db,"02");
// query(db);
update(db,"01","001");
Log.i("aaa","bbbbb");
query(db);
}
private void insert(SQLiteDatabase db, String sname, String snumber) {
// 实例化常用值
ContentValues cValue =new ContentValues();
//添加用户名
cValue.put("sname",sname);
//添加密码
cValue.put("snumber",snumber);
//调用insert()方法插入数据
db.insert("usertable", null, cValue);
}
private void insert1(SQLiteDatabase db, String sname ,String snumber) {
// TODO Auto-generated method stub
String sql="insert into usertable(sname,snumber) values('"+sname+"','"+snumber+"')";
db.execSQL(sql);
}
private void query(SQLiteDatabase db) {
// TODO Auto-generated method stub
Cursor cursor=db.query(false, "usertable",new String[]{"_id","sname","snumber"
}, null, null, null, null, null, null);
if(cursor.moveToFirst()){
for(int i=0;i<cursor.getColumnCount();i++){
int id =cursor.getInt(0);
String sname =cursor.getString(1);
String snumber =cursor.getString(2);
Log