基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

package com.android.database;

import java.util.List;
  import android.app.Activity;
  import android.os.Bundle;
  import android.view.View;
 import android.view.View.OnClickListener;
 import android.widget.Button;
 import android.widget.EditText;
 import android.widget.TextView;
 import android.widget.Toast;
 
 public class mainActivity extends Activity {
     Button btn_createdb,btn_insert,btn_show,btn_update,btn_showall,deleteusertable;
     EditText username,password;
     TextView showsomething;
     
     @Override
     public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.main);
         init();
     }
     
     public void init(){
         username = (EditText) findViewById(R.id.username);
         password = (EditText) findViewById(R.id.password);
         btn_createdb = (Button) findViewById(R.id.btn_create);
         btn_insert = (Button) findViewById(R.id.btn_insert);
         btn_show = (Button) findViewById(R.id.btn_show);
         btn_update = (Button) findViewById(R.id.btn_update);
         deleteusertable = (Button) findViewById(R.id.btn_deleteusertable);
         btn_showall= (Button) findViewById(R.id.btn_showall);
         showsomething = (TextView) findViewById(R.id.showsomething);
         
        btn_createdb.setOnClickListener(listener);
         btn_insert.setOnClickListener(listener);
         btn_createdb.setOnClickListener(listener);
         btn_show.setOnClickListener(listener);
         btn_update.setOnClickListener(listener);
         btn_showall.setOnClickListener(listener);
         deleteusertable.setOnClickListener(listener);
     }
     
     public OnClickListener listener = new OnClickListener() {
         @Override
         public void onClick(View v) {
             Button button = (Button) v;
             if(button.getId()==btn_createdb.getId()){
                 try {
                    DBUtil.createOrOpenDatabase(); 
                } catch (Exception e) {
                     e.printStackTrace();
                 }
             }else if(button.getId()==btn_insert.getId()){
                 String sql="insert into user values ('" username.getText() "','" password.getText() "')";
                 DBUtil.updatetable(sql);
             }else if(button.getId()==btn_show.getId()){
                 List<String>user = DBUtil.searchuser(username.getText().toString());
                 showsomething.setText(user.toString());
             }else if(button.getId()==btn_update.getId()){
                 String sql="update user set username='" username.getText() "',password='" password.getText() "' where username = '" username.getText() "'";
                 System.out.println(sql);
                 DBUtil.updatetable(sql);
             }else if(button.getId()==btn_showall.getId()){
                 List<String>users = DBUtil.searchalluser();
                 showsomething.setText(users.toString());
             }else if(button.getId()==deleteusertable.getId()){
                 DBUtil.droptable();
                 Toast.makeText(getApplicationContext(), "用户表删除成功", Toast.LENGTH_SHORT).show();
             }
         }
     };
 }