登录页面（使用数据库）

sql语句如下:

增加  insert into 表名（参数）values （？，？）；

查询  select * from 表名 where 条件

修改 update 表名 set 参数=? where 条件

首先要创建一个SQLiteHelper

public class MySqlHelper extends SQLiteOpenHelper {
    public MySqlHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        String sql = "create table if not exists user(_id integer primary key autoincrement,uname varchar(20),upass varchar(20))";
        sqLiteDatabase.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}

然后是main函数中

public class MainActivity extends AppCompatActivity {

    EditText username;
    EditText userpass;
    Button btn_login,btn_add,btn_update;

    MySqlHelper helper;
    private SQLiteDatabase read;
    private SQLiteDatabase write;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initview();
        initdata();
    }

    public void initview(){
        username = (EditText) findViewById(R.id.user_name);
        userpass = (EditText) findViewById(R.id.user_pass);
        btn_login = (Button) findViewById(R.id.btn_login);
        btn_add = (Button) findViewById(R.id.btn_add);
        btn_update = (Button) findViewById(R.id.btn_update);

        helper = new MySqlHelper(MainActivity.this,"user",null,1);

        read = helper.getReadableDatabase();
        write = helper.getWritableDatabase();

    }

    public void initdata(){
        btn_login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                Toast.makeText(MainActivity.this,"登录",Toast.LENGTH_SHORT).show();

                String name = username.getText().toString();
                String pass = userpass.getText().toString();
                String sql = "select * from user where uname=? and upass=?";
                Cursor query = read.rawQuery(sql,new String[]{name,pass});
                if(query.moveToNext()==true){
                    Toast.makeText(MainActivity.this,"登陆成功",Toast.LENGTH_SHORT).show();
                }else{
                    Toast.makeText(MainActivity.this,"登陆失败，请注册",Toast.LENGTH_SHORT).show();
                }

            }
        });

        btn_add.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Toast.makeText(MainActivity.this,"注册",Toast.LENGTH_SHORT).show();

                AlertDialog.Builder dialog = new AlertDialog.Builder(MainActivity.this);
                final View view1 = LayoutInflater.from(MainActivity.this).inflate(R.layout.item_add,null);

                dialog.setView(view1);
                dialog.setTitle("注册")
                        .setPositiveButton("确定", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {
                                EditText newname = (EditText) view1.findViewById(R.id.add_name);
                                EditText newpass = (EditText) view1.findViewById(R.id.add_pass);
                                String name = newname.getText().toString();
                                String pass = newpass.getText().toString();
                                String sql = "insert into user(uname,upass) values(?,?)";
                                write.execSQL(sql,new String[]{name,pass});

                            }
                        })
                        .setNegativeButton("取消", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {

                            }
                        })
                        .show();
            }
        });

        btn_update.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Toast.makeText(MainActivity.this,"忘记密码",Toast.LENGTH_SHORT).show();

                AlertDialog.Builder dialog = new AlertDialog.Builder(MainActivity.this);
                final View view1 = LayoutInflater.from(MainActivity.this).inflate(R.layout.item_add,null);

                dialog.setView(view1);
                dialog.setTitle("修改")
                        .setPositiveButton("确定", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {
                                EditText newname = (EditText) view1.findViewById(R.id.add_name);
                                EditText newpass = (EditText) view1.findViewById(R.id.add_pass);
                                String name = newname.getText().toString();
                                String pass = newpass.getText().toString();
                                String sql1 = "update user set uname=?,upass=?where uname=?";
                                write.execSQL(sql1,new String[]{name,pass,name});

                            }
                        })
                        .setNegativeButton("取消", new DialogInterface.OnClickListener() {
                            @Override
                            public void onClick(DialogInterface dialogInterface, int i) {

                            }
                        })
                        .show();

            }
        });
    }

}