@[toc] 作业
注册
activity——注册
package com.example.day1016_homework;
import android.app.Notification;
import android.app.NotificationManager;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.os.Build;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import com.example.day1016_homework.sql.MySHelper;
import com.example.day1016_homework.sql.MySqlHelper;
import java.util.regex.Pattern;
public class Main2Activity extends AppCompatActivity {
private ContentResolver resolver, resolver1;
private Uri uri, uri1;
private EditText numRes;
private EditText valRes;
private Button butRes;
private EditText pwdTes;
private Button resBut;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main2);
numRes = (EditText) findViewById(R.id.num_res);
valRes = (EditText) findViewById(R.id.val_res);
butRes = (Button) findViewById(R.id.but_res);
pwdTes = (EditText) findViewById(R.id.pwd_tes);
resBut = (Button) findViewById(R.id.res_but);
resolver = getContentResolver();
resolver1 = getContentResolver();
if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.M) {
requestPermissions(new String[]{android.Manifest.permission.READ_CONTACTS, android.Manifest.permission.WRITE_CONTACTS}, 100);
} else {
}
uri = Uri.parse("content://com.li.sql");
uri1 = Uri.parse("content://com.li.sqll");
init();
}
private void init() {
String num = numRes.getText().toString();
if (num != null) {
butRes.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
int floor = (int) Math.floor(Math.random() * 10);
String s = "" + floor;
String sql = "select * from val_i where id = ?";
Cursor cursor = resolver.query(uri, new String[]{}, null, null, null);
if (cursor != null) {
while (cursor.moveToNext()) {
String number = cursor.getString(cursor.getColumnIndex("number"));
valRes.setText(number);
Notification build = new Notification.Builder(Main2Activity.this).setSmallIcon(R.mipmap.pic2).setContentText(number).build();
NotificationManager manager = (NotificationManager) getSystemService(Context.NOTIFICATION_SERVICE);
manager.notify(1, build);
}
}
}
});
}
resBut.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String pwd = pwdTes.getText().toString();
String ssi = numRes.getText().toString();
String regex = "[A-Za-z0-9]{6,16}";
Pattern compile = Pattern.compile(regex);
boolean matches = compile.matcher(pwd).matches();
if (matches) {
ContentValues values = new ContentValues();
values.put("phone", ssi);
values.put("password", pwd);
resolver1.insert(uri1, values);
Toast.makeText(Main2Activity.this, "安抚", Toast.LENGTH_SHORT).show();
Intent intent = new Intent(Main2Activity.this, MainActivity.class);
startActivity(intent);
}
}
});
}
}
提供者
package com.example.day1016_homework.provider;
import android.content.ContentProvider;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import com.example.day1016_homework.sql.MySqlHelper;
public class MyProvider1 extends ContentProvider {
private MySqlHelper mySqlHelper;
private SQLiteDatabase database;
public MyProvider1() {
}
@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
return database.delete("user",selection,selectionArgs);
}
@Override
public String getType(Uri uri) {
return null;
}
@Override
public Uri insert(Uri uri, ContentValues values) {
database.insert("user",null,values);
return uri;
}
@Override
public boolean onCreate() {
mySqlHelper = new MySqlHelper(getContext(), "Val.db", null, 1);
database = mySqlHelper.getReadableDatabase();
return false;
}
@Override
public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
Cursor cursor = database.query("user", projection, selection, selectionArgs, sortOrder, null, null);
return cursor;
}
@Override
public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
return database.update("user",values,selection,selectionArgs);
}
}
帮助类
package com.example.day1016_homework.sql;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.support.annotation.Nullable;
public class MySHelper extends SQLiteOpenHelper {
public MySHelper(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
登录
activity
package com.example.day1016_homework;
import android.content.ContentResolver;
import android.content.Intent;
import android.database.Cursor;
import android.net.Uri;
import android.os.Build;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
private EditText username;
private EditText password;
private Button login;
private ContentResolver resolver1;
private Uri uri1;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
username = (EditText) findViewById(R.id.username);
password = (EditText) findViewById(R.id.password);
login = (Button) findViewById(R.id.login);
resolver1 = getContentResolver();
if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.M) {
requestPermissions(new String[]{android.Manifest.permission.READ_CONTACTS, android.Manifest.permission.WRITE_CONTACTS}, 100);
} else {
}
uri1 = Uri.parse("content://com.li.sqll");
final String name = username.getText().toString();
final String pwd = password.getText().toString();
login.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Cursor cursor = resolver1.query(uri1, null, null, null, null);
if(cursor != null){
while (cursor.moveToNext()){
String phone = cursor.getString(cursor.getColumnIndex("phone"));
String pword = cursor.getString(cursor.getColumnIndex("password"));
// if(phone.equals(name)&& pwd.equals(pword) ){
Intent intent = new Intent(MainActivity.this, Main3Activity.class);
startActivity(intent);
finish();
// }
}
Toast.makeText(MainActivity.this, "阿萨德刚发货", Toast.LENGTH_SHORT).show();
}
}
});
}
}