Repository navigation
Expand file tree
/
Copy pathSql_add.java
More file actions
56 lines (51 loc) · 1.83 KB
/
Copy pathSql_add.java
File metadata and controls
56 lines (51 loc) · 1.83 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
package com.example.app_sql;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class Sql_add extends Activity{
private SQLiteHelper hp;
private Cursor cursor;
private Button bu;
private EditText ev1;
private EditText ev2;
private EditText ev3;
private EditText ev4;
private EditText ev5;
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.sqladdui);
ev1=(EditText)this.findViewById(R.id.addname);
ev2=(EditText)this.findViewById(R.id.addprice);
ev3=(EditText)this.findViewById(R.id.addlow);
ev4=(EditText)this.findViewById(R.id.addtime);
ev5=(EditText)this.findViewById(R.id.addnote);
bu=(Button)this.findViewById(R.id.addbu);
hp=SQLiteHelper.getInstance(this);
cursor=hp.select();
bu.setOnClickListener(new OnClickListener(){
@Override
public void onClick(View v){
add();
Intent in = new Intent();
in.setClassName( getApplicationContext(), "com.example.app_sql.MainActivity" );
startActivity( in );
}
});
}
public void add(){
if (ev1.getText().toString().equals(""))
// 空值不进行修改
return;
hp.insert( ev1.getText().toString(),Float.parseFloat(ev2.getText().toString()),Float.parseFloat(ev3.getText().toString()),ev4.getText().toString(),ev5.getText().toString());
// 控件更新
cursor.requery();
// 通知，数据修改成功
Toast.makeText(this, "数据已增加", Toast.LENGTH_LONG).show();
}
}