我怎样才能显示在Android的拉丁词？ [英] How can I display Latin words in Android?
本文介绍了我怎样才能显示在Android的拉丁词？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我是一个新的Android开发者。我与我的应用程序拉丁字体，但我不能让它的工作，并不断得到一个？的角色。我的code是下面，使用SQLite的database.I必须从SQLite数据库，每一个特殊的拉丁字符（即A，O，U，è...）被显示为黑色方块用？获取文本里面。
我怎样才能显示这是否正确？
私人无效displayTestQuestion（）{
resetEverything（）;
stats.setText（Integer.toString（totalRightQuestions）+/+ Integer.toString（totalNumberOfQuestions））;
串questionText = questionCursor.getString（0）;
question.setText（Html.fromHtml（questionText））;
adjectiveNumber = questionCursor.getString（1）;
adjectiveCase = questionCursor.getString（3）;
adjectiveGender = questionCursor.getString（2）;
}
我模拟器的屏幕：
我也试过这个code：
私人无效displayTestQuestion（）{
resetEverything（）;
stats.setText（Integer.toString（totalRightQuestions）+/+ Integer.toString（totalNumberOfQuestions））;
串questionText = questionCursor.getString（0）;
字样字体= Typeface.createFromAsset（questionCursor.getString（0），字体/ LATINWD.TTF）;
//question.setText(Html.fromHtml(questionText））;
question.setText（（CharSequence的）字体）;
adjectiveNumber = questionCursor.getString（1）;
adjectiveCase = questionCursor.getString（3）;
adjectiveGender = questionCursor.getString（2）;
}
但是，这是给我下面的错误：
在类型字样的方法createFromAsset（AssetManager，字符串）不适用的参数（字符串，字符串）。
我用Sqlitehelper类我code是如下：
公共类VocabTesterDatabaseHelper扩展SQLiteOpenHelper {
私有静态字符串DB_PATH =数据/数据/ com.VoacabTester /数据库/;
私有静态字符串DB_NAME =vocabdb.db;
私人SQLiteDatabase vocabDatabase;
私人最终语境vocabContext;
公共VocabTesterDatabaseHelper（上下文的背景下）{
超级（上下文，DB_NAME，空，3）;
this.vocabContext =背景;
}
公共无效的CreateDatabase（）抛出IOException异常{
布尔dbExist = checkDataBase（）;
如果（dbExist）{
} 其他 {
this.getReadableDatabase（）;
copyDataBase（）;
}
}
私人布尔checkDataBase（）{
文件DBFILE =新的文件（DB_PATH + DB_NAME）;
返回dbFile.exists（）;
}
私人无效copyDataBase（）抛出IOException异常{
尝试 {
InputStream的myInput = vocabContext.getAssets（）开（DB_NAME）。
字符串outFileName = DB_PATH + DB_NAME;
//打开空分贝的输出流
的OutputStream myOutput =新的FileOutputStream（outFileName）;
byte []的缓冲区=新的字节[1024];
INT长;
而（（长度= myInput.read（缓冲液））大于0）{
myOutput.write（缓冲液，0，长度）;
}
myOutput.flush（）;
myOutput.close（）;
myInput.close（）;
}赶上（IOException异常E）{
Log.v（数据，e.toString（）CONCAT（SQL））;
}
}
公共无效的openDatabase（）抛出的SQLException {
//打开数据库
字符串mypath中= DB_PATH + DB_NAME;
vocabDatabase = SQLiteDatabase.openDatabase（mypath中，空，
SQLiteDatabase.OPEN_READONLY）;
}
公共光标getFoundationTierQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM FoundationTierVocabularyQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
};
公共光标getHigherTierQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM HigherTierQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasyFirstConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM VerbQuestions1stConjugation ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasySecondConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM VerbQuestions2ndConjugation ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasyThirdConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM VerbQuestions3rdConjugation ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasyFourthConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM VerbQuestions4thConjugation ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasyMixConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM VerbQuestionsallConjugation ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getEasyIrregularConjugationVerbs（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM IrregularVerbsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getFirstDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM FirstDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getSecondDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM SecondDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getThirdDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM ThirdDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getFourthDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM FourthDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getFifthDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM FifthDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getNounsAllDeclensionNounsQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM NounsDeclensionNounsQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getis_ea_idQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IsEaIdQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标gethic_haec_hocQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM HicHaecHocQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getille_illa_illudQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IlleIllaIlludQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getqui_quae_quodQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM QuiQuaeQuodQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getIdem_eadem_idemQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IdemEademIdemQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getipse_ipsa_ipsumQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IpseIpsaIpsumQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getalius_alia_aliudQuestions（）{
光标CUR;
CUR = vocabDatabase
.rawQuery（
SELECT * FROM AliusAliaAliudQuestions ORDER BY随机（），
空值）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAdjectiveQuestions（）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM AdjectivesQuestions ORDER BY随机（），NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerFirstDeclensionNounsQuestion（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM FirstDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getSAnswerecondDeclensionNounsQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM SecondDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerThirdDeclensionNounsQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM ThirdDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerFourthDeclensionNounsQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM FourthDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerFifthDeclensionNounsQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM FifthDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerNounsAllDeclensionNounsQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM NounsDeclensionNounsQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnsweris_ea_idQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IsEaIdQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerhic_haec_hocQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM HicHaecHocQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerille_illa_illudQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IlleIllaIlludQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerqui_quae_quodQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM QuiQuaeQuodQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerIdem_eadem_idemQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IdemEademIdemQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnsweripse_ipsa_ipsumQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM IpseIpsaIpsumQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnsweralius_alia_aliudQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM AliusAliaAliudQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
公共光标getAnswerAdjectiveQuestions（字符串问题）{
光标CUR;
CUR = vocabDatabase.rawQuery（
SELECT * FROM AdjectivesQuestions WHERE问题LIKE'
+问题+'，NULL）;
cur.moveToFirst（）;
vocabDatabase.close（）;
返回CUR;
}
@覆盖
市民同步无效的close（）{
如果（vocabDatabase！= NULL）
vocabDatabase.close（）;
super.close（）;
}
@覆盖
公共无效的onCreate（SQLiteDatabase DB）{
}
@覆盖
公共无效onUpgrade（SQLiteDatabase分贝，INT oldVersion，诠释静态网页）{
}
}
解决方案
我不知道你做了什么在code，为什么使用HTML？但我可以假设你需要这个简单的code。请参见下面的改进方法。
私人无效displayTestQuestion（）{
resetEverything（）;
stats.setText（Integer.toString（totalRightQuestions）+/+ Integer.toString（totalNumberOfQuestions））;
串questionText = questionCursor.getString（0）;
字样字体= Typeface.createFromAsset（的getContext（）getAssets（），字体/ LATINWD.TTF。）;
question.setTypeface（字体）;
question.setText（questionText）;
adjectiveNumber = questionCursor.getString（1）;
adjectiveCase = questionCursor.getString（3）;
adjectiveGender = questionCursor.getString（2）;
}
I am a new Android developer. I'm working with a Latin font in my app but I can't get it to work and keep getting a ? for the character. My code is below, using an sqlite database.I have to fetch text from an Sqlite database and every special Latin character (i.e. à, ò, ù, è...) was displayed with black squares with a "?" inside.
How can i display this correctly?
private void displayTestQuestion() {
resetEverything();
stats.setText(Integer.toString(totalRightQuestions)+"/"+Integer.toString(totalNumberOfQuestions));
String questionText = questionCursor.getString(0);
question.setText(Html.fromHtml(questionText));
adjectiveNumber = questionCursor.getString(1);
adjectiveCase = questionCursor.getString(3);
adjectiveGender = questionCursor.getString(2);
}
My emulator screen:
I've also tried this code:
private void displayTestQuestion() {
resetEverything();
stats.setText(Integer.toString(totalRightQuestions)+"/"+Integer.toString(totalNumberOfQuestions));
String questionText = questionCursor.getString(0);
Typeface font = Typeface.createFromAsset(questionCursor.getString(0), "fonts/LATINWD.TTF");
//question.setText(Html.fromHtml(questionText));
question.setText((CharSequence) font);
adjectiveNumber = questionCursor.getString(1);
adjectiveCase = questionCursor.getString(3);
adjectiveGender = questionCursor.getString(2);
}
But this is giving me the following error:
The method createFromAsset(AssetManager, String) in the type Typeface is not applicable for the arguments (String, String).
And i used Sqlitehelper class my code is below:
public class VocabTesterDatabaseHelper extends SQLiteOpenHelper {
private static String DB_PATH = "data/data/com.VoacabTester/databases/";
private static String DB_NAME = "vocabdb.db";
private SQLiteDatabase vocabDatabase;
private final Context vocabContext;
public VocabTesterDatabaseHelper(Context context) {
super(context, DB_NAME, null, 3);
this.vocabContext = context;
}
public void createDataBase() throws IOException {
boolean dbExist = checkDataBase();
if (dbExist) {
} else {
this.getReadableDatabase();
copyDataBase();
}
}
private boolean checkDataBase() {
File dbFile = new File(DB_PATH + DB_NAME);
return dbFile.exists();
}
private void copyDataBase() throws IOException {
try {
InputStream myInput = vocabContext.getAssets().open(DB_NAME);
String outFileName = DB_PATH + DB_NAME;
// Open the empty db as the output stream
OutputStream myOutput = new FileOutputStream(outFileName);
byte[] buffer = new byte[1024];
int length;
while ((length = myInput.read(buffer)) > 0) {
myOutput.write(buffer, 0, length);
}
myOutput.flush();
myOutput.close();
myInput.close();
} catch (IOException e) {
Log.v("data", e.toString().concat("sql"));
}
}
public void openDataBase() throws SQLException {
// Open the database
String myPath = DB_PATH + DB_NAME;
vocabDatabase = SQLiteDatabase.openDatabase(myPath, null,
SQLiteDatabase.OPEN_READONLY);
}
public Cursor getFoundationTierQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM FoundationTierVocabularyQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
};
public Cursor getHigherTierQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM HigherTierQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasyFirstConjugationVerbs() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM VerbQuestions1stConjugation ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasySecondConjugationVerbs() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM VerbQuestions2ndConjugation ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasyThirdConjugationVerbs() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM VerbQuestions3rdConjugation ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasyFourthConjugationVerbs() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM VerbQuestions4thConjugation ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasyMixConjugationVerbs() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM VerbQuestionsallConjugation ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getEasyIrregularConjugationVerbs() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM IrregularVerbsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getFirstDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM FirstDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getSecondDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM SecondDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getThirdDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM ThirdDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getFourthDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM FourthDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getFifthDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM FifthDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getNounsAllDeclensionNounsQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM NounsDeclensionNounsQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getis_ea_idQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IsEaIdQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor gethic_haec_hocQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM HicHaecHocQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getille_illa_illudQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IlleIllaIlludQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getqui_quae_quodQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM QuiQuaeQuodQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getIdem_eadem_idemQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IdemEademIdemQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getipse_ipsa_ipsumQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IpseIpsaIpsumQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getalius_alia_aliudQuestions() {
Cursor cur;
cur = vocabDatabase
.rawQuery(
"SELECT * FROM AliusAliaAliudQuestions ORDER BY Random()",
null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAdjectiveQuestions() {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM AdjectivesQuestions ORDER BY Random()", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerFirstDeclensionNounsQuestion(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM FirstDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getSAnswerecondDeclensionNounsQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM SecondDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerThirdDeclensionNounsQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM ThirdDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerFourthDeclensionNounsQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM FourthDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerFifthDeclensionNounsQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM FifthDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerNounsAllDeclensionNounsQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM NounsDeclensionNounsQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnsweris_ea_idQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IsEaIdQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerhic_haec_hocQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM HicHaecHocQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerille_illa_illudQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IlleIllaIlludQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerqui_quae_quodQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM QuiQuaeQuodQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerIdem_eadem_idemQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IdemEademIdemQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnsweripse_ipsa_ipsumQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM IpseIpsaIpsumQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnsweralius_alia_aliudQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM AliusAliaAliudQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
public Cursor getAnswerAdjectiveQuestions(String question) {
Cursor cur;
cur = vocabDatabase.rawQuery(
"SELECT * FROM AdjectivesQuestions WHERE Question LIKE '"
+ question + "'", null);
cur.moveToFirst();
vocabDatabase.close();
return cur;
}
@Override
public synchronized void close() {
if (vocabDatabase != null)
vocabDatabase.close();
super.close();
}
@Override
public void onCreate(SQLiteDatabase db) {
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
解决方案
I don't know what you have done in code and why used HTML ? but I can assume you need this simple code. please see below modified method.
private void displayTestQuestion() {
resetEverything();
stats.setText(Integer.toString(totalRightQuestions)+"/"+Integer.toString(totalNumberOfQuestions));
String questionText = questionCursor.getString(0);
Typeface font = Typeface.createFromAsset(getContext().getAssets(), "fonts/LATINWD.TTF");
question.setTypeface(font);
question.setText(questionText);
adjectiveNumber = questionCursor.getString(1);
adjectiveCase = questionCursor.getString(3);
adjectiveGender = questionCursor.getString(2);
}
这篇关于我怎样才能显示在Android的拉丁词？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
