學生管理系統實驗報告.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); 執(zhí)行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,