BaseActivity
previewAction();
setContentView(getContentView());
initView();
initData();
setListener();
setMoreAction();
Fragment:::::
public View onCreateView(@NonNull LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
View v = inflater.inflate(getContentView(), container, false);
initView(v);
return v;
}
@Override
public void onActivityCreated(@Nullable Bundle savedInstanceState) {
super.onActivityCreated(savedInstanceState);
if (mContext == null) {
mContext = getActivity();
}
initData();
setListener();
setMoreAction();
}
DB :::::
public ChannelDao(Context context) {
DBHelper helper = new DBHelper(context);
db = helper.getWritableDatabase();
}
插入
public long insert(Channel channel) {
if (hasId(channel.getId())) {
return 0;
}
ContentValues values = new ContentValues();
values.put(COLUMN_ID, channel.getId());
values.put(COLUMN_NAME, channel.getName());
values.put(COLUMN_PARAM, channel.getParma());
values.put(COLUMN_TYPE, channel.getType());
return db.insert(TABLE_NAME, null, values);
}
插入集合
public int insert(List<Channel> channels) {
int count = 0;
ContentValues values = new ContentValues();
for (Channel channel : channels) {
if (!hasId(channel.getId())) {
values.put(COLUMN_ID, channel.getId());
values.put(COLUMN_NAME, channel.getName());
values.put(COLUMN_PARAM, channel.getParma());
values.put(COLUMN_TYPE, channel.getType());
long l = db.insert(TABLE_NAME, null, values);
if (l > 0) {
count++;
}
}
}
return count;
}
判断是否存在
public boolean hasId(int id) {
Cursor cursor = db.query(TABLE_NAME, null, COLUMN_ID + "=?", new String[]{id + ""}, null, null, null);
if (cursor.moveToNext()) {
return true;
}
查询所有
public List<Channel> queryAll() {
List<Channel> list = new ArrayList<>();
Cursor cursor = db.query(TABLE_NAME, null, null, null, null, null, null);
while (cursor.moveToNext()) {
Channel channel = new Channel();
channel.setId(cursor.getInt(cursor.getColumnIndex(COLUMN_ID)));
channel.setName(cursor.getString(cursor.getColumnIndex(COLUMN_NAME)));
channel.setParma(cursor.getString(cursor.getColumnIndex(COLUMN_PARAM)));
channel.setType(cursor.getInt(cursor.getColumnIndex(COLUMN_TYPE)));
list.add(channel);
}
return list;
}
return false;
}