009.2021-09-03 自定义方法类，实体类，分离客户端与数据库代码

/program.CS

using System;
using System.Data;
using System.Data.SqlClient;
namespace entityclass
{
    class Program
    {
        static void Main(string[] args)
        {
            //string connectionString = "server=.;database=mydatabase082;uid=sa;pwd=886566";
            //SqlConnection conn = new SqlConnection(connectionString);
            //string sql = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            //sql = string.Format(sql, "liuqiangdong", "m", "1999-07-02", 121222, 99, 546456, "tianjinshi",8);
            //conn.Open();
            //SqlCommand comm = new SqlCommand();
            //comm.CommandText = sql;
            //comm.Connection = conn;

            //int result =comm.ExecuteNonQuery();
            //conn.Close();

            //Console.WriteLine("=======================")
            //    ;
            //Console.WriteLine("insert sucessfully "+result+"row");

            //studentname ,gender,birthday,studentidnumber,age,phonenumber,studentaddress,classid
            ///
            ///

            //string sqlsentence = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            //sqlsentence = string.Format(sqlsentence, "liuqiangdong2", "m", "1989-07-02", 121222, 99, 546456, "tianjinshi", 2);
            //SQLHelper.InsertIntoDatabase(sqlsentence);
            //string sqlsentence = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            //
            ///
            //
           
           
            ///
            //Console.WriteLine("please input stuname");
            //string studentname = Console.ReadLine();
            //Console.WriteLine("please input gender");
            //string gender = Console.ReadLine();
            //Console.WriteLine("please input birthday");
            //DateTime birthday = Convert.ToDateTime(  Console.ReadLine());
            //Console.WriteLine("please input studentidnumber");
            //decimal studentidnumber = Convert.ToDecimal(  Console.ReadLine());
            //Console.WriteLine("please input age");
            //int age =Convert.ToInt32(  Console.ReadLine());
            //Console.WriteLine("please input phonenumber");
            //string phonenumber = Console.ReadLine();
            //Console.WriteLine("please input studentaddress");
            //string studentaddress = Console.ReadLine();
            //Console.WriteLine("please input classid");
            //int classid =Convert.ToInt32(Console.ReadLine());

            //string sqlsentence = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            //sqlsentence = string.Format(sqlsentence, studentname, gender, birthday, studentidnumber, age, phonenumber, studentaddress, classid);
            //SQLHelper.InsertIntoDatabase(sqlsentence);

            StudentServiceEntity objsse = new StudentServiceEntity();

            Console.WriteLine("please input stuname");
            objsse. studentname = Console.ReadLine();
            Console.WriteLine("please input gender");
            objsse. gender = Console.ReadLine();
            Console.WriteLine("please input birthday");
            objsse. birthday = Convert.ToDateTime(Console.ReadLine());
            Console.WriteLine("please input studentidnumber");
            objsse.studentidnumber = (Console.ReadLine());
            Console.WriteLine("please input age");
            objsse.age = Convert.ToInt32(Console.ReadLine());
            Console.WriteLine("please input phonenumber");
            objsse.phonenumber =Convert.ToInt32( Console.ReadLine());
            Console.WriteLine("please input studentaddress");
            objsse.studentaddress = Console.ReadLine();
            Console.WriteLine("please input classid");
            objsse.classid = Convert.ToInt32(Console.ReadLine());

            StudentEntityMethod objsem = new StudentEntityMethod();
            string sqlsentence =objsem.WriteSQLSentence(objsse);

            SQLHelper.InsertIntoDatabase(sqlsentence);

        }
    }
}
 

//SQLHelper。cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace entityclass
{
    class SQLHelper
    {
        public static int InsertIntoDatabase(string sqlscript)
        {
            string connectionString = "server=.;database=mydatabase082;uid=sa;pwd=886566";
            SqlConnection conn = new SqlConnection(connectionString);
             //sqlscript = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
           // sql = string.Format(sql, "liuqiangdong", "m", "1999-07-02", 121222, 99, 546456, "tianjinshi", 8);
            conn.Open();
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlscript;
            comm.Connection = conn;

            int result = comm.ExecuteNonQuery();
            conn.Close();
            return result;
        }

    }
}
/studententitymethod TO GET SQL SENC=TENCE

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace entityclass
{
    class StudentEntityMethod
    {
        //studentname ,gender,birthday,studentidnumber,age,phonenumber,studentaddress,classid
        public string WriteSQLSentence(StudentServiceEntity sse)
        {
            string sqlsentence = "insert into student values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')";
            sqlsentence = string.Format(sqlsentence, sse.studentname,sse.gender,sse.birthday,sse.studentidnumber,sse.phonenumber,sse.studentidnumber,sse.studentaddress,    sse.classid);
            return sqlsentence;

        }
    }
}

//STUDENTSERVICEENTITY TO GET AN OBJECT TO PACKAGE '

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace entityclass
{
    class StudentServiceEntity
    {
        //studentname ,gender,birthday,studentidnumber,age,phonenumber,studentaddress,classid

        public string    studentname {   get; set; }
        public string gender { get; set; }
        public DateTime birthday { get; set; }
        public string studentidnumber { get; set; }
        public int age { get; set; }
        public int phonenumber { get; set; }
        public string studentaddress { get; set; }
        public int classid { get; set; }
    }
}