作业9

 

 

 

 

 

 

 

 

package com.example.z10;

import com.example.z10.R;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
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 implements View.OnClickListener {
    MyHelper myHelper;
       private EditText mEtName;
       private EditText mEtPhone;
       private TextView mTvShow;
       private Button mBtnAdd;
       private Button mBtnQuery;
       private Button mBtnUpdate;
       private  Button mBtnDelete;
       @Override
       protected void onCreate(Bundle savedInstanceState) {
           super.onCreate(savedInstanceState);
           setContentView(R.layout.activity_main);
           myHelper=new MyHelper(this);
           init();
       }
       private void init(){
           mEtName=(EditText)findViewById(R.id.et1);  
           mEtPhone=(EditText)findViewById(R.id.et2);
           mTvShow=(TextView)findViewById(R.id.tv1);
           mBtnAdd=(Button)findViewById(R.id.bt1);
           mBtnQuery=(Button)findViewById(R.id.bt2);
           mBtnUpdate=(Button)findViewById(R.id.bt3);
           mBtnDelete=(Button)findViewById(R.id.bt4);
           mBtnAdd.setOnClickListener(this);
           mBtnQuery.setOnClickListener(this);
           mBtnUpdate.setOnClickListener(this);
           mBtnDelete.setOnClickListener(this);
       }
       public void onClick(View view){
           String name,phone;
           SQLiteDatabase db;
           ContentValues values;
           switch (view.getId()){
               case R.id.bt1:
                   name=mEtName.getText().toString();
                   phone=mEtPhone.getText().toString();
                   db=myHelper.getWritableDatabase();
                   values=new ContentValues();
                   values.put("name",name);
                   values.put("phone",phone);
                   db.insert("information",null,values);
                   Toast.makeText(this,"信息已添加",Toast.LENGTH_LONG).show();
                   db.close();
                   break;
               case R.id.bt2:
                   db=myHelper.getReadableDatabase();
                   Cursor cursor=db.query("information",null,null,null,null,null,null);
                   if (cursor.getCount()==0){
                       mTvShow.setText("");
                       Toast.makeText(this,"没有数据",Toast.LENGTH_LONG).show();
                   }else {
                       cursor.moveToFirst();
                       mTvShow.setText("Name:"+cursor.getString(1)+"Tel:"+cursor.getString(2));
                   }
                   while (cursor.moveToNext()){
                       mTvShow.append("\n"+"Name:"+cursor.getString(1)+"Tel:"+cursor.getString(2));
                   }
                   cursor.close();
                   db.close();
                   break;
               case R.id.bt3:
                   db=myHelper.getWritableDatabase();
                   values=new ContentValues();
                   values.put("phone",phone=mEtPhone.getText().toString());
                   db.update("information",values,"name=?",new String[]{mEtName.getText().toString()});
                   Toast.makeText(this,"信息已修改",Toast.LENGTH_LONG).show();
                   db.close();
                   break;
               case R.id.bt4:
                   db=myHelper.getWritableDatabase();
                   db.delete("information","name=?",new String[]{mEtName.getText().toString()});
                   Toast.makeText(this,"信息已删除",Toast.LENGTH_LONG).show();
                   mTvShow.setText("");
                   db.close();
                   break;
           }
       }
       class MyHelper extends SQLiteOpenHelper{
           public MyHelper(Context context){
               super(context,"itcast.db",null,1);
           }
           public void onCreate(SQLiteDatabase db){
               db.execSQL("CREATE TABLE information(_id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(20),phone VARCHAR(20))");
           }
           public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){

           }
       }
   }

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.example.z10.MainActivity" >

    <TextView
        android:id="@+id/textView1"
        android:layout_width="70dp"
        android:layout_height="35dp"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="59dp"
        android:textSize="22sp"
        android:text="姓名:" />

    <TextView
        android:id="@+id/textView2"
        android:layout_width="70dp"
        android:layout_height="35dp"
        android:layout_alignLeft="@+id/textView1"
        android:layout_below="@+id/textView1"
        android:layout_marginTop="15dp"
        android:textSize="22sp"
        android:text="电话：" />

    <EditText
        android:id="@+id/et1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
       android:layout_marginTop="59dp"
        android:ems="10"
        android:hint="请输入姓名" />

    <EditText
        android:id="@+id/et2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="110dp"
        android:ems="10"
        android:hint="请输入电话号码" />

    <Button
        android:id="@+id/bt1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginLeft="0dp"
        android:layout_centerVertical="true"
        android:textSize="18sp"
        android:background="#b9b9ff"
        android:onClick="click"
        android:text="添加" />

    <Button
        android:id="@+id/bt2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
         android:layout_marginLeft="70dp"
        android:layout_centerVertical="true"
        android:textSize="18sp"
        android:background="#dcb5ff"
        android:onClick="click"
        android:text="查询" />

    <Button
        android:id="@+id/bt3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerVertical="true"
        android:layout_marginLeft="140dp"
        android:textSize="18sp"
        android:background="#e6caff"
        android:onClick="click"
        android:text="修改" />

    <Button
        android:id="@+id/bt4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerVertical="true"
        android:layout_marginLeft="210dp"
        android:textSize="18sp"
        android:background="#acd6ff"
        android:onClick="    click"
        android:text="删除" />
   <TextView
      android:id="@+id/tv1"
       android:layout_width="wrap_content"
       android:layout_height="wrap_content"
       android:layout_marginTop="25dp"
       android:textSize="20sp"/>
</RelativeLayout>