2、信息增删改查
Html页面
</t</p><p style='padding:5px 0px;'>13、itle>
<script type ="text/javascript">
var xmlHttp;
var name;
var num;
var Bclass;
var deleteID;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if </p><p style='padding:5px 0px;'>14、window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest(); } }
function addEmployee() {
name = document.getElementById("name").value;
num = document.getElementById("num").value;
Bclass = document.getElementById("Bclass").value;
if (name == "</p><p style='padding:5px 0px;'>15、" || num == "" || Bclass == "") {
return; }
var url = "zsgc.aspx?" + createAddQueryString(name, num, Bclass, "ffstudent"); +"&ts=" + new Date().getTime();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GE</p><p style='padding:5px 0px;'>16、T", encodeURI(url), true);
xmlHttp.send(null);
}
function delEmployee() {
num = document.getElementById("num").value;
if (num == "") {
return; }
var url = "zsgc.aspx?" + createDelQueryString(num, "delstuent"); +"&ts=" + new Date().get</p><p style='padding:5px 0px;'>17、Time();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GET", encodeURI(url), true);
xmlHttp.send(null); }
function cxEmployee() { num = document.getElementById("num").value;
action = "cxstudent";
</p><p style='padding:5px 0px;'>18、 if (num == "") {
return; }
var url = "zsgc.aspx?" + createcxQueryString(num, action); +"&ts=" + new Date().getTime();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GET", encodeURI(url), true);
</p><p style='padding:5px 0px;'>19、 xmlHttp.send(null); }
function createAddQueryString(name, num, Bclass, action) {
var queryString = "name=" + name
+ "&num=" + num
+ "&Bclass=" + Bclass
+ "&action=" + action;
return queryString;
}
function createDelQu</p><p style='padding:5px 0px;'>20、eryString(num, action) {
var queryString = "num=" + num
+ "&action=" + action;
return queryString; }
function createcxQueryString(num, action) {
var queryString = "num=" + num
+ "&action=" + action;
return queryString; }
</p><p style='padding:5px 0px;'>21、function handleAddStatechange() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
alert(xmlHttp.responseText);
clearInputBoxes(); }
else {
alert("Error while adding employee."); } } }
fu</p><p style='padding:5px 0px;'>22、nction clearInputBoxes() {
document.getElementById("name").value = "";
document.getElementById("num").value = "";
document.getElementById("Bclass").value = ""; }
</script></head><body background="img/3.jpg">
<h1> </p><p style='padding:5px 0px;'>23、nbsp; 学¡ì生¦¨²信?息¡é</h1>
<table ><tr><td>姓?名?：êo</td><td>
<input id="name" type="text" /></td><td>学¡ì号?：êo</td><td>
<input id="num" type="text" /></td><td>班㨤级?：êo</td><td>
<input id="Bclass" type="text" /></td></tr><tr>
<td colspan ="2" align="center">
<input </p><p style='padding:5px 0px;'>24、id="Button1" type="button" value="添¬¨ª加¨®" onclick="addEmployee();" /></td>
<td colspan ="2" align="center">
<input id="Button2" type="button" value="删¦?除y" onclick ="delEmployee();" /></td>
<td colspan ="2" align="center">
<input id="Button3" </p><p style='padding:5px 0px;'>25、type="button" value="查¨¦询¡¥" onclick="cxEmployee();"/></td></tr>
</table>
</body>
</html>
Cs后台代码.
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
</p><p style='height:0px;padding:0;overflow:hidden'>26、public partial class zsgc : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "Data Source=.;Initial Catalog=Student;Integrated Security=True";
SqlConnection coon = new SqlConnection(str);
SqlCommand cmd = new SqlCommand();</p><p style='height:0px;padding:0;overflow:hidden'>27、
try {
coon.Open();
string action = Request["action"].ToString();
string num = Request["num"].ToString();
if (action == "ffstudent")
{ string Bclass = Request["Bclass"].ToString();
string name = Request["name</p><p style='height:0px;padding:0;overflow:hidden'>28、"].ToString();
SqlParameter[] par ={
new SqlParameter("@name",name),
new SqlParameter ("@num",num),
new SqlParameter ("@Bclass",Bclass ) };
cmd.Connection = </p><p style='height:0px;padding:0;overflow:hidden'>29、coon;
cmd.CommandText = "ffstudent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
int i = cmd.ExecuteNonQuery();
if (i > 0) {
Response.Write("添¬¨ª加¨®成¨¦功|！ê?"); }</p><p style='height:0px;padding:0;overflow:hidden'>30、
else {
Response.Write("添¬¨ª加¨®失º¡ì败㨹！ê?");} }
else if (action == "delstuent"){
SqlParameter[] par ={
new SqlParameter ("@num",num) };
cmd.Connection = coon;
c</p><p style='height:0px;padding:0;overflow:hidden'>31、md.CommandText = "delstuent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
int i = cmd.ExecuteNonQuery();
if (i > 0){
Response.Write("删¦?除y成¨¦功|！ê?");}
else{
</p><p style='height:0px;padding:0;overflow:hidden'>32、 Response.Write("删¦?除y失º¡ì败㨹！ê?"); }}
else if (action == "cxstudent"){
DataTable dt = new DataTable();
SqlParameter[] par ={
new SqlParameter ("@num",num) };
cmd.Connection = coo</p><p style='height:0px;padding:0;overflow:hidden'>33、n;
cmd.CommandText = "cxstudent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
string str1 = "";
</p><p style='height:0px;padding:0;overflow:hidden'>34、 for (int i = 0; i < dt.Rows.Count; i++) {
str1 += dt.Rows[i][0].ToString() + ":" + dt.Rows[i][1].ToString() + ":" + dt.Rows[i][2].ToString(); }
Response.Write(str1); }
coon.Close(); }
catch (Exception e1)
{
R</p><p style='height:0px;padding:0;overflow:hidden'>35、esponse.Write(e1.ToString());}}}
3、注册
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无T标À¨º题¬a页°3
用®?户¡ì注Á¡é册¨¢验¨¦证¡è
38、"Txt1" type="text" />
<
/body>
Cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
39、using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class zhuce : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e) {
40、 if (Request["name"] != ""){
string name = this.Request["name"];
string connStr = "Data Source=.;Initial Catalog=User;Integrated Security=True;Pooling=False";
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string se
41、lStr = "select * from dbo.use1 where name='" + name + "'";
SqlCommand com = new SqlCommand(selStr, conn);
SqlDataReader da = com.ExecuteReader();
if (da.Read()){
Response.Write("用®?户¡ì名?已°?存ä?在¨²！ê?！ê?"); } else {
Response.W
浙ICP备2021020529号-1 | 浙B2-20240490 
