Listview中取数据

1. package com.hgq.hepler;
   
2. 
   
3. import android.content.ContentValues;
   
4. import android.content.Context;
   
5. import android.database.Cursor;
   
6. import android.database.sqlite.SQLiteDatabase;
   
7. import android.database.sqlite.SQLiteOpenHelper;
   
8. 
   
9. public class MyDatabaseHepler extends SQLiteOpenHelper
   
10. {
    
11. 
    
12. // 数据库名称
    
13. private static final String DB_NAME = "notepad.db";
    
14. // 数据表名称
    
15. private static final String TABLE_NAME = "data";
    
16. // 数据库版本
    
17. private static final int DB_VERSION = 1;
    
18. // 创建数据表SQL语句
    
19. private static final String CREATE_TABLE = 
    
20. "CREATE TABLE " + TABLE_NAME
    
21. + "(" 
    
22. + "_id INTEGER PRIMARY KEY ,"
    
23. + "title VARCHAR(50) NOT NULL ," 
    
24. + "body" 
    
25. + ")";
    
26. // 删除数据表SQL语句
    
27. private static final String DROP_TABLE = "DROP IF TABLE EXISTS "
    
28. + TABLE_NAME;
    
29. // 定义SQLiteDatabase
    
30. private SQLiteDatabase db;
    
31. 
    
32. public MyDatabaseHepler(Context context)
    
33. {
    
34. super(context, DB_NAME, null, DB_VERSION);
    
35. System.out.println("--------------------数据库创建成功!!");
    
36. }
    
37. 
    
38. @Override
    
39. public void onCreate(SQLiteDatabase db)
    
40. {
    
41. // 创建数据表
    
42. db.execSQL(CREATE_TABLE);
    
43. System.out.println("------------------------数据表创建成功!!");
    
44. }
    
45. 
    
46. @Override
    
47. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    
48. {
    
49. db.execSQL(DROP_TABLE);
    
50. System.out.println("-------------------------数据表更新成功!!");
    
51. onCreate(db);
    
52. }
    
53. 
    
54. /**
    
55. * 插入数据
    
56. * 
    
57. * @param values
    
58. */
    
59. public void insert(ContentValues values)
    
60. {
    
61. SQLiteDatabase db = getWritableDatabase();
    
62. 
    
63. db.insert(TABLE_NAME, null, values);
    
64. 
    
65. db.close();
    
66. }
    
67. 
    
68. /**
    
69. * 查询数据