Powered By Blogger

Monday 27 February 2012

Create form and store in database


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class Database1 {
static final String id="id";
static final String name="name";
static final String email="email";
static final String gender="gender";
static final String branch="branch";
static final String dbname="logindb";
static final String dbtable="login";
static String create="create table login(id integer primary key autoincrement,"+"name text not null,email text not null,"+"gender text not null,branch text not null);";
static final int dbversion=1;
private SQLiteDatabase db1;
private DataBaseHelper helper;
public final Context context;
Database1(Context con)
{
this.context=con;
helper=new DataBaseHelper(context);
}
private static class DataBaseHelper extends SQLiteOpenHelper
{

public DataBaseHelper(Context context) {
super(context, dbname, null, dbversion);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(create);

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
Log.w("MyDataBase","upgrade from "+oldVersion+"to"+newVersion);
db.execSQL("DROP TABEL IF EXIST login");
onCreate(db);

}

}
public Database1 open()throws SQLException
{
db1=helper.getWritableDatabase();
return this;
}
public void close()
{
helper.close();
}
public long insert(String name1,String email1,String gender1,String branch1)
{
ContentValues cv=new ContentValues();
cv.put(name, name1);
cv.put(email, email1);
cv.put(gender, gender1);
cv.put(branch, branch1);
return db1.insert(dbtable, null,cv);
}
public Cursor getAllInfo()
{
return db1.query(dbtable, new String[]{id,name,email,gender,branch},null,null,null,null,null);
}
}
Form.java

import java.util.regex.Pattern;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.AutoCompleteTextView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Spinner;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.RadioGroup.OnCheckedChangeListener;

public class FormAss extends Activity {
    /** Called when the activity is first created. */
    
EditText name,email,gender,branch;
Button b1;
AutoCompleteTextView name1;
EditText email1;
//String email2;
String s1[]={"Dheeraj","Varun","Anupama","Rahul","Preeti","Shivam","Nupur"};
RadioGroup rg;
Spinner branch1;
RadioButton male,female;
String s;
String s3[]={"CSE","IT","EC","EE","CIVIL"};
//String s2[]={"dheeraj.giroti1@gmail.com","varun9829@gmail.com","preetivarma12@gmail.com","c_shivam19@gmail.com","rsonone42@gmail.com","granupama@gmail.com"};
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        name1=(AutoCompleteTextView)findViewById(R.id.autoCompleteTextView2);
        email1=(EditText)findViewById(R.id.editText2);
        gender=(EditText)findViewById(R.id.edittext1);
        branch1=(Spinner)findViewById(R.id.spinner1);
        
        ArrayAdapter<String> adapter=new ArrayAdapter<String>(getApplicationContext(),android.R.layout.simple_expandable_list_item_1,s1);
       // ArrayAdapter<String> adapter1=new ArrayAdapter<String>(getApplicationContext(),android.R.layout.simple_expandable_list_item_1,s2);
        final ArrayAdapter<String> adapter2=new ArrayAdapter<String>(getApplicationContext(),android.R.layout.simple_spinner_item,s3);

        name1.setAdapter(adapter);
        name1.setThreshold(2);
       // email1.setAdapter(adapter1);
        //email1.setThreshold(2);
       
        rg=(RadioGroup)findViewById(R.id.radio_group1);
        male=(RadioButton)findViewById(R.id.radioButton1);
        female=(RadioButton)findViewById(R.id.radioButton2);
        b1=(Button)findViewById(R.id.button1);
        rg.setOnCheckedChangeListener(new OnCheckedChangeListener()
        {

@Override
public void onCheckedChanged(RadioGroup arg0, int arg1) {
// TODO Auto-generated method stub
if(male.isChecked())
{
gender.setText("male");
}
else
{
gender.setText("female");
}
}
       
        });
        branch1.setAdapter(adapter2);
        branch1.setOnItemSelectedListener(new OnItemSelectedListener()
        {

@Override
public void onItemSelected(AdapterView<?> arg0, View arg1,
int arg2, long arg3) {
// TODO Auto-generated method stub
s=adapter2.getItem(arg2).toString();
}

@Override
public void onNothingSelected(AdapterView<?> arg0) {
// TODO Auto-generated method stub
}
       
        });
        b1.setOnClickListener(new OnClickListener()
        {

@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
String name2=name1.getText().toString();
String email2=email1.getText().toString();
if(email2.length()==0)
{
email1.setError("enter valid email  id");
return;
}
boolean em=checkmail(email2);
if(em==false)
{
email1.setError("enter valid id");
return;
}
String gender1=gender.getText().toString();
Intent i=new Intent(getApplicationContext(),Show.class);
i.putExtra("subject",s);
i.putExtra("name",name2);
i.putExtra("email",email2);
i.putExtra("gender",gender1);
startActivity(i);
}
       
        });
        
        
    }
    public boolean checkmail(String email2)
    {
    Pattern pattern= Pattern.compile("^([a-zA-Z0-9_.-])+@([a-zA-Z0-9_.-])+\\.([a-zA-Z])+([a-zA-Z])+");
    return pattern.matcher(email2).matches();
    }
}
show.java


import android.app.Activity;
import android.database.Cursor;
import android.graphics.Color;
import android.os.Bundle;
import android.widget.TableRow.LayoutParams;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;

public class Show extends Activity{
TableLayout tl;
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.show);
Database1 db=new Database1(this);
String s1=getIntent().getStringExtra("name");
String s2=getIntent().getStringExtra("email");
String s3=getIntent().getStringExtra("gender");
String s4=getIntent().getStringExtra("subject");
db.open();
long i;
i=db.insert(s1, s2, s3, s4);
Cursor c=db.getAllInfo();
if(c.moveToFirst())
{
do
{
display(c);
}while(c.moveToNext());
}
db.close();
}
public void display(Cursor c)
{
tl=(TableLayout)findViewById(R.id.tableLayout1);
for(int i=0;i<1;i++)
{
TableRow tr1=new TableRow(this);
TextView tx1=new TextView(this);
TextView tx2=new TextView(this);
TextView tx3=new TextView(this);
TextView tx4=new TextView(this);
TextView tx5=new TextView(this);
tabelView(tr1,tx1,c.getString(0));
tabelView(tr1,tx2,c.getString(1));
tabelView(tr1,tx3,c.getString(2));
tabelView(tr1,tx4,c.getString(3));
tabelView(tr1,tx5,c.getString(4));
tl.addView(tr1);
}
}
private void tabelView(TableRow tr, TextView tx, String data) {
// TODO Auto-generated method stub
tx.setText(data);
tx.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
tx.setPadding(5,0,5, 0);
tx.setBackgroundColor(Color.DKGRAY);
tr.setPadding(1,1, 1,1);
tr.setBackgroundColor(Color.CYAN);
tr.addView(tx);
}
/*public void display(Cursor c) {
// TODO Auto-generated method stub
tl=(TableLayout)findViewById(R.id.tableLayout1);
for(int i=0;i<1;i++)
{
TableRow tr1=new TableRow(this);
TextView tx1=new TextView(this);
TextView tx2=new TextView(this);
TextView tx3=new TextView(this);
TextView tx4=new TextView(this);
TextView tx5=new TextView(this);
view(tr1,tx1,c.getString(0));
view(tr1,tx2,c.getString(1));
view(tr1,tx3,c.getString(2));
view(tr1,tx1,c.getString(3));
view(tr1,tx1,c.getString(4));
tl.addView(tr1);
}
}*/
private void view(TableRow tr, TextView tx, String data) {
// TODO Auto-generated method stub
tx.setText(data);
tx.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
tx.setPadding(10,0,0,0);
tx.setBackgroundColor(Color.DKGRAY);
tr.setPadding(1, 1, 1,1);
tr.setBackgroundColor(Color.CYAN);
tr.addView(tx);
//}

}}

No comments:

Post a Comment