android车辆管理系统源码

【核心代码】

public class StudentInformationManagerActivity extends Activity {

private int op_imageid[] = { R.drawable.addstudent_image,
R.drawable.deletestudent_image, R.drawable.refreshstudent_image,
R.drawable.user_image, R.drawable.sms_all };
private String str[] = { "新增", "删除", "刷新", "管理用户", "短信群发" };
private ListView listView;
private View visView;
private boolean flag = true;
private MySqlHelper mySqlHelper;
private SQLiteDatabase db;
private List<Student> students = new ArrayList<Student>();
private ListView stu_listview;
private CheckBox checkboxsum;
private boolean chboxall = false;
private ArrayList<CheckBox> cbs = new ArrayList<CheckBox>();
private String updateName;
private AutoCompleteTextView serach_edit;
private List<String> lists = new ArrayList<String>();
private ActionBar actionBar;
private JSONArray jsonArray;
private ImageView stu_headimage;

@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.studentinfomationmaneger);

mySqlHelper = new MySqlHelper(StudentInformationManagerActivity.this,
"student_inf.db", null, 1);
db = mySqlHelper.getWritableDatabase();

actionBar = getActionBar();
actionBar.setDisplayShowHomeEnabled(false);
actionBar.setHomeButtonEnabled(false);
actionBar.setDisplayShowTitleEnabled(false);

checkboxsum = (CheckBox) findViewById(R.id.checkboxsum);
checkboxsum.setOnCheckedChangeListener(new OnCheckedChangeListener() {

@Override
public void onCheckedChanged(CompoundButton arg0, boolean arg1) {
// TODO Auto-generated method stub
chboxall = arg1;
stu_adapter.notifyDataSetChanged();
}
});

stu_listview = (ListView) findViewById(R.id.stu_listview);
stu_listview.setAdapter(stu_adapter);
stu_listview.setOnItemClickListener(new OnItemClickListener() {

@Override
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
long arg3) {
// TODO Auto-generated method stub
showInformation(arg2);
System.out.println(arg2);
}
});

}

public void addStudent() {
Intent intent = new Intent(StudentInformationManagerActivity.this,
AddStudentActivity.class);
startActivity(intent);

}

public void delStudent() {

for (Student student : students) {
System.out.println(student.isChecked());
if (student.isChecked()) {
Cursor cursor = db.rawQuery("delete from student where id = '"
student.getId() "'", null);
cursor.moveToNext();
}
}

// Cursor cursor =
// db.rawQuery("delete from student where id = '" id "'", null);
// cursor.moveToNext();
onResume();
// chboxall = false;
}

private void sms_all() {
Cursor cursor = db.rawQuery("select phone from student", null);
String str_sms = "";
while (cursor.moveToNext()) {
str_sms = str_sms cursor.getString(0) ",";
}
Intent intent1 = new Intent(Intent.ACTION_SENDTO, Uri.parse("smsto:"
str_sms));
startActivity(intent1);
}

public void showInformation(final int temp) {
Builder builder = new Builder(StudentInformationManagerActivity.this);
LayoutInflater inflater = LayoutInflater
.from(StudentInformationManagerActivity.this);
View view = inflater.inflate(R.layout.showstudentinf, null);
final AlertDialog dialog = builder.setTitle("车辆详细信息").setView(view)
.create();
Button sxiugai = (Button) view.findViewById(R.id.sxiugai);
Button sok = (Button) view.findViewById(R.id.sok);
Button scancel = (Button) view.findViewById(R.id.scancel);
final EditText sname = (EditText) view.findViewById(R.id.sname);
final EditText ssex = (EditText) view.findViewById(R.id.ssex);
final EditText smingzu = (EditText) view.findViewById(R.id.smingzu);
final EditText sid = (EditText) view.findViewById(R.id.sid);
final EditText sbir = (EditText) view.findViewById(R.id.sbir);
final EditText sphone = (EditText) view.findViewById(R.id.sphone);
final EditText smore = (EditText) view.findViewById(R.id.smore);
stu_headimage = (ImageView) view
.findViewById(R.id.stu_headimage);
ImageView callstu = (ImageView) view.findViewById(R.id.callstu);
ImageView smsstu = (ImageView) view.findViewById(R.id.smsstu);
sname.setText(students.get(temp).getName().toString());
ssex.setText(students.get(temp).getSex().toString());
smingzu.setText(students.get(temp).getMingZu().toString());
sid.setText(students.get(temp).getId().toString());
sbir.setText(students.get(temp).getBirthday().toString());
sphone.setText(students.get(temp).getPhone().toString());
smore.setText(students.get(temp).getMore().toString());

Cursor cursor = db.rawQuery(
"select * from student where id = '"
students.get(temp).getId().toString() "'", null);
// 知道只有一条记录 直接moveToNext
cursor.moveToNext();
// cursor.getColumnIndex("image")获取列的索引
byte[] imageBytes = cursor.getBlob(cursor.getColumnIndex("image"));
Bitmap bitmap = BitmapFactory.decodeByteArray(imageBytes, 0,
imageBytes.length);
stu_headimage.setImageBitmap(bitmap);

dialog.show();
updateName = students.get(temp).getName().toString();
stu_headimage.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
chooseImage();
}
});
sxiugai.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
sname.setEnabled(true);
ssex.setEnabled(true);
smingzu.setEnabled(true);
sid.setEnabled(true);
sbir.setEnabled(true);
sphone.setEnabled(true);
smore.setEnabled(true);
}
});
sok.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Bitmap bitmap = ((BitmapDrawable)stu_headimage.getDrawable()).getBitmap();
ByteArrayOutputStream byteOut = new ByteArrayOutputStream();
// 压缩bitmap到ByteArrayOutputStream
bitmap.compress(CompressFormat.PNG, 100, byteOut);
// Cursor cursor = db.rawQuery("update student set name = '"
// sname.getText().toString() "',sex = '"
// ssex.getText().toString() "',mingzu = '"
// smingzu.getText().toString() "',id = '"
// sid.getText().toString() "',birthday = '"
// sbir.getText().toString() "',phone = '"
// sphone.getText().toString() "',more = '"
// smore.getText().toString() "' ,image = '"
// byteOut.toByteArray() "' where name = '"
// updateName "'", null);

ContentValues values = new ContentValues();
values.put("name", sname.getText().toString());
values.put("sex", ssex.getText().toString());
values.put("mingzu", smingzu.getText().toString());
values.put("id", sid.getText().toString());
values.put("birthday", sbir.getText().toString());
values.put("phone", sphone.getText().toString());
values.put("more", smore.getText().toString());
values.put("image", byteOut.toByteArray());
db.update("student", values, "name=?", new String[]{updateName});
//cursor.moveToNext();
// Toast.makeText(StudentInformationManagerActivity.this,
// "修改成功！",
// Toast.LENGTH_SHORT).show();
dialog.dismiss();
}
});
scancel.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
dialog.dismiss();
}
});
callstu.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent intent = new Intent(Intent.ACTION_CALL, Uri.parse("tel:"
sphone.getText().toString()));
startActivity(intent);
}
});
smsstu.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent intent = new Intent(Intent.ACTION_SENDTO, Uri
.parse("smsto:" sphone.getText().toString()));
startActivity(intent);
}
});
}

public void userMana() {
Intent intent = new Intent(StudentInformationManagerActivity.this,
UserManage.class);
startActivity(intent);
}

@Override
protected void onResume() {
// TODO Auto-generated method stub
students = new ArrayList<Student>();
Cursor cursor = db.rawQuery("select * from student", null);
while (cursor.moveToNext()) {
students.add(new Student(cursor.getString(1), cursor.getString(2),
cursor.getString(3), cursor.getString(4), cursor
.getString(5), cursor.getString(6), cursor
.getString(7)));
}
// stu_listview.setAdapter(stu_adapter);
stu_adapter.notifyDataSetChanged();
super.onResume();
}

BaseAdapter stu_adapter = new BaseAdapter() {

@Override
public View getView(int arg0, View arg1, ViewGroup arg2) {
// TODO Auto-generated method stub
View view = LayoutInflater.from(
StudentInformationManagerActivity.this).inflate(
R.layout.stulistviewitems, null);
CheckBox stu_checkbox = (CheckBox) view
.findViewById(R.id.stu_checkbox);
TextView stu_list_name = (TextView) view
.findViewById(R.id.stu_list_name);
TextView stu_list_id = (TextView) view
.findViewById(R.id.stu_list_id);
TextView stu_list_sex = (TextView) view
.findViewById(R.id.stu_list_sex);
final int position = arg0;
stu_checkbox.setChecked(chboxall);
stu_checkbox
.setOnCheckedChangeListener(new OnCheckedChangeListener() {

@Override
public void onCheckedChanged(CompoundButton buttonView,
boolean isChecked) {
// TODO Auto-generated method stub
students.get(position).setChecked(isChecked);
}
});
stu_list_name.setText(students.get(arg0).getName().toString());
stu_list_id.setText(students.get(arg0).getId().toString());
stu_list_sex.setText(students.get(arg0).getSex().toString());

return view;
}

@Override
public long getItemId(int arg0) {
// TODO Auto-generated method stub
return 0;
}

@Override
public Object getItem(int arg0) {
// TODO Auto-generated method stub
return null;
}

@Override
public int getCount() {
// TODO Auto-generated method stub
return students.size();
}
};

public void jsonDownload(){
StringBuffer stringBuffer = new StringBuffer();
try {
InputStream inStream = getResources().openRawResource(R.raw.student);
BufferedReader bfReader = new BufferedReader(new InputStreamReader(
inStream, "GBK"));

String strLine = "";
while ((strLine=bfReader.readLine()) != null) {
stringBuffer.append(strLine);
}
jsonArray = new JSONArray(stringBuffer.toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

for(int i = 0;i < jsonArray.length();i ){
try {
JSONObject object = jsonArray.getJSONObject(i);
Bitmap bitmap = ((BitmapDrawable) getResources().getDrawable(
R.drawable.image)).getBitmap();
//Bitmap bitmap = ((BitmapDrawable)headimage.getDrawable()).getBitmap();
ByteArrayOutputStream byteOut = new ByteArrayOutputStream();
// 压缩bitmap到ByteArrayOutputStream
bitmap.compress(CompressFormat.PNG, 100, byteOut);
ContentValues values = new ContentValues();
values.put("name", object.getString("name"));
values.put("sex", object.getString("sex"));
values.put("mingzu", object.getString("mingzu"));
values.put("id", object.getString("id"));
values.put("birthday",object.getString("birthday"));
values.put("phone", object.getString("phone"));
values.put("more", object.getString("more"));
values.put("image", byteOut.toByteArray());
db.insert("student", null, values);


} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Toast.makeText(StudentInformationManagerActivity.this, "导入成功，请刷新！", Toast.LENGTH_SHORT).show();
onResume();
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
// TODO Auto-generated method stub
MenuInflater inflater = new MenuInflater(
StudentInformationManagerActivity.this);
inflater.inflate(R.menu.contextmenu, menu);

View searchView = menu.findItem(R.id.search).getActionView();
ImageView search = (ImageView) searchView
.findViewById(R.id.image_search);
search.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
System.out.println(1111);
// TODO Auto-generated method stub
students = new ArrayList<Student>();
Cursor cursor = db.rawQuery(
"select * from student where name like '%"
serach_edit.getText().toString() "%' or id like '%" serach_edit.getText().toString() "%' or sex like '%" serach_edit.getText().toString() "%'", null);
while (cursor.moveToNext()) {
students.add(new Student(cursor.getString(1), cursor
.getString(2), cursor.getString(3), cursor
.getString(4), cursor.getString(5), cursor
.getString(6), cursor.getString(7)));
}
// stu_listview.setAdapter(stu_adapter);
Toast.makeText(StudentInformationManagerActivity.this, "搜索完毕！",
Toast.LENGTH_SHORT).show();
stu_adapter.notifyDataSetChanged();
}
});
serach_edit = (AutoCompleteTextView) searchView
.findViewById(R.id.search_edit);
Cursor cursorstu = db.rawQuery("select name from student", null);
while (cursorstu.moveToNext()) {
lists.add(cursorstu.getString(0));
}
serach_edit.setThreshold(1);
ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(
StudentInformationManagerActivity.this,
android.R.layout.simple_list_item_1, lists);
serach_edit.setAdapter(arrayAdapter);

return super.onCreateOptionsMenu(menu);
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case R.id.stu_add:
addStudent();
break;
case R.id.stu_del:
delStudent();
break;
case R.id.stu_ref:
onResume();
break;
case R.id.user_ma:
userMana();
break;
case R.id.stu_smsall:
sms_all();
break;
case R.id.stu_json:
jsonDownload();
break;

}
return super.onOptionsItemSelected(item);
}

private void chooseImage() {
// 选择相册
Intent intent = new Intent(Intent.ACTION_PICK,
android.provider.MediaStore.Images.Media.EXTERNAL_CONTENT_URI);
startActivityForResult(intent, 1);
}

@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);

if (requestCode == 1) {
if (resultCode == Activity.RESULT_OK && null != data) {
Uri selectedImagePath = data.getData();
Cursor cursor = getContentResolver().query(selectedImagePath,
null, null, null, null);

if (cursor == null) {
Toast.makeText(StudentInformationManagerActivity.this, "cursor == null",
2000).show();
} else {
cursor.moveToFirst();
String img = cursor.getString(1);
// System.out.println("img:" img);
//
// student.setImgPath(img);
cursor.close();
Bitmap bitmap = BitmapFactory.decodeFile(img);

stu_headimage.setImageBitmap(bitmap);
}
}
}
}
}