jQuery可以查MySQL吗,我们可以在JQuery中执行SQL查询吗

can we execute mySQL queries in jQuery Calllback functions & misc. functions

like simple query

UPDATE EMPLOYEE SET PAY = PAY + 500 WHERE E_ID = '32'

解决方案

The best thing you can do is to issue an AJAX request to a server and then execute this query using a server side code.

You can use jQuery.post() in this case.

Edit

To get an overview of AJAX Read this

Read this to get and overview of AJAX methods in jQuery.

Write a server side logic to execute the SQL command, in a page. Then using AJAX issue a request to that page.

Sample Code

$(function(){

// Bind a click event to your anchor with id `updateSal`

$("#updateSal").click(function(){

// get your employeeID

var empID = "32";

// issue an AJAX request with HTTP post to your server side page.

//Here I used an aspx page in which the update login is written

$.post("test.aspx", { EmpID: empID},

function(data){

// callack function gets executed

alert("Return data" + data);

});

// to prevent the default action

return false;

});

});