- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我是 Android 编程的新手,我想问一下如何加速我的 phonegap sqlite 应用程序。里面有 150 个单词,但是当我按下刷新按钮时,它需要 30 秒才能加载。谁能帮我改进一下?
我想在数据库中填充最多 500 个单词,我可以在不按刷新按钮的情况下显示这些单词吗?
function init() {
document.addEventListener("deviceready", onDeviceReady, true);
}
function onDeviceReady() {
var db = window.openDatabase("Database", "1.0", "Database Sqlite", 200000);
db.transaction(populateDB, errorCB, successCB);
}
$(document).ready(function(){
document.addEventListener("deviceready", onDeviceReady, false);
var db = window.openDatabase("Database", "1.0", "KamusDB", 200000);
function onDeviceReady(){
//Populate the database
db.transaction(populateDB, errorCB, successCB);
//Override the back button functionality
document.addEventListener('backbutton', onBack, false);
}
function onBack(){
//If the current page is index page then exit other wise navigate to index page
if($.mobile.activePage.is('#index')){
navigator.app.exitApp();
}
else{
db.transaction(queryDB, errorCB);
}
}
function populateDB(tx){
//Create the table
//tx.executeSql('DROP TABLE IF EXISTS MyContacts');
tx.executeSql('CREATE TABLE IF NOT EXISTS MyContacts (id INTEGER PRIMARY KEY AUTOINCREMENT, jerman TEXT, indonesia TEXT)');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (1, "Aber", "Tapi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (2, "Abfall", "Sampah")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (3, "Abkommen", "Persetujuan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (4, "Abreise", "Keberangkatan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (5, "Abschied", "Perpisahan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (6, "Abendessen", "Makan Malam")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (7, "Alter", "Umur")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (9, "Absicht", "Niat")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (10, "Abstand", "Jarak")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (11, "Abstimmung", "Suara dalam pemilihan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (12, "Abtreibung", "Aborsi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (13, "Affe", "Monyet")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (14, "Adresse", "Alamat")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (15, "Ahnung", "Ide")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (16, "Adler", "Elang")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (17, "Apfelsine", "Orange")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (18, "Baum", "Pohon")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (19, "Bart", "Jenggot")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (20, "Beamte", "Pegawai Negeri Sipil")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (21, "Banane", "Pisang")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (22, "Baumwolle", "Kapas")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (23, "Bedeutung", "Penting")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (24, "Bedeckt", "Mendung")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (25, "Befugnis", "Kewenangan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (26, "Brot", "Roti")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (27, "Chef", "Bos")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (28, "Chirurgin", "Operasi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (29, "Creme", "Krim")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (30, "Clown", "Badut")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (31, "Circa", "Kira kira")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (32, "Chemie", "Kimia")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (33, "Champignon", "Jamur")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (34, "Charakteristisch", "Karakterisitik")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (35, "Chinesich", "Cina")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (36, "Computer", "Komputer")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (37, "Dach", "Atap")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (38, "Darlehen", "Pinjaman")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (39, "Darstellerin", "Aktris")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (40, "Darsteller", "Aktor")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (41, "Degen", "Pedang")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (42, "Dehnbar", "Elastis")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (43, "Dreckig", "Kotor")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (44, "Drachen", "Layangan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (45, "Diebstahl", "Pencuri")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (46, "Disziplin", "Disiplin")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (47, "Eckig", "Kotak")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (48, "Egoistisch", "Egois")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (49, "Ehre", "Kehormatan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (50, "Ehrgeiz", "Ambisi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (51, "Eigentum", "Properti")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (52, "Eimer", "Ember")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (53, "Einfall", "Ide")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (54, "Einfluss", "Influenza")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (55, "Einheitlich", "Seragam")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (56, "Erlebnis", "Pengalaman")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (57, "Fenster", "Jendela")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (58, "Ferien", "Liburan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (59, "Feuerwerk", "Kembang Api")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (60, "Fluch", "Kutukan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (61, "Finderlohn", "Penghargaan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (62, "Fleisch", "Daging")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (63, "Fuhrer", "Pemimpin")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (64, "Galgen", "Tiang gantungan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (65, "Gans", "Angsa")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (66, "Ganztagz", "Sepanjang hari")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (67, "Garten", "Kebun")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (68, "Gasthof", "Penginapan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (69, "Gebet", "Doa")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (70, "Geburtsdatum", "Tanggal lahir")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (71, "Gebiss", "Gigi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (72, "Gedicht", "Puisi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (73, "Gefangene", "Tahanan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (74, "Gutschein", "Kupon")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (75, "Handel", "Pertukaran")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (76, "Hass", "Kebencian")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (77, "Hengst", "Kuda jantan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (78, "Herlich", "Menakjubkan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (79, "Industrie", "Industri")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (80, "Ingwer", "Jahe")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (81, "Insel", "Pulau")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (82, "Irrtum", "Kesalahan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (83, "Jahreszeit", "Musim")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (84, "Jagd", "Berburu")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (85, "Jawohl", "Ya")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (86, "Jura", "Hukum")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (87, "Jedoch", "Bagaimanapun")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (88, "Kalt", "Dingin")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (89, "Kamm", "Sisir")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (90, "Kein", "No")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (91, "Katze", "Kucing")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (92, "Kleingeld", "Ganti")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (93, "Lachs", "Salmon")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (94, "Muster", "Model")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (95, "Mowe", "Burung Camar")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (96, "Mude", "Lelah")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (97, "Merkmal", "Fitur")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (98, "Neld", "Cemburu")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (99, "Nachbarin", "Tetangga")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (100, "Nass", "Basah")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (101, "Nutzen", "Keuntungan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (102, "Nochmals", "Lagi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (103, "Neun", "Sembilan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (104, "Pflege", "Peduli")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (105, "Pinsel", "Sikat")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (106, "Plakat", "Poster")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (107, "Polizei", "Polisi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (108, "Preis", "Harga")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (109, "Promille", "Kadar Alkohol")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (110, "Pult", "Meja")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (111, "Quelle", "Sumber")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (112, "Qualitat", "Kualitas")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (113, "Quittung", "Resep")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (114, "Razzia", "Serangan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (115, "Rechnen", "Aritmatika")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (116, "Rauch", "Merokok")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (117, "Rassistich", "Rasis")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (118, "Ritter", "Kesatria")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (119, "Rot", "Merah")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (120, "Schelm", "Bajingan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (121, "Schauspielerin", "Aktor")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (122, "Schande", "Malu")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (123, "Sekunde", "Detik")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (124, "Smoking", "Jas makan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (125, "Stein", "Batu")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (126, "Treibstoff", "Bensin")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (127, "Treffen", "Rapat")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (128, "Tat", "Aksi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (129, "Teigh", "Adonan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (130, "Tier", "Hewan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (131, "Uberschwemmung", "Banjir")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (132, "Uberfall", "Serangan")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (133, "Unkraut", "Ganja")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (134, "Unfug", "Tidak masuk akal")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (135, "Unterlagen", "Dokumen")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (136, "Vater", "Ayah")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (137, "Verhandlung", "Mendengar")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (138, "Verrat", "Pengkhianat")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (139, "Vogel", "Burung")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (140, "Verwaltung", "Administrasi")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (141, "Wahr", "Betul")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (142, "Weil", "Karena")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (143, "Wecker", "Jam Alarm")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (144, "Wurst", "Sosis")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (145, "X-mal", "Sekian kali")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (146, "X-beliebig", "Apa saja")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (147, "Yoga", "Yoga")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (148, "Yacht", "Kapal pesiar")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (149, "Zug", "Kereta")');
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (150, "Zeiger", "Tangan")');
tx.executeSql('SELECT id, jerman, indonesia FROM MyContacts ORDER BY jerman', [], querySuccess, errorCB);
}
function successCB(){
db.transaction(queryDB, errorCB);
}
function queryDB(tx){
tx.executeSql('SELECT id, jerman, indonesia FROM MyContacts ORDER BY jerman', [], querySuccess, errorCB);
}
function querySuccess(tx, results){
$.mobile.showPageLoadingMsg(true);
var len = results.rows.length;
$("#userList").html('');
for (var i=0; i<len; i++){
var row= results.rows.item(i);
var htmlData = '<li id="'+row["id"]+'"><a href="#"><h2>'+row["jerman"]+'</h2><p class="ui-li-aside">'+row["indonesia"]+'</p></a></li>';
$("#userList").append(htmlData).listview('refresh');
}
$.mobile.changePage($("#index"), { transition : "slide"});
$.mobile.hidePageLoadingMsg();
}
function errorCB(err){
}
$(".refresh").bind("click", function (event){
db.transaction(queryDB, errorCB);
});
$("#index [data-role='content'] ul").on('tap taphold', 'li', function (event){
event.preventDefault();
event.stopImmediatePropagation();
var liId = this.id;
if (event.type === 'taphold'){
navigator.notification.vibrate(30);
var $popup = $('#actionList-popup');
$("#actionList").html('');
$popup.popup();
$popup.popup('open');
$("#tapHoldCheck").val('true');
}
else if (event.type === 'tap'){
if ($("#tapHoldCheck").val() == ''){ //If the value of the text box is blank then only tap will work
db.transaction(function (tx){
tx.executeSql("SELECT jerman, indonesia FROM MyContacts WHERE id=?;", [liId], function (tx, results){
var row = results.rows.item(0);
$.mobile.showPageLoadingMsg(true);
$.mobile.changePage($("#displayDataPage"), { transition : "slide"});
$("#nameHeader").html(row['jerman']);
$("#datajerman").html(row['jerman']);
$("#dataindonesia").html(row['indonesia']);
$('#dataList').listview('refresh');
$.mobile.hidePageLoadingMsg();
});
});
}
}
});
//Change the hidden field value when the popup is closed
$('#actionList-popup').bind({
popupafterclose: function(event, ui){
$("#tapHoldCheck").val('');
}
});
});
</script>
</head>
<!-- Index Page Start -->
<div data-role="page" id="index">
<div data-role="header" data-position="fixed" data-theme="e">
<a href="#" class="refresh" data-role="button" data-icon="refresh" data-theme="a" title="Refresh">Refresh</a>
<h1 class="in">Jerman Dictionary</h1>
<a href="#right-panel" data-role="button" data-icon="home" data-theme="a" title="Menu" >Menu</a>
</div>
<div data-role="content">
<ul data-role="listview" data-autodividers="false" data-divider-theme="e" data-inset="true" data-filter="true" data-filter-placeholder="Search..." id="userList"> </ul>
</div>
<div data-role="popup" id="actionList-popup" data-overlay-theme="m">
<ul data-role="listview" id="actionList" style="border: 1px solid blue; width:15em"> </ul>
</div>
<input type="hidden" id="tapHoldCheck" value="" />
</div>
<!-- Index Page End -->
<!-- Data Display Page Start -->
<div data-role="page" id="displayDataPage">
<div data-role="header" data-position="fixed" data-theme="e">
<h1>Penjelasan</h1>
</div>
<div data-role="content">
<ul data-role="listview" data-divider-theme="e" id="dataList">
<li>Jerman = <span id="datajerman"></span></li>
<li>Indonesia = <span id="dataindonesia"></span></li>
</ul>
</div>
<div data-role="footer" data-position="fixed" data-theme="e">
</div>
</div>
<!-- Data Display Page End -->
</div>
</body>
最佳答案
一些注意事项:
在同一次执行中有多个 INSERT:
tx.executeSql('INSERT INTO MyContacts (id, jerman, indonesia) VALUES (1, "Aber", "Tapi");
INSERT INTO MyContacts (id, jerman, indonesia) VALUES (2, "Abfall", "Sampah");');
tx.executeSql
末尾的 SELECT 查询需要放入串联插入的成功回调中像这样
tx.executeSql('<inserts here>', [], function(tx) {
tx.executeSql('SELECT id, jerman, indonesia FROM MyContacts ORDER BY jerman', [], querySuccess, errorCB);
});
如果这些方法没有帮助,请添加警报 以跟踪执行 SQL 查询的开始和结束时间,以查看这些查询实际花费了多少时间。
关于jquery - Phonegap SQLite 性能速度加载,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/27875114/
我正在开发一个 SQLite 数据库。数据库已经填满了,但我想重构它。这是我需要做的一个示例: 我目前有一张 table : CREATE TABLE Cars (ID INTEGER PRIMARY
我正在使用 Mono、SQLite、Dapper 和 Dapper 扩展。我可以从数据库中读取数据,但插入不起作用。我正在使用 sqlite 的 Mono 驱动程序。 错误并不能提供太多信息,至少对我
我有一个使用 SQLite 的 Windows Phone 8 应用程序。该应用程序具有许多数据库功能,并包含一个 sqlite 数据库文件,在运行该应用程序时,该文件将被复制到本地文件夹并进行访问。
为 sqlite 创建索引时有排序顺序。 https://sqlite.org/lang_createindex.html Each column name or expression can be
顾名思义,我怀疑如果有一些引用被删除的表会发生什么,例如表的某些字段的索引。 SQLite是否会自动处理?在执行drop命令之前,数据库所有者是否应注意任何实例? 最佳答案 我认为不需要家政服务。 S
我想知道是否有可能将从计数中获得的整数转换为REAL 类似于以下内容(尽管这不起作用) SELECT CAST (COUNT (ColumnA) AS Count) AS REAL) FROM Tab
我无法在SQLite数据库上执行一些更新。我正在Windows上使用SQLite 3 Shell。 我正在运行以下命令: update resovled_chrom_counts set genus
我知道SQLite中的触发器顺序是不确定的(您不能确定将首先执行哪个触发器),但是表约束和触发器之间的关系又如何呢? 我的意思是,假设我在一个列中有一个UNIQUE(或CHECK)约束,并且在该表上有
我的 CustomTags 表可能有一系列“临时”记录,其中 Tag_ID 为 0,并且 Tag_Number 将有一些五位数的值。 定期,我想清理我的 Sqlite 表以删除这些临时值。 例如,我可
我有A,B,C和D的记录。 我的SQL1 SELECT * FROM main_table order by main_table.date desc limit 2返回A和B。 我的SQL2 SEL
select round(836.0)返回836.0 我如何删除sqlite查询中的尾随零。 836.00应该是836 836.440应该是836.44 最佳答案 如果需要836.44,则需要十进制返
我正在研究RQDA中的文本,并且正在使用Firefox SQLite Manager访问数据库,以便可以更轻松地搜索文件。我创建并填充了虚拟表: CREATE VIRTUAL TABLE texts
我有这样的数据: table1 id | part | price 1 | ox900 | 100 2 | ox980 | 200 和 table2 id | part | price 1
我正在尝试将一些数据插入现有的SQLite表中。该表和数据库是使用相同的API创建的,但是由于某种原因,插入操作无效,并且从不给我任何错误消息。 我正在BlackBerry 9550模拟器上对此进行测
例如,我在名为SALARY的列中插入一个值。如果插入的值大于1000,我想将字符串HIGH插入到RANK列中,否则将插入LOW中。 我可以使用SQLite做到吗? 最佳答案 在插入之前使用触发器,然后
假设我有一个包含三列A,B,C的表t1,其中(A,B)包含唯一键(具有数十万行)。由于90%的查询将采用SELECT C FROM t1 WHERE A =?和B = ?,我想我要为A,B和C提供覆盖
在一个SQLite3数据库中,我有一个表“ projects”,其id字段由以下方式组成: [user id]_[user's project id] 例如,用户ID = 45,这是一些数据: 45_
我了解PRAGMA foreign_key和ON DELETE RESTRICT/NO ACTION的概念,但是我面临的是另一种情况。 我需要删除一个父行,但保持与之关联的子行。例如: CREATE
我的c#应用程序从Web服务1读取文件列表,并将完整的文件名插入table1,然后从第二个Web服务读取list并将它们插入到table2。 这些表具有相同的结构,如下所示: create table
我在以下情况下尝试将Record1的ID更新为Record2的ID: 两个表中的名称相同,并且 在Record2中权重更大。 记录1 | ID | Weight | Name | |----|----
我是一名优秀的程序员,十分优秀!