这是我的代码:
public class thirdActivity extends Activity {
EditText t1, t2, t3, t4;
Button b1, b2;
SQLiteDatabase db;
Cursor cursor;
public int id_this;
static String TABLE_NAME = "Users";
static String ID = "_id";
static String USER_NAME = "user_name";
static String NUM = "num";
static String SNO = "sno";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.hey);
t1 = (EditText) findViewById(R.id.editText3);
t2 = (EditText) findViewById(R.id.editText20);
t3 = (EditText) findViewById(R.id.editText21);
t4 = (EditText) findViewById(R.id.editText22);
b1 = (Button) findViewById(R.id.button3);
b1.setOnClickListener(new mClick());
b2 = (Button) findViewById(R.id.button20);
b2.setOnClickListener(new mClick1());
}
class mClick implements OnClickListener {
@Override
public void onClick(View v) {
db = openOrCreateDatabase("sql.db",
SQLiteDatabase.CREATE_IF_NECESSARY, null);
try {
db.execSQL("create table if not exists "
+ TABLE_NAME
+ " (ID integer primary key autoincrement, "
+ "USER_NAME text not null,NUM text not null, SNO text not null);");
} catch (SQLException e) {
Toast.makeText(getApplicationContext(), "数据表创建失败",
Toast.LENGTH_LONG).show();
}
ContentValues values = new ContentValues();
values.put(USER_NAME, "1");
values.put(SNO, "1");
values.put(NUM, "1");
db.insert(TABLE_NAME, null, values);
String a=t1.getText().toString();
cursor = db.query(TABLE_NAME, null,"SNO="+a,null,
null,null,null);
id_this=Integer.parseInt(cursor.getString(0));
String user_name_this=cursor.getString(1);
String num_this=cursor.getString(2);
String sno_this=cursor.getString(3);
t2.setText(user_name_this);
t3.setText(num_this);
t4.setText(sno_this);
}
}
class mClick1 implements OnClickListener {
@Override
public void onClick(View v) {
Intent intent = new Intent();
intent.setClass(thirdActivity.this, MainActivity.class);
startActivityForResult(intent, 0);
thirdActivity.this.finish();
}
}