栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

数据库的记账本

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

数据库的记账本

package com.example.myfinancier;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class DateBase extends SQLiteOpenHelper{

    private static SQLiteDatabase db_user,db_user_write,db_income_write,db_income_read,db_outcome_write,db_outcome_read,db_bianqian_write,db_bianqian_read,db_tubiao;

    //创建数据库
    public DateBase(Context context) {
        super(context, "my_financier_db", null, 1);


        db_user = getReadableDatabase();
        db_user_write=getWritableDatabase();

        db_income_write=getWritableDatabase();
        db_income_read=getReadableDatabase();

        db_outcome_write=getWritableDatabase();
        db_outcome_read=getReadableDatabase();

        db_bianqian_write= getWritableDatabase();
        db_bianqian_read=getReadableDatabase();

        db_tubiao=getWritableDatabase();

    }

            //创建数据表
            @Override
            public void onCreate(SQLiteDatabase db) {
                db.execSQL("CREATE TABLE IF NOT EXISTS user(" +
                       "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                       "name TEXT UNIQUE," +
                     "password TEXT)");

                db.execSQL("CREATE TABLE IF NOT EXISTS income(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                        "money Float ," +
                        "time String ," +
                        "type String ," +
                        "fukuanren String ," +
                        "beizhu String ," +
                        "username String)");

                db.execSQL("CREATE TABLE IF NOT EXISTS outcome(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                        "money Float ," +
                        "time String ," +
                        "type String ," +
                        "shoukuanren String ," +
                        "beizhu String ," +
                        "username String)");

              //  db.execSQL("CREATE TABLE IF NOT EXISTS bianqian(" +
                 //       "_id INTEGER PRIMARY KEY AUTOINCREMENT," +

               //         "message String ," +
                //        "username String)");

            }

            @Override
            public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
                 db.execSQL("DROP TABLE IF EXISTS user");
                 db.execSQL("DROP TABLE IF EXISTS income");
                db.execSQL("DROP TABLE IF EXISTS outcome");
                db.execSQL("DROP TABLE IF EXISTS bianqian");
                 onCreate(db);
            }


        //插入用户
        public void add_user (String name, String password){
            db_user.execSQL("INSERT INTO user (name,password) VALUES(?,?)", new Object[]{name, password});
        }

        //更新用户密码
        public void update_user (String password, String name ){
            db_user_write.execSQL("UPDATE user SET password = ? WHERe name=? ", new Object[]{password,name});
        }


        //插入收入信息
    public void add_income (Float money, String time,String type,String fukuanren,String beizhu,String username){
        db_income_write.execSQL("INSERT INTO income (money,time,type,fukuanren,beizhu,username) VALUES(?,?,?,?,?,?)", new Object[]{money, time,type,fukuanren,beizhu,username});
    }


    //插入支出信息
    public void add_outcome (Float money, String time,String type,String shoukuanren,String beizhu,String username){
        db_outcome_write.execSQL("INSERT INTO outcome (money,time,type,shoukuanren,beizhu,username) VALUES(?,?,?,?,?,?)", new Object[]{money, time,type,shoukuanren,beizhu,username});
    }




    //用于验证注册时候验证用户名是否使用过
        public static ArrayList getAllData () {

            ArrayList list = new ArrayList();
            Cursor cursor = db_user.query("user", null, null, null, null, null, "name DESC");
            while (cursor.moveToNext()) {
                String name = cursor.getString(cursor.getColumnIndex("name"));
                String password = cursor.getString(cursor.getColumnIndex("password"));
                list.add(new User(name, password));
            }
            return list;
        }
}
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/936759.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号