studentoperator.cs

学生信息管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// FindStudent 的摘要说明
/// </summary>
public class StudentOperator
{
    public StudentOperator()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}  
        
    public static bool FindStudent(string StuNum, string Stu_Pwd)
    {
        SqlConnection con = DB.CreateCon();
        con.Open(); 
        //数据库操作字符串
        SqlCommand cmd = new SqlCommand("select count(*) from StudentLogin where Stu_Num='" + StuNum + "'" + " and Stu_Pwd='" + Stu_Pwd + "'",con);
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        con.Close();
        if (count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }        
    }    
}