public ArrayList<penjualanlogDTO> selectByUser(String user_id) { ArrayList<penjualanlogDTO> list = new ArrayList<penjualanlogDTO>(); Cursor cursor = this.db.query( TABLE_NAME, new String[] { "id" + ", user_id" + ", cust_name" + ", address" + ", remark" + ", top_id" + ", date" + ", identitas_type_id" + ", identitas_name" + ", identitas_no" + ", birthday" + ", expired_date" + ", picture_name" + ", identitas_picture" }, "user_id=?", new String[] {String.valueOf(user_id)}, null, null, "date asc"); if (cursor.moveToFirst()) { do { penjualanlogDTO jd = new penjualanlogDTO(); jd.setId(cursor.getLong(0)); jd.setUserId(cursor.getString(1)); jd.setCustName(cursor.getString(2)); jd.setAddress(cursor.getString(3)); jd.setRemark(cursor.getString(4)); jd.setTopId(cursor.getString(5)); jd.setDate(cursor.getString(6)); jd.setIdentitasTypeId(cursor.getString(7)); jd.setIdentitasName(cursor.getString(8)); jd.setIdentitasNo(cursor.getString(9)); jd.setBirthday(cursor.getString(10)); jd.setExpiredDate(cursor.getString(11)); jd.setPictureName(cursor.getString(12)); jd.setIdentitasPicture(cursor.getBlob(13)); list.add(jd); } while (cursor.moveToNext()); } if (cursor != null && !cursor.isClosed()) { cursor.close(); } return list; }