package com.delivery;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DB_Open extends SQLiteOpenHelper {
static String name = "db_user";
static CursorFactory factory = null;
static int version = 1;
/** Called when the activity is first created. */
public DB_Open(Context context) {
super(context, name, factory, version);
// TODO Auto-generated method stub
}
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query = "CREATE TABLE account (" +
"_id INTEGER PRIMARY KEY autoincrement," +
"price INTEGER NOT NULL DEFAULT(0)," +
"savetime DATETIME DEFAULT(date('now')))";
db.execSQL(query);
}
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
String query = "DROP TABLE IF EXISTS db_user";
db.execSQL(query);
onCreate(db);
}
}
Button btnDone = (Button)findViewById(R.id.done);
btnDone.setOnClickListener(new Button.OnClickListener(){
public void onClick(View v){
EditText price = (EditText)findViewById(R.id.price);
String getprice = price.getText().toString();
int getPrice = Integer.valueOf(getprice);
ContentValues row = new ContentValues();
row.put("price", getPrice);
db.insert("account", null, row);
}
});
데이터베이스 생성하고 테이블 만들고 데이터 입력했는데
cmd 로 확인해보니 splite를 찾을수 없다고 나옵니다.
에러도 안잡히고.... 뭘 확인해야할까요?