用C#简单实现了数据的封装

/*

*说明：一共四个.cs文件。DBHelp类实现了连接数据库，StudentDao类实现了数据的逻辑上的处理，student为实体类， Program测试类

*时间：2013.11.4

*作者：Mr.Smart

*/

using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System .Text;

namespace Demo
{
    /// <summary>
    /// Description of DBHElp.
    /// </summary>
    public class DBHElp
    {
        public DBHElp()
        {
        }
        
        //返回一个数据库连接
        public static SqlConnection sqlcon(string database)
        {
            string conText = string.Format(@"server = .; database ={0};Integrated Security= sspi",database);
            return new SqlConnection (conText);
        }
    }
}

namespace Demo
{
    /// <summary>
    /// Description of StudentDao.
    /// </summary>
    public class StudentDao
    {
        public StudentDao()
        {
        }
        public void AddToDatabase(Student stu)
        {
            SqlConnection sc = DBHElp.sqlcon("db_stu");
            string cmdText = "insert into student(Names,Sex,Age) values(@names,@sex,@age)";
            SqlCommand cmd = new SqlCommand(cmdText,sc);
            cmd.Parameters.Add("@names",SqlDbType.VarChar).Value = stu.stuName;
            cmd.Parameters.Add("@sex",SqlDbType.VarChar).Value = stu.stuSex;
            cmd.Parameters.Add("@age",SqlDbType.Int).Value=stu.stuAge;
            try
            {
                sc.Open();
                int i = cmd.ExecuteNonQuery();
                if(i>0)
                {
                    Console.WriteLine("insert success !");
                }
                else
                {
                    Console.WriteLine("insert failed!");
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine("ERROR :"+ex.Message);
            }
            finally
            {
                if(sc.State== ConnectionState.Open)
                {
                    sc.Close();
                }
            }
        }
        
    }
}

using System;
using System.Text;
using System.Collections;
using System.Collections.Generic;

namespace Demo
{
    /// <summary>
    /// Description of Student.
    /// </summary>
    public class Student
    {
        //对象初始化构造器
        public string stuName{get;set;}
        public string stuSex{get;set;}
        public int stuAge{get;set;}
        
        public Student()
        {
            
        }
        
        public Student(string stuName,string stuSex,int stuAge){
            this.stuName = stuName;
            this.stuSex = stuSex;
            this.stuAge = stuAge;
        }
        
    }
}

namespace Demo
{
    class Program
    {
        public static void Main(string[] args)
        {
            Student stu = new Student("蜡笔小新","男",10);
            StudentDao stuDao = new StudentDao();
            stuDao.AddToDatabase(stu);
            Console.ReadKey();
        }
    }
}