package com.yangliansheng.news;
import java.util.ArrayList;
import android.os.Bundle;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ListView;
import android.widget.Toast;
public class MainActivity extends Activity {
private ListView lv_title,lv_id;
private Button bt_add;
SqliteDatabaseCreate sd;
SQLiteDatabase db;
int id;
Cursor cr;
AlertDialog ad;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
lv_title=(ListView) findViewById(R.id.lv_title);
lv_id=(ListView) findViewById(R.id.lv_id);
bt_add=(Button) findViewById(R.id.bt_add);
dataInit();
lv_title.setOnItemClickListener(new OnItemClickListener() {
public void onItemClick(AdapterView<?> arg0, View arg1, int position,
long uid) {
// TODO Auto-generated method stub
cr.moveToPosition(position);
id=cr.getInt(cr.getColumnIndex(InformationTable.ID));
alertDialogCreat();
ad.show();
}
});
lv_id.setOnItemClickListener(new OnItemClickListener() {
public void onItemClick(AdapterView<?> arg0, View arg1, int position,
long uid) {
// TODO Auto-generated method stub
cr.moveToPosition(position);
id=cr.getInt(cr.getColumnIndex(InformationTable.ID));
alertDialogCreat();
ad.show();
}
});
bt_add.setOnClickListener(new OnClickListener() {
public void onClick(View arg0) {
// TODO Auto-generated method stub
Intent in=new Intent(MainActivity.this,AddActivity.class);
startActivity(in);
}
});
}
private void alertDialogCreat() {
ad=new AlertDialog.Builder(this).create();
ad.setMessage("提示信息：");
ad.setButton("查看", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface arg0, int arg1) {
// TODO Auto-generated method stub
Intent in=new Intent(MainActivity.this,SelectActivity.class);
Bundle bd=new Bundle();
bd.putInt("id", id);
in.putExtras(bd);
startActivity(in);
}
public void onClick(View arg0) {
// TODO Auto-generated method stub
}
});
ad.setButton2("修改", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface arg0, int arg1) {
// TODO Auto-generated method stub
Intent in=new Intent(MainActivity.this,UpdateActivity.class);
Bundle bd=new Bundle();
bd.putInt("id", id);
in.putExtras(bd);
startActivity(in);
}
public void onClick(View arg0) {
// TODO Auto-generated method stub
}
});
ad.setButton3("直接删除", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface arg0, int arg1) {
// TODO Auto-generated method stub
String condition=" " id "=" InformationTable.ID;
db.delete(InformationTable.DataTable_Name, condition, null);
Toast.makeText(MainActivity.this, "删除成功",Toast.LENGTH_SHORT).show();
dataInit();
}
public void onClick(View arg0) {
// TODO Auto-generated method stub
}
});
}
private void dataInit() {
ArrayList<String> al_title=new ArrayList<String>();
ArrayList<String> al_id=new ArrayList<String>();
sd=new SqliteDatabaseCreate(MainActivity.this);
db=sd.getReadableDatabase();
String []col={InformationTable.ID,InformationTable.Title,InformationTable.Content};
cr=db.query(InformationTable.DataTable_Name, col, null, null, null, null, null);
startManagingCursor(cr);
while(cr.moveToNext())
{
String title=cr.getString(cr.getColumnIndex(InformationTable.Title));
String id=cr.getString(cr.getColumnIndex(InformationTable.ID));
al_title.add(title);
al_id.add(id);
}
ArrayAdapter<String> aa=new ArrayAdapter<String>(MainActivity.this, R.layout.tv_lv, R.id.tv_lv_title,al_title);
lv_title.setAdapter(aa);
ArrayAdapter<String> a=new ArrayAdapter<String>(MainActivity.this, R.layout.tv_lv, R.id.tv_lv_id,al_id);
lv_id.setAdapter(a);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.activity_main, menu);
return true;
}
}
资源文件列表
news/.classpath , 475
news/.project , 840
news/.settings/org.eclipse.jdt.core.prefs , 177
news/AndroidManifest.out.xml , 0
news/AndroidManifest.xml , 1269
news/bin/AndroidManifest.xml , 1269
news/bin/classes/com/yangliansheng/news/AddActivity$1.class , 2202
news/bin/classes/com/yangliansheng/news/AddActivity.class , 1758
news/bin/classes/com/yangliansheng/news/BuildConfig.class , 353
news/bin/classes/com/yangliansheng/news/InformationTable.class , 655
news/bin/classes/com/yangliansheng/news/MainActivity$1.class , 1574
news/bin/classes/com/yangliansheng/news/MainActivity$2.class , 1574
news/bin/classes/com/yangliansheng/news/MainActivity$3.class , 1046
news/bin/classes/com/yangliansheng/news/MainActivity$4.class , 1463
news/bin/classes/com/yangliansheng/news/MainActivity$5.class , 1463
news/bin/classes/com/yangliansheng/news/MainActivity$6.class , 1719
news/bin/classes/com/yangliansheng/news/MainActivity.class , 4657
news/bin/classes/com/yangliansheng/news/R$attr.class , 352
news/bin/classes/com/yangliansheng/news/R$drawable.class , 459
news/bin/classes/com/yangliansheng/news/R$id.class , 967
news/bin/classes/com/yangliansheng/news/R$layout.class , 558
news/bin/classes/com/yangliansheng/news/R$menu.class , 523
news/bin/classes/com/yangliansheng/news/R$string.class , 657
news/bin/classes/com/yangliansheng/news/R$style.class , 407
news/bin/classes/com/yangliansheng/news/R.class , 661
news/bin/classes/com/yangliansheng/news/SelectActivity$1.class , 1301
news/bin/classes/com/yangliansheng/news/SelectActivity.class , 3149
news/bin/classes/com/yangliansheng/news/SqliteDatabaseCreate.class , 1648
news/bin/classes/com/yangliansheng/news/UpdateActivity$1.class , 1301
news/bin/classes/com/yangliansheng/news/UpdateActivity.class , 3043
news/bin/classes.dex , 412840
news/bin/com.yangliansheng.news.MainActivity.apk , 157069
news/bin/dexedLibs/android-support-v4-d744862b9942cafa5d6ffd44ceba00c6.jar , 135171
news/bin/jarlist.cache , 120
news/bin/news.apk , 159552
news/bin/res/crunch/drawable-hdpi/ic_action_search.png , 409
news/bin/res/crunch/drawable-hdpi/ic_launcher.png , 1499
news/bin/res/crunch/drawable-ldpi/ic_launcher.png , 649
news/bin/res/crunch/drawable-mdpi/ic_action_search.png , 311
news/bin/res/crunch/drawable-mdpi/ic_launcher.png , 940
news/bin/res/crunch/drawable-xhdpi/ic_action_search.png , 491
news/bin/res/crunch/drawable-xhdpi/ic_launcher.png , 1792
news/bin/res/drawable-hdpi/ic_action_search.png , 409
news/bin/res/drawable-hdpi/ic_launcher.png , 1499
news/bin/res/drawable-ldpi/ic_launcher.png , 649
news/bin/res/drawable-mdpi/ic_action_search.png , 311
news/bin/res/drawable-mdpi/ic_launcher.png , 940
news/bin/res/drawable-xhdpi/ic_action_search.png , 491
news/bin/res/drawable-xhdpi/ic_launcher.png , 1792
news/bin/resources.ap_ , 15997
news/gen/com/yangliansheng/news/BuildConfig.java , 164
news/gen/com/yangliansheng/news/R.java , 2683
news/ic_launcher-web.png , 8407
news/libs/android-support-v4.jar , 349252
news/proguard-project.txt , 781
news/project.properties , 563
news/res/drawable-hdpi/ic_action_search.png , 3120
news/res/drawable-hdpi/ic_launcher.png , 1122
news/res/drawable-ldpi/ic_launcher.png , 485
news/res/drawable-mdpi/ic_action_search.png , 3030
news/res/drawable-mdpi/ic_launcher.png , 722
news/res/drawable-xhdpi/ic_action_search.png , 3199
news/res/drawable-xhdpi/ic_launcher.png , 1624
news/res/layout/activity_add.xml , 1702
news/res/layout/activity_main.xml , 1071
news/res/layout/activity_select.xml , 962
news/res/layout/activity_update.xml , 1681
news/res/layout/tv_lv.xml , 635
news/res/menu/activity_add.xml , 240
news/res/menu/activity_main.xml , 240
news/res/menu/activity_select.xml , 240
news/res/menu/activity_update.xml , 240
news/res/values/strings.xml , 429
news/res/values/styles.xml , 89
news/res/values-v11/styles.xml , 94
news/res/values-v14/styles.xml , 108
news/src/com/yangliansheng/news/AddActivity.java , 1775
news/src/com/yangliansheng/news/InformationTable.java , 318
news/src/com/yangliansheng/news/MainActivity.java , 4758
news/src/com/yangliansheng/news/SelectActivity.java , 2070
news/src/com/yangliansheng/news/SqliteDatabaseCreate.java , 1180
news/src/com/yangliansheng/news/UpdateActivity.java , 2130