public class DBAdapter extends SQLiteOpenHelper {
public static final String KEY_ROWID = "_id";
public static final String KEY_NAME = "username";
public static final String KEY_PASS = "password";
public static final int DATABASE_VERSION = 1;
public static final String DATABASE_NAME = "DB";
public static final String DATABASE_CREATE =
"create table login (_id integer primary key
autoincrement,"+
"+name text not null,password text
not null)";
private DatabaseHelper helper;
private SQLiteDatabase db;
private Context context;
public DatabaseHelper(Context context) {
// TODO Auto-generated constructor stub
super(context,DATABASE_NAME , null,DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
try{
db.execSQL(DATABASE_CREATE);
}
catch (Exception e) {
// TODO: handle exception
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int
newVersion) {
// TODO Auto-generated method stub
}
}
//open the data base
public DBAdapter open() throws SQLException{
db = helper.getWritableDatabase();
return this;
}
//close
public void close(){
db.close();
}
//insert user name and password
public long insertUser(String name,String password)
{
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NAME, name);
initialValues.put(KEY_PASS, password);
return db.insert(DATABASE_CREATE, null,
initialValues);
}
}
2012/2/6 srikanth chitturi <[email protected]>
> package Database.login;
>
> import android.app.Activity;
> import android.content.Intent;
> import android.os.Bundle;
> import android.view.View;
> import android.widget.Button;
> import android.widget.EditText;
>
> public class DatabaseLogin extends Activity {
> private EditText edit;
> private Button login;
> private DBAdapter db;
> private Button register;
> /** Called when the activity is first created. */
> @Override
> public void onCreate(Bundle savedInstanceState) {
> super.onCreate(savedInstanceState);
> setContentView(R.layout.main);
> setUpViews();
>
> }
>
> private void setUpViews() {
>
> //add the user names and passwords
> //db.open();
> //long id = db.insertUser("srikanth", "srikanth");
> //db.close();
>
>
> edit = (EditText)findViewById(R.id.edit);
> login = (Button)findViewById(R.id.login);
> login.setOnClickListener(new View.OnClickListener() {
>
> @Override
> public void onClick(View v) {
> // TODO Auto-generated method stub
>
> String username = edit.getText().toString();
> String password = edit.getText().toString();
>
>
> }
> });
>
> register = (Button)findViewById(R.id.register);
> register.setOnClickListener(new View.OnClickListener() {
>
> @Override
> public void onClick(View v) {
> // TODO Auto-generated method stub
> Intent in = new
> Intent(getApplicationContext(),Register.class);
> startActivity(in);
> }
> });
> }
>
>
> }
>
>
> package Database.login;
>
> import android.content.ContentValues;
> import android.content.Context;
> import android.database.SQLException;
> import android.database.sqlite.SQLiteDatabase;
> import android.database.sqlite.SQLiteOpenHelper;
>
> public class DBAdapter {
>
>
> public static final String KEY_ROWID = "_id";
>
> public static final String KEY_NAME = "username";
> public static final String KEY_PASS = "password";
> public static final int DATABASE_VERSION = 1;
> public static final String DATABASE_NAME = "DB";
>
> public static final String DATABASE_CREATE =
> "create table login (_id integer primary key
> autoincrement,"+
> "+name text not null,password text
> not null)";
> private DatabaseHelper helper;
> private SQLiteDatabase db;
> private Context context;
>
> public DBAdapter(Context ctx)
> {
> this.context = ctx;
> helper = new DatabaseHelper(context);
> }
> class DatabaseHelper extends SQLiteOpenHelper
> {
>
> public DatabaseHelper(Context context) {
> // TODO Auto-generated constructor stub
> super(context,DATABASE_NAME ,
> null,DATABASE_VERSION);
> }
>
> @Override
> public void onCreate(SQLiteDatabase db) {
> // TODO Auto-generated method stub
> try{
> db.execSQL(DATABASE_CREATE);
> }
> catch (Exception e) {
> // TODO: handle exception
> }
>
> }
>
> @Override
> public void onUpgrade(SQLiteDatabase db, int oldVersion, int
> newVersion) {
> // TODO Auto-generated method stub
>
> }
> }
> //open the data base
> public DBAdapter open() throws SQLException{
> db = helper.getWritableDatabase();
> return this;
> }
> //close
> public void close(){
> db.close();
> }
>
> //insert user name and password
> public long insertUser(String name,String password)
> {
> ContentValues initialValues = new ContentValues();
> initialValues.put(KEY_NAME, name);
> initialValues.put(KEY_PASS, password);
>
> return db.insert(DATABASE_CREATE, null,
> initialValues);
> }
>
> }
>
>
> package Database.login;
>
> import android.app.Activity;
> import android.os.Bundle;
> import android.view.View;
> import android.view.View.OnClickListener;
> import android.widget.Button;
> import android.widget.EditText;
>
> public class Register extends Activity {
>
> private Button agree;
> private EditText userName;
> private EditText pass;
> DBAdapter db = new DBAdapter(this);
>
> @Override
> protected void onCreate(Bundle savedInstanceState) {
> // TODO Auto-generated method stub
> super.onCreate(savedInstanceState);
> setContentView(R.layout.register);
> userName = (EditText)findViewById(R.id.username);
> pass = (EditText)findViewById(R.id.password);
> agree = (Button)findViewById(R.id.agree);
>
> agree.setOnClickListener(new OnClickListener() {
>
> public void onClick(View v) {
> // TODO Auto-generated method stub
>
> String userName1 = userName.getText().toString();
> String password1 = pass.getText().toString();
> db.open();
> long id = db.insertUser(userName1, password1);
> db.close();
>
> }
> });
> }
>
> }
>
> i have created the respective layout xml files namely
> main.xml,register.xml .
> But table is not inserting.
> please help.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
--
- Marcelo Henrique -
"Se não puder se destacar pelo talento, vença pelo esforço." (Dave
Weinbaum)
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
