/*
@author:Xiangzi
@date:2009/12/31
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DormManage//数据库连接类
{
class DataCon
{
static string strCon = "Data Source=XIANGZI-PC//SQLEXPRESS;Initial Catalog=DormManage;Persist Security Info=True;User ID=xz;Password=comeon";//数据库连接串
SqlConnection conn = new SqlConnection(strCon);
public SqlDataReader query(string str)//查询
{
if (this.conn.State == System.Data.ConnectionState.Closed)//判断连接是否打开
{
this.conn.Open();
}
SqlCommand cmd = new SqlCommand(str, conn);
return cmd.ExecuteReader();
}
public int insert(string str)//插入,删除,更新 返回影响的行数
{
if (this.conn.State == System.Data.ConnectionState.Closed)
{
this.conn.Open();
}
SqlCommand cmd = new SqlCommand(str, conn);
return cmd.ExecuteNonQuery();
}
public int login(string str, string name, string pas)//此代码专用于登录,防止sql注入
{
conn.Open();
SqlCommand comm = new SqlCommand(str,conn);
comm.Parameters.Add(new SqlParameter("@loginame",SqlDbType.NVarChar, 20));
comm.Parameters["@loginame"].Value=name;
comm.Parameters.Add(new SqlParameter("@loginpassword", SqlDbType.NVarChar, 20));
comm.Parameters["@loginpassword"].Value=pas;
return (int)comm.ExecuteScalar();
}
public void close()//关闭连接
{
conn.Close();
}
}
}