Android | 1. Fragment中使用SQLite实现简单存储及查询

流程：1.在新建页面输入标题(et_title)和内容(et_content)

          2.点击“提交(btn_submit)”，添加至SQLite数据库

          3.点击“Log显示数据(btn_show)”，通过Log查看数据库中已存数据

1.SoundFragment（新建页）

（效果如下）

public class SoundFragment extends Fragment { 
	 
	String TAG = "TAG";
	private EditText et_title,et_content;
	private Button btn_submit,btn_show;
	private SQLiteDatabase db;	
	MySQLiteHelper helper;
	
    @Override 
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { 
        View view = inflater.inflate(R.layout.sound_fragment, container, false); 
        return view; 
    } 
    
    @Override
	public void onActivityCreated(Bundle savedInstanceState) {
		// TODO Auto-generated method stub
		super.onActivityCreated(savedInstanceState);
		
		et_title = (EditText)getActivity().findViewById(R.id.et_title);
		et_content = (EditText)getActivity().findViewById(R.id.et_content);
		
		
		helper = new MySQLiteHelper(getActivity(),"diary",null,1);
		
		
		btn_submit = (Button)getActivity().findViewById(R.id.btn_submit);
		btn_submit.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				db = helper.getWritableDatabase();
				Insert();
				
				et_title.setText("");
				et_content.setText("");

			}
		});
		
		btn_show = (Button)getActivity().findViewById(R.id.btn_show);
		btn_show.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				
				//得到数据库
				db = helper.getWritableDatabase();
				//查询数据
				Query();
			}
		});
	
	}
    public void Query(){
		Cursor cursor= db.query("diary",null,null,null,null,null,null);
		if(cursor.moveToFirst()){
			do{
				String title = cursor.getString(cursor.getColumnIndex("title"));
				String content = cursor.getString(cursor.getColumnIndex("content"));
				Log.i(TAG, "title:" + title);
				Log.i(TAG, "content:" + content);
			}while(cursor.moveToNext());
		}
		cursor.close();
	}
    public void Insert(){
    	ContentValues values = new ContentValues();
		values.put("title", et_title.getText().toString());
		values.put("content", et_content.getText().toString());
		db.insert("diary", null, values);
    }
 
} 

2.MySQLiteHelper

学习SQLite必知的SQLiteOpenHelper，如果不知道自行度娘吧，我解释的也不专业~

public class MySQLiteHelper extends SQLiteOpenHelper{

	private Context context;
	
	public MySQLiteHelper(Context context, String name,
			CursorFactory factory, int version) {
		
		super(context, "Blossom.db", null, 1);
		this.context = context;
	}
	
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL("create table diary(id integer PRIMARY KEY AUTOINCREMENT," 
				+"title text,content text)");
	}
	
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldversion, int newversion) {
		// TODO Auto-generated method stub
		db.execSQL("drop table if exists diary");
		onCreate(db);
	}
		
}

之后我们点击Log显示数据，在logcat中即显示：

证明数据成功的存入了SQLite，同时也成功的查到了数据！！

ps.感谢我在网上借鉴的一些大佬，希望我也能早日成为大佬。