public class DatabaseHelper extends SQLiteOpenHelper {
private static final int DATABASE_VERSION=1;
private static final String DATABASE_NAME="Original";
private static final String TABLE_NAME="Register";
private static final String COLUMN_ID="id";
private static final String COLUMN_UNAME="name";
//private static final String COLUMN_EMAIL="email";
private static final String COLUMN_PHONENUMBER="number";
private static final String COLUMN_PASSWORD="password";
public DatabaseHelper(Context mcontext)
{
super(mcontext , DATABASE_NAME , null , DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
String CREATE_REGISTER_TABLE = " CREATE TABLE " + TABLE_NAME + " ("
+ COLUMN_ID + " INTEGER PRIMARY KEY, "
+ COLUMN_UNAME + " TEXT, "
+ COLUMN_PHONENUMBER + " TEXT, "
+ COLUMN_PASSWORD + " TEXT " + ") ";
db.execSQL(CREATE_REGISTER_TABLE);
}
public void insertContact(Original c)
{
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
//String query="SELECT * FROM "+TABLE_NAME;
//Cursor cursor = db.rawQuery(query,null);
// int count=cursor.getCount();
values.put(COLUMN_ID,c.getID());
values.put(COLUMN_UNAME,c.getName());
//values.put(COLUMN_EMAIL,c.getEmail());
values.put(COLUMN_PASSWORD,c.getPassw());
values.put(COLUMN_PHONENUMBER,c.getNumber());
db.insert(TABLE_NAME , null , values);
db.close();
}
public String searchPass(String name)
{
SQLiteDatabase db = this.getReadableDatabase();
String query="SELECT "+COLUMN_UNAME + "AND " +COLUMN_PASSWORD +"FROM "+TABLE_NAME;
Cursor mCursor=db.rawQuery(query , null);
String a,b;
b="not found";
if(mCursor.moveToFirst())
{
do
{
a=mCursor.getString(0);
if(a.equals(name))
{
b=mCursor.getString(1);
break;
}
}
while(mCursor.moveToNext());
}
return b;
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1)
{
String query="DROP TABLE IF EXITS"+TABLE_NAME;
db.execSQL(query);
onCreate(db);
}
}
一个错误的错误显示在db.insert()操作。 的主要目的是将细节添加到数据库名称原始和表名注册我做Android Studio中的一个小项目,我使用SQLite。有附近的插入操作
+2
请发表您的logcat –
+3
“的错误显示在db.insert()操作” - 如果你的意思是你的应用程序崩溃,请编辑您的问题和后与崩溃相关的整个Java堆栈跟踪。请注意,在单个操作(例如'insertContact()')之后关闭数据库通常不是一个好计划,因为应用程序中的其他线程可能依赖于打开的数据库。 –