//修改 public int ModifyStudent(student objStudent) { //编写sql语句 StringBuilder sqlB = new StringBuilder(); sqlB.Append("update students set studentName='{0}',Gender='{1}',Birthday='{2}',"); sqlB.Append("studentIdNo='{3}',PhoneNumber='{4}',studentAddress='{5}',classId={6} "); sqlB.Append(" where studentId={7}"); //解析对象 string sql = string.Format(sqlB.ToString(), objStudent.StudentName, objStudent.Gender, objStudent.Birthday, objStudent.StudentIdNo, objStudent.PhoneNumber, objStudent.StudentAddress, objStudent.ClassId, objStudent.StudentId); try { return(Convert.ToInt32(MysqlHelper.Update(sql))); } catch (MySqlException ex) { throw new Exception("数据库操作异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
//删除 public int DeleteStudent(string studentId) { String sql = "delete from students where studentId='{0}'"; sql = string.Format(sql, studentId); try { return(Convert.ToInt32(MysqlHelper.Update(sql))); } catch (MySqlException ex) { throw new Exception("数据库操作异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
//添加 public int AddStudent(student objStudent) { //编写语句 StringBuilder sqlB = new StringBuilder(); sqlB.Append("INSERT INTO students(StudentId, StudentName, Gender, Birthday, StudentIdNo, Age,PhoneNumber,StudentAddress,CardNo,ClassId) VALUES"); sqlB.Append("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')"); string sql = string.Format(sqlB.ToString(), objStudent.StudentId, objStudent.StudentName, objStudent.Gender, objStudent.Birthday, objStudent.StudentIdNo, objStudent.Age, objStudent.PhoneNumber, objStudent.StudentAddress, objStudent.CardNo, objStudent.ClassId); try { return(Convert.ToInt32(MysqlHelper.Update(sql))); } catch (MySqlException ex) { throw new Exception("数据库操作异常:" + ex.Message); } catch (Exception ex) { throw ex; } }