基于OOP实现对象添加到数据库

最新推荐文章于 2021-02-06 01:39:27 发布

原创最新推荐文章于 2021-02-06 01:39:27 发布 · 224 阅读

1 ·

CC 4.0 BY-SA版权

C# .NET 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了如何使用面向对象编程(OOP)原则在数据库中添加对象实例，通过实例化学生对象并将其属性映射到数据库字段，展示了数据访问对象(DAO)模式的运用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

基于OOP实现对象添加到数据库

		 //初始化内容应该写在构造方法里面
        //定义一个数据层访问对象

        private StudentService objStudentService = new StudentService();

    //封装学员对象
            Student objStudent = new Student()
            {
                StudentName = this.txtStudentName.Text.Trim(),
                Gender =this.rdoFemale.Checked?"男":"女",
                Birthday = Convert.ToDateTime(this.dtpBirthday.Text),
                Age = DateTime.Now.Year - Convert.ToDateTime(this.dtpBirthday.Text).Year,
                ClassId = Convert.ToInt32(this.cboClassName.SelectedValue),
                StudentIdNo = this.txtStudentIdNo.Text.Trim(),
                CardNo = this.txtCardNo.Text.Trim(),
                PhoneNumber = this.txtPhoneNumber.Text.Trim(),
                StudentAddress = this.txtPhoneNumber.Text.Trim(),
                StuImage = this.pbStu.Image ==null?"":new SerializeObjectToString().SerializeObject(this.pbStu.Image),

            };

            //提交对象
            try
            {
                int result = objStudentService.AddStudent(objStudent);
                if (result == 1)
                {
                    DialogResult dresult = MessageBox.Show("添加成功，继续添加么", "添加询问", MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
                    if (dresult == DialogResult.OK)
                    {
                        //清空当前文本框
                        foreach (Control item in this.groupBox1.Controls)
                        {
                            if (item is TextBox)
                                item.Text = "";
                            else if (item is RadioButton)
                                ((RadioButton)item).Checked = false;
                            else if (item is ComboBox)
                                ((ComboBox)item).SelectedIndex = -1;
                        }
                        this.pbStu.Image = null;
                        this.txtStudentName.Focus();
                    }                        
                }
                else MessageBox.Show("添加失败", "添加提示");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            

            //判断是否保存成功
        }

 /// <summary>
        /// 添加学员对象
        /// </summary>
        /// <param name="objStudent"></param>
        /// <returns></returns>
        public int AddStudent(Student objStudent)
        {
            string sql = "insert into Students (StudentName,Gender,Birthday,Age,ClassId,StudentIdNo,CardNo,PhoneNumber,StudentAddress,StuImage) ";
            sql += "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')";
            sql = string.Format(sql, objStudent.StudentName,objStudent.Gender,objStudent.Birthday, objStudent.Age, 
                objStudent.ClassId, objStudent.StudentIdNo,objStudent.CardNo, objStudent.PhoneNumber, 
                objStudent.StudentAddress, objStudent.StuImage);
            try
            {
                return SQLHelper.Update(sql);
            }
            catch (Exception ex)
            {
                throw new Exception("保存数据出现问题！"+ex.Message);
            }
        }