addsubject.cs

一个简单的考生答题系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace Myschool
{
    class AddSubject
    {
        static SqlCommand comm = null;
        static string sql="";
        static int i = 0;
        /// <summary>
        /// 添加题目
        /// </summary>
        /// <param name="title"></param>
        /// <param name="AnswerA"></param>
        /// <param name="AnswerB"></param>
        /// <param name="AnswerC"></param>
        /// <param name="AnswerD"></param>
        /// <param name="suerA"></param>
        /// <param name="defl"></param>
        /// <param name="subject"></param>
        /// <returns></returns>
        public static bool AddSubjects(string title,string AnswerA,string AnswerB,string AnswerC,string AnswerD,string suerA,string defl,int subject) {
            
            try
            {
                
                comm = Connect.conn.CreateCommand();//建立关联
                Connect.conn.Open();//打开连接
                sql = string.Format("insert into question values('{0}','{1}',{2},{3},'{4}','{5}','{6}','{7}')", title, suerA, defl,subject,AnswerA, AnswerB, AnswerC, AnswerD);
                comm.CommandText = sql;
                 i = comm.ExecuteNonQuery();//执行命令
                 if (i > 0)
                 {
                     return true;
                 }
                 else {
                     return false;
                 }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally {
                Connect.conn.Close();
            }
            return false;
        }
        /// <summary>
        /// 添加学生信息
        /// </summary>
        /// <param name="loginid"></param>
        /// <param name="loginpwd"></param>
        /// <returns></returns>
        public static bool AddStudent(string loginid,string loginpwd) {
            try
            {
         
                comm = Connect.conn.CreateCommand();
                Connect.conn.Open();
                sql = string.Format("insert into sudent values('{0}','{1}')", loginid, loginpwd);
                comm.CommandText = sql;
                i = comm.ExecuteNonQuery();//执行命令
                if (i != 1)
                {
                    return false;
                }
                else {
                    return true;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally {
                Connect.conn.Close();
            }
            return false;
        }
        public static void Additem(System.Windows.Forms.ComboBox com) {
          
            try
            {

                comm = Connect.conn.CreateCommand();
                if (Connect.conn.State == ConnectionState.Closed)
                {//判断链接是否是关闭的
                    Connect.conn.Open();
                }
                sql = string.Format("select subname from subject");
                comm.CommandText = sql;
                SqlDataReader read = comm.ExecuteReader();
                while (read.Read()) {
                    com.Items.Add(read["subname"].ToString());
                }
                read.Close();
                
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            finally {
                if (Connect.conn.State==ConnectionState.Open)
                {//判断链接是否是打开的
                    Connect.conn.Close();
                }
            }
         
        }
    }
}