数据库的简单使用Sqllite

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();

            }
        });
    }

}
activity_main
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/activity_main"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.bwie.sqllite.MainActivity">

    <EditText
        android:id="@+id/user_name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
    <EditText
        android:layout_below="@+id/user_name"
        android:id="@+id/user_pass"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
    <LinearLayout
        android:layout_below="@+id/user_pass"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">
        <Button
            android:id="@+id/btn_login"
            android:text="登录"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" />
  <Button
            android:id="@+id/btn_add"
            android:text="添加"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" />
  <Button
            android:id="@+id/btn_update"
            android:text="修改"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" />
    </LinearLayout>
</RelativeLayout>

ite_add

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:orientation="vertical"
    android:layout_height="match_parent">
<EditText
    android:id="@+id/add_name"
    android:layout_width="match_parent"
    android:layout_height="wrap_content" />
    <EditText
    android:id="@+id/add_pass"
    android:layout_width="match_parent"
    android:layout_height="wrap_content" />
</LinearLayout>