求教各位大神,我在添加数据库信息的时候只能添加前两行,其他行都乱码了,倒数第几行是添加数据库代码,添加name和sex时出现乱码,所有数据都是text格式

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有效
在这里插入图片描述

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值