分层
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();
}
}
public string name { get; set; }
public string pwd { get; set; }
}
}