📄 jiaoshiguanli.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="jiaoshiguanli.aspx.vb" Inherits="jiaoshiguanli" %>
<!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>
<style type="text/css">
<!--
body,td,th {
font-size: 10pt;
color: #000000;
}
body {
background-color: #00CCFF;
}
-->
</style>
</head>
<body style="background-image: url(图片/7d8e3733deed41f41b4cffc0.jpg)">
<p> </p>
<p>
</p>
<p>
</p>
<p style="color: red">管理员：<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></p>
<p style="color: red">欢迎使用本教务系统</p>
<p> </p>
<form id="form1" runat="server">
<div>
<table width="206" border="1" align="center" >
<tr>
<td colspan="2"><div align="center">添加教师</div></td>
</tr>
<tr>
<td width="115" height="29"><div align="center">用户名</div></td>
<td width="124"> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td height="29"><div align="center">密码</div></td>
<td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td height="29"><p align="center">密码重复</p> </td>
<td> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2" style="height: 29px">
<asp:Button ID="Button1" runat="server" Text="添加" /></td>
</tr>
</table>
<br />
现有教师<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" DataKeyNames="ID">
<Columns>
<asp:BoundField DataField="用户名" HeaderText="用户名" SortExpression="用户名" />
<asp:BoundField DataField="密码" HeaderText="密码" SortExpression="密码" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" Visible="False" />
<asp:CommandField ButtonType="Button" ShowEditButton="True" />
<asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
</Columns>
</asp:GridView>
<br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/db1.mdb"
SelectCommand="SELECT [用户名], [密码], [ID] FROM [yonghu] WHERE ([等级] = ?)" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [yonghu] WHERE [ID] = ? AND [用户名] = ? AND [密码] = ?" InsertCommand="INSERT INTO [yonghu] ([用户名], [密码], [ID]) VALUES (?, ?, ?)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [yonghu] SET [用户名] = ?, [密码] = ? WHERE [ID] = ? AND [用户名] = ? AND [密码] = ?">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="等级" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_用户名" Type="String" />
<asp:Parameter Name="original_密码" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="用户名" Type="String" />
<asp:Parameter Name="密码" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_用户名" Type="String" />
<asp:Parameter Name="original_密码" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="用户名" Type="String" />
<asp:Parameter Name="密码" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</InsertParameters>
</asp:AccessDataSource>
<br />
<asp:Button ID="Button2" runat="server" Text="返回" /></div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -