我有一个名为 calcDays() 的方法，它一遍又一遍地循环遍历数据库，直到满足特定条件。问题是 Android Studio 告诉我文件用完了。我意识到我正在打开数据库而不是关闭它们，这就是我出现错误的原因。但是，我似乎无法修复此错误。
用 calcDays() 方法类
package com.example.brandon.netflixcalculator;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.SQLException;
import java.util.Calendar;
public class MainActivity extends Activity {
private Button b1;
private Button b2;
private Button b3;
private Button b4;
private TextView daysRemaining, showName;;
private int x;
private int[] dailyMin = new int[7];
private String[] dailyPercent = {"100%", "75%", "50%", "25%", "0%"};
private double[] percent = {1, .75, .5, .25, 0};
private DatabaseHelper db;
String[] stringDays = {"Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"};
private File viewingInfo;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
setOnButton1ClickListener();
setOnButton2ClickListener();
setOnButton3ClickListener();
setOnButton4ClickListener();
daysRemaining = (TextView)findViewById(R.id.textViewRemainingDays);
showName = (TextView)findViewById(R.id.textViewCurrentShow);
if(!ifFileExists()){
createDBFirstTime();
}
else{
db = new DatabaseHelper(getApplicationContext());
daysRemaining.setText(String.valueOf(calcDays()));
showName.setText(db.getShowName());
}
}
public void createDBFirstTime(){
System.out.println("Database deleted? " + this.deleteDatabase("viewing_database"));
db = new DatabaseHelper(this.getApplicationContext());
for(int i = 0; i < stringDays.length; i++){
db.insertDataViewing(stringDays[i], 0, "100%");
}
db.insertDataShow("N/A", 0, 0, 0);
try {
FileOutputStream fos = openFileOutput("madeDB", MODE_PRIVATE);
try {
fos.write("true".getBytes());
fos.close();
} catch (IOException e) {
e.printStackTrace();
}
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
public boolean ifFileExists(){
File file = getApplicationContext().getFileStreamPath("madeDB");
if(file.exists())
return true;
else return false;
}
public int calcDays() {
int seasons, episodes, epiLength;
int[] info = new int[3];
for(int i = 0; i < info.length; i++){
info[i] = db.extractShowInfo()[i];
}
seasons = info[0];
episodes = info[1];
epiLength = info[2];
int totalTime = (seasons * episodes * epiLength);
System.out.println(seasons);
int dayOfWeek = getDay();
int days = 0;
int y;
double z;
while (totalTime > 0) {
y = db.getMin(dayOfWeek);
z = db.getPercentage(dayOfWeek);
totalTime -= y*z;
dayOfWeek++;
if (dayOfWeek == 7) {
dayOfWeek = 0;
}
days++;
}
return days;
}
public int getDay() {
Calendar calendar = Calendar.getInstance();
int day = calendar.get(Calendar.DAY_OF_WEEK);
return day;
}
public void setOnButton1ClickListener() {
b1 = (Button) findViewById(R.id.button);
b1.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent i = new Intent("com.example.brandon.netflixcalculator.RoughGuessActivity");
startActivity(i);
}
});
}
public void setOnButton2ClickListener() {
b2 = (Button) findViewById(R.id.button2);
b2.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent i = new Intent("com.example.brandon.netflixcalculator.Exact_Activity");
startActivity(i);
}
});
}
public void setOnButton3ClickListener() {
b3 = (Button) findViewById(R.id.button3);
b3.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent i = new Intent("com.example.brandon.netflixcalculator.ShowInfoActivity");
startActivity(i);
}
});
}
public void setOnButton4ClickListener() {
b4 = (Button) findViewById(R.id.btnUpdate);
b4.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
System.out.println("-----------------------------------------------------");
System.out.println(calcDays());
showMessage("Days remaining", String.valueOf(calcDays()));
daysRemaining.setText(String.valueOf(calcDays()));
}
});
}
public int getTotalMin(){
int x = 0;
Cursor res = db.getWritableDatabase().rawQuery("select MINUTES from VIEWING", null);
StringBuffer sb = new StringBuffer();
while(res.moveToNext()){
x += Integer.parseInt(res.getString(0));
}
return x;
}
public void readDB(){
Cursor res = db.getAllData("SHOW_INFO");
if (res.getCount() == 0) {
showMessage("Error", "No data found");
return;
}
StringBuffer sb = new StringBuffer();
while (res.moveToNext()) {
sb.append("\nName: " + res.getString(1) + "\nSeasons: "
+ res.getString(2) + "\nEpisodes: " + res.getString(3) + "\nEpisode Length: " +
res.getString(4));
}
showMessage("Test", sb.toString());
db.close();
}
public void showMessage(String title, String msg){
AlertDialog.Builder builder = new AlertDialog.Builder(this);
builder.setCancelable(true);
builder.setTitle(title);
builder.setMessage(msg);
builder.show();
}
}
数据库助手类
public class DatabaseHelper extends SQLiteOpenHelper{
private static final String dbName = "viewing_database";
private static final String tableViewing = "VIEWING";
private static final String tableShowInfo = "SHOW_INFO";
private static final String COL_1 = "ID";
private static final String COL_2 = "WEEKDAY";
private static final String COL_3 = "MINUTES";
private static final String COL_4 = "PERCENTAGE";
private static DatabaseHelper sInstance;
public DatabaseHelper(Context context) {
super(context, dbName, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table " + tableViewing + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, WEEKDAY TEXT, MINUTES INTEGER, PERCENTAGE TEXT)");
db.execSQL("create table " + tableShowInfo + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, SEASONS INTEGER, EPISODES INTEGER," +
" EPISODE_LENGTH INTEGER)");
}
public static synchronized DatabaseHelper getInstance(Context context) {
// Use the application context, which will ensure that you
// don't accidentally leak an Activity's context.
if (sInstance == null) {
sInstance = new DatabaseHelper(context.getApplicationContext());
}
return sInstance;
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + tableViewing);
db.execSQL("DROP TABLE IF EXISTS " + tableShowInfo);
onCreate(db);
}
public boolean updateDataViewing(String id, String weekday, int minutes, String percentage){
SQLiteDatabase myDataBase = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COL_1, id);
cv.put(COL_2, weekday);
cv.put(COL_3, minutes);
cv.put(COL_4, percentage);
myDataBase.update(tableViewing, cv, "ID = ?", new String[]{id});
myDataBase.close();
return true;
}
public boolean updateDataShow(String id, String name, int seasons, int episodes, int episodeLength){
SQLiteDatabase myDataBase = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COL_1, id);
cv.put("NAME", name);
cv.put("SEASONS", seasons);
cv.put("EPISODES", episodes);
cv.put("EPISODE_LENGTH", episodeLength);
myDataBase.update(tableShowInfo, cv, "ID = ?", new String[]{id});
return true;
}
public double getPercentage(int id){
SQLiteDatabase myDataBase = this.getWritableDatabase();
Cursor res = myDataBase.rawQuery("select PERCENTAGE from " + tableViewing + " where ID =" + id, null);
if (res.getCount() == 0) {
return 0;
}
StringBuffer sb = new StringBuffer();
while (res.moveToNext()) {
sb.append(res.getString(0));
}
String msg = sb.toString();
myDataBase.close();
return Integer.parseInt(msg.substring(0, msg.length()-1)) / 100.0;
}
public int getMin(int id){
SQLiteDatabase myDataBase = this.getWritableDatabase();
Cursor res = myDataBase.rawQuery("select MINUTES from " + tableViewing + " where ID =" + id, null);
if (res.getCount() == 0) {
return 0;
}
StringBuffer sb = new StringBuffer();
while (res.moveToNext()) {
sb.append(res.getString(0));
}
myDataBase.close();
return Integer.parseInt(sb.toString());
}
public Cursor getAllData(String tableName){
SQLiteDatabase myDataBase = this.getWritableDatabase();
Cursor res = myDataBase.rawQuery("select * from " + tableName, null);
return res;
}
public boolean insertDataViewing(String dayOfWeek, int minutes, String percentage){
SQLiteDatabase myDataBase = getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(COL_2, dayOfWeek);
cv.put(COL_3, minutes);
cv.put(COL_4, percentage);
double result = myDataBase.insert(tableViewing, null, cv);
myDataBase.close();
return(result != -1);
}
public boolean insertDataShow(String name, int seasons, int episodes, int episodeLength){
SQLiteDatabase myDataBase = getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put("NAME", name);
cv.put("SEASONS", seasons);
cv.put("EPISODES", episodes);
cv.put("EPISODE_LENGTH", episodeLength);
double result = myDataBase.insert(tableShowInfo, null, cv);
myDataBase.close();
return(result != -1);
}
public String getShowName(){
Cursor res = getAllData("SHOW_INFO");
if (res.getCount() == 0) {
System.out.println("No data found");
return "N/A";
}
StringBuffer sb = new StringBuffer();
while (res.moveToNext()) {
sb.append(res.getString(1));
}
return sb.toString();
}
public int[] extractShowInfo() {
int[] info = new int[3];
Cursor res = getAllData("SHOW_INFO");
if (res.getCount() == 0) {
System.out.println("No data found");
return new int[] {0, 0, 0};
}
while(res.moveToNext()){
info[0] = Integer.parseInt(res.getString(2)); //seasons
info[1] = Integer.parseInt(res.getString(3)); //episodes
info[2] = Integer.parseInt(res.getString(4)); //episode length
}
for(int x:info){
System.out.println(x);
}
return info;
}
}
最后是错误
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator W/SQLiteLog: (28) failed to open "/data/user/0/com.example.brandon.netflixcalculator/databases/viewing_database-journal" with flag (131072) and mode_t (1b0) due to error (24)
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator E/SQLiteLog: (14) cannot open file at line 31517 of [2ef4f3a5b1]
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator E/SQLiteLog: (14) os_unix.c:31517: (24) open(/data/user/0/com.example.brandon.netflixcalculator/databases/viewing_database-journal) -
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator W/SQLiteLog: (28) failed to open "/data/user/0/com.example.brandon.netflixcalculator/databases/viewing_database-journal" with flag (131074) and mode_t (1b0) due to error (24)
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator W/SQLiteLog: (28) failed to open "/data/user/0/com.example.brandon.netflixcalculator/databases/viewing_database-journal" with flag (131072) and mode_t (1b0) due to error (24)
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator E/SQLiteLog: (14) cannot open file at line 31517 of [2ef4f3a5b1]
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator E/SQLiteLog: (14) os_unix.c:31517: (24) open(/data/user/0/com.example.brandon.netflixcalculator/databases/viewing_database-journal) -
04-06 13:59:22.081 1327-1327/com.example.brandon.netflixcalculator E/SQLiteLog: (2062) statement aborts at 9: [select PERCENTAGE from VIEWING where ID =4] unable to open database file
04-06 13:59:22.091 1327-1327/com.example.brandon.netflixcalculator E/SQLiteQuery: exception: unable to open database file (code 2062)
#################################################################
Error Code : 2062 (SQLITE_CANTOPEN_EMFILE)
Caused By : Application has opened two many files. Maximum of available file descriptors in one process is 1024 in default.
(unable to open database file (code 2062))
#################################################################; query: select PERCENTAGE from VIEWING where ID =4
04-06 13:59:22.091 1327-1327/com.example.brandon.netflixcalculator D/AndroidRuntime: Shutting down VM
04-06 13:59:22.091 1327-1327/com.example.brandon.netflixcalculator E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.example.brandon.netflixcalculator, PID: 1327
android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 2062)
#################################################################
Error Code : 2062 (SQLITE_CANTOPEN_EMFILE)
Caused By : Application has opened two many files. Maximum of available file descriptors in one process is 1024 in default.
(unable to open database file (code 2062))
#################################################################
at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:980)
at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:132)
at com.example.brandon.netflixcalculator.DatabaseHelper.getPercentage(DatabaseHelper.java:83)
at com.example.brandon.netflixcalculator.MainActivity.calcDays(MainActivity.java:108)
at com.example.brandon.netflixcalculator.MainActivity$4.onClick(MainActivity.java:166)
at android.view.View.performClick(View.java:5697)
at android.widget.TextView.performClick(TextView.java:10815)
at android.view.View$PerformClick.run(View.java:22526)
at android.os.Handler.handleCallback(Handler.java:739)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:158)
at android.app.ActivityThread.main(ActivityThread.java:7229)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
04-06 13:59:28.401 1327-1338/com.example.brandon.netflixcalculator W/SQLiteConnectionPool: A SQLiteConnection object for database '+data+user+0+com_example_brandon_netflixcalculator+databases+viewing_database' was leaked! Please fix your application to end transactions in progress properly and to close the database when it is no longer needed.
04-06 14:04:22.231 1327-1327/com.example.brandon.netflixcalculator I/Process: Sending signal. PID: 1327 SIG: 9
最佳答案
您应该只创建 a single SqliteOpenHelper object适用于您的整个应用程序，并在需要访问数据库的任何地方使用它。这将防止并发访问数据库时出现很多问题。
关于android - 应用程序打开的文件太多 - Android，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/36459277/
我有一个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看起来疯狂不安全。所以，功能正常，
我需要在客户计算机上运行Ruby应用程序。通常需要几天才能完成(复制大备份文件)。问题是如果启用sleep，它会中断应用程序。否则，计算机将持续运行数周，直到我下次访问为止。有什么方法可以防止执行期间休眠并让Windows在执行后休眠吗？欢迎任何疯狂的想法;-) 最佳答案 Here建议使用SetThreadExecutionStateWinAPI函数，使应用程序能够通知系统它正在使用中，从而防止系统在应用程序运行时进入休眠状态或关闭显示。像这样的东西:require'Win32API'ES_AWAYMODE_REQUIRED=0x0
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-如何将脚
Rackup通过Rack的默认处理程序成功运行任何Rack应用程序。例如:classRackAppdefcall(environment)['200',{'Content-Type'=>'text/html'},["Helloworld"]]endendrunRackApp.new但是当最后一行更改为使用Rack的内置CGI处理程序时，rackup给出“NoMethodErrorat/undefinedmethod`call'fornil:NilClass”:Rack::Handler::CGI.runRackApp.newRack的其他内置处理程序也提出了同样的反对意见。例如Rack
使用带有Rails插件的vim，您可以创建一个迁移文件，然后一次性打开该文件吗？textmate也可以这样吗？ 最佳答案 你可以使用rails.vim然后做类似的事情::Rgeneratemigratonadd_foo_to_bar插件将打开迁移生成的文件，这正是您想要的。我不能代表textmate。 关于ruby-使用VimRails，您可以创建一个新的迁移文件并一次性打开它吗？，我们在StackOverflow上找到一个类似的问题： https://sta
我想用ruby编写一个小的命令行实用程序并将其作为gem分发。我知道安装后，Guard、Sass和Thor等某些gem可以从命令行自行运行。为了让gem像二进制文件一样可用，我需要在我的gemspec中指定什么。 最佳答案 Gem::Specification.newdo|s|...s.executable='name_of_executable'...endhttp://docs.rubygems.org/read/chapter/20 关于ruby-在Ruby中编写命令行实用程序