public class new_jobseeker extends AppCompatActivity {
private data_build db1;
private EditText editText1;
private EditText editText2;
private EditText editText3;
private EditText editText4;
private EditText editText5;
private EditText editText6;
private EditText editText7;
private EditText editText8;
private EditText editText9;
private EditText editText10;
private Button button1;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_new_jobseeker);
editText1 = (EditText) findViewById(R.id.jobseeker_name1);
editText2 = (EditText) findViewById(R.id.jobseeker_sex1);
editText3 = (EditText) findViewById(R.id.jobseeker_id1);
editText4 = (EditText) findViewById(R.id.jobseeker_phonecall1);
editText5 = (EditText) findViewById(R.id.jobseeker_address1);
editText6 = (EditText) findViewById(R.id.jobseeker_school1);
editText7 = (EditText) findViewById(R.id.jobseeker_major1);
editText8 = (EditText) findViewById(R.id.jobseeker_selfintrduction1);
editText9 = (EditText) findViewById(R.id.js_new_account);
editText10 = (EditText) findViewById(R.id.js_new_password);
button1 = (Button) findViewById(R.id.add_new_js);
db1 = new data_build(this, “ERR_System.db”, null, 120);
button1.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
SQLiteDatabase db = db1.getWritableDatabase();
String account = editText9.getText().toString();
String password = editText10.getText().toString();
if ((account.length() != 0) && (password.length() != 0)) {
int i = 1;
Cursor cursor = db.query(“jobseeker_info”, null, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
String account1 = cursor.getString(cursor.getColumnIndex(“account”));
String password1 = cursor.getString(cursor.getColumnIndex(“password”));
if (account.equals(account1) && (password.equals(password1))) {
i = 0;
Toast.makeText(new_jobseeker.this, “User already exists”, Toast.LENGTH_SHORT).show();
break;
}
} while (cursor.moveToNext());
}
if (i == 1) {
db.execSQL(“insert into jobseeker_info (account, password, name, sex) values(?, ?, ?, ?)”,
new String[]{editText9.getText().toString(), editText10.getText().toString(),
editText1.toString(), editText2.toString()});
Toast.makeText(new_jobseeker.this, “creat success”, Toast.LENGTH_SHORT).show();
}
} else
Toast.makeText(new_jobseeker.this, “The account or password is incorrect. Please re-enter”, Toast.LENGTH_SHORT).show();
}
});
}添加了account和password, 需要显示name和sex,account和password有效