CREATE TABLE DLION ( _id INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT, questionId INTEGER, answerId INTEGER, [right] INTEGER );
public void addContent() {
try {
BufferedReader localBufferReader = new BufferedReader(
new InputStreamReader(getResources().openRawResource(
R.raw.test)));
db = openDatabase();
for (int i = length + 1;; i++) {
// 添加问题到数据库
String questionStr = localBufferReader.readLine();
if (questionStr == null) {
localBufferReader.close();
db.close();
break;
}
Log.v("insert", "insert questionContent " + questionStr
+ " success!");
db.execSQL("insert into DLION(questionId,content) values(" + i
+ ",'" + questionStr + "')");
// 添加答案1到数据库
String answerStr1 = localBufferReader.readLine();
if (answerStr1 == null) {
localBufferReader.close();
db.close();
break;
}
Log.v("insert", "insert answerContent1 " + answerStr1
+ " success!");
db.execSQL("insert into DLION(answerId,content) values(" + i
+ ",'" + answerStr1 + "')");
// 添加答案2到数据库
String answerStr2 = localBufferReader.readLine();
if (answerStr2 == null) {
localBufferReader.close();
db.close();
break;
}
Log.v("insert", "insert answerContent2 " + answerStr2
+ " success!");
ContentValues answerContent2 = new ContentValues();
answerContent2.put("answerId", i);
answerContent2.put("content", answerStr2);
db.insert("DLION", "_id", answerContent2);
// 添加答案3到数据库
String answerStr3 = localBufferReader.readLine();
if (answerStr3 == null) {
localBufferReader.close();
db.close();
break;
}
Log.v("insert", "insert answerContent3 " + answerStr3
+ " success!");
ContentValues answerContent3 = new ContentValues();
answerContent3.put("answerId", i);
answerContent3.put("content", answerStr3);
db.insert("DLION", "_id", answerContent3);
// 添加答案4到数据库
String answerStr4 = localBufferReader.readLine();
if (answerStr4 == null) {
localBufferReader.close();
db.close();
break;
}
Log.v("insert", "insert answerContent4 " + answerStr4
+ " success!");
ContentValues answerContent4 = new ContentValues();
answerContent4.put("answerId", i);
answerContent4.put("content", answerStr4);
db.insert("DLION", "_id", answerContent4);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有