· 7 years ago · Jan 21, 2019, 09:04 AM
1public class DBAdapter {
2
3//EditText mHead;
4public static final String KEY_ROWID="_id";
5public static final String KEY_DATE="date";
6public static final String KEY_HEAD="head";
7private static final String TAG="DBAdapter";
8
9private static final String DATABASE_NAME="accounting";
10private static final String DATABASE_TABLE="accounts";
11private static final int DATABASE_VERSION=1;
12
13private static final String DATABASE_CREATE=
14 "create table accounts (_id integer primary key autoincrement," +
15 "date datetime not null, head text not null);";
16
17private final Context context;
18
19private DataBaseHelper DBHelper;
20private SQLiteDatabase db;
21
22public DBAdapter(Context ctx){
23 this.context=ctx;
24 DBHelper=new DataBaseHelper(context);
25}
26private static class DataBaseHelper extends SQLiteOpenHelper {
27
28 DataBaseHelper(Context context){
29
30 super(context,DATABASE_NAME,null,DATABASE_VERSION);
31 }
32
33 @Override
34 public void onCreate(SQLiteDatabase db) {
35 // TODO Auto-generated method stub
36 try {
37 db.execSQL(DATABASE_CREATE);
38
39 }catch(SQLException e){
40 e.printStackTrace();
41 }
42
43 }
44
45 @Override
46 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
47 // TODO Auto-generated method stub
48
49 Log.w(TAG, "Updrading database from version "+oldVersion+" to "+newVersion+"," +
50 "which will destroy all old data");
51 db.execSQL("drop table if exists accounts");
52 onCreate(db);
53 }
54 }
55
56public DBAdapter open() throws SQLException{
57db=DBHelper.getWritableDatabase();
58return this;
59
60 }
61
62public void close(){
63DBHelper.close();
64 }
65
66**//--insert contact in the database--**
67public long insertContact(String date,String head)
68 {
69
70ContentValues initialvalue=new ContentValues();
71initialvalue.put(KEY_DATE, date);
72initialvalue.put(KEY_HEAD, head);
73return db.insert(DATABASE_TABLE, null, initialvalue);
74
75
76 }
77
78 //--delete a particular contact--
79 public boolean deleteContact(long rowId){
80
81return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null)>0;
82
83 }
84
85 //--Retrieving all the contacts--
86 public Cursor getAllContacts(){
87return db.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_DATE,KEY_HEAD}, null, null, null, null,null);
88
89 }
90 //--Retrieve a particular contact--
91 public Cursor getContact(long rowId)throws SQLException{
92Cursor mCursor=
93 db.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,KEY_DATE,KEY_HEAD},
94 KEY_ROWID + "="+ rowId, null, null, null,
95 null, null);
96if(mCursor != null){
97 mCursor.moveToFirst();
98}
99return mCursor;
100
101 }
102 //--update a contact--
103 public Boolean updateContact(long rowId,String date,String head){
104ContentValues args=new ContentValues();
105args.put(KEY_DATE, date);
106args.put(KEY_HEAD, head);
107return db.update(DATABASE_TABLE, args, KEY_ROWID + "=" +rowId,null)>0;
108
109 }
110
111}
112
113public class MyArrayAdapter extends ArrayAdapter<Object>{
114
115private final Context context;
116private final String[] values;
117
118//@SuppressWarnings("unchecked")
119public MyArrayAdapter(Context context,String[] values){
120 super(context,R.layout.list_things,values);
121 this.context=context;
122 this.values=values;
123}
124
125
126@Override
127public View getView(int position, View convertView, ViewGroup parent) {
128 // TODO Auto-generated method stub
129 //return super.getView(position, convertView, parent);
130 LayoutInflater inflate=(LayoutInflater)context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
131 View rowview=inflate.inflate(R.layout.list_things, parent, false);
132 TextView mDate=(TextView)rowview.findViewById(R.id.tvdate);
133 TextView mHead=(TextView)rowview.findViewById(R.id.tvhead);
134 mDate.setText(values[position]);
135 mHead.setText(values[position]);
136 return rowview;
137}
138
139public class Head extends ListActivity {
140String date = "";
141String head;
142TextView display;
143EditText headname;
144ListView list;
145LayoutInflater inflate;
146Layout layout;
147
148@Override
149protected void onCreate(Bundle savedInstanceState) {
150 // TODO Auto-generated method stub
151 super.onCreate(savedInstanceState);
152 setContentView(R.layout.head);
153 display=(TextView)findViewById(R.id.tvCurrentDate);
154 display.setText(date);
155 // Intent intent=new Intent();
156 DBAdapter db=new DBAdapter(this);
157 SimpleCursorAdapter adapter=new SimpleCursorAdapter(Head.this, R.layout.list_things, null, null, null);
158
159 //Cursor cursor=getContentResolver().query("/data/data/com.crypto.ranjit/DBAdapter",
160 //new String []{db., selection, selectionArgs, sortOrder)
161 Bundle b = getIntent().getExtras();
162 if (b != null) {
163 date = b.getString("date");
164
165 }
166
167 Button btnSave = (Button) findViewById(R.id.btnSave);
168 btnSave.setOnClickListener(new View.OnClickListener() {
169
170 public void onClick(View v) {
171 // TODO Auto-generated method stub
172
173 headname=(EditText)findViewById(R.id.etHeadname);
174 date=display.getText().toString();
175
176 head=headname.getText().toString();
177
178 DBAdapter dba = new DBAdapter(Head.this);
179 dba.open();
180 long id = dba.insertContact(date, head);
181 // id=dba.insertContact(head, date);
182
183 dba.close();
184
185 }
186 });
187 //DBAdapter db=new DBAdapter(Head.this);
188 //db.open();
189
190}