a aplicación de Android se bloquea al hacer clic en un elemento en la vista de lista
Mi aplicación hace lo siguiente:
-Introduzca el nombre del empleado, haga clic en el botón de búsqueda.
-Lista de nombres coincidentes como resultado.
-Cuando haga clic en uno de los nombres resultantes.
-Se abre una nueva actividad con el nombre en el que se hizo clic, su título, teléfono, datos de correo electrónico mostrado
Sin embargo, mi aplicación se bloquea cuando hago clic en uno de los nombres resultantes, no muestra errores.
Esto es lo que he hecho hasta ahora.
public class MainActivity extends Activity
{
EditText name;
ArrayAdapter<String> nameAdapter;
DeptDPHelper Emp;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
final Button Search = (Button)findViewById(R.id.Search);
name = (EditText)findViewById(R.id.name);
final ListView namelist = (ListView)findViewById(R.id.LV);
nameAdapter = new ArrayAdapter<>(getApplicationContext() , android.R.layout.simple_list_item_1);
namelist.setAdapter(nameAdapter);
Emp = new DeptDPHelper(getApplicationContext());
//Inserting some data into database
Emp.InsertEmp("AhmedMhmmd" , "010224455" , "[email protected]" , "xx");
Emp.InsertEmp("MhmmdMhmoud" , "010224455" , "[email protected]" , "xx");
Emp.InsertEmp("Ahmedxxx" , "010224455" , "[email protected]" , "xx");
Emp.InsertDept("Finance");
Emp.InsertDept("Sales");
//Search button
Search.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v) {
Cursor cur = Emp.GetEmpname(name.getText().toString());
nameAdapter.clear();
if(cur != null)
{
while(!cur.isAfterLast())
{
//Toast.makeText(getApplicationContext() , "Error" , Toast.LENGTH_LONG).show();
nameAdapter.add(cur.getString(0));
cur.moveToNext();
//nameAdapter.add("gg");
}
}
else
{
Toast.makeText(getApplicationContext() , "ErrOooor" , Toast.LENGTH_LONG).show();
}
}
});
//When clicking a name from the list of results.
namelist.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id)
{
String name = namelist.getItemAtPosition(position).toString(); //get the name
Cursor empID = Emp.getEmpID(name); //pass the name to a method to get its ID
Cursor DepID = Emp.getDeptID(name);
empID.moveToFirst();
DepID.moveToFirst();
int eID = empID.getInt(0); //Converting ID into Integer
int dID = DepID.getInt(0);
Intent intent = new Intent(MainActivity.this, empDetails.class);
intent.putExtra("empName", Emp.getEmpData(eID).toString()); //getting value of name using ID
intent.putExtra("empTitle",Emp.getEmpData(eID).toString());
intent.putExtra("empPhone",Emp.getEmpData(eID).toString());
intent.putExtra("empEmail",Emp.getEmpData(eID).toString());
intent.putExtra("empDept",Emp.getDeptName(dID).toString());
startActivity(intent);
}
});
}
//SQLITE Part
public static class DeptDPHelper extends SQLiteOpenHelper {
SQLiteDatabase EmpDept;
public DeptDPHelper(Context context) {
super(context, "EmpDept", null, 2);
}
@Override
public void onCreate(SQLiteDatabase db)
{
db.execSQL("create table department(DeptID integer primary key autoincrement , name text);");
db.execSQL("create table Employee (EmpID integer primary key autoincrement , name text not null," +
"Title text not null , phone text not null , email text not null ," +
"DeptID integer, foreign key(DeptID) references department (DeptID))");
//ContentValues row = new ContentValues();
//db.execSQL("insert into Employee (EmpID , name , Title , phone , email ) values ('Ahmemhmmd' , '010224455' , '[email protected]' , 'xx')");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("drop table if exists department ");
db.execSQL("drop table if exists Employee ");
onCreate(db);
}
public void InsertEmp (String Empname, String phone, String Email, String title)
{
ContentValues roww = new ContentValues();
//roww.put("Id",empID );
roww.put("name", Empname);
roww.put("Title", title);
roww.put("phone", phone);
roww.put("Email", Email);
EmpDept = getWritableDatabase();
EmpDept.insert("Employee ", null, roww);
EmpDept.close();
}
public void InsertDept(String Deptname)
{
ContentValues row = new ContentValues();
//row.put("Id", DeptID);
row.put("name", Deptname);
EmpDept = getWritableDatabase();
EmpDept.insert("department ", null, row);
EmpDept.close();
}
public Cursor GetEmpname(String namee)
{
EmpDept = getReadableDatabase();
String[] arg = {namee};
Cursor cur = EmpDept.rawQuery("select name from employee where name like ?;", new String[]{"%"+namee+"%"});
cur.moveToFirst();
EmpDept.close();
return cur;
}
public Cursor Fetchallemployee() {
EmpDept = getReadableDatabase();
String[] rowdetails = {"name"};
Cursor cursor = EmpDept.query("employee", rowdetails, null
, null, null, null, null);
if (cursor != null) {
cursor.moveToFirst();
}
EmpDept.close();
return cursor;
}
//This method in order to get the employee id using the clicked name
public Cursor getEmpID(String nameList)
{
EmpDept = getReadableDatabase();
String[] rowID = {nameList};
Cursor cursor = EmpDept.rawQuery("select EmpID from Employee where name like ?",rowID);
EmpDept.close();
if (cursor != null)
{
cursor.moveToFirst();
}
return cursor;
}
public Cursor getDeptID(String nameList)
{
EmpDept = getReadableDatabase();
String[] rowwID = {nameList};
Cursor curr = EmpDept.rawQuery("select DeptID from department inner join Employee on department.DeptID = Employee.DeptID where Employee.name like ? ",rowwID);
//department d inner join Employee e on d.DeptID = e.DeptID where e.name like ?
if (curr != null)
{
curr.moveToFirst();
}
EmpDept.close();
return curr;
}
//This method for returning employee data using employee id as an input
public Cursor getEmpData(Integer employeeID)
{
EmpDept = getReadableDatabase();
// String[] empRow = {"name", "title", "phone", "Email"};
//String[] arg = {name, title, phone, email};
Integer[] empRow = {employeeID};
//Cursor c = EmpDept.query("Employee", empRow, null, null, null, null, null);
Cursor c = EmpDept.rawQuery("Select name, Title, phone, email from Employee where EmpID like ?", new String[]{employeeID.toString()});
if (c != null)
{
c.moveToFirst();
}
EmpDept.close();
return c;
}
public Cursor getDeptName(Integer departmentID)
{
EmpDept = getReadableDatabase();
Integer[] deptRow = {departmentID};
//Cursor cr = EmpDept.rawQuery("Select name from department d inner join Employee e on d.DeptID = e.DeptID where e.name like ?",new String[]{deptartmentID.toString()});
Cursor cr = EmpDept.rawQuery("Select name from department where DeptID like ?",new String[]{departmentID.toString()});
if (cr != null)
{
cr.moveToFirst();
}
EmpDept.close();
return cr;
}
}
}
Cuando ingreso un nombre y hago clic en el botón de búsqueda, funciona y obtengo una lista de nombres, sin embargo, cuando hago clic en uno de los nombres, se bloquea.
¿Qué está pasando mal aquí?
Aquí está mi logcat:
11-27 04:39:48.835 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:39:48.835 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:39:58.905 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:39:58.905 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:08.975 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:08.975 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:09.665 704-1339/? E/Watchdog: !@Sync 6712 [11-27 04:40:09.670]
11-27 04:40:10.695 13974-13989/? E/ContactsProvider_EventLog: Flush buffer to file cnt : 1 size : 0Kb duration : 1ms lastUpdatedAfter : 60117 ms mFlush_time_threasold : 2000 mCurrentSize : 294
11-27 04:40:19.045 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:19.045 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:21.025 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.025 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.275 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.315 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.315 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.315 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.435 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.435 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.495 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.595 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.655 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.705 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.775 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.775 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.895 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:21.955 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:22.015 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:22.035 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:22.035 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:22.045 220-225/? E/Tzdaemon: [w2] pthread_setaffinity_np() failed: 22
11-27 04:40:29.095 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:712,format:0
11-27 04:40:29.095 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:712,format:0
11-27 04:40:30.465 3733-3733/? E/AffinityControl: AffinityControl: registerfunction enter
11-27 04:40:39.175 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:39.175 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:39.235 2767-2767/? E/MtpServerJNI: server is null in send_object_removed
11-27 04:40:39.665 704-1339/? E/Watchdog: !@Sync 6713 [11-27 04:40:39.672]
11-27 04:40:49.245 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:49.245 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:59.315 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:40:59.315 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:09.385 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:09.385 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:09.665 704-1339/? E/Watchdog: !@Sync 6714 [11-27 04:41:09.673]
11-27 04:41:10.825 13974-13989/? E/ContactsProvider_EventLog: Flush buffer to file cnt : 1 size : 0Kb duration : 2ms lastUpdatedAfter : 60131 ms mFlush_time_threasold : 2000 mCurrentSize : 294
11-27 04:41:19.465 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:19.465 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:29.535 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:29.535 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:29.775 704-876/? E/MARsDBManager: updateDBAll : begin --size 1
11-27 04:41:29.815 704-876/? E/MARsDBManager: updateDBAll : end
11-27 04:41:39.605 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:39.605 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:39.665 704-1339/? E/Watchdog: !@Sync 6715 [11-27 04:41:39.674]
11-27 04:41:49.675 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:49.675 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:59.745 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:41:59.745 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:09.665 704-1339/? E/Watchdog: !@Sync 6716 [11-27 04:42:09.675]
11-27 04:42:09.815 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:09.815 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:10.955 13974-13989/? E/ContactsProvider_EventLog: Flush buffer to file cnt : 1 size : 0Kb duration : 3ms lastUpdatedAfter : 60123 ms mFlush_time_threasold : 2000 mCurrentSize : 294
11-27 04:42:19.895 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:19.895 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:29.965 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:29.965 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:38.625 1547-32615/? E/Places: ?: Exceeded maximum network back off time, fetching nearby places failed with status: 7
11-27 04:42:39.665 704-1339/? E/Watchdog: !@Sync 6717 [11-27 04:42:39.676]
11-27 04:42:40.035 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:40.035 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:50.105 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:42:50.105 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:00.175 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:00.175 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:09.675 704-1339/? E/Watchdog: !@Sync 6718 [11-27 04:43:09.678]
11-27 04:43:10.245 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:10.245 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:11.065 13974-13989/? E/ContactsProvider_EventLog: Flush buffer to file cnt : 1 size : 0Kb duration : 1ms lastUpdatedAfter : 60110 ms mFlush_time_threasold : 2000 mCurrentSize : 294
11-27 04:43:20.315 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:20.315 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:30.395 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:30.395 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:39.675 704-1339/? E/Watchdog: !@Sync 6719 [11-27 04:43:39.679]
11-27 04:43:40.465 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:40.465 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:50.535 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:43:50.535 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:00.605 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:00.605 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:09.675 704-1339/? E/Watchdog: !@Sync 6720 [11-27 04:44:09.680]
11-27 04:44:10.675 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:10.675 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:11.185 13974-13989/? E/ContactsProvider_EventLog: Flush buffer to file cnt : 1 size : 0Kb duration : 1ms lastUpdatedAfter : 60116 ms mFlush_time_threasold : 2000 mCurrentSize : 294
11-27 04:44:20.745 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:20.745 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:30.815 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:30.815 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:39.675 704-1339/? E/Watchdog: !@Sync 6721 [11-27 04:44:39.681]
11-27 04:44:40.895 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:40.895 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:50.965 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:44:50.965 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:45:01.035 326-1009/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
11-27 04:45:01.035 217-291/? E/NetlinkEvent: NetlinkEvent::decode(): buffer'change@/devices/battery/power_supply/battery' size:713,format:0
Aquí está mi empDetails Código de actividad:
public class empDetails extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_emp_details);
TextView name = (TextView)findViewById(R.id.textView7);
TextView title = (TextView)findViewById(R.id.textView8);
TextView phone = (TextView)findViewById(R.id.textView9);
TextView email = (TextView)findViewById(R.id.textView10);
TextView dept = (TextView)findViewById(R.id.textView11);
name.setText(getIntent().getExtras().getString("empName"));
title.setText(getIntent().getExtras().getString("empTitle"));
phone.setText(getIntent().getExtras().getString("empPhone"));
email.setText(getIntent().getExtras().getString("empEmail"));
dept.setText(getIntent().getExtras().getString("empDept"));
}
}
Cuando depuro, la sección del depurador no muestra nada, parte de la sección de la consola muestra esto:
--------- beginning of crash
E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.example.fatma.assgnment004, PID: 2580
java.lang.IllegalStateException: Cannot perform this operation because the connection pool has been closed.
at android.database.sqlite.SQLiteConnectionPool.throwIfClosedLocked(SQLiteConnectionPool.java:962)
at android.database.sqlite.SQLiteConnectionPool.waitForConnection(SQLiteConnectionPool.java:599)
at android.database.sqlite.SQLiteConnectionPool.acquireConnection(SQLiteConnectionPool.java:348)
at android.database.sqlite.SQLiteSession.acquireConnection(SQLiteSession.java:894)
at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:834)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:132)
at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:219)
at android.database.AbstractCursor.moveToFirst(AbstractCursor.java:258)
at com.example.fatma.assgnment004.MainActivity$DeptDPHelper.getEmpID(MainActivity.java:182)
at com.example.fatma.assgnment004.MainActivity$2.onItemClick(MainActivity.java:77)
at android.widget.AdapterView.performItemClick(AdapterView.java:310)
at android.widget.AbsListView.performItemClick(AbsListView.java:1156)
at android.widget.AbsListView$PerformClick.run(AbsListView.java:3121)
at android.widget.AbsListView.onTouchUp(AbsListView.java:4048)
at android.widget.AbsListView.onTouchEvent(AbsListView.java:3807)
at android.view.View.dispatchTouchEvent(View.java:10023)
at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:2626)
at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:2307)
at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:2632)
at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:2321)
at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:2632)
at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:2321)
at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:2632)
at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:2321)
at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:2632)
at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:2321)
at com.android.internal.policy.DecorView.superDispatchTouchEvent(DecorView.java:413)
at com.android.internal.policy.PhoneWindow.superDispatchTouchEvent(PhoneWindow.java:1808)
at android.app.Activity.dispatchTouchEvent(Activity.java:3061)
at com.android.internal.policy.DecorView.dispatchTouchEvent(DecorView.java:375)
at android.view.View.dispatchPointerEvent(View.java:10243)
at android.view.ViewRootImpl$ViewPostImeInputStage.processPointerEvent(ViewRootImpl.java:4438)
at android.view.ViewRootImpl$ViewPostImeInputStage.onProcess(ViewRootImpl.java:4306)
at android.view.ViewRootImpl$InputStage.deliver(ViewRootImpl.java:3853)
at android.view.ViewRootImpl$InputStage.onDeliverToNext(ViewRootImpl.java:3906)
at android.view.ViewRootImpl$InputStage.forward(ViewRootImpl.java:3872)
at android.view.ViewRootImpl$AsyncInputStage.forward(ViewRootImpl.java:3999)
at android.view.ViewRootImpl$InputStage.apply(ViewRootImpl.java:3880)
at android.view.ViewRootImpl$AsyncInputStage.apply(ViewRootImpl.java:4056)
at android.view.ViewRootImpl$InputStage.deliver(ViewRootImpl.java:3853)
at android.view.ViewRootImpl$InputStage.onDeliverToNext(ViewRootImpl.java:3906)
at android.view.ViewRootImpl$InputStage.forward(ViewRootImpl.java:3872)
at android.view.ViewRootImpl$InputStage.apply(ViewRootImpl.java:3880)
at android.view.ViewRootImpl$InputStage.deliver(ViewRootImpl.java:3853)
at android.view.ViewRootImpl.deliverInputEvent(ViewRootImpl.java:6246)
at android.view.ViewRootImpl.doProcessInputEvents(ViewRootImpl.java:6220)
at android.view.ViewRootImpl.enqueueInputEvent(ViewRootImpl.java:6181)
at android.view.ViewRootImpl$WindowInputEventReceiver.onInputEvent(ViewRootImpl.java:6349)
E/AndroidRuntime: at android.view.InputEventReceiver.dispatchInputEvent(InputEventReceiver.java:185)
at android.os.MessageQueue.nativePollOnce(Native Method)
at android.os.MessageQueue.next(MessageQueue.java:323)
at android.os.Looper.loop(Looper.java:136)
at android.app.ActivityThread.main(ActivityThread.java:6119)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
Disconnected from the target VM, address: 'localhost:8647', transport: 'socket'