database.cs

问题定义 随着生活水平的日益提高

using System;
using System.Data.SqlClient;
using System.Data;
using Microsoft.Win32 ;
using System.Windows.Forms;
namespace 通讯录
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	public class Classdb
	{
		
			#region "测试数据库连接是否正确！"
		public bool con(string server,string database,string userid,string passwd)
		{
		string constr;
			constr="data source=" + server ;
			constr += ";initial catalog=" ;
			constr += database ;
			constr += ";user id=" ;
			constr += userid;
			constr += ";password=";
			constr +=passwd;
	    	SqlConnection sqlcon=new SqlConnection(constr);
			try
			{
				sqlcon.Open() ;
				return true;
			}
			catch
			{
				return false;
			}
			finally
			{
			sqlcon.Close();}
		}
		#endregion

	     	#region "连接数据库"
		public SqlConnection conds()
		{
			//从注册表中获取已注册服务器信息
			RegistryKey su1=Registry.CurrentUser;			
			RegistryKey su2=su1.OpenSubKey("software");
			RegistryKey su3=su2.OpenSubKey("csharp");
			RegistryKey su4=su3.OpenSubKey("dbconnection");
			RegistryKey su5=su4.OpenSubKey("db");
			SqlConnection sqlcon=new SqlConnection();
			try
			{
			string server=su5.GetValue("server").ToString();
			string database=su5.GetValue("database").ToString();
			string user=su5.GetValue("userid").ToString();
			string pwd=su5.GetValue("passwd").ToString();
			string constr;
			constr="data source=" + server ;
			constr += ";initial catalog=" ;
			constr += database ;
			constr += ";user id=" ;
			constr += user;
			constr += ";password=";
			constr +=pwd;
			sqlcon.ConnectionString=constr;
				sqlcon.Open();
				sqlcon.Close();
				return sqlcon;
			}
			catch 
			{
				MessageBox.Show("获取连接信息错误，如果没有注册数据库服务器，请注册\n否则，请确认注册信息是正确的!");
                    return null;
			}
			finally
			{
				sqlcon.Close();}
		}
		#endregion

	    	#region "判断用户登录是否成功"
		public int uservalid(string user,string passwd)
		{
			int i=0;
			string str="select * from account_user where userid='" + user;
			str=str + "' and passwd='";
			str=str + passwd;
			str=str + "'";
          SqlConnection usercon=conds();
			SqlDataReader dr;
	     SqlCommand usercom=new SqlCommand(str,usercon);
		 usercom.CommandType=CommandType.Text;
			try
			{
				usercon.Open();
		    	dr=usercom.ExecuteReader() ;
				while (dr.Read())
				{
				   i=Convert.ToInt16(dr["levels"].ToString());	
				}
				return i; //如果登录成功，返回1 ；
			}
			catch 
			{
				MessageBox.Show("错误，请检查数据库服务器注册信息是否正确，并确保用户名和密码正确！");
				return 0; //如果登录失败，返回0；
			}
		}
		#endregion

	}
}