program.cs

it is beautiful was lit

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

namespace Console
{
    class Program
    {
        static void Main(string[] args)
        {
            string connStr = "Data Source=LENOVOLISHAN;Initial Catalog=ChooseCourse;User ID=sa;Password=oneday";

            Student aStudent = new Student(connStr);

            /// 查询
            string name = System.Console.ReadLine();

            ICollection<ArrayList> list = aStudent.GetDataByName(name);

            foreach (ArrayList fields in list)
            {
                foreach (object fieldValue in fields)
                {
                    System.Console.Write(fieldValue);
                    System.Console.Write("  ");
                }
                System.Console.WriteLine();
            }

            /// 添加
            string inStudentID = System.Console.ReadLine();
            string inStudentName = System.Console.ReadLine();

            if (!inStudentID.Equals("-1"))
            {
                aStudent.Insert(inStudentID, inStudentName);
            }

            /// 查询
            Teacher aTeacher = new Teacher(connStr);

            name = System.Console.ReadLine();

            System.Data.DataTable aTable = aTeacher.GetDataByName(name);

            foreach (System.Data.DataRow aRow in aTable.Rows)
            {
                System.Console.WriteLine("{0},{1},{2}",
                    aRow[Teacher.TeacherIDColumnName],
                    aRow[Teacher.NameColumnName],
                    aRow[Teacher.DepartmentIDColumnName]);
            }

            /// 添加
            string inTeacherID = System.Console.ReadLine();
            string inTeacherName = System.Console.ReadLine();
            string inDepartmentID = System.Console.ReadLine();

            aTeacher.Insert(inTeacherID, inTeacherName, inDepartmentID);
        }
    }
}