application force closes on emulator i am trying to add fields to create a employee database and add details by entering it into the column..............................................................................................................................................................................................................................................
<LinearLayout xmlns:android="http://ift.tt/nIICcg"
xmlns:tools="http://ift.tt/LrGmb4"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context="com.example.gowsikdb.MainActivity" >
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="90dp"
android:layout_marginStart="90dp"
android:layout_marginTop="10dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/enter_details" />
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:layout_marginStart="10dp"
android:orientation="horizontal"
android:paddingTop="15dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/emp_id" />
<EditText
android:id="@+id/edt_id"
android:layout_width="150dp"
android:layout_height="wrap_content"
android:layout_marginEnd="10dp"
android:layout_marginLeft="60dp"
android:layout_marginRight="10dp"
android:layout_marginStart="60dp"
android:inputType="text" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:layout_marginStart="10dp"
android:orientation="horizontal"
android:paddingTop="15dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/emp_name" />
<EditText
android:id="@+id/edt_name"
android:layout_width="150dp"
android:layout_height="wrap_content"
android:layout_marginEnd="10dp"
android:layout_marginLeft="35dp"
android:layout_marginRight="10dp"
android:layout_marginStart="35dp"
android:inputType="text" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:layout_marginStart="10dp"
android:orientation="horizontal"
android:paddingTop="15dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/emp_age" />
<EditText
android:id="@+id/edt_age"
android:layout_width="150dp"
android:layout_height="wrap_content"
android:layout_marginEnd="10dp"
android:layout_marginLeft="50dp"
android:layout_marginRight="10dp"
android:layout_marginStart="50dp"
android:inputType="text" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:layout_marginStart="10dp"
android:orientation="horizontal"
android:paddingTop="15dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/emp_address" />
<EditText
android:id="@+id/edt_address"
android:layout_width="150dp"
android:layout_height="wrap_content"
android:layout_marginEnd="10dp"
android:layout_marginLeft="20dp"
android:layout_marginRight="10dp"
android:layout_marginStart="20dp"
android:inputType="text" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:layout_marginRight="10dp"
android:orientation="horizontal"
android:paddingTop="15dp" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="@string/emp_salary" />
<EditText
android:id="@+id/edt_salary"
android:layout_width="150dp"
android:layout_height="wrap_content"
android:layout_marginEnd="10dp"
android:layout_marginLeft="30dp"
android:layout_marginRight="10dp"
android:layout_marginStart="30dp"
android:inputType="text" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="100dp"
android:layout_marginStart="100dp"
android:orientation="horizontal"
android:paddingTop="30dp" >
<Button
android:id="@+id/btn_submit"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/Submit" />
</LinearLayout>
</LinearLayout>
package com.example.gowsikdb;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.ActionBarActivity;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
public class MainActivity extends ActionBarActivity {
EditText et1, et2, et3, et4, et5;
Button b;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
et1 = (EditText) findViewById(R.id.edt_id);
et2 = (EditText) findViewById(R.id.edt_name);
et3 = (EditText) findViewById(R.id.edt_age);
et4 = (EditText) findViewById(R.id.edt_address);
et5 = (EditText) findViewById(R.id.edt_salary);
b.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
String s1 = et1.getText().toString();
String s2 = et2.getText().toString();
String s3 = et3.getText().toString();
String s4 = et4.getText().toString();
String s5 = et5.getText().toString();
DataBaseHub dba = new DataBaseHub(MainActivity.this);
SQLiteDatabase db = dba.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(DataBaseHub.id, s1);
cv.put(DataBaseHub.name, s2);
cv.put(DataBaseHub.age, s3);
cv.put(DataBaseHub.address, s4);
cv.put(DataBaseHub.salary, s5);
db.insert(DataBaseHub.employee, null, cv);
}
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}
package com.example.gowsikdb;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DataBaseHub extends SQLiteOpenHelper {
private static final String dbname = "company.db";
private static final int version = 1;
public static String employee = "Employee";
public static String id = "Id";
public static String name = "Name";
public static String age = "Age";
public static String address = "Address";
public static String salary = "Salary";
public DataBaseHub(Context context) {
super(context, dbname, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
String emp = "create table " + employee + "(" + id + " integer primary key," + name + " text," + age + " text," + address
+ " text," + salary + " text)";
db.execSQL(emp);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (oldVersion < newVersion) {
String emp = "create table " + employee + "(" + id + " integer primary key," + name + " text," + age + " text," + address
+ " text," + salary + " text)";
db.execSQL(emp);
}
}
}
Aucun commentaire:
Enregistrer un commentaire