//AndroidManifest.xml
<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.example.exp6"> <application android:allowBackup="true" android:icon="@mipmap/ic_launcher" android:label="@string/app_name" android:roundIcon="@mipmap/ic_launcher_round" android:supportsRtl="true" android:theme="@style/AppTheme"> <activity android:name=".MainActivity"> <intent-filter> <action android:name="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> </application> </manifest>
//DBAdapter.java
package com.example.exp6; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteException; import android.database.sqlite.SQLiteOpenHelper; public class DBAdapter { private static final String DB_NAME = "student.db"; private static final String DB_TABLE = "students"; private static final int DB_VERSION = 1; public static final String KEY_ID = "_id"; public static final String KEY_NAME = "name"; public static final String KEY_CLASS = "class"; public static final String KEY_NUMBER = "number"; private SQLiteDatabase db; private final Context context; private DBOpenHelper dbOpenHelper; public DBAdapter(Context _context) { context = _context; } /** Close the database */ public void close() { if (db != null){ db.close(); db = null; } } /** Open the database */ public void open() throws SQLiteException { dbOpenHelper = new DBOpenHelper(context, DB_NAME, null, DB_VERSION); try { db = dbOpenHelper.getWritableDatabase(); } catch (SQLiteException ex) { db = dbOpenHelper.getReadableDatabase(); } } public long insert(Student student) { ContentValues newValues = new ContentValues(); newValues.put(KEY_NAME, student.Name); newValues.put(KEY_CLASS, student.Clas); newValues.put(KEY_NUMBER, student.Number); return db.insert(DB_TABLE, null, newValues); } public Student[] queryAllData() { Cursor results = db.query(DB_TABLE, new String[] { KEY_ID, KEY_NAME, KEY_CLASS, KEY_NUMBER}, null, null, null, null, null); return ConvertToStudent(results); } public Student[] queryOneData(long id) { Cursor results = db.query(DB_TABLE, new String[] { KEY_ID, KEY_NAME, KEY_CLASS, KEY_NUMBER}, KEY_ID + "=" + id, null, null, null, null); return ConvertToStudent(results); } private Student[] ConvertToStudent(Cursor cursor){ int resultCounts = cursor.getCount(); if (resultCounts == 0 || !cursor.moveToFirst()){ return null; } Student[] students = new Student[resultCounts]; for (int i = 0 ; i<resultCounts; i++){ students[i] = new Student(); students[i].ID = cursor.getInt(0); students[i].Name = cursor.getString(cursor.getColumnIndex(KEY_NAME)); students[i].Clas = cursor.getString(cursor.getColumnIndex(KEY_CLASS)); students[i].Number = cursor.getString(cursor.getColumnIndex(KEY_NUMBER)); cursor.moveToNext(); } return students; } public long deleteAllData() { return db.delete(DB_TABLE, null, null); } public long deleteOneData(int id) { return db.delete(DB_TABLE, KEY_ID + "=" + id, null); } public long updateOneData(long id , Student student){ ContentValues updateValues = new ContentValues(); updateValues.put(KEY_NAME, student.Name); updateValues.put(KEY_CLASS, student.Clas); updateValues.put(KEY_NUMBER, student.Number); return db.update(DB_TABLE, updateValues, KEY_ID + "=" + id, null); } private static class DBOpenHelper extends SQLiteOpenHelper { public DBOpenHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } private static final String DB_CREATE = "create table " + DB_TABLE + " (" + KEY_ID + " integer primary key autoincrement, " + KEY_NAME+ " text not null, " + KEY_CLASS+ " text not null," + KEY_NUMBER + " text not null);"; @Override public void onCreate(SQLiteDatabase _db) { _db.execSQL(DB_CREATE); } @Override public void onUpgrade(SQLiteDatabase _db, int _oldVersion, int _newVersion) { _db.execSQL("DROP TABLE IF EXISTS " + DB_TABLE); onCreate(_db); } } }
//MainActivity.java
package com.example.exp6; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.provider.ContactsContract; import android.view.ContextMenu; import android.view.MenuItem; import android.view.View; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.Toast; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class MainActivity extends Activity { private DBAdapter db; private Button bt_add; private EditText et_name; private EditText et_number; private EditText et_class; private ListView listview; private Student student; private int position; private SimpleAdapter simpleAdapter; Map<String, Object> item = new HashMap<String, Object>(); private List<Map<String, Object>> Datas = new ArrayList<Map<String, Object>>(); @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); bt_add = (Button) findViewById(R.id.bt_add); et_name = (EditText) findViewById(R.id.et_name); et_number = (EditText) findViewById(R.id.et_number); et_class = (EditText) findViewById(R.id.et_class); listview = findViewById(R.id.listview); this.registerForContextMenu(listview); db = new DBAdapter(MainActivity.this); db.open(); bt_add.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { String cl = et_class.getText().toString(); String num = et_number.getText().toString(); String na = et_name.getText().toString(); student = new Student(cl, num, na); long colunm = db.insert(student); // Map<String, Object> map = new HashMap<String, Object>(); // map.put("id",student.getID() ); // map.put("class", cl); // map.put("number", num); // map.put("name", na); // Datas.add(map); // simpleAdapter.notifyDataSetChanged(); Datas.clear(); //item.clear(); display(); Toast.makeText(MainActivity.this, "添加成功", Toast.LENGTH_SHORT).show(); } }); display(); // Map<String, Object> map1 = new HashMap<String, Object>(); // map1.put("class", "计算机162"); // map1.put("number", "2016012833"); // map1.put("name", "马梁"); // Datas.add(map1); // String[] from = {"class", "number", "name"}; // //Item布局文件中的子view的id的数组 // int[] to = {R.id.tv_class, R.id.tv_number, R.id.tv_name}; // // /设置适配器 // simpleAdapter = new SimpleAdapter(this, Datas, R.layout.item_view, from, to); // listview.setAdapter(simpleAdapter); } @Override public void onCreateContextMenu(ContextMenu menu, View v, ContextMenu.ContextMenuInfo menuInfo) { super.onCreateContextMenu(menu, v, menuInfo); //添加两个ITEM menu.add(0, 1, 0, "删除"); //得到长按的position AdapterView.AdapterContextMenuInfo info = (AdapterView.AdapterContextMenuInfo) menuInfo; position = info.position; } @Override public boolean onContextItemSelected(MenuItem item) { AdapterView.AdapterContextMenuInfo menuInfo = (AdapterView.AdapterContextMenuInfo) item.getMenuInfo(); int pos = (int) listview.getAdapter().getItemId(menuInfo.position); //得到对应的map对象 Map<String, Object> stu = Datas.get(pos); if(item.getItemId()==1) { //删除 //1). 删除数据表对应的数据 db.deleteOneData((Integer) stu.get("id")); //2). 删除List对应的数据 Datas.remove(pos); //3). 通知更新列表 simpleAdapter.notifyDataSetChanged(); Toast.makeText(MainActivity.this, "ID:" + stu.get("id") + "删除成功", Toast.LENGTH_SHORT).show(); } return super.onContextItemSelected(item); } public void display() { String[] from = {"id", "class", "number", "name"}; //Item布局文件中的子view的id的数组 int[] to = {R.id.tv_id, R.id.tv_class, R.id.tv_number, R.id.tv_name}; // /设置适配器 simpleAdapter = new SimpleAdapter(this, Datas, R.layout.item_view, from, to); listview.setAdapter(simpleAdapter); Student[] students = db.queryAllData(); if (students == null) { return; } String cl; String num; String na; int id; for (int i = 0; i < students.length; i++) { cl = students[i].getClas(); num = students[i].getNumber(); na = students[i].getName(); id = students[i].getID(); //Toast.makeText(MainActivity.this,cl+num+na,Toast.LENGTH_SHORT).show(); Map<String, Object> item = new HashMap<String, Object>(); item.put("id", id); item.put("class", cl); item.put("number", num); item.put("name", na); Datas.add(item); simpleAdapter.notifyDataSetChanged(); } } }
//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" android:orientation="vertical" tools:context=".MainActivity"> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="班级:" android:textSize="20sp" /> <EditText android:id="@+id/et_class" android:layout_width="150dp" android:layout_height="wrap_content" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="学号:" android:textSize="20sp" /> <EditText android:id="@+id/et_number" android:layout_width="150dp" android:layout_height="wrap_content" android:inputType="number" /> </LinearLayout> <LinearLayout android:layout_width="wrap_content" android:layout_height="wrap_content" android:orientation="horizontal"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="姓名:" android:textSize="20sp" /> <EditText android:id="@+id/et_name" android:layout_width="150dp" android:layout_height="wrap_content" /> </LinearLayout> <Button android:id="@+id/bt_add" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="添加" /> <LinearLayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="horizontal"> <TextView android:layout_width="0dp" android:layout_height="wrap_content" android:layout_weight="1" android:text="ID" android:gravity="center" android:textSize="20sp" /> <TextView android:layout_width="0dp" android:layout_height="wrap_content" android:layout_weight="1" android:text="班级" android:gravity="center" android:textSize="20sp" /> <TextView android:layout_width="0dp" android:layout_height="wrap_content" android:layout_weight="1" android:text="学号" android:gravity="center" android:textSize="20sp" /> <TextView android:layout_width="0dp" android:layout_height="wrap_content" android:layout_weight="1" android:text="姓名" android:gravity="center" android:textSize="20sp" /> </LinearLayout> <LinearLayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="horizontal"> <ListView android:id="@+id/listview" android:layout_width="match_parent" android:layout_height="match_parent"></ListView> </LinearLayout> </LinearLayout>
//item_view.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="horizontal"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:gravity="center" android:textSize="20sp" android:id="@+id/tv_id"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:textSize="20sp" android:id="@+id/tv_class"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:textSize="20sp" android:id="@+id/tv_number"/> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_weight="1" android:textSize="20sp" android:id="@+id/tv_name"/> </LinearLayout>