Register class
package com.example.demo;
import java.util.Calendar;
import android.app.Activity;
import android.app.DatePickerDialog;
import android.app.DatePickerDialog.OnDateSetListener;
import android.app.Dialog;
import android.content.Intent;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.DatePicker;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.Spinner;
import android.widget.Toast;
public class Register extends Activity implements OnClickListener{
protected static final String EXTRA_MESSAGE = null;
private ImageButton ib;
private Calendar cal;
private int day;
private int month;
private int year;
private EditText et;
DatabaseHelpers db;
Spinner gender,state,district,city,qualification;
EditText username,password,conform,name,address,datebirth,mobile,email;
Button register;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.register);
ib = (ImageButton) findViewById(R.id.imageButton1);
cal = Calendar.getInstance();
day = cal.get(Calendar.DAY_OF_MONTH);
month = cal.get(Calendar.MONTH);
year = cal.get(Calendar.YEAR);
et = (EditText) findViewById(R.id.datebirth);
ib.setOnClickListener(this);
username =(EditText)findViewById(R.id.username);
password =(EditText)findViewById(R.id.password);
conform =(EditText)findViewById( R.id.conformpass);
name =(EditText)findViewById(R.id.name);
datebirth =(EditText)findViewById(R.id.datebirth);
address =(EditText)findViewById(R.id.address1);
mobile =(EditText)findViewById(R.id.mobile);
email =(EditText)findViewById(R.id.email);
gender =(Spinner)findViewById(R.id.gender);
state =(Spinner)findViewById(R.id.state);
district =(Spinner)findViewById(R.id.district);
city =(Spinner)findViewById(R.id.city);
qualification=(Spinner)findViewById(R.id.qualification);
db =new DatabaseHelpers(this);
register=(Button)findViewById(R.id.register);
register.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
String user =username.getText().toString();
String pass =password.getText().toString();
String conpass =conform.getText().toString();
String names =name.getText().toString();
String datebirths=datebirth.getText().toString();
String addresss=address.getText().toString();
String mob=mobile.getText().toString();
String emails=email.getText().toString();
String genders=gender.getSelectedItem().toString();
String states=state.getSelectedItem().toString();
String districts=district.getSelectedItem().toString();
String citys=city.getSelectedItem().toString();
String quali=qualification.getSelectedItem().toString();
db.add(new Sample(user,pass,names,genders,datebirths,states,districts,citys,addresss,quali,mob,emails));
Toast.makeText(getApplicationContext(), "Your data Created ",Toast.LENGTH_LONG).show();
Intent i=new Intent(Register.this,MainActivity.class);
startActivity(i);
}
});
}
@Override
public void onClick(View v) {
showDialog(0);
}
protected Dialog onCreateDialog(int id) {
return new DatePickerDialog(this, datePickerListener, year, month, day);
}
private DatePickerDialog.OnDateSetListener datePickerListener = new DatePickerDialog.OnDateSetListener() {
public void onDateSet(DatePicker view, int selectedYear,
int selectedMonth, int selectedDay) {
et.setText(selectedDay + " / " + (selectedMonth + 1) + " / "
+ selectedYear);
}
};
}
Java Model Class
package com.example.demo;
public class Sample {
private int id;
private String username;
private String password;
private String name;
private String gender,datebirth,state,district,city,address,qualification,mobile,email;
Sample(){
super();
}
public Sample(int id,String username,String password,String name,String
gender,String datebirth,String state,String district,String city,
String address,String qualification,String mobile,String email)
{
super();
this.id=id;
this.username=username;
this.password=password;
this.name=name;
this.gender=gender;
this.datebirth=datebirth;
this.state=state;
this.district=district;
this.city=city;
this.address=address;
this.qualification=qualification;
this.mobile=mobile;
this.email=email;
}
public Sample(String username,String password,String name ,String
gender,String datebirth,String state,String district,String city,
String address,String qualification,String mobile,String email)
{
super();
this.username=username;
this.password=password;
this.name=name;
this.gender=gender;
this.datebirth=datebirth;
this.state=state;
this.district=district;
this.city=city;
this.address=address;
this.qualification=qualification;
this.mobile=mobile;
this.email=email;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getDatebirth() {
return datebirth;
}
public void setDatebirth(String datebirth) {
this.datebirth = datebirth;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String getDistrict() {
return district;
}
public void setDistrict(String district) {
this.district = district;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getQualification() {
return qualification;
}
public void setQualification(String qualification) {
this.qualification = qualification;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "Sample [id=" + id + ", username=" + username + ", password="
+ password + ", name=" + name + ", gender=" + gender
+ ", datebirth=" + datebirth + ", state=" + state + ", district="
+ district + ", city=" + city + ", address=" + address
+ ", qualification=" + qualification + ", mobile=" + mobile
+ ", email=" + email + "]";
}
}
DataBaseHelper Class
package com.example.demo;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseHelpers extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "counselling.db";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "register";
private static final String STATE_TABLE="State";
private static final String DISTRICT_TABLE="District";
private static final String KEY_ID = "id";
private static final String KEY_USER_NAME = "Username";
private static final String KEY_PASSWORD = "Password";
private static final String KEY_NAME = "Name";
private static final String KEY_DATABIRTH="DataBirth";
private static final String KEY_GENDER="Gender";
private static final String KEY_STATE="State";
private static final String KEY_DISTRICT="District";
private static final String KEY_CITY="City";
private static final String KEY_ADDRESS="Address";
private static final String KEY_QUALIFICATION="Qualification";
private static final String KEY_MOBILE="Mobile";
private static final String KEY_EMAIL="Email";
public DatabaseHelpers(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_REGISTER_TABLE;
//String CREATE_STATE_TABLE;
CREATE_REGISTER_TABLE = "create table " + TABLE_NAME + "(" + KEY_ID
+ " integer primary key autoincrement, " + KEY_USER_NAME + " text, " + KEY_PASSWORD
+ " text, " + KEY_NAME + " text, " + KEY_DATABIRTH + " text, " + KEY_GENDER + " text, " + KEY_STATE + " text, " + KEY_DISTRICT +
" text, " + KEY_CITY + " text, " + KEY_ADDRESS + " text, " + KEY_QUALIFICATION + " text, " + KEY_MOBILE + " text, " +
KEY_EMAIL + " text);";
db.execSQL(CREATE_REGISTER_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
void add(Sample l) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues v = new ContentValues();
v.put(KEY_USER_NAME, l.getUsername());
v.put(KEY_PASSWORD, l.getPassword());
v.put(KEY_NAME, l.getName());
v.put(KEY_DATABIRTH, l.getDatebirth());
v.put(KEY_GENDER, l.getGender());
v.put(KEY_STATE, l.getState());
v.put(KEY_DISTRICT, l.getDistrict());
v.put(KEY_CITY, l.getCity());
v.put(KEY_ADDRESS, l.getAddress());
v.put(KEY_QUALIFICATION,l.getQualification());
v.put(KEY_MOBILE, l.getMobile());
v.put(KEY_EMAIL,l.getEmail());
// Inserting Row
db.insert(TABLE_NAME, null, v);
db.close(); // Closing database connection
}
}
No comments:
Post a Comment