//创建数据库
public class Sql extends SQLiteOpenHelper {
public Sql(Context context) {
super(context, "User.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table user(id integer primary key autoincrement,"+"name text,"+"img text)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
//UserDao里面
package ningjiaxin1.bwie.com.lian;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import java.util.ArrayList;
import java.util.List;
public class UserDao {
private Sql sql;
private SQLiteDatabase database;
public UserDao(Context context){
sql=new Sql(context);
database=sql.getReadableDatabase();
}
//添加到数据库
public void add(String name,String img){
ContentValues values = new ContentValues();
values.put("name",name);
values.put("img",img);
database.insert("user", null, values);
}
//查询数据库
public List<User> select(){
Cursor query = database.query("user", null, null, null, null, null, null);
ArrayList<User> list=new ArrayList<>();
while(query.moveToNext()){
String name = query.getString(query.getColumnIndex("name"));
String img = query.getString(query.getColumnIndex("img"));
User user = new User(name, img);
list.add(user);
}
return list;
}
}
//在那个页面添加
dao = new UserDao(getActivity());
for (int i = 0; i < data.size(); i++) {
String news_summary = data.get(i).getNews_summary();
String pic_url = data.get(i).getPic_url();
dao.add(news_summary, pic_url);
}