学生管理系统实验报告.docx

ADO.NET实现数据库基本操作一、实验目的1.掌握ADO.net数据库连接方式。2.掌握ADO.net数据库的增、删、改、查的基操作。3 掌握ADO.net检索和存储Blob等大的二进制数据。二、实验内容建立一个简单的学生信息管理程序，能够增加、删除、修改，查找学生的基本信息，在其中加入照片信息管理。三 程序界面 登录界面：主界面：增加用户界面：四：实验部分代码 登录代码： private void btnLogin_Click(object sender, EventArgs e) string constr = ConfigurationManager.ConnectionStringssql.ConnectionString; string sql = select count(*) from Login where UserName=UserName and UserPassword=UserPassword; SqlParameter pms = new SqlParameter new SqlParameter(UserName, txtUserName.Text.Trim(), new SqlParameter(UserPassword,txtUserPassword.Text) ; int obj= Convert.ToInt32( SqlHelper.ExecuteScalar(sql,pms); if (obj=1) stuInfo stu = new stuInfo(); stu.ShowDialog(); else MessageBox.Show(登?录?失败。,警告?, MessageBoxButtons.OK, MessageBoxIcon.Warning); 执行sql语句的类代码： public static class SqlHelper private static readonly string constr = ConfigurationManager.ConnectionStringssql.ConnectionString; public static int ExecuteNonquery(string sql, params SqlParameter pms) using (SqlConnection sqlcon = new SqlConnection(constr) using (SqlCommand sqlcmd = new SqlCommand(sql, sqlcon) sqlcon.Open(); if (pms != null) sqlcmd.Parameters.AddRange(pms); return sqlcmd.ExecuteNonQuery(); public static Object ExecuteScalar(string sql, params SqlParameter pms) using (SqlConnection sqlcon = new SqlConnection(constr) using (SqlCommand sqlcmd = new SqlCommand(sql, sqlcon) sqlcon.Open(); if (pms != null) sqlcmd.Parameters.AddRange(pms); return sqlcmd.ExecuteScalar(); public static SqlDataReader ExecuteReader(string sql, params SqlParameter pms) SqlConnection sqlcon = new SqlConnection(constr); using (SqlCommand sqlcmd = new SqlCommand(sql, sqlcon) sqlcon.Open(); if (pms != null) sqlcmd.Parameters.AddRange(pms); return sqlcmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); public static DataTable ExecuteSqlDataTable(string sql, params SqlParameter pms) using (SqlConnection sqlcon = new SqlConnection(constr) SqlDataAdapter adapter = new SqlDataAdapter(sql, sqlcon); if (pms != null) adapter.SelectCommand.Parameters.AddRange(pms); DataTable table = new DataTable(); adapter.Fill(table); return table; 增加用户的代码： private void btnInsert_Click(object sender, EventArgs e) string constr = ConfigurationManager.ConnectionStringssql.ConnectionString; string sql1 = select count(*) from 学生信?息 where 学号?=UserId; string sex=男D; if (rbnnan.Checked) sex=男D; else sex=女?; birthTime= BirthTimes(); string sql = insert into 学生信?息 values (userId,UserName,UserGender,UserBirthdate,UserNational,UserClass,UserAddress); SqlParameter pms = new SqlParameter new SqlParameter(userId, txtId.Text.Trim(), new SqlParameter(UserName,txtName.Text.Trim(), new SqlParameter(UserGender,sex), new SqlParameter(UserBirthdate, birthTime), new SqlParameter(UserNational,txtNational.Text.Trim(), new SqlParameter(UserClass,txtClass.Text.Trim(),new SqlParameter(UserAddress,txtAddress.Text.Trim(); SqlParameter pms1 = new SqlParameter new SqlParameter(userId, txtId.Text.Trim() ; int n = Convert.ToInt32(SqlHelper.ExecuteScalar(sql1, pms1); if (n != 1) SqlHelper.ExecuteNonquery(sql, pms); MessageBox.Show(新?学生信?息插?入?成功|。); else MessageBox.Show(该?学生号?已?被?占?用?，?信?息插?入?失败。); 修改学生信息的代码： private void btnUpdate_Click(object sender, EventArgs e) string constr = ConfigurationManager.ConnectionStringssql.ConnectionString; string sql1 = select count(*) from 学生信?息 where 学号?=UserId1; string sex = 男D; if (rbnnan.Checked) sex = 男D; else sex = 女?; birthTime = 2000-10-10; birthTime = BirthTimes(); string sql = update 学生信?息 set 姓?名?=UserName,性?别e=UserGender,出?生日?期=UserBirthdate,民?族?=UserNational,所属?班级?=UserClass,家庭住?址=UserAddress where 学号?=userId; SqlParameter pms = new SqlParameter new SqlParameter(userId, txtId.Text.Trim(), new SqlParameter(UserName,txtName.Text.Trim(), new SqlParameter(UserGender, sex ), new SqlParameter(UserBirthdate, birthTime), new SqlParameter(UserNational,txtNational.Text.Trim(), new SqlParameter(UserClass,txtClass.Text.Trim(),new SqlParameter(UserAddress,txtAddress.Text.Trim(); SqlParameter pms1 = new SqlParameter new SqlParameter(userId1, txtId.Text.Trim() ; int n = Convert.ToInt32(SqlHelper.ExecuteScalar(sql1,