OrderDbString.java
1.29 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
package com.ectrip.cyt.db;
/**
* @author dengchen
* Created by 2016/9/14.
*/
public interface OrderDbString {
String NAME = "order.db";
int VERSION = 1;
/**
* 浏览历史表
*/
public interface TableHistroy {
String TABLE_NAME = "order";// 表名
String INVITASION_ID = "_id";//id自增
String INVITASION_ORDER = "orderid";//订单号
String INVITASION_PID = "pid";//流水号
/**
* 建表的sql
*/
String CREATE_TABLE_SQL = "create table " + TABLE_NAME + "("
+ INVITASION_ID + " integer primary key autoincrement,"
+ INVITASION_ORDER + " text,"
+ INVITASION_PID + " text,"
+ ")";
/**
* 根据传入的参数查询数据
*/
String QUERY_ALL_SQL = "select "
+ INVITASION_PID + ","
+ " from "
+ TABLE_NAME + " where "
+ INVITASION_ORDER + "=?";
/**
* 根据tid查询数据,判断是否执行插入操作
*/
String QUERY_IS_EXIST_SQL = "select "
+ INVITASION_ORDER + " from "
+ TABLE_NAME + " where "
+ INVITASION_ORDER + "=?";
}
}