ASP.NET在线考试系统设计与实现
基于Ajax技术和JQuery技术的在线考试系统。该系统主要包括学生考试模块,学生讨论交流模块,学生信息管理模块,试卷管理模块,试题管理模块,成绩管理模块。主要完成了该系统的需求分析,系统设计和系统实现并对相关功能模块的功能效果进行有效的测试和详细的总结。在线考试系统的出现,极大的提高了考试的效率和质量,节省大量的人力物力财力,将考生从传统的考试方式解放出来,真正的做到无纸化考试。
目录
Windows10+ASP.NET+SQL Server2012+Vistual studio 2013
数据库设计部分如下:
CREATE TABLE [dbo].[SingleChoice](
[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[CourseID] [int] NOT NULL,
[Title] [varchar](1000) NOT NULL,
[A] [varchar](500) NOT NULL,
[B] [varchar](500) NOT NULL,
[C] [varchar](500) NOT NULL,
[D] [varchar](500) NOT NULL,
[Answer] [varchar](2) NOT NULL,
[AddTime] [datetime] NULL,
CONSTRAINT [PK_Choice_question] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
系统功能:
学生端:
用户登录,注册,注销
用户在线考试、查询成绩、在线交流等
教师端:
管理学生基本信息,上传试题,发布试卷,批改试卷,添加用户等
部分代码如下:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Label1.Text = Session["UserName"].ToString();
this.Label3.Text = "1";
dlBind();
}
}
public void dlBind()
{
int curpage = Convert.ToInt32(this.Label3.Text);
PagedDataSource ps = new PagedDataSource();
conn.Open();
string sqlstr = "select * from Gbook order by createtime desc";
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
da.Fill(ds, "gbook");
conn.Close();
ps.DataSource = ds.Tables["gbook"].DefaultView;
ps.AllowPaging = true; //是否可以分页
ps.PageSize = 5; //每页显示的记录数量
ps.CurrentPageIndex = curpage - 1; //取得当前页的页码
this.LinkButton1.Enabled = true;
this.LinkButton2.Enabled = true;
this.LinkButton3.Enabled = true;
this.LinkButton4.Enabled = true;
if (curpage == 1)
{
this.LinkButton1.Enabled = false;//不显示第一页按钮
this.LinkButton2.Enabled = false;//不显示上一页按钮
}
if (curpage == ps.PageCount)
{
this.LinkButton3.Enabled = false;//不显示下一页
this.LinkButton4.Enabled = false;//不显示最后一页
}
this.Label4.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField = "gbookid";
this.DataList1.DataBind();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
this.Label3.Text = "1";
this.dlBind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
this.Label3.Text = Convert.ToString(Convert.ToInt32(this.Label3.Text) - 1);
this.dlBind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
this.Label3.Text = Convert.ToString(Convert.ToInt32(this.Label3.Text) + 1);
this.dlBind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
this.Label3.Text = this.Label4.Text;
this.dlBind();
}
//触发Timer控件的Timer1_Tick事件实现考试倒计时功能
protected void Timer1_Tick(object sender, EventArgs e)
{
this.index--;
//考试时间到了
if (this.index == 0)
{
//设置Timer控件不可见
this.Timer1.Enabled = false;
BindData();
Response.Redirect("index.aspx");
}
else
{
//显示考试剩余时间
this.time.Text = this.index / 60 + "分" + this.index % 60 + "秒将停止考试,请及时“提交”试卷,否则试卷作费成绩无效!";
}
}
/// <summary>
/// 定义在线考试总时间变量index,
/// 并设置读写属性
/// </summary>
private int index
{
get
{
object o = ViewState["index "];
return (o == null) ? 3600 : (int)o;
}
set
{
ViewState["index "] = value;
}
}
运行界面