· 7 years ago · Dec 13, 2018, 03:46 AM
1package cs.hung;
2
3import android.app.Activity;
4import android.content.ContentValues;
5import android.content.Context;
6import android.database.Cursor;
7import android.database.sqlite.SQLiteDatabase;
8import android.database.sqlite.SQLiteOpenHelper;
9import android.database.sqlite.SQLiteStatement;
10import android.os.Bundle;
11import android.util.Log;
12
13import static cs.hung.StudentInfo.DATABASE_TABLE;
14
15public class SQLiteDemo extends Activity {
16
17 SQLiteDatabase db;
18 DatabaseHelper dbHelper;
19
20 private String[][] studentname = new String[50][4];
21 @Override
22 public void onCreate(Bundle savedInstanceState) {
23 super.onCreate(savedInstanceState);
24 setContentView(R.layout.main);
25
26 dbHelper = new DatabaseHelper(this);
27 db = dbHelper.getWritableDatabase();
28
29 for(int i = 0 ; i <50;i++){
30 studentname[i][0] = Integer.toString(i+1000) ;
31 studentname[i][1] = "name:"+Integer.toString(i) ;
32 studentname[i][2] = "phone"+Integer.toString(i) ;
33 studentname[i][3] = "class"+Integer.toString(i) ;
34 Log.i("studentname:",studentname[i][0]);
35 }
36
37 String sql = "insert into STUDENTINFO values(?, ?,?, ?)";
38 db.beginTransaction();
39 SQLiteStatement stmt = db.compileStatement(sql);
40
41 for (int i = 0; i < studentname.length; i++) {
42
43
44 stmt.bindLong(1,Integer.parseInt(studentname[i][0]) );
45 stmt.bindString(2, studentname[i][1]);
46 stmt.bindString(3, studentname[i][2]);
47 stmt.bindString(4, studentname[i][3]);
48 stmt.executeInsert();
49 //stmt.clearBindings();
50 }
51 db.setTransactionSuccessful();
52 db.endTransaction();
53//
54// ContentValues cv = new ContentValues();
55// cv.put("ID", 4);
56// cv.put("NAME", "hung");
57// cv.put("PHONE", "123456789");
58// cv.put("CLASS", "1A");
59// db.insert(DATABASE_TABLE, null, cv);
60//
61// String sym = "'";
62// db.execSQL("insert into " + DATABASE_TABLE +
63// " values(10," + sym + "tmue" + sym + ","
64// + sym + "222222222" + sym + ","+sym+"2A"+sym+");");
65
66// Cursor c = db.rawQuery("select * from " + DATABASE_TABLE, null);
67//
68// String [] names = c.getColumnNames();
69//
70// for (int i = 0; i < names.length; i++)
71// Log.d("CS", "ColumnNames (" + c.getColumnIndex(names[i])
72// + "): " + names[i]);
73//
74// c.moveToFirst();
75// for (int i = 0; i < c.getCount(); i++) {
76// Log.d("CS", "Name" + i + ": " + c.getString(c.getColumnIndex(names[1])));
77// c.moveToNext();
78// }
79//
80 }
81
82 @Override
83 public void onStop() {
84 super.onStop();
85 db.execSQL("drop table if exists " + DATABASE_TABLE );
86 db.execSQL(DATABASE_CREATE);
87 dbHelper.close();
88 }
89
90 String DATABASE_TABLE = "STUDENTINFO";
91 String DATABASE_CREATE = "create table " +
92 DATABASE_TABLE + "( "
93 + "ID INTEGER NOT NULL,"
94 + "NAME CHAR(20) NOT NULL,"
95 + "PHONE CHAR(20),"
96 + "CLASS CHAR(50),"
97 + "PRIMARY KEY(ID) );";
98
99 class DatabaseHelper extends SQLiteOpenHelper {
100 public DatabaseHelper(Context context) {
101 super(context, "example1", null, 1);
102 }
103 @Override
104 public void onCreate(SQLiteDatabase db) {
105 db.execSQL(DATABASE_CREATE);
106 }
107 @Override
108 public void onUpgrade(SQLiteDatabase db, int oldV, int newV) {
109 }
110 }
111}