创建数据库和表

package com.example.day_10sqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
/*

• SQLiteopenhelper:
• 创建数据库和表
  /
  //继承SQLiteOpenHelper
  public class SqliteHelper extends SQLiteOpenHelper{
  /*

  • @param context 上下文

  • @param name 数据库

  • @param factory 工厂游标

  • @param version 版本号
    /
    public SqliteHelper(Context context) {
    super*(context, “User.db”, null, 1);**
    // TODO Auto-generated constructor stub
    }

    @Override //创建数据库中的表
    public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    //建表 id自增
    db.execSQL(“create table biao(id integer primary key autoincrement,” +
    “name text,” +
    “sex text)”);
    }
    @Override //升级数据库的方法 旧版本号 新版本号
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub

    }

}

Dao:

package com.example.asas;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;
import java.util.List;

public class DaoSQLite {
private static DaoSQLite instance;
private SQLiteDatabase database;
private DaoSQLite(Context con){
database=new Sqlite(con).getWritableDatabase();
}
public static DaoSQLite getInstance(Context con){
if (instance==null){
instance=new DaoSQLite(con);
}
return instance;
}
//添加的方法
public void add(NewsBean.DataBean bean){
ContentValues values=new ContentValues();
values.put(“name”,bean.getNews_title());
values.put(“summary”,bean.getNews_summary());
values.put(“url”,bean.getPic_url());
database.insert(“biao”,null,values);
}

//删除
public void del(String name){
    database.delete("biao","name=?",new String[]{name});
}
//修改
public void updata(String name){
    ContentValues values=new ContentValues();
    values.put("name",name);
    database.update("biao",values,"name=?",new String[]{name});
}

//查看
public List<NewsBean.DataBean> selecte(){
    List<NewsBean.DataBean> databean=new ArrayList <>();
    Cursor query = database.query("biao", null, null, null, null, null, null);
    if (query!=null){
        while (query.moveToNext()){
            String name = query.getString(query.getColumnIndex("name"));
            String summary = query.getString(query.getColumnIndex("summary"));
            String url = query.getString(query.getColumnIndex("url"));
            NewsBean.DataBean bean=new NewsBean.DataBean(name,summary,url);
                databean.add(bean);
        }
    }
    return databean;
}

}