private SQLiteDatabase db; public PersonService(SQLiteDatabase db) { super(); this.db = db; } /** * 添加信息 */ public void insert(Person p){ String sql = "insert into person(name,age,idcard) values(?,?,?)"; db.execSQL(sql, new Object[]{p.getName(),p.getAge(),p.getIDcard()}); }
/** * 查询信息 */ public Person select(int num){ String sql = "select * from person where id=?"; Cursor c = db.rawQuery(sql,new String[]{num+""}); Person p = null; while(c.moveToNext()){ num = c.getInt(c.getColumnIndex("id")); String name = c.getString(c.getColumnIndex("name")); int age = c.getInt(c.getColumnIndex("age")); String idcard = c.getString(c.getColumnIndex("IDcard")); p = new Person(name, age, idcard); } c.close(); return p; } }int number = 0; Intent i = new Intent(MainActivity.this,ShowUserInfoActivity.class);
//访问本地数据库 获取某一条信息 Person person = personservice.select(number); //Log.i("feng",person.getName()+"--"+person.getAge()+"--"+person.getIDcard());
private SQLiteDatabase db;
public PersonService(SQLiteDatabase db) {
super();
this.db = db;
}
/**
* 添加信息
*/
public void insert(Person p){
String sql = "insert into person(name,age,idcard) values(?,?,?)";
db.execSQL(sql, new Object[]{p.getName(),p.getAge(),p.getIDcard()});
}
/**
* 查询信息
*/
public Person select(int num){
String sql = "select * from person where id=?";
Cursor c = db.rawQuery(sql,new String[]{num+""});
Person p = null;
while(c.moveToNext()){
num = c.getInt(c.getColumnIndex("id"));
String name = c.getString(c.getColumnIndex("name"));
int age = c.getInt(c.getColumnIndex("age"));
String idcard = c.getString(c.getColumnIndex("IDcard"));
p = new Person(name, age, idcard);
}
c.close();
return p;
}
}int number = 0;
Intent i = new Intent(MainActivity.this,ShowUserInfoActivity.class);
//访问本地数据库 获取某一条信息
Person person = personservice.select(number);
//Log.i("feng",person.getName()+"--"+person.getAge()+"--"+person.getIDcard());
i.putExtra("name",person.getName());
i.putExtra("age", person.getAge());
i.putExtra("idcard", person.getIDcard());
i.putExtra("id",number);
startActivity(i);
public class ShowUserInfoActivity extends Activity { private EditText userid,username,userage,useridcard;
private String name;
private int age;
private String idcard;
private int id;
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_showuserinfo);
initEditText();
Intent intent = this.getIntent();
name = intent.getStringExtra("name");
age = intent.getIntExtra("age",0);
idcard = intent.getStringExtra("idcard");
int i = intent.getIntExtra("id",0);
i = Integer.parseInt(userid.getText().toString().trim());
} public void initEditText(){
userid = (EditText) this.findViewById(R.id.et_userid_showinfo);
username = (EditText) this.findViewById(R.id.et_username_showinfo);
userage = (EditText) this.findViewById(R.id.et_age_showinfo);
useridcard = (EditText) this.findViewById(R.id.et_idcard_showinfo);
}
public void btn_select(View v){ username.setText(name);
userage.setText(age+"");
useridcard.setText(idcard);
}
运行结果求大神解惑
2、也可以通过一个回调接口,接口的参数为你这个num类型的值。(缺点:为了传这一个参数要实现一个接口,麻烦了点)
http://developer.android.com/reference/android/os/Parcelable.html