x7CP1udq

1public Helper(Context ctx) 
2{
3    this.context = ctx;
4    DBHelper = new DatabaseHelper(context);
5}
6
7private static class DatabaseHelper extends SQLiteOpenHelper 
8{
9    DatabaseHelper(Context context) 
10    {
11        super(context, DATABASE_NAME, null, DATABASE_VERSION);
12    }
13
14    @Override
15    public void onCreate(SQLiteDatabase db) 
16    {
17        db.execSQL(DATABASE_CREATE);
18    }
19
20    @Override
21    public void onUpgrade(SQLiteDatabase db, int oldVersion, 
22    int newVersion) 
23    {
24        Log.w(TAG, "Upgrading database from version " + oldVersion 
25                + " to "
26                + newVersion + ", which will destroy all old data");
27        db.execSQL("DROP TABLE IF EXISTS titles");
28        onCreate(db);
29    }
30}    
31
32//---opens the database---
33public Helper open() throws SQLException 
34{
35    db = DBHelper.getWritableDatabase();
36    return this;
37}
38
39//---closes the database---    
40public void close() 
41{
42    DBHelper.close();
43}
44
45//---insert a title into the database---
46public long insert(String name) 
47{
48     ContentValues initialValues = new ContentValues();
49     initialValues.put("Name", name);
50    return db.insert(DATABASE_TABLE, null,initialValues);
51}
52//---updates a title---
53public long update(String name)
54        {
55            ContentValues args = new ContentValues();
56            args.put("Name",name);
57
58            return db.update(DATABASE_TABLE, args, 
59                             "Name" + "=" + name, null);
60        }
61
62
63//---deletes a particular title---
64public int delete(String name) 
65{
66   // return db.delete(DATABASE_TABLE,"Name="+name, null);
67    return db.delete(DATABASE_TABLE,"Name=?",new String[]{String.valueOf(name)});
68}
69	
70private static final String DATABASE_CREATE =
71    "create table titles (_id integer primary key autoincrement, "
72     + "Name text not null);";
73
74private final Context context; 
75
76private DatabaseHelper DBHelper;
77private SQLiteDatabase db;
78
79public Helper(Context ctx) 
80{
81    this.context = ctx;
82    DBHelper = new DatabaseHelper(context);
83}
84
85private static class DatabaseHelper extends SQLiteOpenHelper 
86{
87    DatabaseHelper(Context context) 
88    {
89        super(context, DATABASE_NAME, null, DATABASE_VERSION);
90    }
91
92    @Override
93    public void onCreate(SQLiteDatabase db) 
94    {
95        db.execSQL(DATABASE_CREATE);
96    }
97
98    @Override
99    public void onUpgrade(SQLiteDatabase db, int oldVersion, 
100    int newVersion) 
101    {
102        Log.w(TAG, "Upgrading database from version " + oldVersion 
103                + " to "
104                + newVersion + ", which will destroy all old data");
105        db.execSQL("DROP TABLE IF EXISTS titles");
106        onCreate(db);
107    }
108}    
109
110//---opens the database---
111public Helper open() throws SQLException 
112{
113    db = DBHelper.getWritableDatabase();
114    return this;
115}
116
117//---closes the database---    
118public void close() 
119{
120    DBHelper.close();
121}
122
123//---insert a title into the database---
124public long insert(String name) 
125{
126     ContentValues initialValues = new ContentValues();
127     initialValues.put("Name", name);
128    return db.insert(DATABASE_TABLE, null,initialValues);
129}
130//---updates a title---
131public long update(String name)
132        {
133            ContentValues args = new ContentValues();
134            args.put("Name",name);
135
136            return db.update(DATABASE_TABLE, args, 
137                             "Name" + "=" + name, null);
138        }
139
140
141//---deletes a particular title---
142public int delete(String name) 
143{
144   // return db.delete(DATABASE_TABLE,"Name="+name, null);
145    return db.delete(DATABASE_TABLE,"Name=?",new String[]{String.valueOf(name)});
146}
147	
148return db.update(DATABASE_TABLE, args, 
149                                 "Name" + "='" + name+"'", null);