前台代码:
<%@ 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;
}
}
}