DBLocalHelper.java
3.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
package com.sunvote.xpadapp.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import com.sunvote.xpadapp.ConstantValues;
/**
* 数据库帮助类
* Created by wutaian on 2017/06/01.
*/
public class DBLocalHelper extends SQLiteOpenHelper {
private static final int VERSION = 1;
private static final String NAME = "audition.db";
private SQLiteDatabase db;
public DBLocalHelper(Context context) {
super(context, NAME, null, VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
//项目名称表
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_ITEM
+ "(ItemNum INTEGER,"+
"ItemName TEXT" + ")"); //项目名称
//综合项目规则表
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_ITEM_RULE
+ " (ItemNum INTEGER," +
"Rule INTEGER , " + //规则编号从1开始
"RuleType INTEGER," +//3自定义评议、4自定义评分
"ItemName TEXT" + ")");//项目名称
//评分规则表
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORE_RULE
+ " (ItemNum INTEGER," +
"Unit TEXT , " + //评分单位
"Min TEXT," +//最小值
"Max TEXT," +//最大值
"DefaultValue TEXT," +//默认值
"IntNum INTEGER," +//整数位
"DecNum INTEGER" + ")");//小数位
//评议规则表
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_EVALUATION_RULE
+ " (ItemNum INTEGER," +
"DefaultValue TEXT," + //默认值
"ItemName TEXT" + ")");//名称
//评分规则说明表
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORERULE_EXPLAIN
+ "(ItemNum INTEGER," +
"ScoreExplain TEXT" + ")");//项目描述
//历史记录
db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORE_HISTORY
+ " (CandidateNo TEXT NOT NULL, " + //考生编号
"GroupNo INTEGER," +//分组编号
"CourseNo TEXT , " + //科目编号
"ItemNo INTEGER , " + //项编号
"Score TEXT , " + //评分
"Remark TEXT , " + //备注项
"HistoryType TEXT , " + //历史记录表类型 1:单人单项历史记录 2:单人多项历史记录 3:多人单项历史记录 4:多人单项table历史记录 5:多人多项历史记录
"PRIMARY KEY(GroupNo,CourseNo,ItemNo,HistoryType)"+ ")");
/**
* 默认评分规则
*/
db.execSQL("INSERT INTO " + ConstantValues.TBL_SCORE_RULE + " VALUES ("+
"'"+ConstantValues.DefalutScoreRuleId +"'," +
"'r'," +
"'0'," +
"'100'," +
"'0'," +
"'3'," +
"'0'" +
")");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}