• 第七周


    <?xml version="1.0" encoding="UTF-8"?>
    
    <LinearLayout android:padding="16dp" android:orientation="vertical" android:background="@drawable/bg" android:layout_height="match_parent" android:layout_width="match_parent" xmlns:android="http://schemas.android.com/apk/res/android">
    
    
        <LinearLayout android:layout_height="wrap_content" android:layout_width="match_parent" android:layout_marginTop="130dp">
    
            <TextView android:layout_height="wrap_content" android:layout_width="wrap_content" android:textSize="18sp" android:text="姓 名 :"/>
    
            <EditText android:layout_height="wrap_content" android:layout_width="match_parent" android:textSize="16sp" android:hint="请输入姓名" android:id="@+id/et_name"/>
    
        </LinearLayout>
    
    
        -<LinearLayout android:layout_height="wrap_content" android:layout_width="match_parent" android:layout_marginBottom="10dp">
    
        <TextView android:layout_height="wrap_content" android:layout_width="wrap_content" android:textSize="18sp" android:text="年 龄:"/>
    
        <EditText android:layout_height="wrap_content" android:layout_width="match_parent" android:textSize="16sp" android:hint="输入年龄" android:id="@+id/et_age"/>
    
    </LinearLayout>
    
    
        -<LinearLayout android:layout_height="wrap_content" android:layout_width="match_parent">
    
        <Button android:background="#B9B9FF" android:layout_height="wrap_content" android:layout_width="0dp" android:textSize="18sp" android:text="添加" android:id="@+id/btn_add" android:onClick="add" android:layout_weight="1" android:layout_marginRight="2dp"/>
    
        <Button android:background="#DCB5FF" android:layout_height="wrap_content" android:layout_width="0dp" android:textSize="18sp" android:text="查询" android:id="@+id/btn_query" android:onClick="search" android:layout_weight="1" android:layout_marginRight="2dp"/>
    
        <Button android:background="#E6CAFF" android:layout_height="wrap_content" android:layout_width="0dp" android:textSize="18sp" android:text="修改" android:id="@+id/btn_update" android:onClick="update" android:layout_weight="1" android:layout_marginRight="2dp"/>
    
        <Button android:background="#ACD6FF" android:layout_height="wrap_content" android:layout_width="0dp" android:textSize="18sp" android:text="删除" android:id="@+id/btn_delete" android:onClick="delete" android:layout_weight="1"/>
    
    </LinearLayout>
    
    
        -<ScrollView android:layout_height="wrap_content" android:layout_width="match_parent">
    
        <TextView android:layout_height="wrap_content" android:layout_width="match_parent" android:layout_marginTop="25dp" android:textSize="20sp" android:id="@+id/tv_show"/>
    
    </ScrollView>
    
    </LinearLayout>
    import android.annotation.SuppressLint;
    import android.os.Bundle;
    import android.app.Activity;
    import android.content.ContentValues;
    import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    import android.view.Menu;
    import android.view.View;
    import android.widget.EditText;
    import android.widget.TextView;
    import android.widget.Toast;
    
    public class MainActivity extends Activity {
    
        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);
        }
    
        @SuppressLint("WrongConstant")
        public void add(View v) {
            StuOpenHelper helper = new StuOpenHelper(this);
            SQLiteDatabase db = helper.getWritableDatabase();
            String name = ((EditText) findViewById(R.id.et_name)).getText()
                    .toString();
            int age = Integer.parseInt(((EditText) findViewById(R.id.et_age))
                    .getText().toString());
    
            // 原生sql操作,
            // db.execSQL("insert into stuinfo (name,age) values('lisi',22)");
            // db.execSQL("insert into stuinfo (name,age) values(?,?)",new
            // Object[]{"kitty",30});
            db.execSQL("insert into stuinfo (name,age) values(?,?)", new Object[] {
                    name, age });
            Toast.makeText(this, "ok", 0).show();
    
        }
    
        public void delete(View view) {
            StuOpenHelper helper = new StuOpenHelper(this);
            SQLiteDatabase db = helper.getWritableDatabase();
            db.execSQL("delete from stuinfo where _id=?", new Object[] { 2 });
            Toast.makeText(this, "删除成功", 0).show();
    
        }
    
        @SuppressLint("WrongConstant")
        public void update(View view) {
            StuOpenHelper helper = new StuOpenHelper(this);
            SQLiteDatabase db = helper.getWritableDatabase();
            db.execSQL("update stuinfo set name=? where _id=?", new Object[] {
                    "micky", 3 });
            Toast.makeText(this, "修改成功", 0).show();
    
        }
    
        public void search(View view) {
            StuOpenHelper helper = new StuOpenHelper(this);
            SQLiteDatabase db = helper.getWritableDatabase();
            String s = "";
            Cursor cursor = db.rawQuery("select * from stuinfo", null);
            if (cursor.getCount() != 0) {
    
                while (cursor.moveToNext()) {
                    s += cursor.getInt(0) + "   " + cursor.getString(1) + "   "
                            + cursor.getInt(2) + "
    ";
                }
            }
    
            // Toast.makeText(this, s, 0).show();
            ((TextView) (findViewById(R.id.tv_show))).setText(s);
    
        }
    
    }
    import android.content.Context;
    import android.database.sqlite.SQLiteDatabase;
    import android.database.sqlite.SQLiteDatabase.CursorFactory;
    import android.database.sqlite.SQLiteOpenHelper;
    
    public class StuOpenHelper extends SQLiteOpenHelper {
    
        public StuOpenHelper(Context context) {
            super(context, "stu.db", null, 1);
            // TODO Auto-generated constructor stub
        }
    
        @Override
        public void onCreate(SQLiteDatabase db) {
            // TODO Auto-generated method stub
            db.execSQL("create table stuinfo(_id integer primary key autoincrement,name varchar(20),age integer)");
    
        }
    
        @Override
        public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
            // TODO Auto-generated method stub
    
        }
    
    }
  • 相关阅读:
    组合和继承
    解决不了问题
    [zz]shared_ptr 在 stl容器中排序的陷阱
    char ** 初始化
    [zz]c++ list sort方法
    [zz]ZeroMQ的学习和研究
    shared_prt自己使用记录
    rapidxml使用笔记
    HDOJ_ACM_I love sneakers!
    HDOJ_ACM_PiggyBank
  • 原文地址:https://www.cnblogs.com/z118127/p/14164381.html
Copyright © 2020-2023  润新知