Android實驗報告Sqlite數(shù)據(jù)庫操作

1、江 西 理 工 大 學Android平臺開發(fā)基礎實驗報告實驗名稱實驗四AndroidSQLite數(shù)據(jù)庫應用日期2016-05-14專業(yè)班級計算機133班地點信息學院M601實驗人學號 12 同組人單獨完成一、 實驗目的(1) 熟悉Android的文件操作(2) 掌握Android SQLite數(shù)據(jù)庫(3) 熟悉XML 和JSon 文件讀取二、 實驗要求1、 熟練使用Android的項目創(chuàng)建；2、 掌握Android的SQLite數(shù)據(jù)庫設計；3、 掌握Android的Activity 和Fragement用法；4、 熟悉XML 和JSon 文件讀取三、 實驗內(nèi)容要求使用SQLite數(shù)據(jù)庫實現(xiàn)用戶

2、注冊和登錄，讀取數(shù)據(jù)庫信息，退出時生成XML文件或JSON文件。四、實驗過程和結果content_main.xml: MainActivity.java:public class MainActivity extends TabActivity Override protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setContentView(R.layout.content_main); /*start code*/ TabHost tabHost = getTabHos

3、t(); /*添加第一個選項卡*/ TabHost.TabSpec tab1 = tabHost.newTabSpec(tab1); tab1.setIndicator(login); tab1.setContent(new Intent(this,LoginActivity.class); tabHost.addTab(tab1); /*添加第二個選項卡*/ RegisterActivity.java: public class RegisterActivity extends Activity SQLiteDatabase db; Override protected void onCre

4、ate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setContentView(R.layout.content_register); /*start*/ db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+/user.db3, null); /*/ Button register = (Button)findViewById(R.id.register); register.setOnClickListener(new

5、View.OnClickListener() Override public void onClick(View v) String username = (EditText)findViewById(R.id.username).getText().toString(); String password = (EditText)findViewById(R.id.password).getText().toString(); try String sql = create table if not exists user_info (_id integer + primary key aut

6、oincrement, + username varchar(255), + password varchar(255) + ); db.execSQL(sql); sql = insert into user_info values( null,?,?); db.execSQL(sql,new Stringusername,password); Toast.makeText(RegisterActivity.this,注冊成功，請登錄,Toast.LENGTH_SHORT).show(); catch (Exception e) e.printStackTrace(); ); LoginAc

7、tivity.java: public class LoginActivity extends AppCompatActivity SQLiteDatabase db; Override protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setContentView(R.layout.content_login); /*start*/ db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir()+/user.db3

8、,null); Button login = (Button)findViewById(R.id.login); login.setOnClickListener(new View.OnClickListener() Override public void onClick(View v) String username = (EditText)findViewById(R.id.username).getText().toString(); String password = (EditText)findViewById(R.id.password).getText().toString()

9、; Cursor cursor = db.rawQuery(select username from user_info where username=? and password=?, new Stringusername,password); if(cursor.getCount() != 0) Toast.makeText(LoginActivity.this,可以登錄,Toast.LENGTH_SHORT).show(); Intent intent = new Intent(LoginActivity.this,EntryActivity.class); intent.putExtr

10、a(user,username); startActivity(intent); else Toast.makeText(LoginActivity.this,不可以登錄,Toast.LENGTH_SHORT).show(); ); content_entry.xml: EntryActivity.java:public class EntryActivity extends Activity Override protected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setCo

11、ntentView(R.layout.content_entry); /*start code*/ String user = (String) getIntent().getExtras().get(user); (TextView)findViewById(R.id.showUser).setText(user); public void exam(View view) startActivity(new Intent(EntryActivity.this, ExamActivity.class); public void exit(View v) finish(); Question.j

12、ava:public class Question public static class question public int id; public String content; public String A; public String B; public String C; public String D; public String answer; question(int id,String content,String a,String b,String c,String d,String answer) public static Map question_items_ma

13、p = new HashMap(); static addItem( new question(1,1.JavaScript執(zhí)行表單驗證。,A),B),C),D),a); public static void addItem(question q) question_items_map.put(q.id,q); ;ShowQuestionActivity.java:public class ShowQuestionActivity extends Fragment Question.question question; Override public void onCreate(Bundle

14、savedInstanceState) super.onCreate(savedInstanceState); if(getArguments().containsKey(item_id) question = Question.question_items_map.get(getArguments().getInt(item_id); Override public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) View rootView = inflate

15、r.inflate(R.layout.show_question, container, false); if(question != null) (TextView)rootView.findViewById(R.id.question).setText(question.content); (TextView)rootView.findViewById(R.id.option_a).setText(question.A); return rootView; 四、 實驗結果：本次實驗通過安裝到手機上的運行效果如下： 圖1-1 注冊頁面 圖1-2 登錄頁面 圖1-1菜單頁面 圖1-2 考試頁面 圖1-1考試規(guī)則頁面