Android實(shí)驗(yàn)報(bào)告Sqlite數(shù)據(jù)庫(kù)操作

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

2、注冊(cè)和登錄，讀取數(shù)據(jù)庫(kù)信息，退出時(shí)生成XML文件或JSON文件。四、實(shí)驗(yàn)過(guò)程和結(jié)果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(); /*添加第一個(gè)選項(xiàng)卡*/ TabHost.TabSpec tab1 = tabHost.newTabSpec(tab1); tab1.setIndicator(login); tab1.setContent(new Intent(this,LoginActivity.class); tabHost.addTab(tab1); /*添加第二個(gè)選項(xiàng)卡*/ 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,注冊(cè)成功，請(qǐng)登錄,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í)行表單驗(yàn)證。,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; 四、 實(shí)驗(yàn)結(jié)果：本次實(shí)驗(yàn)通過(guò)安裝到手機(jī)上的運(yùn)行效果如下： 圖1-1 注冊(cè)頁(yè)面 圖1-2 登錄頁(yè)面 圖1-1菜單頁(yè)面 圖1-2 考試頁(yè)面 圖1-1考試規(guī)則頁(yè)面