<分区>
目前，我正在开发一个 Android 应用程序，我的要求是从外部位置 中的固定位置读取 SQLite 数据库。但我并非无法打开数据库。我正在尝试的代码如下:
数据库助手:
import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Environment;
import android.util.Log;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
public class DataBaseHelper extends SQLiteOpenHelper
{
private static final int DB_VERSION = 1;
//private static final String DB_NAME = "MedRec.db";
private static final String DB_NAME = "MedRec";
public DataBaseHelper(Context context)
{
//super(context,DB_NAME,null,DB_VERSION);
super(context, Environment.getExternalStorageDirectory() + "/EMIS/MedRec", null, 1);
//super(context, context.getExternalFilesDir(null).getAbsolutePath() + "/EMIS/" + DB_NAME, null, 1);
Log.d("DB_PATH:", context.getExternalFilesDir(null).getAbsolutePath() + "/EMIS/" + DB_NAME);
}
@Override
public void onCreate(SQLiteDatabase database)
{
Log.d("CREATING TABLE :", "SUCCESS");
}
@Override
public void onUpgrade(SQLiteDatabase database,int oldVersion,int newVersion)
{
Log.d("UPGRADING TABLE :", "SUCCESS");
onCreate(database);
}
}
患者数据源:
package com.medrecordapp.main.database;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import com.medrecordapp.main.model.Patient;
import java.util.ArrayList;
public class PatientDataSource
{
private SQLiteDatabase database;
private DataBaseHelper dbHelper;
public static final String TABLE_PATIENT = "Patient";
public final static String ID = "_id";
public final static String PATIENT_ID = "PatientID";
public final static String NHS_NUMBER = "NHSNumber";
public final static String FIRST_NAME = "FirstName";
public final static String LAST_NAME = "LastName";
public final static String CATEGORY = "category";
public final static String PHONE_1 = "phone1";
public final static String PHONE_2 = "phone2";
public final static String PHOTO_FILE = "photofile";
public final static String PROFESSION = "profession";
public final static String STREET = "Street";
public final static String VILLAGE = "Village";
public final static String TOWN = "Town";
public final static String COUNTRY = "County";
public final static String POST_CODE = "PostCode";
public final static String COMMENT = "comment";
public final static String E1 = "E1";
public final static String E2 = "E2";
public final static String E3 = "E3";
public final static String E4 = "E4";
public final static String E5 = "E5";
public final static String UPD_DATE = "upddate";
public PatientDataSource(Context context)
{
dbHelper = new DataBaseHelper(context);
}
public void open() throws SQLException
{
///dbHelper.openDataBase();
//dbHelper.getReadableDatabase();
//database = dbHelper.getReadableDatabase();
database = dbHelper.getWritableDatabase();
}
public void close()
{
dbHelper.close();
}
public long addPatient(Patient patient)
{
open();
ContentValues patientValue = new ContentValues();
patientValue.put(PATIENT_ID, patient.getPatientId());
patientValue.put(NHS_NUMBER, patient.getNhsNumber());
patientValue.put(FIRST_NAME, patient.getFirstName());
patientValue.put(LAST_NAME, patient.getFirstName());
patientValue.put(CATEGORY, patient.getFirstName());
patientValue.put(PHONE_1, patient.getFirstName());
patientValue.put(PHONE_2, patient.getFirstName());
patientValue.put(PHOTO_FILE, patient.getFirstName());
patientValue.put(PROFESSION, patient.getFirstName());
patientValue.put(STREET, patient.getFirstName());
patientValue.put(VILLAGE, patient.getFirstName());
patientValue.put(TOWN, patient.getFirstName());
patientValue.put(COUNTRY, patient.getFirstName());
patientValue.put(POST_CODE, patient.getFirstName());
patientValue.put(COMMENT, patient.getFirstName());
patientValue.put(E1, patient.getFirstName());
patientValue.put(E2, patient.getFirstName());
patientValue.put(E3, patient.getFirstName());
patientValue.put(E4, patient.getFirstName());
patientValue.put(E5, patient.getFirstName());
patientValue.put(UPD_DATE, patient.getFirstName());
long insertId = database.insert(TABLE_PATIENT,null,patientValue);
Log.d("RESULT :", insertId + "");
close();
return insertId;
}
public ArrayList<Patient> loadPatient()
{
open();
ArrayList<Patient> patientList = new ArrayList<Patient>();
Cursor cursor = database.rawQuery(" SELECT * FROM Patient " , null );
cursor.moveToFirst();
while (!cursor.isAfterLast())
{
Patient patient = new Patient(
cursor.getInt(cursor.getColumnIndex("_id")) , cursor.getString(cursor.getColumnIndex("PatientID")), cursor.getString(2), cursor.getString(3),
cursor.getString(4), cursor.getString(5), cursor.getString(6), cursor.getString(6),
cursor.getString(7), cursor.getString(8), cursor.getString(9), cursor.getString(10),
cursor.getString(11), cursor.getString(12), cursor.getString(13), cursor.getString(14),
cursor.getString(15), cursor.getString(16), cursor.getString(17), cursor.getString(18),
cursor.getString(19), cursor.getString(20), cursor.getString(21)
);
patientList.add(patient);
cursor.moveToNext();
}
cursor.close();
close();
return patientList;
}
public ArrayList<Patient> loadPatient(String patientId)
{
open();
ArrayList<Patient> patientList = new ArrayList<Patient>();
Cursor cursor = database.rawQuery(" SELECT * FROM Patient WHERE _id = ?" , new String[]{ patientId } );
cursor.moveToFirst();
while (!cursor.isAfterLast())
{
Patient patient = new Patient(
cursor.getInt(0) , cursor.getString(1), cursor.getString(2), cursor.getString(3),
cursor.getString(4), cursor.getString(5), cursor.getString(6), cursor.getString(6),
cursor.getString(7), cursor.getString(8), cursor.getString(9), cursor.getString(10),
cursor.getString(11), cursor.getString(12), cursor.getString(13), cursor.getString(14),
cursor.getString(15), cursor.getString(16), cursor.getString(17), cursor.getString(18),
cursor.getString(19), cursor.getString(20), cursor.getString(21)
);
patientList.add(patient);
cursor.moveToNext();
}
cursor.close();
close();
return patientList;
}
/*public void updateFavorites(Favorites favoritesInfo,String id)
{
open();
ContentValues favoritesInfoValues = new ContentValues();
String strFilter = "id = " + id;
favoritesInfoValues.put(ID, favoritesInfo.getFavoritesId());
favoritesInfoValues.put(JOKES_ID, favoritesInfo.getJokesId());
//Update using the SQLite update function.
database.update(TABLE_FAVORITES, favoritesInfoValues, strFilter, null);
//Close the opened database connection
close();
}*/
public boolean deletePatient(String id)
{
open();
String strFilter = "_id =" + id;
boolean res = database.delete(TABLE_PATIENT, strFilter , null) > 0;
close();
return res;
}
}
list 权限:
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
但我得到的是以下异常:
10-25 12:49:25.838 30502-30502/com.medrecodapp.main.database E/SQLiteLog﹕ (14) cannot open file at line 31278 of [2ef4f3a5b1]
10-25 12:49:25.838 30502-30502/com.medrecodapp.main.database E/SQLiteLog﹕ (14) os_unix.c:31278: (2) open(/storage/emulated/0/EMIS/MedRec) -
10-25 12:49:25.838 30502-30502/com.medrecodapp.main.database E/SQLiteConnection﹕ DB info: sqlite3_open_v2, path: /storage/emulated/0/EMIS/MedRec, flag: 6, ret: 14
10-25 12:49:25.838 30502-30502/com.medrecodapp.main.database E/SQLiteConnection﹕ DB info: errno = 2, errno message = No such file or directory
10-25 12:49:25.839 30502-30502/com.medrecodapp.main.database E/SQLiteDatabase﹕ Failed to open database '/storage/emulated/0/EMIS/MedRec'.
android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:237)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:221)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:468)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:190)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:182)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:876)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:856)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:754)
at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:579)
at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:269)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
at com.medrecordapp.main.database.PatientDataSource.open(PatientDataSource.java:53)
at com.medrecordapp.main.database.PatientDataSource.loadPatient(PatientDataSource.java:100)
at com.medrecordapp.main.activity.PatientListActivity.onCreate(PatientListActivity.java:90)
at android.app.Activity.performCreate(Activity.java:6262)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1125)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2462)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2569)
at android.app.ActivityThread.access$900(ActivityThread.java:150)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1399)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:168)
at android.app.ActivityThread.main(ActivityThread.java:5885)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:819)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:709)
10-25 12:49:25.840 30502-30502/com.medrecodapp.main.database E/AndroidRuntime﹕ FATAL EXCEPTION: main
Process: com.medrecodapp.main.database, PID: 30502
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.medrecodapp.main.database/com.medrecordapp.main.activity.PatientListActivity}: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2509)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2569)
at android.app.ActivityThread.access$900(ActivityThread.java:150)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1399)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:168)
at android.app.ActivityThread.main(ActivityThread.java:5885)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:819)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:709)
Caused by: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:237)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:221)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:468)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:190)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:182)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:876)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:856)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:754)
at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:579)
at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:269)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
at com.medrecordapp.main.database.PatientDataSource.open(PatientDataSource.java:53)
at com.medrecordapp.main.database.PatientDataSource.loadPatient(PatientDataSource.java:100)
at com.medrecordapp.main.activity.PatientListActivity.onCreate(PatientListActivity.java:90)
at android.app.Activity.performCreate(Activity.java:6262)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1125)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2462)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2569)
at android.app.ActivityThread.access$900(ActivityThread.java:150)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1399)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:168)
at android.app.ActivityThread.main(ActivityThread.java:5885)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:819)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:709)
文件已放在以下文件夹中:
我想提的最后一件事是，我正在 HTC 10 上测试它，它没有任何外部存储，但有模拟存储。任何帮助将不胜感激。
谢谢
我有一个Ruby程序，它使用rubyzip压缩XML文件的目录树。gem。我的问题是文件开始变得很重，我想提高压缩级别，因为压缩时间不是问题。我在rubyzipdocumentation中找不到一种为创建的ZIP文件指定压缩级别的方法。有人知道如何更改此设置吗？是否有另一个允许指定压缩级别的Ruby库？ 最佳答案 这是我通过查看rubyzip内部创建的代码。level=Zlib::BEST_COMPRESSIONZip::ZipOutputStream.open(zip_file)do|zip|Dir.glob("**/*")d
我试图在一个项目中使用rake，如果我把所有东西都放到Rakefile中，它会很大并且很难读取/找到东西，所以我试着将每个命名空间放在lib/rake中它自己的文件中，我添加了这个到我的rake文件的顶部:Dir['#{File.dirname(__FILE__)}/lib/rake/*.rake'].map{|f|requiref}它加载文件没问题，但没有任务。我现在只有一个.rake文件作为测试，名为“servers.rake”，它看起来像这样:namespace:serverdotask:testdoputs"test"endend所以当我运行rakeserver:testid时
我的目标是转换表单输入，例如“100兆字节”或“1GB”，并将其转换为我可以存储在数据库中的文件大小(以千字节为单位)。目前，我有这个:defquota_convert@regex=/([0-9]+)(.*)s/@sizes=%w{kilobytemegabytegigabyte}m=self.quota.match(@regex)if@sizes.include?m[2]eval("self.quota=#{m[1]}.#{m[2]}")endend这有效，但前提是输入是倍数(“gigabytes”，而不是“gigabyte”)并且由于使用了eval看起来疯狂不安全。所以，功能正常，
Rails2.3可以选择随时使用RouteSet#add_configuration_file添加更多路由。是否可以在Rails3项目中做同样的事情？ 最佳答案 在config/application.rb中:config.paths.config.routes在Rails3.2(也可能是Rails3.1)中，使用:config.paths["config/routes"] 关于ruby-on-rails-Rails3中的多个路由文件，我们在StackOverflow上找到一个类似的问题
对于具有离线功能的智能手机应用程序，我正在为Xml文件创建单向文本同步。我希望我的服务器将增量/差异(例如GNU差异补丁)发送到目标设备。这是计划:Time=0Server:hasversion_1ofXmlfile(~800kiB)Client:hasversion_1ofXmlfile(~800kiB)Time=1Server:hasversion_1andversion_2ofXmlfile(each~800kiB)computesdeltaoftheseversions(=patch)(~10kiB)sendspatchtoClient(~10kiBtransferred)Cl
我正在寻找执行以下操作的正确语法(在Perl、Shell或Ruby中):#variabletoaccessthedatalinesappendedasafileEND_OF_SCRIPT_MARKERrawdatastartshereanditcontinues. 最佳答案 Perl用__DATA__做这个:#!/usr/bin/perlusestrict;usewarnings;while(){print;}__DATA__Texttoprintgoeshere 关于ruby-如何将脚
我主要使用Ruby来执行此操作，但到目前为止我的攻击计划如下:使用gemsrdf、rdf-rdfa和rdf-microdata或mida来解析给定任何URI的数据。我认为最好映射到像schema.org这样的统一模式，例如使用这个yaml文件，它试图描述数据词汇表和opengraph到schema.org之间的转换:#SchemaXtoschema.orgconversion#data-vocabularyDV:name:namestreet-address:streetAddressregion:addressRegionlocality:addressLocalityphoto:i
使用带有Rails插件的vim，您可以创建一个迁移文件，然后一次性打开该文件吗？textmate也可以这样吗？ 最佳答案 你可以使用rails.vim然后做类似的事情::Rgeneratemigratonadd_foo_to_bar插件将打开迁移生成的文件，这正是您想要的。我不能代表textmate。 关于ruby-使用VimRails，您可以创建一个新的迁移文件并一次性打开它吗？，我们在StackOverflow上找到一个类似的问题： https://sta
好的，所以我的目标是轻松地将一些数据保存到磁盘以备后用。您如何简单地写入然后读取一个对象？所以如果我有一个简单的类classCattr_accessor:a,:bdefinitialize(a,b)@a,@b=a,bendend所以如果我从中非常快地制作一个objobj=C.new("foo","bar")#justgaveitsomerandomvalues然后我可以把它变成一个kindaidstring=obj.to_s#whichreturns""我终于可以将此字符串打印到文件或其他内容中。我的问题是，我该如何再次将这个id变回一个对象？我知道我可以自己挑选信息并制作一个接受该信
我正在编写一个小脚本来定位aws存储桶中的特定文件，并创建一个临时验证的url以发送给同事。(理想情况下，这将创建类似于在控制台上右键单击存储桶中的文件并复制链接地址的结果)。我研究过回形针，它似乎不符合这个标准，但我可能只是不知道它的全部功能。我尝试了以下方法:defauthenticated_url(file_name,bucket)AWS::S3::S3Object.url_for(file_name,bucket,:secure=>true,:expires=>20*60)end产生这种类型的结果:...-1.amazonaws.com/file_path/file.zip.A