分层

最新推荐文章于 2025-05-20 01:30:44 发布

weixin_30608503

最新推荐文章于 2025-05-20 01:30:44 发布

阅读量59

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/1234wwww/p/6661259.html

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using MySchoolModel;

namespace MySchoolDAL
{
public class Student
{

          public bool IsLogin(string name, string pwd)
          {
              bool flag = false;
              try
              {
                  string str = "data source=.; initial Catalog=MySchool; uid=sa;pwd=mnbv";
                  SqlConnection conn = new SqlConnection(str);
                  conn.Open();
                  string sql = "select count(1) from Admin where Name='"+name+"' and Pwd='"+pwd+"'";
                  SqlCommand cmd = new SqlCommand(sql,conn);
                  int num = Convert.ToInt32(cmd.ExecuteScalar());
                  if(num>0){
                      flag = true;
                  }
              }
              catch(Exception ex)
              {
                  Console.WriteLine(ex.Message);
              }
              return true;
          }

          public bool Add(string name,string pwd)
          {
              bool flag = false;
              try
              {

                  string str = "data source=.; initial Catalog=MySchool; uid=sa;pwd=mnbv";
                  SqlConnection conn = new SqlConnection(str);
                  conn.Open();
                  string sql = "insert into Student values('"+name+"','"+pwd+"')";
                  SqlCommand cmd = new SqlCommand(sql, conn);
                  int num = Convert.ToInt32(cmd.ExecuteScalar());
                  if (num > 0)
                  {

                  }
              }
              catch (Exception ex)
              {
                  Console.WriteLine(ex.Message);
              }
              return true;
          }
          public static List<Student> Const()
          {
              List<Student> list = new List<Student>();

              DataSet da = new DataSet();
              string sql = "select * from Student";
              SqlConnection conn = new SqlConnection(SqlHelper.ConStr);

              try
              {
                  conn.Open();

                  SqlCommand cmd = new SqlCommand(sql, conn);
                  SqlDataReader dr = cmd.ExecuteReader();
                  while (dr.Read())
                  {
                      Student st = new Student();

                      st.name = dr["name"].ToString();
                      st.pwd = dr["pwd"].ToString();


                      list.Add(st);
                  }
                  dr.Close();
                  return list;
              }
              catch (Exception ex)
              {
                  throw ex;
              }
              finally
              {
                  conn.Close();
              }

          }