我正在尝试将数据库与我的系统连接,但每次调用函数后,在应用程序的浏览器中都会显示如下内容:
以下是代码:
JS部分:
var db = openDatabase("Meubanco", "3.0", "Mybase", 6000);
db.transaction(function(criar){
criar.executeSql("CREATE TABLE granjas (ID INTEGER PRIMARY KEY AUTOINCREMENT, nome TEXT, email TEXT, cnpj TEXT)");
});
function cadastrar(){
var nome = document.getElementById("nome").value;
var email = document.getElementById("email").value;
var cnpj = document.getElementById("cnpj").value;
db.transaction(function(armazenar){
armazenar.executeSql("INSERT INTO granjas (nome, email, cnpj) VALUES (?,?@email.com,?)", [nome, email, cnpj]);
alert("Granja " + document.getElementById("nome").value + " Cadastrada!");
});
};
关于HTML:
<form onsubmit="cadastrar();">
<div class="form-group">
<label>Nome</label>
<input type="text" class="form-control" id="nome" placeholder="nome">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Endereço de email</label>
<input type="email" class="form-control" id="email" aria-describedby="emailHelp" placeholder="email">
</div>
<div class="form-group">
<label>CNPJ</label>
<input type="text" class="form-control" id="cnpj" placeholder="cnpj">
</div>
<form>
<div class="form-group">
<label for="exampleFormControlFile1">Insira uma imagem da granja<small id="emailHelp" class="form-text text-muted">Ação Opcional.</small></label>
<input type="file" class="form-control-file" id="imagem_da_empresa"/>
</div>
</form>
<button type="button" class="btn btn-primary" onclick="cadastrar();">Cadastrar</button>
<a type="button" class="btn btn-outline-info" href="listagem_de_granjas.html">Granjas Cadastrdas</a>
</form>
我想我的意图很明显。这是项目链接:https://github.com/Nidhoggui/beta-_projetoavicultura