一個Android框架下實現(xiàn)登錄和Google檢索的應用程序.docx

1. 需求設計在Android的數(shù)據(jù)庫創(chuàng)建一個login表，包括密碼和賬戶兩個字段 實現(xiàn)兩個activity應用程序，其中一個，提供兩個入力框，分別輸入密碼和賬戶，并且實現(xiàn)登錄check 登錄成功之后，跳轉到第二個Activity，在其上實現(xiàn)一個入力框，根據(jù)輸入的參數(shù)，到google上檢索 2. 效果圖 3. 主要代碼3.1 第一個Activity的代碼public class Android1 extends Activity private Button mButton1; private TextView mTextView1; private TextView mTextView2; private String user = new String(); private String password = new String(); private DBHelper dbHelper; /* Called when the activity is first created. */ Override public void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setContentView(R.layout.main); mTextView1 = (TextView) findViewById(R.id.EditText01); mTextView2 = (TextView) findViewById(R.id.EditText02); dbHelper = new DBHelper(this, TestDB); createTable(); public void onClick(View v) / TODO Auto-generated method stub user = mTextView1.getText().toString(); password = mTextView2.getText().toString(); Boolean result = selectTable(user, password); Log.d(Android1, the result is + result); if (result = true) Intent intent = new Intent(); intent.setClass(Android1.this, Android2.class); startActivity(intent); public void createTable() SQLiteDatabase db = dbHelper.getWritableDatabase(); db .execSQL(create table if not exists LOG (user varchar primary key,password varchar); public boolean selectTable(String user, String password) SQLiteDatabase db = dbHelper.getWritableDatabase(); try Cursor result = db.rawQuery( select * from LOG where user = ? AND password =?, new String user, password ); Log.d(Android1, count is + result.getCount(); if (result.getCount() != 0) result.close(); db.close(); return true; else result.close(); db.close(); return false; catch (SQLException ex) Log.d(Android1, select table failure); return false; 3.2 第二個Activity的代碼public class Android2 extends Activity private TextView mTextView1; Override public void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState); setContentView(R.layout.search); mTextView1 = (TextView) findViewById(R.id.EditTextSearch); public void onClick(View v) String key = mTextView1.getText().toString(); Intent search = new Intent(Intent.ACTION_WEB_SEARCH); search.addFlags(Intent.FLAG_ACTIVITY_NEW_TASK); search.putExtra(SearchManager.QUERY, key); final Bundle appData = getIntent().getBundleExtra( SearchManager.APP_DATA); if (appData != null) search.putExtra(SearchManager.APP_DATA, appData); startActivity(search); 3.3 數(shù)據(jù)庫訪問控制類public class DBHelper extends SQLiteOpenHelper / 數(shù)據(jù)庫版本 private static final int VERSION = 1; / 新建一個表 public DBHelper(Context context, String name, CursorFactory factory, int version) super(context, name, factory, version); public DBHelper(Context context, String name, int version) this(context, name, null, version); public DBHelper(Context context, String name) this(context, name, VERSION); Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) Override public void onCreate(SQLiteDatabase arg0) / TODO Auto