博客

使用SQLite数据库展示用户信息

  • Post author:
  • Post category:其他


只有添加、查看、删除功能，无修改功能

目录结构：

代码：

1.  insertuser_Activity.java

import android.app.Activity;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.Window;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Spinner;

import androidx.annotation.Nullable;

import javax.xml.parsers.SAXParser;

public class Insertuser_Activity extends Activity {
    private EditText name_edit, paswd_edit, age_edit;
    private Spinner spinner;
    private Button save_btn;
    private String select_sex = "男";

    @Override
    protected void onCreate(@Nullable Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        requestWindowFeature(Window.FEATURE_NO_TITLE);
        setContentView(R.layout.user_insert);
        init();
    }

    private void init() {
        name_edit = (EditText)findViewById(R.id.insert_name);
        paswd_edit = (EditText)findViewById(R.id.insert_paswd);
        spinner = (Spinner) findViewById(R.id.insert_sex);

        spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener(){
            @Override
            public void onItemSelected(AdapterView<?> adapterView, View view, int i, long l) {
                select_sex = Insertuser_Activity.this.getResources().getStringArray(R.array.sex)[i];
            }

            @Override
            public void onNothingSelected(AdapterView<?> parent) {

            }
        });
        age_edit = (EditText) findViewById(R.id.insert_age);
        save_btn = (Button) findViewById(R.id.save_username);
        save_btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name_str = name_edit.getText().toString();
                String paswd_str = paswd_edit.getText().toString();
                int age = Integer.parseInt(age_edit.getText().toString());

                User_Database us_db = new User_Database(Insertuser_Activity.this);
                SQLiteDatabase sqLiteDatabase = us_db.getWritableDatabase();
                us_db.adddata(sqLiteDatabase, name_str,paswd_str,select_sex,age);
                Intent intent = new Intent(Insertuser_Activity.this, Sea_deluser_Activity.class);
                startActivity(intent);
            }
        });
    }
}

2.  MainActivity.java

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

    public User_Database user;
    public SQLiteDatabase sqLiteDatabase;
    private Button search_del_btn, insert_btn, update_btn;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        User_Database user = new User_Database(MainActivity.this);
        sqLiteDatabase = user.getReadableDatabase();
        init();
    }

    public void init(){
        search_del_btn = (Button) findViewById(R.id.search_delete);
        insert_btn = (Button) findViewById(R.id.add);
        update_btn = (Button) findViewById(R.id.updata);
        search_del_btn.setOnClickListener(this);
        insert_btn.setOnClickListener(this);
        update_btn.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()){
            case R.id.search_delete:
                Intent intent1 = new Intent(MainActivity.this, Sea_deluser_Activity.class);
                startActivity(intent1);
                break;
            case R.id.add:
                Intent intent2 = new Intent(MainActivity.this,Insertuser_Activity.class);
                startActivity(intent2);
                break;
            case R.id.updata:
                Intent intent3 = new Intent(MainActivity.this,Updareuser_Activity.class);
                startActivity(intent3);
                break;
            default:
                break;
        }
    }
}

3.  Sea_deluser_Activity.java

import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.Window;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

import java.util.List;

public class Sea_deluser_Activity extends Activity {
    public ListView user_list;
    private List<UserInfo> list;
    private SQLiteDatabase sqLiteDatabase;
    private String[] user_mes;

    @Override
    protected void onCreate(Bundle saveInstanceState) {
        super.onCreate(saveInstanceState);
        requestWindowFeature(Window.FEATURE_NO_TITLE);
        setContentView(R.layout.user_search_delete);
        user_list = findViewById(R.id.mes);
        User_Database users = new User_Database(Sea_deluser_Activity.this);
        sqLiteDatabase = users.getReadableDatabase();
        list = users.querydata(sqLiteDatabase);
        user_mes = new String[list.size()];
        for (int i=0; i<list.size(); i++){
            user_mes[i] = list.get(i).getUsername() + " " + list.get(i).getPaswd()+ " " + list.get(i).getAge()+ " " + list.get(i).getSex();
        }
        final ArrayAdapter<String> adapter = new ArrayAdapter<String>(Sea_deluser_Activity.this, android.R.layout.simple_list_item_1, user_mes);
        user_list.setAdapter(adapter);
        user_list.setOnItemClickListener(new AdapterView.OnItemClickListener(){
            public void onItemClick(AdapterView<?> adapterView, View view, int I, long l){
                final int id = list.get(I).getId();
                new AlertDialog.Builder(Sea_deluser_Activity.this).setTitle("系统提示").setMessage("确认删除该条数据吗？").setPositiveButton("确定", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        User_Database user_database = new User_Database(Sea_deluser_Activity.this);
                        SQLiteDatabase sqLiteDatabase = user_database.getWritableDatabase();
                        user_database.delete(sqLiteDatabase, id);
                        refresh();
                        Toast.makeText(Sea_deluser_Activity.this,"删除成功", Toast.LENGTH_SHORT).show();
                    }
                }).setNegativeButton("取消",new DialogInterface.OnClickListener(){
                    public void onClick(DialogInterface dialog , int which){}
                }).show();
            }
        });
    }

    private void refresh(){
        finish();
        Intent intent = new Intent(Sea_deluser_Activity.this, Sea_deluser_Activity.class);
        startActivity(intent);
    }
}

4.  Updareuser_Activity.java（建立即可，可不写代码，只有添加、查看、删除功能，无修改）

5. User_Database.java

import android.annotation.SuppressLint;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.DatabaseErrorHandler;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;

import java.util.ArrayList;
import java.util.List;

public class User_Database extends SQLiteOpenHelper {

    public User_Database(Context context){
        super(context,"user_db",null,1);
    }
    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        String sql = "create table user(id integer primary key autoincrement, username varchar(20), paswd varchar(20), sex varchar(20), age integer)";
        sqLiteDatabase.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    //添加数据
    public void adddata(SQLiteDatabase sqLiteDatabase, String username, String paswd, String sex,int age){
        ContentValues values = new ContentValues();
        values.put("username",username);
        values.put("paswd",paswd);
        values.put("sex",sex);
        values.put("age",age);
        sqLiteDatabase.insert("user",null,values);
        sqLiteDatabase.close();
    }
    //删除数据
    public void delete(SQLiteDatabase sqLiteDatabase, int id){
        sqLiteDatabase.delete("user","id=?",new String[]{id+""});
        sqLiteDatabase.close();
    }
    //更新数据
    public void update(SQLiteDatabase sqLiteDatabase, int id, String username, String paswd, String sex, int age){
        ContentValues values = new ContentValues();
        values.put("username",username);
        values.put("paswd",paswd);
        values.put("sex",sex);
        values.put("age",age);
        sqLiteDatabase.update("user",values, "id=?",new String[]{id+""});
        sqLiteDatabase.close();
    }
    //查询数据
    public List<UserInfo> querydata(SQLiteDatabase sqLiteDatabase){
        Cursor cursor = sqLiteDatabase.query("user",null,null,null,null,null,"id ASC");
        List<UserInfo> list = new ArrayList<UserInfo>();
        while (cursor.moveToNext()){
            @SuppressLint("Range") int id = cursor.getInt(cursor.getColumnIndex("id"));
            String username = cursor.getString(1);
            String paswd = cursor.getString(2);
            String sex = cursor.getString(3);
            @SuppressLint("Range") int age = cursor.getInt(cursor.getColumnIndex("age"));
            list.add(new UserInfo(id,username,paswd,sex,age));
        }
        cursor.close();
        sqLiteDatabase.close();
        return list;
    }
}

6.  UserInfo.java

public class UserInfo {
    private int id;
    private String username;
    private String paswd;
    private String sex;
    private int age;

    public UserInfo(int id, String username, String paswd, String sex, int age) {
        this.id = id;
        this.username = username;
        this.paswd = paswd;
        this.sex = sex;
        this.age = age;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPaswd() {
        return paswd;
    }

    public void setPaswd(String paswd) {
        this.paswd = paswd;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "UserInfo{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", paswd='" + paswd + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                '}';
    }
}

布局文件代码：

1.  activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity"
    android:orientation="vertical">

    <Button
        android:id="@+id/search_delete"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="20dp"
        android:textSize="17sp"
        android:textColor="#FFFFFF"
        android:background="#4169E1"
        android:text="查询/删除用户信息"/>
    <Button
        android:id="@+id/updata"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="20dp"
        android:textSize="17sp"
        android:textColor="#FFFFFF"
        android:background="#4169E1"
        android:text="无用按钮"/>
    <Button
        android:id="@+id/add"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="20dp"
        android:textSize="17sp"
        android:textColor="#FFFFFF"
        android:background="#4169E1"
        android:text="添加用户信息"/>


</LinearLayout>

2. detail.xml(无用)

3.  user_insert.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">
    <EditText
        android:id="@+id/insert_name"
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:gravity="center"
        android:background="@drawable/edit_shape"
        android:layout_marginTop="10dp"
        android:hint="请输入用户名"/>
    <EditText
        android:id="@+id/insert_paswd"
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:gravity="center"
        android:background="@drawable/edit_shape"
        android:layout_marginTop="10dp"
        android:hint="请输入密码"/>

    <Spinner
        android:id="@+id/insert_sex"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="10dp"
        android:entries="@array/sex"
        android:gravity="center" />

    <EditText
        android:id="@+id/insert_age"
        android:layout_width="match_parent"
        android:layout_height="40dp"
        android:gravity="center"
        android:background="@drawable/edit_shape"
        android:hint="请输入年龄"/>
    <Button
        android:id="@+id/save_username"
        android:layout_width="match_parent"
        android:layout_height="50dp"
        android:layout_marginTop="20dp"
        android:textSize="17sp"
        android:textColor="#FFFFFF"
        android:background="#4169E1"
        android:text="添加该用户信息"/>



</LinearLayout>

@drawable/edit_shape会报红，根据系统修复一下就行，会生成这个文件，可以不用写入代码直接运行

4.  user_search_delete.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">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="50dp"
        android:background="#3F51B5"
        android:orientation="horizontal">
        <ImageView
            android:layout_width="50dp"
            android:layout_height="50dp"
            android:layout_marginLeft="10dp"
            android:src="@mipmap/ic_launcher"/>
        <TextView
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:text="查询用户"
            android:textSize="18sp"
            android:gravity="center_vertical"
            android:textColor="#FFFFFF"/>

    </LinearLayout>
    <ListView
        android:id="@+id/mes"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:dividerHeight="2dp"/>

</LinearLayout>

5.  加入values文件夹中:arrays.xml 

<?xml version="1.0" encoding="utf-8"?>
<resources xmlns:tools="http://schemas.android.com/tools">
    <string-array name="sex">
        <item>男</item>
        <item>女</item>
    </string-array>

</resources>

看到这里，应该复制粘贴完了吧，另外，还需要在

这个文件中添加活动。 

 <activity android:name=".Sea_deluser_Activity">

 </activity>

 <activity android:name=".Insertuser_Activity">

 </activity>


版权声明：本文为m0_57362214原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。