前台代碼:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="servestudent.aspx.cs" Inherits="servestudent" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>無標題頁</title>
<script language="javascript" type="text/javascript" src="ajax/jquery.js"></script>
<script language="javascript" type="text/javascript">
//初始化時為伺服器控制項savebtn 綁定事件
$(function(){
$("#savebtn").click(
function(){
var username=$("#txtUsername").val();
if(username.length==0)
{
alert("使用者名稱不可為空");
return false;
}
var pwd=$("#txtPwd").val();
if(pwd.length==0)
{
alert("密碼不可為空");
return false;
}
$.ajax({
type:'POST',
url:'servestudent.aspx',
data:{action:'action',Username:username,Pwd:pwd},
success: savesuccesscallbace
})
}
)
});
//儲存成功後的回呼函數
function savesuccesscallbace(r)
{
if(r=="ok")
{
alert('儲存成功');
$("#Savespan").html(" <img src='image/check_right.gif'/>儲存成功");
}
else
{
$("#Savespan").html(" <img src='image/check_error.gif'/>儲存失敗");
return;
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtUsername" runat="server"></asp:TextBox>
<asp:TextBox ID="txtPwd" runat="server" TextMode="password" ></asp:TextBox>
<asp:Button ID="savebtn" runat="server" Text="儲存" /></div>
<span id="Savespan"></span>
</form>
</body>
</html>
後台代碼:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class servestudent : System.Web.UI.Page
{
string StrAction = "";
protected void Page_Load(object sender, EventArgs e)
{
StrAction = Request["action"];
if (StrAction == "action")
{
string username = Request["Username"];
string pwd = Request["Pwd"];
if (saveData(username, pwd))
{
Response.Clear();
Response.ContentType = "application/text";
Response.Write("ok");
Response.End();
}
else
{
Response.Clear();
Response.ContentType = "application/text";
Response.Write("no");
Response.End();
}
}
}
/// <summary>
/// 建立時間:2009-6-9
/// 建立人:周昕
/// 方法名稱:saveData();
/// 作用:用於去判斷儲存資訊是否成功。
/// </summary>
/// <param name="username"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool saveData(string username, string pwd)
{
SqlConnection mycon = new SqlConnection();
mycon.ConnectionString = ConfigurationManager.ConnectionStrings["BoBoConn"].ToString();
mycon.Open();
string sql = "insert into test values(@username,@pwd)";
SqlCommand mycom = new SqlCommand(sql, mycon);
mycom.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = username;
mycom.Parameters.Add("@pwd", SqlDbType.VarChar, 50).Value = pwd;
int n = (int)mycom.ExecuteNonQuery();
mycon.Close();
if (n > 0)
{
return true;
}
else
{
return false;
}
}
}