package yyy.testdatabase;
import java.io.File;
import java.util.ArrayList;
import android.app.Activity;
import android.app.AlertDialog;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.Window;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.GridView;
import android.widget.HorizontalScrollView;
import android.widget.ListView;
import android.widget.TextView;
public class TestDataBase extends Activity {
DataBaseHelper helper;
private TextView textView;
private ListView listView;
private GridView gridView;
private Button button;
private HorizontalScrollView layout;
private ArrayList<String> list1;
private ArrayList<ArrayList<String>> lists = new ArrayList<ArrayList<String>>();
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
listView = (ListView) findViewById(R.id.listview);
button = (Button) findViewById(R.id.button);
layout = (HorizontalScrollView) findViewById(R.id.layout);
File file = getFilesDir();
String path = file.getAbsolutePath()+"/trade.db";
ArrayList<String> list = new ArrayList<String>();
list.add("");
list.add("流水号");
list.add("交易金额");
list.add("银行卡号");
list.add("交易时间");
list.add("交易状态");
lists.add(list);
helper = new DataBaseHelper(this, path, 1);
final SQLiteDatabase db = helper.getReadableDatabase();
db.execSQL("insert into trade values(null,?,?,?,?,?)",
new String[]{"123456","100","622712546985642","2009-12-21 20:21:12","成功"} );
db.execSQL("insert into trade values(null,?,?,?,?,?)",
new String[]{"123456","100","622712546985642","2009-12-21 20:21:12","成功"} );
db.execSQL("insert into trade values(null,?,?,?,?,?)",
new String[]{"123456","100","622712546985642","2009-12-21 20:21:12","成功"} );
int i = 0;
button.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
Cursor cursor = db.rawQuery("select * from trade", null);
while (cursor.moveToNext()) {
//"create table trade(_id integer primary key autoincrement,serialNo,money,cardNum,date,status)";
list1 = new ArrayList<String>();
list1.add(cursor.getString(cursor.getColumnIndex("_id")));
list1.add(cursor.getString(cursor.getColumnIndex("serialNo")));
list1.add(cursor.getString(cursor.getColumnIndex("money")));
list1.add(cursor.getString(cursor.getColumnIndex("cardNum")));
list1.add(cursor.getString(cursor.getColumnIndex("date")));
list1.add(cursor.getString(cursor.getColumnIndex("status")));
lists.add(list1);
}
cursor.close();
MyAdapter adapter = new MyAdapter(TestDataBase.this, lists);
listView.setAdapter(adapter);
layout.setVisibility(View.VISIBLE);
}
});
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
TestDataBase.rar (44个子文件)
TestDataBase
bin
TestDataBase.apk 33KB
classes.dex 9KB
res
drawable-ldpi
ic_launcher.png 2KB
drawable-hdpi
ic_launcher.png 4KB
drawable
domo_toolbar_bg.png 166B
num_bg.png 279B
filemanagermenubg_w.png 11KB
scanframeline.png 449B
drawable-mdpi
ic_launcher.png 2KB
classes
yyy
testdatabase
R$layout.class 458B
R$id.class 614B
R$drawable.class 550B
R$attr.class 334B
R.class 609B
TestDataBase$1.class 2KB
R$string.class 421B
TestDataBase.class 4KB
R$color.class 419B
DataBaseHelper.class 1KB
R$style.class 437B
MyAdapter.class 3KB
resources.ap_ 26KB
res
drawable-ldpi
ic_launcher.png 2KB
drawable-hdpi
ic_launcher.png 4KB
drawable
domo_toolbar_bg.png 166B
num_bg.png 279B
filemanagermenubg_w.png 11KB
scanframeline.png 449B
values
colors.xml 153B
strings.xml 190B
styles.xml 555B
drawable-mdpi
ic_launcher.png 3KB
layout
list_item.xml 2KB
main.xml 1KB
search_result.xml 1KB
assets
gen
yyy
testdatabase
R.java 2KB
proguard.cfg 1KB
src
yyy
testdatabase
DataBaseHelper.java 797B
MyAdapter.java 3KB
TestDataBase.java 3KB
.project 848B
.classpath 364B
project.properties 360B
AndroidManifest.xml 783B
共 44 条
- 1
Central-Perk
- 粉丝: 474
- 资源: 20
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页