package com.kaixinbook.helper;
import java.text.SimpleDateFormat;
import java.util.Date;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class UpdateDate extends SQLiteOpenHelper {
private static String DATABASE_NAME = "book.db";
private static int DATABASE_VERSION = 1;
public UpdateDate(Context context ) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql2="create table if not exists updateDte( updatename text not null,updatedate text not null);";
db.execSQL(sql2);
}
public void updateData(SQLiteDatabase db)
{
deleteData(db);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//
String sql2=" insert into updateDte (updatename,updatedate) values('update','"+sdf.format(new Date())+"')";
db.execSQL(sql2);
}
public void deleteData(SQLiteDatabase db)
{
String sql2="delete from updateDte;";
db.execSQL(sql2);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}
import java.text.SimpleDateFormat;
import java.util.Date;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class UpdateDate extends SQLiteOpenHelper {
private static String DATABASE_NAME = "book.db";
private static int DATABASE_VERSION = 1;
public UpdateDate(Context context ) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql2="create table if not exists updateDte( updatename text not null,updatedate text not null);";
db.execSQL(sql2);
}
public void updateData(SQLiteDatabase db)
{
deleteData(db);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//
String sql2=" insert into updateDte (updatename,updatedate) values('update','"+sdf.format(new Date())+"')";
db.execSQL(sql2);
}
public void deleteData(SQLiteDatabase db)
{
String sql2="delete from updateDte;";
db.execSQL(sql2);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}