1.Vocabulary.class
public class Vocabulary {
public int ID;
public String name;
public String text;}
2.MyDatabaseHelper.class
public class MyDatabaseHelper extends SQLiteOpenHelper {
public MyDatabaseHelper(Context context, String name, int version) {
super(context, name, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) { }
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}}
3.vocabulary_entity.class
public class vocabulary_entity {
public TextView vocabulary_text;
}
4.MyAdapter.class
public class MyAdapter extends SimpleAdapter {
List<Map<String,Vocabulary>> mList;
LayoutInflater mInflater;
public MyAdapter(Context context, List<Map<String,Vocabulary>> list, int resource, String[] from, int[] to) {
super(context,list,resource,from,to);
mList = list;
mInflater = LayoutInflater.from(context);
}
@Override
public int getCount() {
return mList.size();
}
@Override
public Object getItem(int position) {
return mList.get(position);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
ViewHolder viewHolder;
if(convertView == null){
viewHolder = new ViewHolder();
convertView = mInflater.inflate(R.layout.item,null);
viewHolder.voc_text = (TextView)convertView.findViewById(R.id.item_voc);
convertView.setTag(viewHolder);
}
else {
viewHolder = (ViewHolder)convertView.getTag();
}
Vocabulary bean = mList.get(position).get("name");
viewHolder.voc_text.setText(bean.name);
return convertView;
}
class ViewHolder{
public TextView voc_text;
}}
5.activity_vocabulary.xml
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
android:paddingBottom="@dimen/activity_vertical_margin"
android:weightSum="2" android:orientation="vertical"
tools:context="com.ljh.datatest.VocabularyActivity">
<TextView
android:gravity="center"
android:textSize="35sp"
android:text="词汇表"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
<ScrollView
android:layout_weight="2"
android:fillViewport="true"
android:layout_width="match_parent"
android:layout_height="0dp">
<ListView
android:id="@+id/lv_voc"
android:layout_width="match_parent"
android:layout_height="wrap_content"/>
</ScrollView>
<ImageButton
android:layout_gravity="center"
android:background="@drawable/add"
android:layout_width="wrap_content"
android:layout_height="wrap_content" />
</LinearLayout>
VocabularyActivity.class
6.activity_vocabulary_detail.xml
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:orientation="vertical"
android:layout_height="match_parent"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
android:paddingBottom="@dimen/activity_vertical_margin"
tools:context="com.ljh.datatest.VocabularyDetailActivity">
<TextView
android:text="1"
android:id="@+id/voc_name"
android:textSize="30sp"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
<TextView
android:text="2"
android:id="@+id/voc_text"
android:textSize="20sp"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
</LinearLayout>
VocabularyDetailActivity.class
public class VocabularyDetailActivity extends Activity {
TextView voc_name;
TextView voc_text;
MyDatabaseHelper dbHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_vocabulary_detail);
voc_name = (TextView)findViewById(R.id.voc_name);
voc_text = (TextView)findViewById(R.id.voc_text);
dbHelper = new MyDatabaseHelper(this,"question.db",1);
Bundle data = getIntent().getExtras();
int position = data.getInt("position");
String p = String.valueOf(position + 1);
/*Cursor cursor = dbHelper.getReadableDatabase().rawQuery("select * from vocabulary",null);
List<Map<String,Vocabulary>> list = getDatas(cursor);
Vocabulary vocabulary = list.get(position).get("name");
voc_name.setText(vocabulary.name);
voc_text.setText(vocabulary.text);
String name = String.valueOf(cursor.getColumnIndex("text"));*/
String sql = "select * from vocabulary where ID='"+p+"'";
Cursor cursor = dbHelper.getReadableDatabase().rawQuery(sql, null);
cursor.moveToFirst();
String name = cursor.getString(cursor.getColumnIndex("name"));
String text = cursor.getString(cursor.getColumnIndex("text"));
voc_name.setText(name);
voc_text.setText(text);
//测试可行,拿出第一条也是唯一一条记录
/* List<Map<String,Vocabulary>> list = getDatas(cursor);
Vocabulary vocabulary = list.get(0).get("name");
voc_name.setText(vocabulary.name);*/ }
protected ArrayList<Map<String,Vocabulary>> getDatas(Cursor cursor){
ArrayList<Map<String,Vocabulary>> result = new ArrayList<>();
while (cursor.moveToNext()){
Map<String,Vocabulary> map = new HashMap<>();
Vocabulary vocabulary = new Vocabulary();
vocabulary.name = cursor.getString(1);
vocabulary.text = cursor.getString(2);
map.put("name",vocabulary);
result.add(map); }
return result;
}}
item.xml
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical" android:layout_width="match_parent"
android:layout_height="match_parent">
<TextView
android:id="@+id/item_voc"
android:textSize="35sp"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
</LinearLayout>
7。MainActivity.class
public class MainActivity extends Activity {
MyDatabaseHelper dbHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
dbHelper = new MyDatabaseHelper(this,"question.db",1);
Button btn_voc=(Button)findViewById(R.id.btn_voc);
btn_voc.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent intent = new Intent(MainActivity.this,VocabularyActivity.class);
startActivity(intent);
}
});
String DB_PATH = "/data/data/com.ljh.datatest/databases/";
String DB_NAME = "question.db";
if((new File(DB_PATH+DB_NAME).exists())==false){
File dir=new File(DB_PATH);
if(!dir.exists()){
dir.mkdir();
}
try {
InputStream is = getBaseContext().getAssets().open(DB_NAME);
OutputStream os = new FileOutputStream(DB_PATH+DB_NAME);
byte[] buffer=new byte[2048];
int length;
while ((length = is.read(buffer))>0){
os.write(buffer,0,length);
}
os.flush();
os.close();
is.close();
} catch (IOException e) {
e.printStackTrace();
} } }}
