Dao类:
public class Dao {
private Mysql mysql;
private Mysql mysql;
public Dao(Context context) {
mysql = new Mysql(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();
}
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;
}
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();
}
}
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
}
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))");
}
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
}
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}