图书馆管理系统之一----------登陆界面
开发环境vs2008,语言:.net 数据库:SQL2005
在数据库中创建user表,列为:userid,name,pass
登陆界面设计
login.aspx文件源码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="login.aspx.cs" Inherits="_Default" %>
login.aspx.cs文件源码
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void login_Click(object sender, EventArgs e)
{
bool isexist = false;
if (txtname.Text == string.Empty || txtpass.Text == string.Empty)
{
HttpContext.Current.Response.Write("");
HttpContext.Current.Response.End();
}
else
{
string username = this.txtname.Text;
string userpass = this.txtpass.Text;
string ss = DBHelper.Getscalar("select * from [user] where name='" + username + "'and pass='" + userpass + "'");
if(ss!="")
{
isexist = true;
}
if(isexist){
Response.Redirect("Default.aspx?id=0");
}else{
HttpContext.Current.Response.Write("");
HttpContext.Current.Response.End();
}
}
}
protected void cannel_Click(object sender, EventArgs e)
{
txtname.Text = txtpass.Text = string.Empty;
}
}
web.config文件源码
DBHelper文件源码
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
///
///DBHelper 的摘要说明
///
public class DBHelper
{
public static string connstring = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
public DBHelper()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
public static string Getscalar(string safeSql)
{
SqlConnection connection = new SqlConnection(connstring);
connection.Open();
SqlCommand cmd = new SqlCommand(safeSql, connection);
string resutl="";
if (cmd.ExecuteScalar() != null)
{
resutl = cmd.ExecuteScalar().ToString();
}
connection.Close();
connection.Dispose();
return resutl;
}
}
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！