首页 > 其他分享 >2022-11-22学习内容-Client端代码编写-数据删除

2022-11-22学习内容-Client端代码编写-数据删除

时间：2022-11-22 21:56:10浏览次数：63  
标签：11 name 22 married cursor Client USER id UserInfoContent

1.Client端代码编写

1.1activity_content_write.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    android:padding="5dp">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:orientation="horizontal">

        <TextView
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:gravity="center"
            android:text="姓名："
            android:textColor="@color/black"
            android:textSize="17sp" />

        <EditText
            android:id="@+id/et_name"
            android:layout_width="0dp"
            android:layout_height="match_parent"
            android:layout_marginTop="3dp"
            android:layout_marginBottom="3dp"
            android:layout_weight="1"
            android:background="@drawable/editext_selector"
            android:hint="请输入姓名"
            android:inputType="text"
            android:maxLength="12"
            android:text="Jack"
            android:textColor="@color/black"
            android:textSize="17sp" />
    </LinearLayout>

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:orientation="horizontal">

        <TextView
            android:id="@+id/tv_age"
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:gravity="center"
            android:text="年龄："
            android:textColor="@color/black"
            android:textSize="17sp" />

        <EditText
            android:id="@+id/et_age"
            android:layout_width="0dp"
            android:layout_height="match_parent"
            android:layout_marginTop="3dp"
            android:layout_marginBottom="3dp"
            android:layout_weight="1"
            android:background="@drawable/editext_selector"
            android:hint="请输入年龄"
            android:inputType="number"
            android:maxLength="2"
            android:text="18"
            android:textColor="@color/black"
            android:textSize="17sp" />
    </LinearLayout>

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:orientation="horizontal">

        <TextView
            android:id="@+id/tv_height"
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:gravity="center"
            android:text="身高："
            android:textColor="@color/black"
            android:textSize="17sp" />

        <EditText
            android:id="@+id/et_height"
            android:layout_width="0dp"
            android:layout_height="match_parent"
            android:layout_marginTop="3dp"
            android:layout_marginBottom="3dp"
            android:layout_weight="1"
            android:background="@drawable/editext_selector"
            android:hint="请输入身高"
            android:inputType="number"
            android:maxLength="3"
            android:text="180"
            android:textColor="@color/black"
            android:textSize="17sp" />
    </LinearLayout>

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:orientation="horizontal">

        <TextView
            android:id="@+id/tv_weight"
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:gravity="center"
            android:text="体重："
            android:textColor="@color/black"
            android:textSize="17sp" />

        <EditText
            android:id="@+id/et_weight"
            android:layout_width="0dp"
            android:layout_height="match_parent"
            android:layout_marginTop="3dp"
            android:layout_marginBottom="3dp"
            android:layout_weight="1"
            android:background="@drawable/editext_selector"
            android:hint="请输入体重"
            android:inputType="numberDecimal"
            android:maxLength="5"
            android:text="180"
            android:textColor="@color/black"
            android:textSize="17sp" />
    </LinearLayout>

    <CheckBox
        android:id="@+id/ck_married"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:checked="false"
        android:gravity="center"
        android:text="已婚"
        android:textColor="@color/black"
        android:textSize="17sp" />

    <Button
        android:id="@+id/btn_save"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="保存"
        android:textColor="@color/black"
        android:textSize="17sp" />

    <Button
        android:id="@+id/btn_read"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="读取"
        android:textColor="@color/black"
        android:textSize="17sp" />

    <Button
        android:id="@+id/btn_delete"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="删除"
        android:textColor="@color/black"
        android:textSize="17sp" />

</LinearLayout>

1.2ContentWriteActivity.java

package com.example.chapter07_client;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.database.Cursor;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.CheckBox;
import android.widget.EditText;

import com.example.chapter07_client.entity.User;
import com.example.chapter07_client.util.ToastUtil;

public class ContentWriteActivity extends AppCompatActivity implements View.OnClickListener{

    private EditText et_name;
    private EditText et_age;
    private EditText et_height;
    private EditText et_weight;
    private CheckBox ck_married;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_content_write);

        et_name = findViewById(R.id.et_name);
        et_age = findViewById(R.id.et_age);
        et_height = findViewById(R.id.et_height);
        et_weight = findViewById(R.id.et_weight);
        ck_married = findViewById(R.id.ck_married);

        findViewById(R.id.btn_save).setOnClickListener(this);
        findViewById(R.id.btn_delete).setOnClickListener(this);
        findViewById(R.id.btn_read).setOnClickListener(this);
    }

    @SuppressLint("Range")
    @Override
    public void onClick(View v) {
        switch(v.getId()) {
            case R.id.btn_save:
                ContentValues values = new ContentValues();
                values.put(UserInfoContent.USER_NAME, et_name.getText().toString());
                values.put(UserInfoContent.USER_AGE, Integer.parseInt(et_age.getText().toString()));
                values.put(UserInfoContent.USER_HEIGHT, Integer.parseInt(et_height.getText().toString()));
                values.put(UserInfoContent.USER_WEIGHT, Float.parseFloat(et_weight.getText().toString()));
                values.put(UserInfoContent.USER_MARRIED, ck_married.isChecked());
                getContentResolver().insert(UserInfoContent.CONTENT_URI, values);
                ToastUtil.show(this, "保存成功");
                break;
            case R.id.btn_read:
                Cursor cursor = getContentResolver().query(UserInfoContent.CONTENT_URI, null, null, null, null);
                if (cursor != null) {
                    while(cursor.moveToNext()) {
                        User info = new User();
                        info.id = cursor.getInt(cursor.getColumnIndex(UserInfoContent._ID));
                        info.name = cursor.getString(cursor.getColumnIndex(UserInfoContent.USER_NAME));
                        info.age = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_AGE));
                        info.height = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_HEIGHT));
                        info.weight = cursor.getFloat(cursor.getColumnIndex(UserInfoContent.USER_WEIGHT));
                        info.married = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_MARRIED)) == 1 ? true : false;
                        Log.d("ning", info.toString());
                    }
                    cursor.close();
                }
                break;
        }
    }
}

1.3UserInfoContent.java

package com.example.chapter07_client;

import android.net.Uri;
import android.provider.BaseColumns;

public class UserInfoContent implements BaseColumns {

    public static final String AUTHORITIES = "com.example.chapter07_server.provider.UserInfoProvider";

    // content://com.example.chapter07_server.provider.UserInfoProvider

    // 访问内容提供器的URI
    public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITIES + "/user");

    // 下面是该表的各个字段名称
    public static final String USER_NAME = "name";
    public static final String USER_AGE = "age";
    public static final String USER_HEIGHT = "height";
    public static final String USER_WEIGHT = "weight";
    public static final String USER_MARRIED = "married";

}

1.4效果：

先启动server端：

控制台输出：

D/ning: UserInfoProvider onCreate

再启动client：

点“保存”：

 控制台输出：

D/ning: UserInfoProvider insert

再点“读取”： 控制台输出：

D/ning: UserInfoProvider query
D/ning: User{id=1, name='Jack', age=18, height=180, weight=180.0, married=false}

再点击“保存”、“读取”，控制台输出：

D/ning: UserInfoProvider query
D/ning: User{id=1, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=2, name='Jack', age=18, height=180, weight=180.0, married=false}

2.数据删除

2.1chapter07-server应用的UserInfoProvider.java新增内容：



private static final UriMatcher URI_MATCHER = new UriMatcher(UriMatcher.NO_MATCH);

private static final int USERS = 1;
private static final int USER = 2;

static {
    // 往Uri匹配器中添加指定的数据路径
    URI_MATCHER.addURI(UserInfoContent.AUTHORITIES, "/user", USERS);
    URI_MATCHER.addURI(UserInfoContent.AUTHORITIES, "/user/#", USER);
}



// content://com.example.chapter07_server.provider.UserInfoProvider/user
@Override
public Uri insert(Uri uri, ContentValues values) {
    Log.d("ning", "UserInfoProvider insert");
    if (URI_MATCHER.match(uri) == USERS) {
        SQLiteDatabase db = dbHelper.getWritableDatabase();
        db.insert(UserDBHelper.TABLE_NAME, null, values);
    }
    return uri;
}

@Override
public Cursor query(Uri uri, String[] projection, String selection,
                    String[] selectionArgs, String sortOrder) {
    Log.d("ning", "UserInfoProvider query");
    if (URI_MATCHER.match(uri) == USERS) {
        SQLiteDatabase db = dbHelper.getReadableDatabase();
        return db.query(UserDBHelper.TABLE_NAME, projection, selection, selectionArgs, null, null, null);
    }
    return null;
}

@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
    int count = 0;
    switch (URI_MATCHER.match(uri)) {
        // content://com.example.chapter07_server.provider.UserInfoProvider/user
        // 删除多行
        case USERS:
            SQLiteDatabase db1 = dbHelper.getWritableDatabase();
            count = db1.delete(UserDBHelper.TABLE_NAME, selection, selectionArgs);
            db1.close();
            break;
        // content://com.example.chapter07_server.provider.UserInfoProvider/user/2
        // 删除单行
        case USER:
            String id = uri.getLastPathSegment();
            SQLiteDatabase db2 = dbHelper.getWritableDatabase();
            count = db2.delete(UserDBHelper.TABLE_NAME, "_id=?", new String[]{id});
            db2.close();
            break;
    }

    return count;
}



2.2charpter07-client应用的清单文件，新增内容：



<!-- 出于安全考虑，Android 11 要求应用事先说明需要访问的其他软件包 -->
    <queries>
        <package android:name="com.example.chapter07_server"/>
    </queries>



2.3charpter07-client应用的ContentWriteActivity.java中新增内容：



@SuppressLint("Range")
    @Override
    public void onClick(View v) {
        switch(v.getId()) {
            case R.id.btn_save:
                ContentValues values = new ContentValues();
                values.put(UserInfoContent.USER_NAME, et_name.getText().toString());
                values.put(UserInfoContent.USER_AGE, Integer.parseInt(et_age.getText().toString()));
                values.put(UserInfoContent.USER_HEIGHT, Integer.parseInt(et_height.getText().toString()));
                values.put(UserInfoContent.USER_WEIGHT, Float.parseFloat(et_weight.getText().toString()));
                values.put(UserInfoContent.USER_MARRIED, ck_married.isChecked());
                getContentResolver().insert(UserInfoContent.CONTENT_URI, values);
                ToastUtil.show(this, "保存成功");
                break;
            case R.id.btn_read:
                Cursor cursor = getContentResolver().query(UserInfoContent.CONTENT_URI, null, null, null, null);
                if (cursor != null) {
                    while(cursor.moveToNext()) {
                        User info = new User();
                        info.id = cursor.getInt(cursor.getColumnIndex(UserInfoContent._ID));
                        info.name = cursor.getString(cursor.getColumnIndex(UserInfoContent.USER_NAME));
                        info.age = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_AGE));
                        info.height = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_HEIGHT));
                        info.weight = cursor.getFloat(cursor.getColumnIndex(UserInfoContent.USER_WEIGHT));
                        info.married = cursor.getInt(cursor.getColumnIndex(UserInfoContent.USER_MARRIED)) == 1 ? true : false;
                        Log.d("ning", info.toString());
                    }
                    cursor.close();
                }
                break;
            case R.id.btn_delete:

                // 单行删除：
                // content://com.example.chapter07_server.provider.UserInfoProvider/user/2
//                Uri uri = ContentUris.withAppendedId(UserInfoContent.CONTENT_URI, 10);
//                int count = getContentResolver().delete(uri, null, null);

                // 多行删除：
                // content://com.example.chapter07_server.provider.UserInfoProvider/user
                int count = getContentResolver().delete(UserInfoContent.CONTENT_URI, "name=?", new String[]{"Jack"});
                if (count > 0) {
                    ToastUtil.show(this, "删除成功");
                }
                break;
        }
    }



2.4charpter07-client及charpter07-server应用的UserInfoContent.java新增内容：



public static final String AUTHORITIES = "com.example.chapter07_server.provider.UserInfoProvider";

    // content://com.example.chapter07_server.provider.UserInfoProvider

    // 访问内容提供器的URI
    public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITIES + "/user");



2.5效果：


2.5.1单条删除：


点“读取”：



D/ning: User{id=8, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=9, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=10, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=11, name='Jack', age=18, height=180, weight=180.0, married=false}



点“删除”，删除id=10的，再点“读取”，可以看到id=10的已经被删除了：



D/ning: User{id=8, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=9, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=11, name='Jack', age=18, height=180, weight=180.0, married=false}



2.5.2多条删除：


点“读取”：



D/ning: User{id=8, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=9, name='Jack', age=18, height=180, weight=180.0, married=false}
D/ning: User{id=11, name='Jack', age=18, height=180, weight=180.0, married=false}



点“删除”，删除所有名字等于"Jack"的，再点“读取”，可以看到全都删除了（因为名字都等于Jack）：


（备注：这里直接点“读取”，会报WaitForGcToComplete blocked Instrumentation on None for 6.246ms。所以我采用先点一下“保存”，再点“读取”的方式。查出来id=12，说明点击“删除”时，当时所有name=Jack的记录即id=8,9,11的，已经都被删掉了。）



D/ning: User{id=12, name='Jack', age=18, height=180, weight=180.0, married=false}



 



标签：11,name,22,married,cursor,Client,USER,id,UserInfoContent	

From： https://www.cnblogs.com/pingfanliliang/p/16913405.html
      

      




      

      

        
相关文章

        

          
    
 
  • 2022-11-22-2
    1packagecn.itsource._inputsteam;23importjava.io.UnsupportedEncodingException;45/**6*该类用于编译问题：7*编码转换方法及......
     
  • 报告分享|青源会：2022年人工智能重要方向进展与未来展望报告
    报告链接：http://tecdat.cn/?p=30489青源会举办了青源学术年会及一系列学术研讨活动，邀请自然语言处理、智能信息检索与挖掘、计算机视觉、智能体系结构与芯片、机器学习数......
     
  • 2022.11.22
    P8579我认为这题挺难的，应该不止蓝题难度，我做它的时候没有一步是严谨的甚至到最后A的时候都是不具有正确性的。首先我们要看出它是个二分，然后我们要感性理解一下它的最......
     
  • RTL8811CU
    https://www.realtek.com/zh-tw/products/communications-network-ics/item/rtl8811cu......
     
  • window11设置电脑默认存储到D盘图文版步骤
    点击控制面板进入系统和安全，点击系统=>点击系统=>存储=>高级存储设置=>保存新内容的位置改新内容的保存位置，将所有保存地址改为【D盘】，点击【应用】即可。......
     
  • 2022 ICPC沈阳合肥游记
    选赛区的时候很争议，除了沈阳是确定要选，队友对于合肥新赛区的看法很质疑，但我想选合肥，一是觉得人少，二是觉得强队会少，因为隔壁CCPC。然后就选了合肥，看情况选合肥确实很对。一......
     
  • UNCTF2022 pwn
    welcomeUNCTF2022nc好耶，直接输入UNCTF&2022​即可‍石头剪刀布一道经典的伪随机数题sla('(y/n)\n','y')libc.srand(0xa)rand=['0','0','1','1','2','1','1','0',......
     
  • 11.22 闲话
    感觉物理要做笔记了，至少要把一些经典的计算结果记下来，今天做导练算得有点慢。。。其实一直想补一下数理化的笔记的，但是想了一下有好多内容，于是摆了。我从小到大就没有记笔......
     
  • 2022-11-22
    1packagecn.itsource._inputsteam;23importjava.io.FileInputStream;4importjava.io.FileNotFoundException;5importjava.io.FileOutputStream;6imp......
     
  • BZOJ2460-[BeiJing2011]元素
    BZOJ2460Description    相传，在远古时期，位于西方大陆的MagicLand上，人们已经掌握了用魔法矿石炼制法杖的技术。那时人们就认识到，一个法杖的法力取决于使用的矿石......
     
    •            
          

        

      

    

    

      
赞助商

      




      

      
阅读排行

      

        
      

    

  





  
 
    
网站主页关于我们联系我们网站地图 

    
本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。 

    
Copyright © 2020-2023  IPS99  版权所有 IPS99