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 <ysrikanth2011@gmail.com>
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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
No comments:
Post a Comment