java安卓版代码_Android仓库管理系统（单机版）

package tian.biye;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import android.app.Activity;

import android.app.AlertDialog;

import android.content.DialogInterface;

import android.content.DialogInterface.OnClickListener;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.view.View;

import android.widget.AdapterView;

import android.widget.AdapterView.OnItemClickListener;

import android.widget.ListView;

import android.widget.SimpleAdapter;

/**

* 查询入库页面

*

* @author 田志远

*

*/

public class Chaxunr extends Activity {

private ListView listview;

String id[];

String cname[];

String pname[];

String add[];

String city[];

String diqu[];

String youbian[];

String tel[];

String chuanzhen[];

String web[];

SqlHelpdemo db;

int i = 0;

SQLiteDatabase sDatabase = null;

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.chaxunc1);

setTitle("查询入库");

final AlertDialog.Builder builder = new AlertDialog.Builder(this);

db = new SqlHelpdemo(getApplicationContext(), "store.db", null, 1);

sDatabase = db.getWritableDatabase();

listview = (ListView) findViewById(R.id.kehulist);

List> slist = new ArrayList>();

String selectStr = "select _id,comname,pername,tel,products,guige,danwei,danjia,num,date from ruku";

Cursor cursor = sDatabase.rawQuery(selectStr, null);

cursor.moveToFirst();

int count = cursor.getCount();

id = new String[count];

cname = new String[count];

pname= new String[count];

add= new String[count];

city= new String[count];

diqu = new String[count];

youbian= new String[count];

tel= new String[count];

chuanzhen= new String[count];

web = new String[count];

do {

try {

id[i] = cursor.getString(0);

cname[i] = cursor.getString(1);

pname[i] = cursor.getString(2);

add[i] = cursor.getString(3);

city[i] = cursor.getString(4);

diqu[i] = cursor.getString(5);

youbian[i] = cursor.getString(6);

tel[i] = cursor.getString(7);

chuanzhen[i] = cursor.getString(8);

web[i] = cursor.getString(9);

i++;

} catch (Exception e) {

// TODO: handle exception

}

} while (cursor.moveToNext());

for (int i = 0; i < id.length; i++) {

Map map = new HashMap();

map.put("id", id[i]);

map.put("cname", cname[i]);

map.put("pname", pname[i]);

map.put("add", add[i]);

map.put("city", city[i]);

map.put("diqu", diqu[i]);

map.put("youbian", youbian[i]);

map.put("tel", tel[i]);

map.put("chuanzhen", chuanzhen[i]);

map.put("web", web[i]);

slist.add(map);

}

SimpleAdapter simple = new SimpleAdapter(this, slist,

R.layout.shanchukadpter1, new String[] { "id", "cname", "pname",

"add" ,"city","diqu","youbian","tel","chuanzhen","web"}, new int[] { R.id.t1, R.id.t2, R.id.t3,

R.id.t4, R.id.t5,R.id.t6,R.id.t7,R.id.t8,R.id.t9,R.id.t10,});

listview.setAdapter(simple);

listview.setOnItemClickListener(new OnItemClickListener() {

@Override

public void onItemClick(AdapterView> arg0, View arg1, int arg2,

long arg3) {

// TODO Auto-generated method stub

for(int i=0;i

if(arg2==i){

builder.setTitle("确认消息");

builder.setMessage("确定要删除该出库吗？");

final int j=i;

builder.setPositiveButton("确定", new OnClickListener() {

@Override

public void onClick(DialogInterface dialog, int which) {

// TODO Auto-generated method stub

sDatabase.execSQL("delete from ruku where comname='"+cname[j]+"'");

Intent intent=new Intent();

intent.setClass(Chaxunr.this, Chaxunr.class);

startActivity(intent);

finish();

}

});

builder.setNegativeButton("取消", new OnClickListener() {

@Override

public void onClick(DialogInterface dialog, int which) {

// TODO Auto-generated method stub

}

});

builder.create().show();

}

}

}

});

}

}