div弹出层的ajax登录(Jquery版+c#)

这次主要的分享就是div+css+jquery，你可以改版成你要的登录，随意改版！后台代码由于时间限制，没有完成，里面有些乱，重点分享界面，还望理解

页面初始化，界面如图所示：

Server name文本框获取焦点时候，界面如图所示（这里可以改成你登录的验证码）：

可以加载SQL Server服务列表，也是我的简易SQL查询分析器评论中静夜妙思给予的方法，非常感谢！

加载列表如下图所示：

可以随意地点击添加到Server name中，登录时截图所示：

文本框验证都写好了！还有Authentication验证方式，windows验证下面Login,Password文本框禁掉！由于时间原因，不上图了

demo.html(全部前台代码，js/css还没分文件存储)

复制代码代码如下:

DataBase Test Demo

SQL Server
- DataBases
  - Test

Handler.ashx

复制代码代码如下:

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Collections.Generic;
using System.Text;
using System.Web.SessionState;

public class Handler : IHttpHandler,IRequiresSessionState {

public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
string tempValue = string.Empty;
if (context.Request["flag"] == null)
context.Response.Write("error");
else
{
string flag = context.Request["flag"];
switch (flag)
{
case "server":
tempValue = this.GetServers();
break;
case "islogin":
tempValue = (context.Session["login"] != null).ToString();//判断是否登录到SQL
break;
case "login":
tempValue = IsLogin(context);
break;
default:
tempValue = "error";
break;
}
}
context.Response.Write(tempValue);
}

///

/// 加载SQL Server 服务列表
///

///
private string GetServers()
{
IList list = Common.GetServers();
if (list == null || list.Count == 0) return "empty";
StringBuilder sb = new StringBuilder();
foreach (string s in list)
{
sb.AppendFormat("

{0}

", s);
}
return sb.ToString();
}

///

/// 登录SQL Server
///

///
///
private string IsLogin(HttpContext context)
{
if (context.Request["user"] == null || context.Request["password"] == null)
{
context.Session["login"] = "success";
return "";
}
else
{
string server = HttpUtility.UrlDecode(context.Request["sqlServer"]);
string user = HttpUtility.UrlDecode(context.Request["user"]);
string password = HttpUtility.UrlDecode(context.Request["password"]);
string sqlConstring;
if (Common.IsLogin(server, user, password, out sqlConstring))
{
context.Session["login"] = sqlConstring;
return "True";
}
else
{
return "False";
}
}
}

public bool IsReusable {
get {
return false;
}
}
}

Common.cs

复制代码代码如下:

 
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Data.Sql; 
using System.Data.SqlClient; 
using System.Data; 

///  
/// Summary description for Common 
/// 
public class Common 
{ 
public Common() 
{ 
// 
// TODO: Add constructor logic here 
// 
} 

///  
/// 加载SQL服务列表 
/// 
/// 
public static IList GetServers() 
{ 
IList list = new List(); 
SqlDataSourceEnumerator sse = SqlClientFactory.Instance.CreateDataSourceEnumerator() as SqlDataSourceEnumerator; 
if (sse == null) return null; 
DataTable dt = sse.GetDataSources(); 
foreach (DataRow dr in dt.Rows) 
{ 
string server = dr["ServerName"] as string; 
string instance = dr["InstanceName"] as string; 
if (string.IsNullOrEmpty(instance) || instance.ToUpper() == "MSSQLSERVER") 
list.Add(server); 
else 
list.Add(server + @"\" + instance); 
} 
return list; 
} 

///  
/// SQL Server Authentication 
/// 
/// SQL服务
/// 用户名
/// 密码
/// 数据库连接字符串
/// 
public static bool IsLogin(string server,string user,string password,out string sqlConstring) 
{ 
sqlConstring = string.Format("Data Source={0};Initial Catalog=master;Persist Security Info=True;User ID={1};Password={2}", server, user, password); 
return SQLHelper.LoginSQL(sqlConstring); 
} 
} 

SQLHelper.cs

复制代码代码如下:

 
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Data; 
using System.Data.SqlClient; 

///  
/// Summary description for SQLHelper 
/// 
public class SQLHelper 
{ 
public SQLHelper() 
{ 
// 
// TODO: Add constructor logic here 
// 
} 


///  
/// 判断是否登录SQL Server 
/// 
/// 
/// 
public static bool LoginSQL(string sqlConstring) 
{ 
bool isLogin = false; 
using(SqlConnection conn = new SqlConnection(sqlConstring)) 
{ 
conn.Open(); 
if (conn.State.ToString().ToLower() == "open") 
isLogin = true; 
return isLogin; 
} 
} 
} 