数据库

Dao类：

public class Dao {
 private Mysql mysql;

 public Dao(Context context) {
  mysql = new Mysql(context);
 }

 public void insert(String date, String weather, String wind,
   String temperature) {
  SQLiteDatabase db = mysql.getWritableDatabase();
  db.execSQL(
    "insert into weather(date,weather,wind,temperature) values (?,?,?,?)",
    new String[] { date, weather, wind, temperature });
  db.close();
 }

 public ArrayList<Bean2> query() {
  ArrayList<Bean2> list = new ArrayList<Bean2>();
  SQLiteDatabase db = mysql.getReadableDatabase();
  Cursor cursor = db.rawQuery("select * from weather", null);
  while (cursor.moveToNext()) {
   int id = cursor.getInt(cursor.getColumnIndex("_id"));
   String date = cursor.getString(cursor.getColumnIndex("date"));
   String weather = cursor.getString(cursor.getColumnIndex("weather"));
   String wind = cursor.getString(cursor.getColumnIndex("wind"));
   String temperature = cursor.getString(cursor
     .getColumnIndex("temperature"));
   Bean2 bean2 = new Bean2(id, date, weather, wind, temperature);
   list.add(bean2);
  }
  return list;
 }

 public void delete(int ids) {
  SQLiteDatabase db = mysql.getWritableDatabase();
  db.execSQL(" delete from weather where _id=?",
    new String[] { "" + ids });
  db.close();
 }
}

Mysql类：

public class Mysql extends SQLiteOpenHelper {

 public Mysql(Context context) {
  super(context,"yuejunfei",null,1);
  // TODO Auto-generated constructor stub
 }

 @Override
 public void onCreate(SQLiteDatabase db) {
  db.execSQL("create table qq (_id integer primary key autoincrement, name varchar(20), pwd varchar(20), email varchar(20))");
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  // TODO Auto-generated method stub
  
 }

}