android 操作数据库

package com.jlins; import android.app.Activity; import android.app.AlertDialog; import android.content.Context; import android.content.DialogInterface; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.view.Display; import android.view.View; import android.view.View.OnClickListener; import android.widget.AbsoluteLayout; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; public class Schedule extends Activity implements OnClickListener{ private SQLiteDatabase db; private int DB_VERSION = 1; private int DB_MODE = Context.MODE_PRIVATE; private String DB_NAME = "login"; private String TABLE_NAME = "db_user"; private TextView textView1,textView2; private EditText userName,password; private Button submit,cancle; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); AbsoluteLayout absLayout = new AbsoluteLayout(this); textView1 = new TextView(this); textView2 = new TextView(this); userName = new EditText(this); password = new EditText(this); submit = new Button(this); cancle = new Button(this); Display display = getWindowManager().getDefaultDisplay(); int leftMargin = (display.getWidth()-(150+50))/2; int topMargin = (display.getHeight()-(30+30+30+50))/2; AbsoluteLayout.LayoutParams textView1Param = new AbsoluteLayout.LayoutParams(50,40,leftMargin,topMargin); AbsoluteLayout.LayoutParams textView2Param = new AbsoluteLayout.LayoutParams(50,40,leftMargin,topMargin+45); AbsoluteLayout.LayoutParams userNameParam = new AbsoluteLayout.LayoutParams(150,40,leftMargin+55,topMargin); AbsoluteLayout.LayoutParams passwordParam = new AbsoluteLayout.LayoutParams(150,40,leftMargin+55,topMargin+45); AbsoluteLayout.LayoutParams submitParam = new AbsoluteLayout.LayoutParams(60,40,leftMargin+60,topMargin+90); AbsoluteLayout.LayoutParams cancleParam = new AbsoluteLayout.LayoutParams(60,40,leftMargin+130,topMargin+90); textView1.setText("帐号:"); textView2.setText("口令:"); textView1.setTextSize(20); textView2.setTextSize(20); textView1.setWidth(50); textView2.setWidth(50); userName.setWidth(150); password.setWidth(150); submit.setText("确定"); cancle.setText("取消"); absLayout.addView(textView1,textView1Param); absLayout.addView(textView2,textView2Param); absLayout.addView(userName,userNameParam); absLayout.addView(password,passwordParam); absLayout.addView(submit,submitParam); absLayout.addView(cancle,cancleParam); submit.setOnClickListener(this); cancle.setOnClickListener(this); setContentView(absLayout); openDatabase(); } private void openDatabase(){ db = this.openOrCreateDatabase(DB_NAME, DB_MODE, null); db.execSQL("CREATE TABLE IF NOT EXISTS "+ TABLE_NAME+ " (username VARCHAR, password VARCHAR);"); db.execSQL("INSERT INTO "+ TABLE_NAME+ " (username, password)"+ " VALUES ('test', '123456');"); db.execSQL("INSERT INTO "+ TABLE_NAME+ " (username, password)"+ " VALUES ('jlins', '989897');"); } @Override public void onClick(View v) { if(v.equals(submit)) { String username =userName.getText().toString(); String pass =password.getText().toString(); Cursor cur = loadAll(); Log.d(String.valueOf(cur.getColumnCount()), String.valueOf(cur.getColumnCount())); StringBuffer sf = new StringBuffer(); cur.moveToFirst(); int i=0; while (!cur.isLast()) { sf.append(cur.getString(0)).append(" : ").append(cur.getString(1)) .append(" : ").append("\n"); cur.moveToNext(); } db.close(); Log.d("result", sf.toString()); if("test".equals(username)&&"123456".equals(pass)) { setTitle("恭喜登陆成功!"); } else { AlertDialog.Builder alertDialog = new AlertDialog.Builder(this); alertDialog.setIcon(R.drawable.icon); alertDialog.setTitle("失败"); alertDialog.setMessage("用户名或密码错误"); alertDialog.setPositiveButton("确定",new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int whichButton) { dialog.dismiss(); } }); alertDialog.show(); } } else if(v.equals(cancle)) { userName.setText(""); password.setText(""); } } public Cursor loadAll() { Cursor cur = db.query(TABLE_NAME, new String[] { "username", "password"}, null,null, null, null, null); return cur; } }