极客学院 android sqlite 参考代码

    xiaoxiao2026-05-16  8

    copy 到 /data/data/com.exam.administrator.exam/question 文件夹中没有拷贝权限

    @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_index); String DB_PATH = "/data/data/com.exam.administrator.exam/database/"; 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[1024]; int length; while( (length = is.read(buffer)) > 0 ) { os.write(buffer, 0, length); } os.flush(); os.close(); is.close(); }catch(IOException e){ e.printStackTrace(); } } SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(DB_PATH + DB_NAME, null); Cursor cursor = database.rawQuery("select * from question", null); if (cursor.getCount() > 0) { cursor.moveToFirst(); try { // 解决中文乱码问题 byte test[] = cursor.getBlob(0); String strtest = new String(test, "utf-8").trim(); // 看输出的信息是否正确 System.out.println(strtest); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); } } cursor.close(); Button btn = (Button)findViewById(R.id.button); btn.setOnClickListener(new View.OnClickListener(){ @Override public void onClick(View view) { Intent intent = new Intent(IndexActivity.this, ExamActivity.class); startActivity(intent); } }); }

    转载请注明原文地址: https://ju.6miu.com/read-1309742.html
    最新回复(0)