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;
}
}