SQLite保存数据和更新显示代码,Java代码库,德仔网

代码语言
代码分类
【Java】 SQLite保存数据和更新显示
作者:泺清 / 发布于2015/5/12/ 743

	package com.example.save;
	
	import java.io.FileNotFoundException;
	import java.io.InputStream;
	import java.io.OutputStream;
	import java.util.List;
	
	import com.dao.ProductDao;
	import com.entity.Product;
	import android.os.Bundle;
	import android.app.Activity;
	import android.content.Intent;
	import android.content.SharedPreferences;
	import android.content.SharedPreferences.Editor;
	import android.view.Menu;
	import android.view.View;
	import android.view.ViewGroup;
	import android.view.View.OnClickListener;
	import android.widget.BaseAdapter;
	import android.widget.Button;
	import android.widget.EditText;
	import android.widget.TextView;
	import android.widget.Toast;
	
	public class MainActivity extends Activity {
	
	 private EditText edtname,edtprice,edtcount,edtaddress;
	 private Button btnSave,btnSelect;
	 private ProductDao dao;
	 private Product product;
	 List<Product> proList;
	 public void init(){
	 edtname=(EditText) findViewById(R.id.edtname);
	 edtprice=(EditText) findViewById(R.id.edtprice);
	 edtcount=(EditText) findViewById(R.id.edtcount);
	 edtaddress=(EditText) findViewById(R.id.edtaddress);
	 btnSave=(Button) findViewById(R.id.btnSave);
	 btnSelect=(Button) findViewById(R.id.btnSelect);
	 }
	 protected void onCreate(Bundle savedInstanceState) {
	 super.onCreate(savedInstanceState);
	 setContentView(R.layout.activity_main);
	 init();
	 dao=new ProductDao(getApplicationContext(), null, null, 0);
	 btnSave.setOnClickListener(new OnClickListener() {
	 public void onClick(View arg0) {
	 product=new Product();
	 product.setProName(edtname.getText().toString());
	 product.setProPrice(Float.parseFloat(edtprice.getText().toString()));
	 product.setProCount(Integer.parseInt(edtcount.getText().toString()));
	 product.setProAddr(edtaddress.getText().toString());
	 dao.add(product);
	 Toast toast=Toast.makeText(getApplicationContext(), "保存成功", 2000);
	 toast.show();
	
	 }
	 });
	 btnSelect.setOnClickListener(new OnClickListener() {
	 public void onClick(View arg0) {
	 Intent intent=new Intent();
	 intent.setClass(getApplicationContext(), SelectActivity.class);
	 startActivity(intent);
	 }
	 });
	 }
	
	}
	
	
	
	
	package com.example.save;
	
	import java.util.ArrayList;
	import java.util.List;
	import junit.runner.Version;
	import com.dao.ProductDao;
	import com.entity.Product;
	import android.app.Activity;
	import android.content.Intent;
	import android.opengl.Visibility;
	import android.os.Bundle;
	import android.util.Log;
	import android.view.View;
	import android.view.View.*;
	import android.view.ViewGroup;
	import android.widget.BaseAdapter;
	import android.widget.Button;
	import android.widget.LinearLayout;
	import android.widget.ListView;
	import android.widget.TextView;
	import android.widget.Toast;
	
	
	public class SelectActivity extends Activity {
	
	 private ListView listinfo;
	 private ProductDao dao;
	 private List<Product> proList;
	
	 private MyAdapter adapter;
	 public void init(){
	 listinfo=(ListView) findViewById(R.id.listinfo);
	 }
	 protected void onCreate(Bundle savedInstanceState) {
	 super.onCreate(savedInstanceState);
	 setContentView(R.layout.selectinfo);
	 init();
	 dao=new ProductDao(getApplicationContext(), null, null, 1);
	 adapter=new MyAdapter();
	 listinfo.setAdapter(adapter);
	}
	
	
	 public class MyAdapter extends BaseAdapter{
	
	 @Override
	 public int getCount() {
	 // TODO Auto-generated method stub
	 proList=dao.query();
	 return proList.size();
	 }
	
	 @Override
	 public Object getItem(int arg0) {
	 // TODO Auto-generated method stub
	 return null;
	 }
	
	 @Override
	 public long getItemId(int arg0) {
	 // TODO Auto-generated method stub
	 return 0;
	 }
	
	 @Override
	 public View getView(int arg0, View arg1, ViewGroup arg2) {
	 // TODO Auto-generated method stub
	 View v=getLayoutInflater().inflate(R.layout.item, null);
	 TextView txtid=(TextView) v.findViewById(R.id.txtid);
	 TextView txtname=(TextView) v.findViewById(R.id.txtname);
	 TextView txtprice=(TextView) v.findViewById(R.id.txtprice);
	 TextView txtcount=(TextView) v.findViewById(R.id.txtcount);
	 TextView txtaddresss=(TextView) v.findViewById(R.id.txtaddresss);
	 Button but1=(Button)v.findViewById(R.id.but1);
	 Button but2=(Button)v.findViewById(R.id.but2);
	 final Product product=proList.get(arg0);
	 txtid.setText(product.get_id()+"");
	 txtname.setText(product.getProName()+"");
	 txtprice.setText(product.getProPrice()+"");
	 txtcount.setText(product.getProCount()+"");
	 txtaddresss.setText(product.getProAddr()+"");
	 //txtid.setVisibility(View.INVISIBLE);
	 but1.setOnClickListener(new OnClickListener() {
	 public void onClick(View arg0) {
	 Toast toast=Toast.makeText(getApplicationContext(), "正在删除"+product.getProName(), 1000);
	 toast.show();
	 dao.delById(product.get_id());
	 notifyDataSetChanged();
	 }
	 });
	 but2.setOnClickListener(new OnClickListener() {
	 public void onClick(View arg0) {
	 Intent intent=new Intent();
	 Bundle b=new Bundle();
	 b.putString("id", product.get_id()+"");
	 b.putString("proName", product.getProName()+"");
	 b.putString("proPrice", product.getProPrice()+"");
	 b.putString("proCoune", product.getProCount()+"");
	 b.putString("proAddr", product.getProAddr()+"");
	 intent.putExtras(b);
	 intent.setClass(getApplicationContext(), UpdateActivity.class);
	 startActivity(intent);
	 }
	 });
	 return v;
	 }
	
	 }
	
	}
	
	
	package com.example.save;
	
	import java.util.List;
	
	import com.dao.ProductDao;
	import com.entity.Product;
	
	import android.app.Activity;
	import android.content.Intent;
	import android.os.Bundle;
	import android.view.View;
	import android.view.View.OnClickListener;
	import android.widget.Button;
	import android.widget.EditText;
	
	public class UpdateActivity extends Activity {
	 private EditText edtname,edtprice,edtcount,edtaddress;
	 private Button btnSave,btnSelect;
	 private ProductDao dao;
	 private Product product;
	 List<Product> proList;
	 public void init(){
	 edtname=(EditText) findViewById(R.id.etname);
	 edtprice=(EditText) findViewById(R.id.etprice);
	 edtcount=(EditText) findViewById(R.id.etcount);
	 edtaddress=(EditText) findViewById(R.id.etaddress);
	 btnSave=(Button) findViewById(R.id.bnSave);
	 btnSelect=(Button) findViewById(R.id.bnSelect);
	 }
	 private void show() {
	 // TODO Auto-generated method stub
	 Bundle bundle=this.getIntent().getExtras();
	 String name=bundle.getString("proName");
	 proList=dao.queryByName(name);
	 edtname.setText(proList.get(0).getProName());
	 edtprice.setText(proList.get(0).getProName());
	 edtcount.setText(proList.get(0).getProCount());
	 edtaddress.setText(proList.get(0).getProAddr());
	 }
	 protected void onCreate(Bundle savedInstanceState) {
	 super.onCreate(savedInstanceState);
	 setContentView(R.layout.update);
	 init();
	 dao=new ProductDao(this, null, null, 0);
	 show();
	 btnSave.setOnClickListener(new OnClickListener() {
	 public void onClick(View arg0) {
	 // TODO Auto-generated method stub
	 product=new Product();
	 product.setProName(edtname.getText().toString());
	 product.setProPrice(Float.parseFloat(edtprice.getText().toString()));
	 product.setProCount(Integer.parseInt(edtcount.getText().toString()));
	 product.setProAddr(edtaddress.getText().toString());
	 dao.updateByName(product);
	 }
	 });
	 btnSelect.setOnClickListener(new OnClickListener() {
	
	 @Override
	 public void onClick(View v) {
	 // TODO Auto-generated method stub
	 startActivity(new Intent(UpdateActivity.this,SelectActivity.class));
	 }
	 });
	
	 }
	
	}
	
	
	package com.entity;
	
	public class Product {
	
	 private int _id;
	 private String proName;
	 private double proPrice;
	 private int proCount;
	 private String proAddr;
	
	 public int get_id() {
	 return _id;
	 }
	
	 public void set_id(int _id) {
	 this._id = _id;
	 }
	
	 public String getProName() {
	 return proName;
	 }
	
	 public void setProName(String proName) {
	 this.proName = proName;
	 }
	
	 public double getProPrice() {
	 return proPrice;
	 }
	
	 public void setProPrice(double proPrice) {
	 this.proPrice = proPrice;
	 }
	
	 public int getProCount() {
	 return proCount;
	 }
	
	 public void setProCount(int proCount) {
	 this.proCount = proCount;
	 }
	
	 public String getProAddr() {
	 return proAddr;
	 }
	
	 public void setProAddr(String proAddr) {
	 this.proAddr = proAddr;
	 }
	
	}
	
	
	package com.dao;
	
	import java.util.ArrayList;
	import java.util.List;
	
	import com.entity.Product;
	
	import android.content.Context;
	import android.database.Cursor;
	import android.database.sqlite.SQLiteDatabase;
	import android.database.sqlite.SQLiteDatabase.CursorFactory;
	import android.database.sqlite.SQLiteOpenHelper;
	
	public class ProductDao extends SQLiteOpenHelper{
	 private static final String DataName="data.db";
	 private static final int VERSIN=1;
	 public ProductDao(Context context, String name, CursorFactory factory,
	 int version) {
	 super(context, DataName, factory, VERSIN);
	 // TODO Auto-generated constructor stub
	 }
	
	 @Override
	 public void onCreate(SQLiteDatabase db) {
	 // TODO Auto-generated method stub
	 String sqlstr="create table Product(_id integer primary key autoincrement," +
	 "proName text,proPrice real,proCount integer,proAddr text)";
	
	 String sql0="create table product(_id int identity(1,1) primary key ,proName varchar(20),proPrice double,proCount int,proAddr varchar(20))";
	 String sql2="CREATE TABLE [product]("
	 +"[_id] AUTOINC,"
	 +"[proName] varchar(20) not null on conflict fail,"
	 +"[proPrice] double"
	 +"[proCount] int"
	 +"[proAddr] varchar(20)"
	 +"constraint[sqllite_autoindex_t_contacts_1 primary key([_id]))";
	 String sql = "create table product(_id integer primary key autoincrement," +
	 "proName text,proPrice real,proCount integer,proAddr text)";
	 db.execSQL(sqlstr);
	 }
	 @Override
	 public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
	 // TODO Auto-generated method stub
	 String sql="drop table if exists product";
	 db.execSQL(sql);
	 db.close();
	 }
	 //增
	 public void add(Product p){
	
	
	 String sql="insert into product(proName,proPrice,proCount,proAddr) values(?,?,?,?)";
	 SQLiteDatabase db=getWritableDatabase();
	 db.execSQL(sql, new Object[]{
	 p.getProName(),
	 p.getProPrice(),
	 p.getProCount(),
	 p.getProAddr()
	 });
	 db.close();
	 }
	 //通过id删
	 public void delById(int id){
	 String sql="delete from product where _id =?";
	 SQLiteDatabase db=getWritableDatabase();
	 db.execSQL(sql, new Object[]{id});
	 db.close();
	 }
	 //查所有
	 public List<Product> query(){
	 List<Product> list=new ArrayList<Product>();
	 String sql="select * from product";
	 SQLiteDatabase db=getReadableDatabase();
	 Cursor cursor=db.rawQuery(sql,null);
	 while(cursor.moveToNext()){
	 Product p=new Product();
	 p.set_id(cursor.getInt(0));
	 p.setProName(cursor.getString(1));
	 p.setProPrice(cursor.getDouble(2));
	 p.setProCount(cursor.getInt(3));
	 p.setProAddr(cursor.getString(4));
	 list.add(p);
	 }
	 db.close();
	 cursor.close();
	 return list;
	 }
	
	 //通过proname删除
	 public void delbyName(String proName) {
	 String sql="delete from product where proName =?";
	 SQLiteDatabase db=getWritableDatabase();
	 db.execSQL(sql, new Object[]{proName});
	 db.close();
	 }
	
	 //通过proName更新
	 public void updateByName(Product p){
	 String sql="update product set proPrice=?,proCount=?,proAddr=? where proName = ?";
	 SQLiteDatabase db=getWritableDatabase();
	 db.execSQL(sql, new Object[]{
	 p.getProPrice(),
	 p.getProCount(),
	 p.getProAddr(),
	 p.getProName(),
	 });
	 db.close();
	 }
	 //通过name查
	 public List<Product> queryByName(String name){
	 List<Product> list=new ArrayList<Product>();
	 String sql="select * from product";
	 SQLiteDatabase db=getReadableDatabase();
	 Cursor cursor=db.rawQuery(sql,new String []{name});
	 while(cursor.moveToNext()){
	 Product p=new Product();
	 p.set_id(cursor.getInt(0));
	 p.setProName(cursor.getString(1));
	 p.setProPrice(cursor.getDouble(2));
	 p.setProCount(cursor.getInt(3));
	 p.setProAddr(cursor.getString(4));
	 list.add(p);
	 }
	 db.close();
	 cursor.close();
	 return list;
	 }
	
	}
试试其它关键字
　SQLite　
同语言下
可能有用的
泺清贡献的其它代码(14)