app类;
public class
App
extends
Application{
private
DbManager.DaoConfig
daoConfig
;
@Override
public void
onCreate() {
super
.onCreate();
x.Ext.
init
(
this
);
x.Ext.
setDebug
(BuildConfig.
DEBUG
);
//创建数据库
daoConfig
=
new
DbManager.DaoConfig()
//数据库名字
.setDbName(
"yw.db"
)
//数据集的版本
.setDbVersion(
1
)
//是否开启事物
.setAllowTransaction(
true
)
//创建表的监听
.setTableCreateListener(
new
DbManager.TableCreateListener() {
@Override
public void
onTableCreated(DbManager db, TableEntity<?> table) {
Toast.
makeText
(App.
this
, table.getName(), Toast.
LENGTH_SHORT
).show();
}
})
//数据库打开的监听
.setDbOpenListener(
new
DbManager.DbOpenListener() {
@Override
public void
onDbOpened(DbManager db) {
//提高访问数据库的效率
db.getDatabase().enableWriteAheadLogging();
}
});
public
DbManager.DaoConfig getDaoConfig() {
}
return daoConfig;
}
}
data(封装类)
//表名字
@Table
(name =
"yws"
)
public class
DataBean {
@Column
(name =
"id"
,isId =
true
)
private
String
news_id
;
@Column
(name =
"news_title"
)
private
String
news_title
;
private
String
news_summary
;
@Column
(name =
"pic_url"
)
private
String
pic_url
;
public
String getNews_id() {
return
news_id
;
}
public void
setNews_id(String news_id) {
this
.
news_id
= news_id;
}
public
String getNews_title() {
return
news_title
;
}
public void
setNews_title(String news_title) {
this
.
news_title
= news_title;
}
public
String getNews_summary() {
return
news_summary
;
}
public void
setNews_summary(String news_summary) {
this
.
news_summary
= news_summary;
}
public
String getPic_url() {
return
pic_url
;
}
public void
setPic_url(String pic_url) {
this
.
pic_url
= pic_url;
}
}
mainactivity类
//获取到数据库
App app = (App) getApplication();
DbManager db = x.getDb(app.getDaoConfig());
//判断数据库里面的内容
try
{
List<DataBean> list =
db
.findAll(DataBean.
class
);
if
(list!=
null
&&list.size()>
0
){
mlist
.addAll(list);
myadapter
.notifyDataSetChanged();
Toast.
makeText
(MainActivity.
this
,
"数据库"
,Toast.
LENGTH_LONG
).show();
}
else
{
Toast.
makeText
(MainActivity.
this
,
"网络"
,Toast.
LENGTH_LONG
).show();
loadData();
}
}
catch
(DbException e) {
e.printStackTrace();
}
加入数据库
try
{
db
.save(
mlist
);
}
catch
(DbException e) {
e.printStackTrace();
}