- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我想在 android 中对我的数据库(添加、删除、编辑)进行任何更新时设置一个“标志”。我通过在我的数据库适配器类中创建一个 getter 和 setter 来完成此操作:
Boolean updateOnlineDatabase = false;
public Boolean updateNeeded() {
return updateOnlineDatabase;
}
public void setUpdateNeeded(Boolean bool) {
updateOnlineDatabase = bool;
}
所以在其他类(class)我一直在打电话
adapter.setUpdateNeeded(true);
但是当我尝试使用以下方法返回值时:updateNeeded()
它总是返回 false。
添加完整类(class)。
这里是数据库适配器类
public class MySQLiteAdapters {
SQLiteDatabase database_ob;
MySQLiteHelper openHelper_ob;
Context context;
Boolean updateOnlineDatabase = false;
public MySQLiteAdapters(Context c) {
context = c;
}
public MySQLiteAdapters opnToRead() {
openHelper_ob = new MySQLiteHelper(context,
openHelper_ob.DATABASE_NAME, null, openHelper_ob.DATABASE_VERSION);
database_ob = openHelper_ob.getReadableDatabase();
return this;
}
public void del(){
database_ob.execSQL("DROP TABLE IF EXISTS " + openHelper_ob.TABLE_PLAYER_INFO);
}
public MySQLiteAdapters opnToWrite() {
openHelper_ob = new MySQLiteHelper(context,
openHelper_ob.DATABASE_NAME, null, openHelper_ob.DATABASE_VERSION);
database_ob = openHelper_ob.getWritableDatabase();
database_ob.execSQL("PRAGMA foreign_keys = ON;");
return this;
}
public void Close() {
database_ob.close();
}
public long insertDetails(String fname, String lname, String age, String heightValue, String weightValue, String positionValue, String teamValue, String notPicked, int match_no) {
ContentValues contentValues = new ContentValues();
contentValues.put(openHelper_ob.KEY_FNAME, fname);
contentValues.put(openHelper_ob.KEY_LNAME, lname);
contentValues.put(openHelper_ob.KEY_AGE, age);
contentValues.put(openHelper_ob.KEY_HEIGHT, heightValue);
contentValues.put(openHelper_ob.KEY_WEIGHT , weightValue);
contentValues.put(openHelper_ob.KEY_POSITION, positionValue);
contentValues.put(openHelper_ob.TEAM_ID, lookupOrCreateTeamID(teamValue));
contentValues.put(openHelper_ob.KEY_PICKED, notPicked);
contentValues.put(openHelper_ob.KEY_PICKED_NO, match_no);
//testing the foreign key constraint
//contentValues.put(openHelper_ob.TEAM_ID, "30");
opnToWrite();
long val = database_ob.insert(openHelper_ob.TABLE_PLAYER_INFO, null,
contentValues);
Close();
return val;
}
public long lookupOrCreateTeamID(String name) {
opnToWrite();
Cursor c = database_ob.query(openHelper_ob.TABLE_TEAM_INFO, new String[] { openHelper_ob.KEY_TEAM_ID },
openHelper_ob.KEY_TEAMNAME + " = ?", new String[] { name }, null, null, null);
if (c.moveToFirst())
return c.getLong(0);
else {
ContentValues cv = new ContentValues();
cv.put(openHelper_ob.KEY_TEAMNAME, name);
return database_ob.insert(openHelper_ob.TABLE_TEAM_INFO, null, cv);
}
}
public long insertTeamDetails(String teamName) {
ContentValues contentValues = new ContentValues();
contentValues.put(openHelper_ob.KEY_TEAMNAME, teamName);
opnToWrite();
long val = database_ob.insert(openHelper_ob.TABLE_TEAM_INFO, null,
contentValues);
Close();
Log.i("INSERT TEAM", "inserted" + teamName + "into" + openHelper_ob.TABLE_TEAM_INFO);
return val;
}
// Return list of players depending on current team in alphabetical order
public Cursor queryName(String filterTeam) {
String[] context = {filterTeam};
opnToWrite();
Cursor mCursor = database_ob.rawQuery("SELECT PLAYER_Local._id AS p_id, * FROM PLAYER_Local, TEAM_local "
+ "WHERE PLAYER_Local.team_id = TEAM_local._id "
+ "AND team_name = ? "
+ "ORDER BY first_name ", context);
return mCursor;
}
// Return the list of teams
public Cursor queryTeamName() {
String[] cols = {openHelper_ob.KEY_PLAYER_ID, openHelper_ob.KEY_TEAMNAME};
opnToWrite();
Cursor c = database_ob.query(openHelper_ob.TABLE_TEAM_INFO, cols, null,
null, null, null, null);
return c;
}
public Cursor queryAll(int nameId) {
String[] cols = { openHelper_ob.KEY_PLAYER_ID, openHelper_ob.KEY_FNAME,
openHelper_ob.KEY_LNAME, openHelper_ob.KEY_HEIGHT, openHelper_ob.KEY_WEIGHT, openHelper_ob.KEY_POSITION };
opnToWrite();
Cursor c = database_ob.query(openHelper_ob.TABLE_PLAYER_INFO, cols,
openHelper_ob.KEY_PLAYER_ID + "=" + nameId, null, null, null, null);
return c;
}
public Cursor queryRecord(int nameId) {
String[] cols = {openHelper_ob.KEY_FNAME,openHelper_ob.KEY_LNAME};
opnToWrite();
Cursor c = database_ob.query(openHelper_ob.TABLE_PLAYER_INFO, cols,
openHelper_ob.KEY_PLAYER_ID + "=" + nameId, null, null, null, null);
return c;
}
public Cursor getPickedPlayer(int playerNo) {
String[] cols = {openHelper_ob.KEY_FNAME,openHelper_ob.KEY_LNAME};
opnToWrite();
Cursor c = database_ob.query(openHelper_ob.TABLE_PLAYER_INFO, cols,
openHelper_ob.KEY_PICKED_NO + "=" + playerNo, null, null, null, null);
return c;
}
public long updateldetail(int rowId, String fname, String lname, String heightValue, String weightValue, String positionValue) {
ContentValues contentValues = new ContentValues();
contentValues.put(openHelper_ob.KEY_FNAME, fname);
contentValues.put(openHelper_ob.KEY_LNAME, lname);
contentValues.put(openHelper_ob.KEY_HEIGHT, heightValue);
contentValues.put(openHelper_ob.KEY_WEIGHT , weightValue);
contentValues.put(openHelper_ob.KEY_POSITION, positionValue);
opnToWrite();
long val = database_ob.update(openHelper_ob.TABLE_PLAYER_INFO, contentValues,
openHelper_ob.KEY_PLAYER_ID + "=" + rowId, null);
Close();
return val;
}
public int deletOneRecord(int rowId) {
// TODO Auto-generated method stub
opnToWrite();
int val = database_ob.delete(openHelper_ob.TABLE_PLAYER_INFO,
openHelper_ob.KEY_PLAYER_ID + "=" + rowId, null);
Close();
//// add teamName to team_updates > del_player > player_ID
return val;
}
public List<String> getAllLabels(){
List<String> labels = new ArrayList<String>();
// Select All Query
String selectQuery = "SELECT * FROM " + openHelper_ob.TABLE_TEAM_INFO;
opnToRead();
Cursor cursor = database_ob.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
labels.add(cursor.getString(1));
} while (cursor.moveToNext());
}
// closing connection
cursor.close();
database_ob.close();
// returning lables
return labels;
}
public long playerPicked(int playerRecord, String string, int pos) {
ContentValues contentValues = new ContentValues();
contentValues.put(openHelper_ob.KEY_PICKED, string);
contentValues.put(openHelper_ob.KEY_PICKED_NO, pos);
opnToWrite();
long val = database_ob.update(openHelper_ob.TABLE_PLAYER_INFO, contentValues,
openHelper_ob.KEY_PLAYER_ID + "=" + playerRecord, null);
Close();
return val;
}
public Cursor queryUpdatedPlayerList(String team, String filter2) {
String[] context = {team};
opnToWrite();
Cursor mCursor = database_ob.rawQuery("SELECT PLAYER_Local._id AS p_id, * FROM PLAYER_Local, TEAM_local "
+ "WHERE PLAYER_Local.team_id = TEAM_local._id "
+ "AND team_name = ? "
+ "AND p_id not in ("+filter2+")"
+ "ORDER BY first_name ", context);
return mCursor;
}
public void resetPickedPlayers() {
ContentValues contentValues = new ContentValues();
contentValues.put(openHelper_ob.KEY_PICKED, "NO");
contentValues.put(openHelper_ob.KEY_PICKED_NO, 0);
//testing the foreign key constraint
//contentValues.put(openHelper_ob.TEAM_ID, "30");
opnToWrite();
long val = database_ob.update(openHelper_ob.TABLE_PLAYER_INFO, contentValues,null, null);
Close();
}
public Boolean updateNeeded() {
return updateOnlineDatabase;
}
public void setUpdateNeeded(Boolean bool) {
updateOnlineDatabase = bool;
}
我将 Boolean 设置为 True 的类之一:
public class AddPlayerActivity extends Activity {
MySQLiteAdapters adapter;
MySQLiteHelper helper;
EditText fnameEdit, lnameEdit, ageEdit, heightEdit, weightEdit, positionEdit;
String teamEdit, json, jsonString;
Button submitBtn, resetBtn;
SharedPreferences exmaple;
Editor editor;
public static final String PREFS = "examplePrefs";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
Bundle extras = getIntent().getExtras();
setContentView(R.layout.activity_add_player);
fnameEdit = (EditText) findViewById(R.id.et_fname);
lnameEdit = (EditText) findViewById(R.id.et_lname);
ageEdit = (EditText) findViewById(R.id.et_age);
heightEdit = (EditText) findViewById(R.id.et_height);
weightEdit = (EditText) findViewById(R.id.et_weight);
positionEdit = (EditText) findViewById(R.id.et_position);
submitBtn = (Button) findViewById(R.id.btn_submit);
resetBtn = (Button) findViewById(R.id.btn_reset);
adapter = new MySQLiteAdapters(this);
exmaple = getSharedPreferences(PREFS, 0);
teamEdit = exmaple.getString("teamName", "cant find team");
editor = exmaple.edit();
json = exmaple.getString("ChangesJSON", "cant find Changes_json");
submitBtn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
// sets flag to update online database.
adapter.setUpdateNeeded(true);
// add name to database
String fnameValue = fnameEdit.getText().toString();
String lnameValue = lnameEdit.getText().toString();
String heightValue = heightEdit.getText().toString();
String weightValue = weightEdit.getText().toString();
String positionValue = positionEdit.getText().toString();
String ageValue = ageEdit.getText().toString();
String teamValue = teamEdit;
adapter.insertDetails(fnameValue, lnameValue, ageValue, heightValue, weightValue, positionValue, teamValue, "NO",0);
//// add above to team_updates > add_player > above
// Logic to add changes to JSON to update remote database
JSONObject MainObj = null;
try {
MainObj = new JSONObject(json);
} catch (JSONException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
JSONObject obj = new JSONObject();
try {
obj.put("first_name", fnameValue);
obj.put("last_name", lnameValue);
obj.put("age", ageValue);
obj.put("height", heightValue);
obj.put("weight", weightValue);
obj.put("position", positionValue);
MainObj.accumulate("New_Players", obj);
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
jsonString = MainObj.toString(3);
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
editor.putString("ChangesJSON", jsonString);
editor.commit();
Log.i("Submit Button", "CLICKED");
fnameEdit.setText("");
lnameEdit.setText("");
heightEdit.setText("");
weightEdit.setText("");
positionEdit.setText("");
ageEdit.setText("");
}
});
resetBtn.setOnClickListener(new View.OnClickListener() {
public void onClick(View view) {
fnameEdit.setText("");
lnameEdit.setText("");
heightEdit.setText("");
weightEdit.setText("");
positionEdit.setText("");
ageEdit.setText("");
}
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.add_player, menu);
return true;
}
这是我调用 updateNeeded()
if(adapter.updateNeeded()){
JSONObject main = new JSONObject(exmaplePrefs.getString("jsonString", "cant find json"));
JSONObject dbUpdates = new JSONObject(exmaplePrefs.getString("ChangesJSON", "cant find Changejson"));
main.put("Team_Updates", dbUpdates);
json = main.toString();
}else{
json = exmaplePrefs.getString("jsonString", "cant find json");
// String json = "{\"twitter\":\"test\",\"country\":\"test\",\"name\":\"test\"}";
}
最佳答案
您正在此处创建适配器的新副本。如果其他类也在做同样的事情,那么它们都在与不同的实例对话。
adapter = new MySQLiteAdapters(this);
单例会对此有所帮助,但您必须小心确保它是线程安全的。如果它不是同步的并且两个线程尝试同时使用它,您将得到一个 ConcurrencyException
。
class MySingleton {
private static MySingleton instance = null;
// Prevent it from being instantiated
MySingleton() {}
public static synchronized MySingleton getInstance() {
if (instance == null) {
instance = this;
}
return instance;
}
}
然后在需要使用的时候使用adapter = MySingleton.getInstance();
就可以了。
关于java - 设置和访问来自各种类的 boolean 值,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/21653836/
关闭。这个问题是opinion-based 。目前不接受答案。 想要改进这个问题吗?更新问题,以便 editing this post 可以用事实和引文来回答它。 . 已关闭 4 年前。 Improv
PowerShell Web Access 允许您通过 Web 浏览器运行 PowerShell cmdlet。它显示了一个基于 Web 的控制台窗口。 有没有办法运行 cmdlet 而无需在控制台窗
我尝试在无需用户登录的情况下访问 Sharepoint 文件。 我可以通过以下任一方式获取访问 token 方法一: var client = new RestClient("https://logi
我目前正在尝试通过 Chrome 扩展程序访问 Google 服务。我的理解是,对于 JS 应用程序,Google 首选的身份验证机制是 OAuth。我的应用目前已成功通过 OAuth 向服务进行身份
假设我有纯抽象类 IHandler 和派生自它的类: class IHandler { public: virtual int process_input(char input) = 0; };
我有一个带有 ThymeLeaf 和 Dojo 的 Spring 应用程序,这给我带来了问题。当我从我的 HTML 文件中引用 CSS 文件时,它们在 Firebug 中显示为中止。但是,当我通过在地
这个问题已经有答案了: JavaScript property access: dot notation vs. brackets? (17 个回答) 已关闭 6 年前。 为什么这不起作用? func
我想将所有流量重定向到 https,只有 robot.txt 应该可以通过 http 访问。 是否可以为 robot.txt 文件创建异常(exception)? 我的 .htaccess 文件: R
我遇到了 LinkedIn OAuth2: "Unable to verify access token" 中描述的相同问题;但是,那里描述的解决方案并不能解决我的问题。 我能够成功请求访问 toke
问题 我有一个暴露给 *:8080 的 Docker 服务容器. 我无法通过 localhost:8080 访问容器. Chrome /curl无限期挂断。 但是如果我使用任何其他本地IP,我就可以访
我正在使用 Google 的 Oauth 2.0 来获取用户的 access_token,但我不知道如何将它与 imaplib 一起使用来访问收件箱。 最佳答案 下面是带有 oauth 2.0 的 I
我正在做 docker 入门指南:https://docs.docker.com/get-started/part3/#recap-and-cheat-sheet-optional docker-co
我正在尝试使用静态 IP 在 AKS 上创建一个 Web 应用程序,自然找到了一个带有 Nginx ingress controller in Azure's documentation 的解决方案。
这是我在名为 foo.js 的文件中的代码。 console.log('module.exports:', module.exports) console.log('module.id:', modu
我试图理解访问键。我读过https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-se
我正在使用 MGTwitterEngine"将 twitter 集成到我的应用程序中。它在 iOS 4.2 上运行良好。当我尝试从任何 iOS 5 设备访问 twitter 时,我遇到了身份验证 to
我试图理解访问键。我读过https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-se
我正在使用以下 API 列出我的 Facebook 好友。 https://graph.facebook.com/me/friends?access_token= ??? 我想知道访问 token 过
401 Unauthorized - Show headers - { "error": { "errors": [ { "domain": "global", "reas
我已经将我的 django 应用程序部署到 heroku 并使用 Amazon s3 存储桶存储静态文件,我发现从 s3 存储桶到 heroku 获取数据没有问题。但是,当我测试查看内容存储位置时,除
我是一名优秀的程序员,十分优秀!