Android 实验报告 Sqlite 数据库操作

Question.question question;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
if(getArguments().containsKey("item_id")){
android:onClick="exam"/>
<TextView
android:text="开始考试" />
</LinearLayout>
···</Linea NhomakorabeaLayout>
EntryActivity.java:
public class EntryActivity extends Activity {
<LinearLayout>
<LinearLayout
android:gravity="center_horizontal"
android:layout_weight="1"
android:orientation="vertical">
<Button
android:background="@drawable/main_menu_exam"
intent.putExtra("user",username);
startActivity(intent);
}else{
Toast.makeText(LoginActivity.this,"不可以登录",Toast.LENGTH_SHORT).show();
}
}
});
}
}
content_entry.xml:
<TabWidget
android:id="@android:id/tabs"/>
<FrameLayout
android:id="@android:id/tabcontent">
</FrameLayout>
</LinearLayout>
</TabHost>
MainActivity.java:
public class MainActivity extends TabActivity {
/**/
Button register = (Button)findViewById(R.id.register);
register.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
···
}
public static void addItem(question q){
question_items_map.put(q.id,q);
};
}
ShowQuestionActivity.java:
public class ShowQuestionActivity extends Fragment{
super.onCreate(savedInstanceState);
setContentView(yout.content_register);
/*start*/
db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+"/user.db3", null);
2、掌握Android的SQLite数据库设计；
3、掌握Android的Activity和Fragement用法；
4、熟悉XML和JSon文件读取
三、
要求使用SQLite数据库实现用户注册和登录，读取数据库信息，退出时生成XML文件或JSON文件。
四
content_main.xml:
<TabHost
super.onCreate(savedInstanceState);
setContentView(yout.content_login);
/*start*/
db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir()+"/user.db3",null);
android:id="@android:id/tabhost"
tools:context="com.example.ydc.filemanager.MainActivity">
<LinearLayout
android:background="@drawable/login_bg"
android:orientation="vertical">
···
public void exit(View v){
finish();
}
}
Question.java:
public classQuestion {
public static class question{
public int id;
public String content;
public String A;
((TextView)findViewById(R.id.showUser)).setText(user);
}
public void exam(View view){
startActivity(new Intent(EntryActivity.this, ExamActivity.class));
}
Android平台开发基础
实验报告
实验名称
实验四AndroidSQLite数据库应用
日期
2016-05-14
专业班级
计算机133班
地点
信息学院M601
实验人
学号
12
同组人
单独完成
一、
(1)熟悉Android的文件操作
(2)掌握AndroidSQLite数据库
(3)熟悉XML和JSon文件读取
二、
1、熟练使用Android的项目创建；
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(yout.content_main);
/*start code*/
TabHost tabHost = getTabHost();
Button login = (Button)findViewById(R.id.login);
login.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String username = ((EditText)findViewById(ername)).getText().toString();
String password = ((EditText)findViewById(R.id.password)).getText().toString();
Cursor cursor = db.rawQuery("select username from user_info where username=? and password=?",
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){···}
try{
String sql = "create table if not exists user_info (_id integer "
+ " primary key autoincrement,"
+ " username varchar(255),"
+ " password varchar(255)"
/*添加第二个选项卡*/
···
}
RegisterActivity.java:
public class RegisterActivity extends Activity {
SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {
}catch (Exception e){
e.printStackTrace();
}
}
});
}
}
LoginActivity.java:
public class LoginActivity extends AppCompatActivity {
SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {