PTxskBZt

1private  static String DATABASE_TABLE = "tb_travel";
2private SQLiteDatabase db;
3private DBHelper dbHelper;
4
5private EditText photonameView2;
6private EditText albumnameView2;
7private EditText dataView2;
8private EditText placeView2;
9private EditText inforView2;
10Button btn;
11
12@Override
13protected void onCreate(Bundle savedInstanceState) {
14    super.onCreate(savedInstanceState);
15    setContentView(R.layout.activity_travel_data_update);
16
17    dbHelper = new DBHelper(this);
18    db = dbHelper.getWritableDatabase();
19
20    photonameView2 = (EditText) findViewById(R.id.photo_name_update);
21    albumnameView2 = (EditText) findViewById(R.id.album_name_update);
22    dataView2 = (EditText) findViewById(R.id.photo_data_update);
23    placeView2 = (EditText) findViewById(R.id.photo_place_update);
24    inforView2 = (EditText) findViewById(R.id.photo_infor_update);
25    btn = (Button) findViewById(R.id.btn_update);
26
27    btn.setOnClickListener(new View.OnClickListener() {
28        @Override
29        public void onClick(View v) {
30            String photoname = photonameView2.getText().toString();
31            String albumname = albumnameView2.getText().toString();
32            String data = dataView2.getText().toString();
33            String place = placeView2.getText().toString();
34            String infor = inforView2.getText().toString();
35
36            ContentValues cv = new ContentValues();
37
38            cv.put("tbook", albumname);
39            cv.put("tdata", data);
40            cv.put("tplace", place);
41            cv.put("tnote", infor);
42
43            db.update(DATABASE_TABLE, cv, "tphoto='" + photoname + "'", new 
44                      String[]{"1"});
45
46            finish();
47        }
48    });
49}
50	
51public DBHelper(Context context){
52    super(context, "traveldb", null, DATABASE_VERSION);
53}
54
55@Override
56public void onCreate(SQLiteDatabase db) {
57    String travlSql = "create table tb_travel (_id "+
58            "Integer primary key autoincrement, "+
59            "tphoto text not null, "+
60            "tbook, "+
61            "tdata, "+
62            "tplaese, "+
63            "tnote)";
64
65    String trailerSql = "create table tb_traveler (_id "+
66            "Integer primary key autoincrement, "+
67            "name not null, "+
68            "number, "+
69            "LineID, "+
70            "Gmail)";
71
72    db.execSQL(travlSql);
73    db.execSQL(trailerSql);
74}
75
76@Override
77public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
78    if (newVersion == DATABASE_VERSION){
79        db.execSQL("drop table if exists tb_travel");
80        db.execSQL("drip table if exists tb_traveler");
81        onCreate(db);
82    }
83}