資源簡介
學生:注冊登錄,點卡充值,修改個人信息,作文上傳,上傳管理,請求老師批改,查詢批改內容
教師:登錄,批改學生作文,獲取點數,修改個人信息
管理員:管理學生,管理教師,管理上傳作文,查詢管理批改情況,查詢老師點數,查詢管理學生充值點數。修改登錄信息密碼

代碼片段和文件信息
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;
///?
///?DB?的摘要說明
///?
public?class?DB
{
????SqlConnection?con?=?null;
????SqlCommand?cmd?=?new?SqlCommand();
????public?DB()
????{
????????con?=?new?SqlConnection(ConfigurationManager.AppSettings[“SqlConString“]);
????}
????public?SqlConnection?getCon()
????{
????????if?(con.State?==?ConnectionState.Closed)
????????????con.Open();//打開連接
????????return?con;
????}
????public?void?clear()
????{
????????if?(con.State?==?ConnectionState.Open)
????????????con.Close();
????}
????public?int?sqlDone(string?strSql)
????{
????????cmd.Connection?=?getCon();
????????cmd.CommandText?=?strSql;
????????int?i?=?cmd.ExecuteNonQuery();
????????clear();
????????return?i;
????}
????public?string?sqlBack(string?strSql)
????{
????????cmd.Connection?=?getCon();
????????cmd.CommandText?=?strSql;
????????string?result?=?cmd.ExecuteScalar().ToString();
????????clear();
????????return?result;
????}
????public?SqlDataReader?getSdr(string?strSql)
????{
????????cmd.Connection?=?getCon();
????????cmd.CommandText?=?strSql;
????????SqlDataReader?sdr?=?cmd.ExecuteReader();
????????//clear();
????????return?sdr;
????}
????public?DataSet?getDs(string?strSql?string?tableName)
????{
????????SqlDataAdapter?sda?=?new?SqlDataAdapter(strSql?getCon());
????????DataSet?ds?=?new?DataSet();
????????sda.Fill(ds?tableName);
????????clear();
????????return?ds;
????}
????public?bool?executeTranaction(string[]?arrSql)
????{
????????bool?flag?=?false;
????????con?=?getCon();
????????cmd.Connection?=?con;
????????SqlTransaction?myTransaction;
????????myTransaction?=?con.BeginTransaction();
????????try
????????{
????????????for?(int?i?=?0;?i?????????????{
????????????????cmd.Transaction?=?myTransaction;
????????????????cmd.CommandText?=?arrSql[i];
????????????????cmd.ExecuteNonQuery();
????????????}
????????????myTransaction.Commit();
????????????flag?=?true;
????????}
????????catch?(Exception?e)
????????{
????????????myTransaction.Rollback();
????????????flag?=?false;
????????}
????????finally
????????{
????????????clear();
????????}
????????return?flag;
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????2031616??2016-05-19?21:44??作業批改系統\App_Data\Systemba
?????文件????3211264??2016-05-19?21:44??作業批改系統\App_Data\Systemba
?????文件???????2492??2016-05-13?17:01??作業批改系統\Code\App_Code\DB.cs
?????文件????????739??2016-05-13?09:01??作業批改系統\Code\App_Code\smart.cs
?????文件???????4266??2016-05-13?09:01??作業批改系統\Code\Edit\Admin_Add.aspx
?????文件???????1828??2016-05-13?14:01??作業批改系統\Code\Edit\Admin_Add.aspx.cs
?????文件???????8986??2016-05-13?17:01??作業批改系統\Code\Edit\Admin_Manage.aspx
?????文件???????3436??2016-05-13?11:01??作業批改系統\Code\Edit\Admin_Manage.aspx.cs
?????文件???????4048??2016-05-13?17:01??作業批改系統\Code\Edit\Admin_Update.aspx
?????文件???????2244??2016-05-13?17:01??作業批改系統\Code\Edit\Admin_Update.aspx.cs
?????文件????????733??2016-05-13?19:01??作業批改系統\Code\Edit\components\dtree\dtree.css
?????文件??????12377??2016-05-13?17:01??作業批改系統\Code\Edit\components\dtree\dtree.js
?????文件????????621??2016-05-13?14:01??作業批改系統\Code\Edit\components\dtree\img\ba
?????文件????????239??2016-05-13?11:01??作業批改系統\Code\Edit\components\dtree\img\cd.gif
?????文件?????????62??2016-05-13?18:01??作業批改系統\Code\Edit\components\dtree\img\empty.gif
?????文件????????372??2016-05-13?09:01??作業批改系統\Code\Edit\components\dtree\img\folder.gif
?????文件????????376??2016-05-13?14:01??作業批改系統\Code\Edit\components\dtree\img\folderopen.gif
?????文件???????1095??2016-05-13?17:01??作業批改系統\Code\Edit\components\dtree\img\globe.gif
?????文件????????622??2016-05-13?12:01??作業批改系統\Code\Edit\components\dtree\img\imgfolder.gif
?????文件?????????69??2016-05-13?11:01??作業批改系統\Code\Edit\components\dtree\img\join.gif
?????文件?????????66??2016-05-13?13:01??作業批改系統\Code\Edit\components\dtree\img\joinbottom.gif
?????文件?????????66??2016-05-13?16:01??作業批改系統\Code\Edit\components\dtree\img\line.gif
?????文件?????????86??2016-05-13?13:01??作業批改系統\Code\Edit\components\dtree\img\minus.gif
?????文件?????????85??2016-05-13?11:01??作業批改系統\Code\Edit\components\dtree\img\minusbottom.gif
?????文件????????633??2016-05-13?19:01??作業批改系統\Code\Edit\components\dtree\img\musicfolder.gif
?????文件????????861??2016-05-13?14:01??作業批改系統\Code\Edit\components\dtree\img\nolines_minus.gif
?????文件????????870??2016-05-13?18:01??作業批改系統\Code\Edit\components\dtree\img\nolines_plus.gif
?????文件????????582??2016-05-13?19:01??作業批改系統\Code\Edit\components\dtree\img\page.gif
?????文件?????????89??2016-05-13?10:01??作業批改系統\Code\Edit\components\dtree\img\plus.gif
?????文件?????????88??2016-05-13?18:01??作業批改系統\Code\Edit\components\dtree\img\plusbottom.gif
............此處省略969個文件信息
- 上一篇:文件對比軟件+文件分割
- 下一篇:北京工業大學 計算機組成原理課件
評論
共有 條評論