• 个人冲刺(四)——体温上报app(二阶段)


    冲刺任务:完成用户注册功能和数据库类

    RegisterActivity.java

    package com.example.helloworld;
    import android.content.Intent;
    import android.os.Bundle;
    import android.text.TextUtils;
    import android.view.View;
    import android.widget.Button;
    import android.widget.EditText;
    import android.widget.ImageView;
    import android.widget.LinearLayout;
    import android.widget.RelativeLayout;
    import android.widget.Toast;
    
    import androidx.appcompat.app.AppCompatActivity;
    /**
     * Created by littlecurl 2018/6/24
     */
    /**
     * 此类 implements View.OnClickListener 之后,
     * 就可以把onClick事件写到onCreate()方法之外
     * 这样,onCreate()方法中的代码就不会显得很冗余
     */
    public class RegisterActivity extends AppCompatActivity implements View.OnClickListener {
    
        private String realCode;
        private DBOpenHelper mDBOpenHelper;
        private Button mBtRegisteractivityRegister;
        private RelativeLayout mRlRegisteractivityTop;
        private ImageView mIvRegisteractivityBack;
        private LinearLayout mLlRegisteractivityBody;
        private EditText mEtRegisteractivityUsername;
        private EditText mEtRegisteractivityUserid;
        private EditText mEtRegisteractivityUserphone;
        private EditText mEtRegisteractivityUseraddress;
        private EditText mEtRegisteractivityPhonecodes;
        private ImageView mIvRegisteractivityShowcode;
        private RelativeLayout mRlRegisteractivityBottom;
    
        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_register);
    
            initView();
    
            mDBOpenHelper = new DBOpenHelper(this);
    
            //将验证码用图片的形式显示出来
            mIvRegisteractivityShowcode.setImageBitmap(Code.getInstance().createBitmap());
            realCode = Code.getInstance().getCode().toLowerCase();
        }
    
        private void initView(){
            mBtRegisteractivityRegister = findViewById(R.id.bt_registeractivity_register);
            mRlRegisteractivityTop = findViewById(R.id.rl_registeractivity_top);
            mIvRegisteractivityBack = findViewById(R.id.iv_registeractivity_back);
            mLlRegisteractivityBody = findViewById(R.id.ll_registeractivity_body);
            mEtRegisteractivityUsername = findViewById(R.id.et_registeractivity_name);
            mEtRegisteractivityUserid = findViewById(R.id.et_registeractivity_id);
            mEtRegisteractivityUserphone = findViewById(R.id.et_registeractivity_phone);
            mEtRegisteractivityUseraddress = findViewById(R.id.et_registeractivity_address);
            mEtRegisteractivityPhonecodes = findViewById(R.id.et_registeractivity_phoneCodes);
            mIvRegisteractivityShowcode = findViewById(R.id.iv_registeractivity_showCode);
            mRlRegisteractivityBottom = findViewById(R.id.rl_registeractivity_bottom);
    
            /**
             * 注册页面能点击的就三个地方
             * top处返回箭头、刷新验证码图片、注册按钮
             */
            mIvRegisteractivityBack.setOnClickListener(this);
            mIvRegisteractivityShowcode.setOnClickListener(this);
            mBtRegisteractivityRegister.setOnClickListener(this);
        }
    
        public void onClick(View view) {
            switch (view.getId()) {
                case R.id.iv_registeractivity_back: //返回登录页面
                    Intent intent1 = new Intent(this, loginActivity.class);
                    startActivity(intent1);
                    finish();
                    break;
                case R.id.iv_registeractivity_showCode:    //改变随机验证码的生成
                    mIvRegisteractivityShowcode.setImageBitmap(Code.getInstance().createBitmap());
                    realCode = Code.getInstance().getCode().toLowerCase();
                    break;
                case R.id.bt_registeractivity_register:    //注册按钮
                    //获取用户输入的用户名、密码、验证码
                    String username = mEtRegisteractivityUsername.getText().toString().trim();
                    String userid = mEtRegisteractivityUserid.getText().toString().trim();
                    String userphone = mEtRegisteractivityUserphone.getText().toString().trim();
                    String useraddress = mEtRegisteractivityUseraddress.getText().toString().trim();
                    String phoneCode = mEtRegisteractivityPhonecodes.getText().toString().toLowerCase();
                    //注册验证
                    if (!TextUtils.isEmpty(username) && !TextUtils.isEmpty(userid) && !TextUtils.isEmpty(phoneCode) && !TextUtils.isEmpty(userphone)
                            && !TextUtils.isEmpty(useraddress)    ) {
                        if (phoneCode.equals(realCode)) {
                            //将用户名和密码加入到数据库中
                            mDBOpenHelper.add(username, userid,userphone,useraddress);
                            Intent intent2 = new Intent(this, MainActivity.class);
                            startActivity(intent2);
                            finish();
                            Toast.makeText(this,  "验证通过,注册成功", Toast.LENGTH_SHORT).show();
                        } else {
                            Toast.makeText(this, "验证码错误,注册失败", Toast.LENGTH_SHORT).show();
                        }
                    }else {
                        Toast.makeText(this, "未完善信息,注册失败", Toast.LENGTH_SHORT).show();
                    }
                    break;
            }
        }
    }

     MyDBHelper.java

    package com.example.helloworld;
    
    import android.content.Context;
    import android.database.sqlite.SQLiteDatabase;
    import android.database.sqlite.SQLiteOpenHelper;
    import android.widget.Toast;
    
    import androidx.annotation.Nullable;
    
    public class MyDBHelper extends SQLiteOpenHelper {
        private Context context;
        public MyDBHelper(Context context,String name,int version) {
            super(context, name, null, version);
            this.context=context;
        }
    
        @Override
        public void onCreate(SQLiteDatabase db) {
            String sql="create table IF NOT EXISTS personwendu(id integer primary key autoincrement, address varchar, name varchar, wendu varchar, dateandtime varchar,more varchar)";
            db.execSQL(sql);
            Toast.makeText(context,"数据加入成功",Toast.LENGTH_LONG).show();
        }
    
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        }
    }

     DBOpenHelper.java

    package com.example.helloworld;
    
    import android.content.Context;
    import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    import android.database.sqlite.SQLiteOpenHelper;
    import android.util.Log;
    
    import java.util.ArrayList;
    
    public class DBOpenHelper extends SQLiteOpenHelper {
        /**
         * 声明一个AndroidSDK自带的数据库变量db
         */
        private SQLiteDatabase db;
    
        /**
         * 写一个这个类的构造函数,参数为上下文context,所谓上下文就是这个类所在包的路径
         * 指明上下文,数据库名,工厂默认空值,版本号默认从1开始
         * super(context,"db_test",null,1);
         * 把数据库设置成可写入状态,除非内存已满,那时候会自动设置为只读模式
         * 不过,以现如今的内存容量,估计一辈子也见不到几次内存占满的状态
         * db = getReadableDatabase();
         */
        public DBOpenHelper(Context context){
            super(context,"db_test",null,1);
            db = getReadableDatabase();
        }
    
        /**
         * 重写两个必须要重写的方法,因为class DBOpenHelper extends SQLiteOpenHelper
         * 而这两个方法是 abstract 类 SQLiteOpenHelper 中声明的 abstract 方法
         * 所以必须在子类 DBOpenHelper 中重写 abstract 方法
         * 想想也是,为啥规定这么死必须重写?
         * 因为,一个数据库表,首先是要被创建的,然后免不了是要进行增删改操作的
         * 所以就有onCreate()、onUpgrade()两个方法
         * @param db
         */
        @Override
        public void onCreate(SQLiteDatabase db){
            db.execSQL("CREATE TABLE IF NOT EXISTS user(" +
                    "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                    "username TEXT," +
                    "userid TEXT,"+
                    "userphone TEXT,"+
                    "useraddress TEXT)"
            );
        }
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
            db.execSQL("DROP TABLE IF EXISTS user");
            onCreate(db);
        }
        /**
         * 接下来写自定义的增删改查方法
         * 这些方法,写在这里归写在这里,以后不一定都用
         * add()
         * delete()
         * update()
         * getAllData()
         */
        public void add(String username,String userid,String userphone,String useraddress){
            db.execSQL("INSERT INTO user (username,userid,userphone,useraddress) VALUES(?,?,?,?)",
                    new Object[]{username,userid,userphone,useraddress});
        }
        public void delete(String userphone){
            db.execSQL("DELETE FROM user WHERE userphone = "+userphone);
        }
        public void updata(String userphone){
            db.execSQL("UPDATE user SET userphone = ?",new Object[]{userphone});
        }
    
        /**
         * 前三个没啥说的,都是一套的看懂一个其他的都能懂了
         * 下面重点说一下查询表user全部内容的方法
         * 我们查询出来的内容,需要有个容器存放,以供使用,
         * 所以定义了一个ArrayList类的list
         * 有了容器,接下来就该从表中查询数据了,
         * 这里使用游标Cursor,这就是数据库的功底了,
         * 在Android中我就不细说了,因为我数据库功底也不是很厚,
         * 但我知道,如果需要用Cursor的话,第一个参数:"表名",中间5个:null,
         *                                                     最后是查询出来内容的排序方式:"name DESC"
         * 游标定义好了,接下来写一个while循环,让游标从表头游到表尾
         * 在游的过程中把游出来的数据存放到list容器中
         * @return
         */
        public ArrayList<User> getAllData(){
    
            ArrayList<User> list = new ArrayList<User>();
            Cursor cursor = db.query("user",null,null,null,null,null,"username DESC");
            cursor.moveToFirst();
            while(cursor.moveToNext()){
                String username = cursor.getString(cursor.getColumnIndex("username"));
                String userid = cursor.getString(cursor.getColumnIndex("userid"));
                String userphone = cursor.getString(cursor.getColumnIndex("userphone"));
                String useraddress = cursor.getString(cursor.getColumnIndex("useraddress"));
                list.add(new User(username,userid,userphone,useraddress));
            }
            Log.v("输出数据库查询结果:",list.toString());
            return list;
        }
    }
  • 相关阅读:
    HDU--1212大数取模
    欧拉函数
    自制体重转换器
    常用快捷键
    Markdown基本语法
    python全栈开发day50-jquery之ajax、XmlHttpRquest
    python全栈开发day49-jquery的位置信息、事件流、事件对象,事件委托,事件绑定和解绑
    阳历转阴历算法
    python全栈开发day48-jqurey自定义动画,jQuery属性操作,jQuery的文档操作,jQuery中的ajax
    python全栈开发day47-jqurey
  • 原文地址:https://www.cnblogs.com/zyj3955/p/14872810.html
Copyright © 2020-2023  润新知