Here today i am Learned SQlite for Insert and View the Insereted Records..When click the Save button i got the error "Unfortunately AppName Was Stopped" plz Help
SqliteDatabase Helper
public class SqliteDatabaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME="reg";
public static final String TABLE_NAME="user_details";
public static final String COLUMN_ID="id";
public static final String COLUMN_NAME="name";
public static final String COLUMN_EMAIL="email";
public static final String COLUMN_UNAME="uname";
public static final String COLUMN_PASSWORD="pass";
public static final int DATABASE_VERSION=1;
public SqliteDatabaseHelper(Context context){
super(context,DATABASE_NAME,null,DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql="CREATE TABLE"+TABLE_NAME+"("+COLUMN_ID+"INTEGER PRIMARY KEY AUTO INCREMENT"+COLUMN_NAME+"VARCHAR"+COLUMN_EMAIL+"VARCHAR"
+COLUMN_UNAME+"VARCHAR"+COLUMN_PASSWORD+"VARCHAR);";
db.execSQL(sql);
Log.d("create","Table Created Sucessfully");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String sql="DROP TABLE IF EXIST user_details ";
db.execSQL(sql);
onCreate(db);
}
public boolean adduser(String name,String email,String uname,String pass)
{
SQLiteDatabase db=this.getWritableDatabase();
ContentValues contentValues=new ContentValues();
contentValues.put(COLUMN_NAME,name);
contentValues.put(COLUMN_EMAIL,email);
contentValues.put(COLUMN_UNAME,uname);
contentValues.put(COLUMN_PASSWORD,pass);
db.insert(TABLE_NAME, null, contentValues);
db.close();
return true;
}
public Cursor getuser(int id)
{
SQLiteDatabase db=this.getReadableDatabase();
String sql="SELECT * FROM user_details WHERE id="+id+"; ";
Cursor cursor= db.rawQuery(sql,null);
return cursor;
}
MainActivity
enter code herepublic class MainActivity extends AppCompatActivity implements View.OnClickListener{
private EditText edname;
private EditText edemail;
private EditText eduname;
private EditText edpass;
private Button bsave;
private Button bview;
SqliteDatabaseHelper db;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
edname= (EditText) findViewById(R.id.fullname);
edemail= (EditText) findViewById(R.id.email);
eduname= (EditText) findViewById(R.id.uname);
edpass= (EditText) findViewById(R.id.pass);
bsave= (Button) findViewById(R.id.save);
bview= (Button) findViewById(R.id.view);
db= new SqliteDatabaseHelper(this);
bsave.setOnClickListener(this);
bview.setOnClickListener(this);
} @Override
public void onClick(View v) {
if (v==bsave){
insert();
}
if (v==bview){
Intent intent= new Intent(MainActivity.this,ViewUser.class);
startActivity(intent);
}
}
public void insert() {
String name=edname.getText().toString().trim();
String email=edemail.getText().toString().trim();
String unmae=eduname.getText().toString().trim();
String upass=edpass.getText().toString().trim();
db.adduser(name,email,unmae,upass);
Toast.makeText(this,"New REcords Inserted Sucessfully",Toast.LENGTH_LONG).show();
}
ViewUser
public class ViewUser extends AppCompatActivity {
private EditText dispFullname;
private EditText dispEmail;
private EditText dispUname;
private EditText dispass;
private EditText dispuid;
private Button show;
private Button home;
SqliteDatabaseHelper db;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_view_user);
dispuid= (EditText) findViewById(R.id.uid);
dispFullname= (EditText) findViewById(R.id.fullnamedisp);
dispEmail= (EditText) findViewById(R.id.emaildisp);
dispUname= (EditText) findViewById(R.id.unamedisp);
dispass= (EditText) findViewById(R.id.passdisp);
show= (Button) findViewById(R.id.show);
home= (Button) findViewById(R.id.Home);
db= new SqliteDatabaseHelper(this);
show.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
showuser(Integer.parseInt(dispuid.getText().toString().trim()));
}
});
home.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent intent= new Intent(ViewUser.this,MainActivity.class);
startActivity(intent);
}
});
}
private void showuser(int id) {
Cursor c =db.getuser(id);
c.moveToFirst();
{
if (c!=null){
dispuid.setText(c.getString(c.getColumnIndex(SqliteDatabaseHelper.COLUMN_ID)));
dispFullname.setText(c.getString(c.getColumnIndex(SqliteDatabaseHelper.COLUMN_NAME)));
dispEmail.setText(c.getString(c.getColumnIndex(SqliteDatabaseHelper.COLUMN_EMAIL)));
dispUname.setText(c.getString(c.getColumnIndex(SqliteDatabaseHelper.COLUMN_UNAME)));
dispass.setText(c.getString(c.getColumnIndex(SqliteDatabaseHelper.COLUMN_PASSWORD)));
}
}
}
Log:
09-21 18:54:42.686 2110-2110/com.example.aeiltech.sqlitedesign E/AndroidRuntime﹕ FATAL EXCEPTION: main
Process: com.example.aeiltech.sqlitedesign, PID: 2110
android.database.sqlite.SQLiteException: near "AUTO": syntax error (code 1): , while compiling: CREATE TABLE user_details(id INTEGER PRIMARY KEY AUTO INCREMENT name VARCHAR email VARCHAR uname VARCHAR pass VARCHAR);
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1113)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:690)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1806)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1737)
at com.example.aeiltech.sqlitedesign.SqliteDatabaseHelper.onCreate(SqliteDatabaseHelper.java:34)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
at com.example.aeiltech.sqlitedesign.SqliteDatabaseHelper.adduser(SqliteDatabaseHelper.java:48)
at com.example.aeiltech.sqlitedesign.MainActivity.insert(MainActivity.java:90)
at com.example.aeiltech.sqlitedesign.MainActivity.onClick(MainActivity.java:71)
at android.view.View.performClick(View.java:4661)
at android.view.View$PerformClick.run(View.java:19498)
at android.os.Handler.handleCallback(Handler.java:733)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:146)
at android.app.ActivityThread.main(ActivityThread.java:5641)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1288)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1104)
at dalvik.system.NativeStart.main(Native Method)
Aucun commentaire:
Enregistrer un commentaire