接收到信号处理,
@SuppressLint("HandlerLeak")
private Handler mHandler = new Handler(){
@SuppressLint("MissingPermission")
@Override
public void handleMessage(Message msg) {
super.handleMessage(msg);
switch(msg.what){
case RECEIVE_SUCCESS: //接收成功
String receiveResult = (String) msg.obj;
weight.setText(receiveResult.substring(receiveResult.indexOf(":")+1,receiveResult.lastIndexOf("#"))+"g");
if (receiveResult.contains(",time1_on")){
s1.setChecked(true);
}
if (receiveResult.contains(",time1_off")){
s1.setChecked(false);
}
if (receiveResult.contains(",time2_on")){
s2.setChecked(true);
}
if (receiveResult.contains(",time2_off")){
s2.setChecked(false);
}
if (receiveResult.contains(",time3_on")){
s3.setChecked(true);
}
if (receiveResult.contains(",time3_off")){
s3.setChecked(false);
}
if (receiveResult.contains(",time4_on"))
s4.setChecked(true);
if (receiveResult.contains(",time4_off"))
s4.setChecked(false);
if (receiveResult.contains("time5_on"))
s5.setChecked(true);
if (receiveResult.contains("time5_off"))
s5.setChecked(false);
if (receiveResult.contains(",start")){
Calendar calendar=Calendar.getInstance();
Date d1=calendar.getTime();
calendar.add(Calendar.MINUTE,30);
Date d2=calendar.getTime();
SQLiteDatabase db=dataBase.getWritableDatabase();
ContentValues contentValues=new ContentValues();
contentValues.put(DataBase.COLUMN_ST,String.valueOf(d1));
db.insert(DataBase.TABLE2,null,contentValues);
TimerTask timerTask=new TimerTask() {
@Override
public void run() {
contentValues.put(DataBase.COLUMN_ET,String.valueOf(d2));
contentValues.put(DataBase.COLUMN_EW,Integer.valueOf(weight.getText().toString()));
}
};
Timer timer=new Timer(true);
timer.schedule(timerTask,d2);
if (String.valueOf(weight.getText())=="0"){
timer.cancel();
Date d3=calendar.getTime();
contentValues.put(DataBase.COLUMN_ET,String.valueOf(d3));
contentValues.put(DataBase.COLUMN_EW,0);
db.insert(DataBase.TABLE2,null,contentValues);
}
if(receiveResult.contains(",stop")){
contentValues.put(DataBase.COLUMN_SW,Integer.valueOf(weight.getText().toString()));
db.insert(DataBase.TABLE2,null,contentValues);
}
}
break;
}
数据库的记录表,已经创建好这个表的数据库,怎么加id,(ID只是为了让插入的数据在同一行,不用再listview上显示ID)
String sql2 = "create table " + TABLE2 + " ( " + COLUMN_ST + " text not null, " + COLUMN_SW + " integer(10), " + COLUMN_ET + " text not null, " + COLUMN_EW + " integer(10) ) ";