安卓数据管理mysql_Android高级-Android操作SQL数据管理，增删改查

1 packagewuxianedu.com.sqllistview;2

3 importandroid.content.Context;4 importandroid.content.DialogInterface;5 importandroid.content.Intent;6 importandroid.support.v7.app.AlertDialog;7 importandroid.view.LayoutInflater;8 importandroid.view.View;9 importandroid.view.ViewGroup;10 importandroid.widget.BaseAdapter;11 importandroid.widget.Button;12 importandroid.widget.TextView;13 importandroid.widget.Toast;14

15 importjava.util.List;16

17 importwuxianedu.com.sqllistview.DB.DBauxiliary;18

19 /**

20 * Created by Administrator on 2016/9/20.21 */

22 public class MainAdapter extendsBaseAdapter {23 privateContext context;24 private List list;//接收数据的LIST

25 private DBauxiliary db;//数据库操作类的实例26 //适配器

27 public MainAdapter(Context context,Listlist){28 this.context =context;29 this.list =list;30 }31 //更新集合用

32 public void setList(Listlist) {33 this.list =list;34 notifyDataSetChanged();35 }36

37 @Override38 public intgetCount() {39 returnlist.size();40 }41

42 @Override43 public Object getItem(intposition) {44 returnlist.get(position);45 }46

47 @Override48 public long getItemId(intposition) {49 returnposition;50 }51

52 @Override53 public View getView(final intposition, View convertView, ViewGroup parent) {54 finalHUi hui;55 if(convertView == null){56 hui = newHUi();57 final intwo ;58 wo =position;59 db =DBauxiliary.getInstance(context);60 convertView = LayoutInflater.from(context).inflate(R.layout.item_lie, null);61 hui.name =(TextView) convertView.findViewById(R.id.tv_name);62 hui.age =(TextView) convertView.findViewById(R.id.tv_age);63 hui.sex =(TextView) convertView.findViewById(R.id.tv_sex);64 hui.update =(Button) convertView.findViewById(R.id.but_name);65 hui.delete =(Button) convertView.findViewById(R.id.but_delete);66

67 //

68 //修改按钮

69 hui.update.setOnClickListener(newView.OnClickListener() {70 @Override71 public voidonClick(View v) {72 Intent intent = new Intent(context,UpdateActivity.class);73 int on = (int) hui.update.getTag();74 JavaBean javabean =list.get(on);75 intent.putExtra("name",javabean);76 context.startActivity(intent);77

78 }79 });80 convertView.setTag(hui);81 }else{82 hui =(HUi) convertView.getTag();83 }84

85 final JavaBean java =list.get(position);86 hui.update.setTag(position);87 hui.name.setText(java.getName());88 hui.age.setText(String.valueOf(java.getAge()));89 hui.sex.setText(java.getSex());90 final String naaa =java.getName();91 //构建删除对话框

92 hui.delete.setOnClickListener(newView.OnClickListener() {93 @Override94 public voidonClick(View v) {95 AlertDialog.Builder builder = newAlertDialog.Builder(context);96 builder.setMessage("确定删除吗？");97 builder.setPositiveButton("取消",null);98 builder.setNegativeButton("确定", newDialogInterface.OnClickListener() {99 @Override100 public void onClick(DialogInterface dialog, intwhich) {101 db.delete(naaa);102 list =db.select();103 setList(list);104 notifyDataSetChanged();105 Toast.makeText(context,"删除成功",Toast.LENGTH_SHORT).show();106 }107 }).show();108

109 }110 });111 returnconvertView;112 }113

114 classHUi {115 TextView name,age,sex;116 Button update,delete;117 }118 }