美文网首页
Android英语单词本

Android英语单词本

作者: shakesbears | 来源:发表于2016-04-16 13:57 被阅读267次

    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();           
     }        }    }}
    

    相关文章

      网友评论

          本文标题:Android英语单词本

          本文链接:https://www.haomeiwen.com/subject/ndgnlttx.html