資源簡介
基于asp.net SQLServer技術,在線考試系統,非常適合初學者學習參考。

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
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?_Default?:?System.Web.UI.Page
{
????Datacon?dataconn=new?Datacon();
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????Session[“StuName“]?=?this.txtUserName.Text;
????????if?(!IsPostBack)
????????{
????????????Random?rnd?=?new?Random();
????????????this.labValidate.Text?=?rnd.Next(1000?9999).ToString();
????????}
????}
????protected?void?Button1_Click(object?sender?EventArgs?e)
????{
????????//判斷驗證碼是否有誤
????????if?(txtValidate.Text?!=?txtValidate.Text)
????????{
????????????Response.Write(“ript?language=javascript>alert(‘驗證碼有誤!‘)location=‘javascript:history.go(-1)‘ ript>“);
????????}
????????else
????????{
????????????//判斷是否是管理員登錄,如果是則調用方法getcom方法中的條件1
????????????if?(cblAdminLog.Items[0].Selected?==?true)
????????????{
????????????????getcom(1);
????????????}
????????????//非管理員登錄,調用getcom方法中條件2
????????????else
????????????{
????????????????getcom(2);
????????????}
????????}
????}
????//自定義方法getcom方法,判斷是否是管理員還是考生
????private?void?getcom(int?i)
????{
????????//打開數據庫連接,并調用公共類中的getcon方法
????????SqlConnection?con?=?dataconn.getcon();
????????con.Open();
????????//創建一個新的SqlCommand實例對象
????????SqlCommand?com?=?con.CreateCommand();
????????switch?(i)
????????{
????????????case?1:
????????????????com.CommandText?=?“select?count(*)?from?tb_Administrator?where?Name=‘“?+?this.txtUserName.Text?+?“‘and?PWD=‘“?+?this.txtPwd.Text?+?“‘“;
????????????????//獲取SQL語句的值?強制轉換成數值類型
????????????????int?count1?=?Convert.ToInt32(com.ExecuteScalar());
????????????????//判斷數據庫中是否存在數據
????????????????if?(count1?>?0)
????????????????{
????????????????????Application[“Name“]?=?txtUserName.Text;//成功
????????????????????Application[“PWD“]?=?txtPwd.Text;//成功
????????????????????//如果登錄成功,則跳轉到管理員頁面
????????????????????Page.Response.Redirect(“HouAdmin/admin.aspx“);
????????????????}
????????????????else
????????????????{
????????????????????//如果登錄失敗,則彈出錯誤信息
????????????????????Response.Write(“ript?lanuage=javascript>alert(‘用戶名或密碼有誤!‘);location=‘javascript:history.go(-1)‘ ript>“);
????????????????}
????????????????break;
????????????case?2:
????????????????com.CommandText?=?“select?count(*)?from?tb_Student?where?ID=‘“?+?txtUserName.Text?+?“‘?and?PWD=‘“?+?txtPwd.Text?+?“‘“;
????????????????int?count2?=?Convert.ToInt32(com.ExecuteScalar());
????????????????if?(count2?>?0)
????????????????{
????????????????????Application[“ID“]?=?txtUserName.Text;
????????????????????Application[“PWD“]?=?txtPwd.Text;
????????????????????Page.Response.Redirect(“QianUser/zaixian_kaoshi.aspx“);
????????????????}
????????????????else
????????????????{
????????????????????Response.Write(“ript?lanuage=javascri
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-25?11:19??07\
?????目錄???????????0??2017-09-20?18:48??07\NE\
?????目錄???????????0??2017-09-20?18:48??07\NE\App_Code\
?????文件????????3870??2010-08-12?15:51??07\NE\App_Code\Datacon.cs
?????目錄???????????0??2017-09-20?18:48??07\NE\App_Data\
?????文件?????2097152??2018-02-08?20:50??07\NE\App_Data\db_Examination_Data.MDF
?????文件?????1048576??2018-02-08?20:50??07\NE\App_Data\db_Examination_Log.LDF
?????目錄???????????0??2017-09-20?18:48??07\NE\App_Themes\
?????目錄???????????0??2017-09-20?18:48??07\NE\App_Themes\mytheme\
?????文件????????1211??2007-12-13?18:29??07\NE\App_Themes\mytheme\SkinFile.skin
?????文件????????4226??2007-12-10?14:35??07\NE\Default.aspx
?????文件????????3628??2007-12-17?11:13??07\NE\Default.aspx.cs
?????目錄???????????0??2017-09-20?18:48??07\NE\HouAdmin\
?????文件????????6726??2007-12-28?10:59??07\NE\HouAdmin\AdminInsert.aspx
?????文件????????1930??2007-12-04?10:23??07\NE\HouAdmin\AdminInsert.aspx.cs
?????文件???????11156??2007-12-17?09:47??07\NE\HouAdmin\InsertShiTi.aspx
?????文件???????17132??2007-12-17?10:18??07\NE\HouAdmin\InsertShiTi.aspx.cs
?????文件???????12403??2007-12-15?15:26??07\NE\HouAdmin\KaoshiUpdate.aspx
?????文件???????18499??2007-12-04?18:35??07\NE\HouAdmin\KaoshiUpdate.aspx.cs
?????文件????????5915??2007-12-28?11:04??07\NE\HouAdmin\KechengInsert.aspx
?????文件????????1348??2007-12-04?16:33??07\NE\HouAdmin\KechengInsert.aspx.cs
?????文件????????5693??2007-12-15?15:16??07\NE\HouAdmin\KechengUpdate.aspx
?????文件????????2008??2007-12-04?16:37??07\NE\HouAdmin\KechengUpdate.aspx.cs
?????文件????????5647??2007-12-17?11:22??07\NE\HouAdmin\TaotiInsert.aspx
?????文件????????1356??2007-12-17?12:08??07\NE\HouAdmin\TaotiInsert.aspx.cs
?????文件????????5673??2007-12-15?11:37??07\NE\HouAdmin\TaotiUpdate.aspx
?????文件????????2865??2007-12-17?20:21??07\NE\HouAdmin\TaotiUpdate.aspx.cs
?????文件????????6593??2008-01-02?17:05??07\NE\HouAdmin\ZhuangyeInsert.aspx
?????文件????????2779??2008-01-02?11:14??07\NE\HouAdmin\ZhuangyeInsert.aspx.cs
?????文件????????7187??2007-12-15?11:52??07\NE\HouAdmin\ZhuanyeUpdate.aspx
?????文件????????1733??2007-12-17?09:27??07\NE\HouAdmin\ZhuanyeUpdate.aspx.cs
............此處省略53個文件信息
- 上一篇:極力推薦家教信息管理平臺含源碼和數據庫
- 下一篇:多邊形方向及頂點凹凸性的判斷
評論
共有 條評論