//创建数据库SQLiteOpenHelper
public class sqlliteHelper extends SQLiteOpenHelper{
public sqlliteHelper(Context context) {
super(context, "User.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table users (id integer primary key autoincrement,name text, age text)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
//创建表Dao包
public class UserDao {
private SQLiteDatabase database;
private sqlliteHelper sqlHelper;
public UserDao(Context context) {
// TODO Auto-generated constructor stub
sqlHelper=new sqlliteHelper(context);
database=sqlHelper.getReadableDatabase();
}
//添加
public Boolean add(String name,String age) {
// TODO Auto-generated method stub
ContentValues values =new ContentValues();
values.put("name", name);
values.put("age", age);
long insert = database.insert("users", null, values);
if (insert !=0) {
return true;
}
return false;
}
//查询
public List<UserBean> select() {
Cursor query = database.query("users", null, null, null, null, null, null);
ArrayList<UserBean> list=new ArrayList<UserBean>();
while (query.moveToNext()) {
String name = query.getString(query.getColumnIndex("name"));
String age = query.getString(query.getColumnIndex("age"));
UserBean bean=new UserBean(name, age);
list.add(bean);
}
// TODO Auto-generated method stub
return list;
}
//修改
public Boolean update(String name,String age,String oldName) {
// TODO Auto-generated method stub
ContentValues values =new ContentValues();
values.put("name", name);
values.put("age", age);
int update = database.update("users", values, "name=?", new String[]{oldName});
if (update !=0) {
return true;
}
return false;
}
//删除
public Boolean delete(String name) {
// TODO Auto-generated method stub
int delete = database.delete("users", "name=?", new String[]{name});
if (delete !=0) {
return true;
}
return false;
}
}
//创建bean包
public class UserBean {
private String name;
private String age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public UserBean(String name, String age) {
super();
this.name = name;
this.age = age;
}
@Override
public String toString() {
return "UserBean [name=" + name + ", age=" + age + "]";
}
}
//适配器
public class UserBean {
private String name;
private String age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public UserBean(String name, String age) {
super();
this.name = name;
this.age = age;
}
@Override
public String toString() {
return "UserBean [name=" + name + ", age=" + age + "]";
}
}
//Mainaction主页面
private Button btn1,btn2;
private UserDao dao;
private EditText edit_name,edit_age;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
//创建dao包
dao=new UserDao(MainActivity.this);
btn1=(Button) findViewById(R.id.btn_add);
btn2=(Button) findViewById(R.id.btn_select);
btn1.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
//弹出框
AlertDialog.Builder diBuilder=new Builder(MainActivity.this);
diBuilder.setTitle("提示");
//获取子布局
View view =View.inflate(MainActivity.this, R.layout.adapteredit, null);
edit_name = (EditText) view.findViewById(R.id.edit_name);
edit_age = (EditText) view.findViewById(R.id.edit_age);
diBuilder.setView(view);
diBuilder.setPositiveButton("确定", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
String name = edit_name.getText().toString();
String age = edit_age.getText().toString();
dao.add(name, age);
}
});
diBuilder.show();
}
});
btn2.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent intent=new Intent(MainActivity.this, ShowActivity.class);
startActivity(intent);
}
});
}
//ShowActivity
public class ShowActivity extends Activity {
private UserDao dao;
private ListView list;
private List<UserBean> arrayList;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_show);
dao=new UserDao(this);
arrayList=new ArrayList<>();
//获取组件
list=(ListView) findViewById(R.id.list1);
arrayList = dao.select();
MyBase base=new MyBase(ShowActivity.this, arrayList);
list.setAdapter(base);
}
public class sqlliteHelper extends SQLiteOpenHelper{
public sqlliteHelper(Context context) {
super(context, "User.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table users (id integer primary key autoincrement,name text, age text)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
//创建表Dao包
public class UserDao {
private SQLiteDatabase database;
private sqlliteHelper sqlHelper;
public UserDao(Context context) {
// TODO Auto-generated constructor stub
sqlHelper=new sqlliteHelper(context);
database=sqlHelper.getReadableDatabase();
}
//添加
public Boolean add(String name,String age) {
// TODO Auto-generated method stub
ContentValues values =new ContentValues();
values.put("name", name);
values.put("age", age);
long insert = database.insert("users", null, values);
if (insert !=0) {
return true;
}
return false;
}
//查询
public List<UserBean> select() {
Cursor query = database.query("users", null, null, null, null, null, null);
ArrayList<UserBean> list=new ArrayList<UserBean>();
while (query.moveToNext()) {
String name = query.getString(query.getColumnIndex("name"));
String age = query.getString(query.getColumnIndex("age"));
UserBean bean=new UserBean(name, age);
list.add(bean);
}
// TODO Auto-generated method stub
return list;
}
//修改
public Boolean update(String name,String age,String oldName) {
// TODO Auto-generated method stub
ContentValues values =new ContentValues();
values.put("name", name);
values.put("age", age);
int update = database.update("users", values, "name=?", new String[]{oldName});
if (update !=0) {
return true;
}
return false;
}
//删除
public Boolean delete(String name) {
// TODO Auto-generated method stub
int delete = database.delete("users", "name=?", new String[]{name});
if (delete !=0) {
return true;
}
return false;
}
}
//创建bean包
public class UserBean {
private String name;
private String age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public UserBean(String name, String age) {
super();
this.name = name;
this.age = age;
}
@Override
public String toString() {
return "UserBean [name=" + name + ", age=" + age + "]";
}
}
//适配器
public class UserBean {
private String name;
private String age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public UserBean(String name, String age) {
super();
this.name = name;
this.age = age;
}
@Override
public String toString() {
return "UserBean [name=" + name + ", age=" + age + "]";
}
}
//Mainaction主页面
private Button btn1,btn2;
private UserDao dao;
private EditText edit_name,edit_age;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
//创建dao包
dao=new UserDao(MainActivity.this);
btn1=(Button) findViewById(R.id.btn_add);
btn2=(Button) findViewById(R.id.btn_select);
btn1.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
//弹出框
AlertDialog.Builder diBuilder=new Builder(MainActivity.this);
diBuilder.setTitle("提示");
//获取子布局
View view =View.inflate(MainActivity.this, R.layout.adapteredit, null);
edit_name = (EditText) view.findViewById(R.id.edit_name);
edit_age = (EditText) view.findViewById(R.id.edit_age);
diBuilder.setView(view);
diBuilder.setPositiveButton("确定", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
String name = edit_name.getText().toString();
String age = edit_age.getText().toString();
dao.add(name, age);
}
});
diBuilder.show();
}
});
btn2.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent intent=new Intent(MainActivity.this, ShowActivity.class);
startActivity(intent);
}
});
}
//ShowActivity
public class ShowActivity extends Activity {
private UserDao dao;
private ListView list;
private List<UserBean> arrayList;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_show);
dao=new UserDao(this);
arrayList=new ArrayList<>();
//获取组件
list=(ListView) findViewById(R.id.list1);
arrayList = dao.select();
MyBase base=new MyBase(ShowActivity.this, arrayList);
list.setAdapter(base);
}