SQLite数据库储存图片信息，GridView显示，基本实现添加、删除图标操作 ... ...

Sqlite 前端之家
前端之家收集整理的这篇文章主要介绍了SQLite数据库储存图片信息，GridView显示，基本实现添加、删除图标操作 ... ...，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

sqlite数据库储存图片信息，GridView显示，基本实现添加、删除图标操作@H_502_3@

效果图如下：@H_502_3@

@H_502_3@

@H_502_3@

@H_502_3@

@H_502_3@

@H_502_3@

@H_502_3@

废话不多说，直接上代码：@H_502_3@

MainActivity.java@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
@H_976_301@ 133
134
135
136
137
138
139
package com.database.sqlite;
import java.util.List;
import android.app.Activity;
import android.app.ActivityManager;
import android.content.Context;
import android.content.Intent;
@H_404_53@ import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.Window;
import android.widget.AdapterView;
import android.widget.GridView;
import android.widget.TextView;
import android.widget.Toast;
import android.widget.AdapterView.OnItemClickListener;
/**
* 主菜单类
*
*
*
* @author 小赵
*
*/
public class MainActivity extends Activity {
private GridView gridView;
private PictureAdapter adapter;
private DBContror dbcon;
private List<Picture> mylist;
private Intent intent;
@Override
public void onCreate(Bundle savedInstanceState) {
super .onCreate(savedInstanceState);
//标题栏自定义设置
requestWindowFeature(Window.FEATURE_CUSTOM_TITLE);
setContentView(R.layout.main);
getWindow().setFeatureInt(Window.FEATURE_CUSTOM_TITLE,R.layout.title);
TextView tv = (TextView) findViewById(R.id.textTile);
tv.setText(R.string.main_menu);
dbcon = new DBContror( this ); // 初始化数据库
mylist = dbcon.queryAllItem(); // 查询数据库中的全部数据，并存放到List<Picture>中
intent = new Intent();
gridView = (GridView) findViewById(R.id.gridview);
adapter = new PictureAdapter(mylist, this ); // 自定义适配器
gridView.setAdapter(adapter);
gridView.setOnItemClickListener( new OnItemClickListener() {
public void onItemClick(AdapterView<?> parent,View v,
int position,long id) {
OnClickGridViewItem(position); // 点击事件
}
});
}
/**
* GridView中图标点击事件
*
* @param position
*/
protected void OnClickGridViewItem(int position) {
String result = mylist.get(position).getTitle();
if (result.endsWith( "商城" )) {
// 进入AppStore
intent.setClass(MainActivity. this ,AppStoreActivity.class);
MainActivity. this .startActivity(intent);
} else {
Toast.makeText(MainActivity. this ,mylist.get(position).getTitle(),
Toast.LENGTH_SHORT).show();
}
}
@Override
protected void onResume() {
super .onResume();
mylist = dbcon.queryAllItem();
adapter = new PictureAdapter(mylist, this );
adapter.notifyDataSetChanged();
gridView.setAdapter(adapter);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.main,menu); //功能菜单键
return true ;
}
/**
* 功能菜单选项
*/
@Override
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case R.id.About:
Toast.makeText(MainActivity. this , "关于" ,Toast.LENGTH_SHORT).show();
break ;
case R.id.Exit:
// Toast.makeText(MainActivity.this,"退出",Toast.LENGTH_SHORT).show();
ActivityManager am = (ActivityManager) getSystemService(Context.ACTIVITY_SERVICE);
am.restartPackage(getPackageName());
intent.setClass( this ,MainActivity.class);
Intent i = new Intent(Intent.ACTION_MAIN);
i.addCategory(Intent.CATEGORY_HOME);
intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
startActivity(intent);
startActivity(i);
break ;
default :
break ;
}
return false ;
}
/**
* 管理应用（删除操作）
*
* @param view
*/
public void OnManage(View view) {
intent.setClass(MainActivity. this ,ManageActivity.class);
this .startActivity(intent);
}
@H_976_301@ /**
* 禁用返回键
*/
public void onBackPressed() {
}
}


@H_502_3@

主菜单布局XML@H_502_3@

main.xml@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?xml version= "1.0" encoding= "utf-8" ?>
<LinearLayout xmlns:android= "http://schemas.android.com/apk/res/android"
android:layout_width= "fill_parent"
android:layout_height= "fill_parent"
android:layout_gravity= "left"
android:background= "@drawable/top_image"
android:orientation= "vertical"
android:weightSum= "2" >
@H_404_53@
<LinearLayout
xmlns:android= "http://schemas.android.com/apk/res/android"
android:layout_width= "fill_parent"
android:layout_height= "wrap_content"
android:background= "@drawable/top_image"
android:orientation= "horizontal" >
<!-- 帮助按钮 -->
<Button
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "bottom|center"
android:layout_weight= "1"
android:background= "@drawable/btn_home_bg"
android:gravity= "center"
android:text= "@string/help"
android:textColor= "#000000"
android:textSize= "15dip" />
<TextView
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_weight= "2" />
<!-- 返回主页按钮 -->
<Button
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "bottom|center"
android:layout_weight= "1"
android:background= "@drawable/btn_home_bg"
android:gravity= "center"
android:onClick= "OnManage"
android:text= "@string/manage"
android:textColor= "#000000"
android:textSize= "15dip" />
</LinearLayout>
<GridView
xmlns:android= "http://schemas.android.com/apk/res/android"
android:id= "@+id/gridview"
android:layout_width= "fill_parent"
android:layout_height= "fill_parent"
android:columnWidth= "80dip"
android:gravity= "center"
android:horizontalSpacing= "5dip"
android:numColumns= "auto_fit"
android:stretchMode= "columnWidth"
android:verticalSpacing= "5dip" />
</LinearLayout>


@H_502_3@

标题布局：@H_502_3@

title.xml@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
<?xml version= "1.0" encoding= "utf-8" ?>
<!-- 标题栏文字设置 -->
<LinearLayout xmlns:android= "http://schemas.android.com/apk/res/android"
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "center" >
<TextView
@H_404_53@ android:id= "@+id/textTile"
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:textColor= "#FFFFFF"
android:textStyle= "bold"
android:textSize= "18dip" />
</LinearLayout>


@H_502_3@

菜单选项布局：@H_502_3@

main.xml@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
<menu xmlns:android= "http://schemas.android.com/apk/res/android" >
<item
android:id= "@+id/About"
android:orderInCategory= "100"
android:title= "@string/menu_about" />
<item
@H_404_53@ android:id= "@+id/Exit"
android:orderInCategory= "100"
android:title= "@string/menu_cancel" />
</menu>


创建数据类：@H_502_3@

DBHelper.java@H_502_3@

[代码]java代码：

@H_403_2090@
?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
package com.database.sqlite;
import android.content.Context;
import android.database.sqlite.sqliteDatabase;
import android.database.sqlite.sqliteOpenHelper;
/**
* 创建数据库
@H_404_53@ *
* @author 小赵
*
*/
public class DBHelper extends sqliteOpenHelper {
public DBHelper(Context context) {
super (context,Gloable.DB_NAME, null ,Gloable.DB_VERSION);
}
/**
* 创建数据库
*/
@Override
public void onCreate(sqliteDatabase db) {
String sql = "CREATE TABLE IF NOT EXISTS "
+ Gloable.TABLE_NAME
+ "(id INTEGER PRIMARY KEY NOT NULL,pictureId INTEGER NOT NULL,pictureName varchar not null)" ;
db.execsql(sql);
}
@Override
public void onUpgrade(sqliteDatabase arg0,int arg1,int arg2) {
}
}

数据库操作类：@H_502_3@

DBContror.java@H_502_3@


@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
@H_976_301@ 133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
package com.database.sqlite;
import java.util.ArrayList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
@H_404_53@ import android.database.sqlite.sqliteDatabase;
/**
* 数据库操作类
*
* @author 小赵
*
*/
public class DBContror {
private DBHelper picdb;
private List<Picture> all = new ArrayList<Picture>();
public DBContror(Context context) {
picdb = new DBHelper(context);
all = queryAllItem(); // 查询全部数据
// 如果不存在数据就初始化数据库并添加数据
if (all.size() > 0) {
} else {
initDB(getData());
}
}
/**
* 数据库初始化
*
* @param value
* @return
*/
private long initDB(List<Picture> value) {
long row = 0;
sqliteDatabase db = picdb.getWritableDatabase();
picdb.onCreate(db);
ContentValues values = null ;
Picture map = null ;
try {
while (value.size() > 0) {
map = value.remove(0);
values = new ContentValues();
values.put( "pictureId" ,map.getImageId());
values.put( "pictureName" ,map.getTitle());
row = db.insert(Gloable.TABLE_NAME,values);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (db.isOpen()) {
db.close();
}
}
return row;
}
/**
* 添加数据
*
* @param picBean
* @return
*/
public long insertItem(Picture picBean) {
long row = 0;
try {
sqliteDatabase db = picdb.getWritableDatabase();
picdb.onCreate(db);
ContentValues contentValues = new ContentValues();
contentValues.put( "pictureId" ,picBean.getImageId());
contentValues.put( "pictureName" ,picBean.getTitle());
row = db.insert(Gloable.TABLE_NAME,contentValues);
db.close();
} catch (Exception e) {
}
return row;
}
/**
* 按名称删除指定名称（name）的数据
*
* @param name
* @return
*/
public int deleteById(String name) {
int i = 0;
try {
String[] sb = new String[1];
sb[0] = name;
sqliteDatabase db = picdb.getWritableDatabase();
picdb.onCreate(db);
i = db. delete (Gloable.TABLE_NAME, "pictureName=?" ,sb);
} catch (Exception e) {
}
return i;
}
/**
* 查询数据库中是否存在名称为name的数据
*
* @param name
* @return
*/
public boolean checkByName(String name) {
Cursor cursor;
try {
sqliteDatabase db = picdb.getWritableDatabase();
picdb.onCreate(db);
cursor = db.query(Gloable.TABLE_NAME,
new String[] { name }, null );
cursor.moveToFirst();
int count = cursor.getCount();
db.close();
if (count > 0) {
cursor.close();
return true ;
}
cursor.close();
} catch (Exception e) {
}
return false ;
}
/**
* 查询数据库所有的数据
*
@H_976_301@ * @return
*/
public List<Picture> queryAllItem() {
sqliteDatabase db = picdb.getReadableDatabase();
picdb.onCreate(db);
List<Picture> pictures = new ArrayList<Picture>();
try {
Cursor cursor = db.query(Gloable.TABLE_NAME,
null , null );
while (cursor.moveToNext()) {
Picture picture = new Picture();
picture.setImageId(cursor.getInt(cursor
.getColumnIndex( "pictureId" )));
picture.setTitle(cursor.getString(cursor
.getColumnIndex( "pictureName" )));
pictures.add(picture);
}
cursor.close();
db.close();
} catch (Exception e) { }
return pictures;
}
/**
* 查看picture数据库是否已经存在该图片
*/
public boolean checkPic(Picture picture) {
try {
sqliteDatabase db = picdb.getWritableDatabase();
picdb.onCreate(db);
String clientCode = picture.getTitle();
Cursor cursor = db.query(Gloable.TABLE_NAME,
new String[] { clientCode }, null );
cursor.moveToFirst();
int count = cursor.getCount();
db.close();
if (count > 0) {
cursor.close();
return true ;
}
cursor.close();
} catch (Exception e) { }
return false ;
}
/**
* 初始化添加系统数据
*
* @return
*/
private List<Picture> getData() {
List<Picture> list = new ArrayList<Picture>();
for (int i = 0; i < Gloable.IMAGES.length; i++) {
Picture picture = new Picture();
picture.setImageId(Gloable.IMAGES[i]);
picture.setTitle(Gloable.TITLES[i]);
list.add(picture);
}
return list;
}
}

适配器类PictureAdapter.java@H_502_3@


@H_502_3@

[代码]java代码：

@H_420_4044@
?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
package com.database.sqlite;
import java.util.List;
import android.content.Context;
import android.graphics.Color;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
@H_404_53@ import android.widget.BaseAdapter;
import android.widget.ImageView;
import android.widget.TextView;
/**
* 适配器类PictureAdapter
*
* @author 小赵
*
*/
public class PictureAdapter extends BaseAdapter {
List<Picture> pictures;
Context context;
public PictureAdapter(List<Picture> pic_list,Context context) {
super ();
this .pictures = pic_list;
this .context = context;
}
@Override
public int getCount() {
if ( null != pictures) {
return pictures.size();
} else {
return 0;
}
}
@Override
public Object getItem(int position) {
return pictures.get(position);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position,View convertView,ViewGroup parent) {
LayoutInflater inflater = LayoutInflater.from(context);
ViewHolder viewHolder;
if (convertView == null ) {
convertView = inflater.inflate(R.layout.picture_item, null );
viewHolder = new ViewHolder();
viewHolder.title = (TextView) convertView.findViewById(R.id.title);
viewHolder.image = (ImageView) convertView.findViewById(R.id.image);
convertView.setTag(viewHolder);
} else {
viewHolder = (ViewHolder) convertView.getTag();
}
viewHolder.title.setText((CharSequence) pictures.get(position)
.getTitle());
viewHolder.title.setTextColor(Color.BLACK);
viewHolder.image.setImageResource(pictures.get(position).getImageId());
return convertView;
}
}
class ViewHolder {
public TextView title;
public ImageView image;
}


图片Bean类：@H_502_3@

Picture.java@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
package com.database.sqlite;
public class Picture {
private String title; //图片名称
private int imageId; //图片ID(位置)
public Picture() {
@H_404_53@ super ();
}
public Picture(String title,int imageId) {
super ();
this .title = title;
this .imageId = imageId;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this .title = title;
}
public int getImageId() {
return imageId;
}
public void setImageId(int imageId) {
this .imageId = imageId;
}
}

管理界面类：@H_502_3@

ManageActivity.java@H_502_3@


@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
package com.database.sqlite;
import java.util.List;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.Window;
@H_404_53@ import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.GridView;
import android.widget.TextView;
import android.widget.Toast;
/**
* 管理界面（用于删除操作）
*
* @author 小赵
*
*/
public class ManageActivity extends Activity {
private GridView gridView;
private PictureAdapter adapter;
private Intent intent;
private DBContror dbcon;
private List<Picture> mylist;
@Override
protected void onCreate(Bundle savedInstanceState) {
super .onCreate(savedInstanceState);
requestWindowFeature(Window.FEATURE_CUSTOM_TITLE);
setContentView(R.layout.manage);
getWindow().setFeatureInt(Window.FEATURE_CUSTOM_TITLE,R.layout.title);
TextView tv = (TextView) findViewById(R.id.textTile);
tv.setText(R.string. delete );
dbcon = new DBContror( this );
mylist = dbcon.queryAllItem();
intent = new Intent();
gridView = (GridView) findViewById(R.id.gridview);
adapter = new PictureAdapter(mylist, this );
gridView.setAdapter(adapter);
gridView.setOnItemClickListener( new OnItemClickListener() {
public void onItemClick(AdapterView<?> parent,
int position,long id) {
if (position < 2) {
Toast.makeText(ManageActivity. this , "系统应用，无法删除！正在返回请稍后……" ,
Toast.LENGTH_SHORT).show();
} else {
dbcon.deleteById(mylist.get(position).getTitle());
adapter.notifyDataSetChanged();
Toast.makeText(ManageActivity. this , "删除成功！正在返回请稍后……" ,
Toast.LENGTH_SHORT).show();
}
onBack( null );
}
});
}
public void onBack(View view) {
intent.setClass(ManageActivity. this ,MainActivity.class);
ManageActivity. this .startActivity(intent);
}
public void onMain(View view) {
intent.setClass(ManageActivity. this ,MainActivity.class);
ManageActivity. this .startActivity(intent);
}
/**
* 禁用返回键
*/
public void onBackPressed() {
}
}


管理布局类：@H_502_3@

Manage.xml@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?xml version= "1.0" encoding= "utf-8" ?>
<LinearLayout xmlns:android= "http://schemas.android.com/apk/res/android"
android:layout_width= "fill_parent"
android:layout_height= "fill_parent"
android:layout_gravity= "left"
android:orientation= "vertical"
android:weightSum= "2" >
@H_404_53@ <LinearLayout
xmlns:android= "http://schemas.android.com/apk/res/android"
android:layout_width= "fill_parent"
android:layout_height= "wrap_content"
android:background= "@drawable/top_image"
android:orientation= "horizontal" >
<!-- 帮助按钮 -->
<Button
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "bottom|center"
android:layout_weight= "1"
android:gravity= "center"
android:text= "@string/back"
android:background= "@drawable/btn_home_bg"
android:onClick= "onBack"
android:textColor= "#FF0000"
android:textSize= "15dip" />
<TextView
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_weight= "2" />
<!-- 返回主页按钮 -->
<Button
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "bottom|center"
android:layout_weight= "1"
android:gravity= "center"
android:text= "@string/main"
android:onClick= "onMain"
android:background= "@drawable/btn_home_bg"
android:textColor= "#FF0000"
android:textSize= "15dip" />
</LinearLayout>
<GridView
xmlns:android= "http://schemas.android.com/apk/res/android"
android:id= "@+id/gridview"
android:layout_width= "fill_parent"
android:layout_height= "fill_parent"
android:columnWidth= "80dip"
android:gravity= "center"
android:horizontalSpacing= "5dip"
android:numColumns= "auto_fit"
android:stretchMode= "columnWidth"
android:verticalSpacing= "5dip" />
</LinearLayout>

应用商城类：@H_502_3@

AppStoreActivity.java@H_502_3@


@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package com.database.sqlite;
import java.util.ArrayList;
import java.util.List;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
@H_404_53@ import android.view.View;
import android.view.Window;
import android.widget.AdapterView;
import android.widget.GridView;
import android.widget.TextView;
import android.widget.Toast;
import android.widget.AdapterView.OnItemClickListener;
/**
* 商城
*
* @author 小赵
*
*/
public class AppStoreActivity extends Activity {
private GridView gridView;
private PictureAdapter adapter;
private Intent intent;
private List<Picture> mylist;
private DBContror dbcon;
public String[] addtitles = new String[] { "博客" , "历史" , "计算器" , "分享" , "微博" ,
"时钟" };
public Integer[] addimages = new Integer[] { R.drawable.blog,
R.drawable.history,R.drawable.calculator,R.drawable.share,
R.drawable.weibo,R.drawable.time };
@Override
protected void onCreate(Bundle savedInstanceState) {
super .onCreate(savedInstanceState);
requestWindowFeature(Window.FEATURE_CUSTOM_TITLE);
setContentView(R.layout.manage);
getWindow().setFeatureInt(Window.FEATURE_CUSTOM_TITLE,R.layout.title);
TextView tv = (TextView) findViewById(R.id.textTile);
tv.setText(R.string.add);
dbcon = new DBContror( this );
intent = new Intent();
gridView = (GridView) findViewById(R.id.gridview);
mylist = new ArrayList<Picture>();
for (int i = 0; i < addtitles.length; i++) {
Picture newPic = new Picture();
newPic.setImageId(addimages[i]);
newPic.setTitle(addtitles[i]);
mylist.add(newPic);
}
adapter = new PictureAdapter(mylist, this );
gridView.setAdapter(adapter);
gridView.setOnItemClickListener( new OnItemClickListener() {
public void onItemClick(AdapterView<?> parent,
int position,long id) {
if (dbcon.checkByName(mylist.get(position).getTitle())) {
Toast.makeText(AppStoreActivity. this ,
"该应用已经存在无法再次添加！正在返回请稍后……" ,Toast.LENGTH_SHORT)
.show();
} else {
dbcon.insertItem(mylist.get(position));
adapter.notifyDataSetChanged();
Toast.makeText(AppStoreActivity. this , "添加成功！正在返回请稍后……" ,
Toast.LENGTH_SHORT).show();
}
intent.setClass(AppStoreActivity. this ,MainActivity.class);
AppStoreActivity. this .startActivity(intent);
}
});
}
/**
* 返回
*
* @param view
*/
public void onBack(View view) {
intent.setClass(AppStoreActivity. this ,MainActivity.class);
AppStoreActivity. this .startActivity(intent);
}
/**
* 返回主页
*
* @param view
*/
public void onMain(View view) {
intent.setClass(AppStoreActivity. this ,MainActivity.class);
AppStoreActivity. this .startActivity(intent);
}
/**
* 禁用返回键
*/
public void onBackPressed() {
}
}

商城布局和管理布局一样，可以共用一个，呵呵……@H_502_3@

全局变量类：@H_502_3@

Gloable.java@H_502_3@


@H_502_3@

[代码]java代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
package com.database.sqlite;
/**
* 全局资源类
*
* @author 小赵
*
*/
@H_404_53@ public class Gloable {
public static String[] TITLES = new String[] { "商城" , "测试1" , "测试2" , "测试3" };
public static Integer[] IMAGES = new Integer[] { R.drawable.appstore,
R.drawable.test1,R.drawable.test2,R.drawable.test3 };
public static String DB_NAME = "pictureDB" ;
public static String TABLE_NAME = "picture" ;
public static int DB_VERSION = 1;
}

图片item类：@H_502_3@

picture_item.xml@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?xml version= "1.0" encoding= "utf-8" ?>
<LinearLayout xmlns:android= "http://schemas.android.com/apk/res/android"
android:id= "@+id/root"
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:orientation= "vertical" >
<TextView
@H_404_53@ android:layout_width= "wrap_content"
android:layout_height= "wrap_content" />
<ImageView
android:id= "@+id/image"
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "center"
android:contentDescription= "@string/app_name"
android:padding= "4dp"
android:scaleType= "fitXY" />
<TextView
android:id= "@+id/title"
android:layout_width= "wrap_content"
android:layout_height= "wrap_content"
android:layout_gravity= "center"
android:gravity= "center_horizontal" />
</LinearLayout>

String类：@H_502_3@

string.xml@H_502_3@


@H_502_3@

[代码]xml代码：

?
1
2
3
4
5
6
7
8
@H_404_53@ 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<resources>
<string name= "app_name" >sqliteDemo</string>
<string name= "hello_world" >Hello world!</string>
<string name= "menu_settings" >设置</string>
<!-- 界面标题 -->
<string name= "main_menu" >主菜单</string>
@H_404_53@ <string name= "shop_list" >商城应用</string>
<string name= "local_list" >本地应用</string>
<!-- 标题上的选择按钮 -->
<string name= "help" >帮助</string>
<string name= "main" >主页</string>
<string name= "back" >返回</string>
<string name= "manage" >管理</string>
<string name= "delete" >点击图标删除</string>
<string name= "add" >点击图标添加应用</string>
<!-- 菜单功能键下的控件 -->
<string name= "menu_about" >关于</string>
<string name= "menu_cancel" >退出</string>
</resources>

最后需要添加如下权限：@H_502_3@


@H_502_3@

[代码]xml代码：

?
1
<uses-permission android:name= "android.permission.RESTART_PACKAGES" />

资源图片呢，没有找到在哪里添加附件，以后再说……只是数据库操作的小Demo，希望各位大虾多多指教，相互学习！！！@H_502_3@

最后附上工程结构图：@H_502_3@

@H_502_3@

猜你在找的Sqlite相关文章

SQLite学习笔记
安装 在Windows上安装SQLite。 访问官网下载下Precompliled Binaries for Windows的两个压...
windows上如何安装Sqlite
一、安装 下载地址：http://www.sqlite.org/download.html 将Precompiled Binaries for Wi...
【Android数据存储】SQLite使用实例(附源码)
实例: 会员信息管理 功能：1.查看数据库 2.清空数据库 3.增加会员 4.删除会员 5.更新会员 ...
SQLite数据库管理
SQLite3常用命令
加密你的SQLite
关于SQLite SQLite是一个轻量的、跨平台的、开源的数据库引擎，它的在读写效率、消耗总量、...
SQLite这么娇小可爱，不多了解点都不行啊
在我眼里，MySQL和Oracle是这样的 而SQLite在是这样的 所以这么萌的数据库，我真的应该多了...
SQLite这么娇小可爱，不多了解点都不行啊
在我眼里，MySQL和Oracle是这样的 而SQLite在是这样的 所以这么萌的数据库，我真的应该多了...
SQLite 这么娇小可爱，不多了解点都不行啊
（点击上方蓝字，快速关注我们) 作者：空之境界 网址：http://supermao.cn/sqlitezhe-yao-...
SQLITE3 使用总结
SQLITE3 使用总结 投稿：hebedich 字体：[ 增加  减小] 类型：转载 时间：2014-08-19 Sql...
MySQLMsSQLOracleSqlitePostgre SQLMariadbMongoDBNoSQLHBaseJDBC
undo日志persistent-cmysql-error-postal-codesql-match-almysql-5.6mysql-8.0database-tri安装路径系统错误data_dir丢失文件主从同步sql_mode数据库目录匿名用户character_seID归零数据库位置查询表重复字段查询字段截断日志SUSPECT7391Remote ServeLinked Serve玄学问题登录不上开启远程访问