Android实验报告Sqlite数据库操作

1、江 西 理 工 大 学Android平台开发基础实验报告实验名称实验四AndroidSQLite数据库应用日期2016-05-14专业班级计算机133班地点信息学院M601实验人学号 12 同组人单独完成一、 实验目的(1) 熟悉Android的文件操作(2) 掌握Android SQLite数据库(3) 熟悉XML 和JSon 文件读取二、 实验要求1、 熟练使用Android的项目创建；2、 掌握Android的SQLite数据库设计；3、 掌握Android的Activity 和Fragement用法；4、 熟悉XML 和JSon 文件读取三、 实验内容要求使用SQLite数据库实现用户

2、注册和登录，读取数据库信息，退出时生成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执行表单验证。,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考试规则页面