AJAX讀取數(shù)據(jù)庫(kù)數(shù)據(jù)
ajax讀取數(shù)據(jù)庫(kù)數(shù)據(jù)代碼實(shí)例:
既然ajax可以向后臺(tái)發(fā)送請(qǐng)求，也可以傳遞參數(shù)，當(dāng)然就可以根據(jù)需要進(jìn)行數(shù)據(jù)庫(kù)查詢(xún)功能。
下面就通過(guò)代碼實(shí)例介紹一下如何實(shí)現(xiàn)此需求，當(dāng)然代碼比較簡(jiǎn)單，僅作為參考之用。
代碼實(shí)例:
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="author" content="http://www.miracleart.cn/" />
<title>php中文網(wǎng)</title>
<style>
body{
font-size:12px;
}
</style>
<script>
function loadXMLDoc(keywords) {
var xmlhttp;
if (window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
}
else {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById("show").innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open("get", "demo/ajax/net/Query.aspx?keywords=" + escape(keywords), true);
xmlhttp.send();
}
window.onload = function () {
var otxt = document.getElementById("txt");
var obt = document.getElementById("bt");
obt.onclick = function () {
loadXMLDoc(otxt.value);
}
}
</script>
</head>
<body>
<input type="text" id="txt"/>
<input type="button" id="bt" value="查看效果"/>
(例如輸入:css教程或者div教程)
<div>結(jié)果:<span id="show"></span></div>
</body>
</html>在文本框中輸入要查詢(xún)的課程名稱(chēng)，然后點(diǎn)擊按鈕即可實(shí)現(xiàn)查詢(xún)效果。asp.net后臺(tái)代碼如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Configuration;
namespace ajax
{
public partial class Query : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string keywords = Server.UrlDecode(Request.QueryString["keywords"]);
if (String.IsNullOrEmpty(keywords.Trim()))
{
Response.Write("輸入查詢(xún)關(guān)鍵詞");
Response.End();
}
string connString=ConfigurationManager.ConnectionStrings["access_con"].ConnectionString;
string configPath=ConfigurationManager.ConnectionStrings["access_path"].ConnectionString;
string conPath = HttpContext.Current.Server.MapPath(configPath);
OleDbConnection conn = new OleDbConnection(connString + conPath);
string sql = "select * from data where type='" + keywords + "' order by id desc";
OleDbCommand cmd = new OleDbCommand(sql,conn);
try
{
conn.Open();
OleDbDataReader MyReader = cmd.ExecuteReader();
if (MyReader.Read())
{
Response.Write("存在指定教程");
}
else
{
Response.Write("不存在指定教程");
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
}
}
