| 发表于：2007-01-25 11:37:08 楼主 |
文件index_.aspx.cs
using system;
using system.collections;
using system.componentmodel;
using system.data;
using system.drawing;
using system.web;
using system.web.sessionstate;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.htmlcontrols;
using system.web.security;
namespace website3
{
public partial class user_loginx : system.web.ui.page
{
public int ii;
private void page_load（object sender, system.eventargs e)
{
if （session[ "username "] == null)
{
response.redirect（ "index_.aspx ");
}
else
{
response.redirect（ "index.aspx ");
}
}
public void submit_click（object sender, eventargs e)
{
sitedb sitedb = new sitedb（);
string sqlselect = "select * from user where user_name= ' " + username.text + " ' and password= ' " + user_password + " ' ";
if （sitedb.username_select（sqlselect) > 0)
{
session[ "username "] = username.text;
}
else
{
response.write（ " <script> alert（ '用户名或密码错误 '); </script> ");
response.write（ " <script> history.go（-1); </script> ");
}
}
}
}
文件sitedb.cs
using system;
using system.web;
using system.data;
using system.data.oledb;
namespace website3
{
public class sitedb
{
public int v3, ii, i;
public int startindex = 0;
public int username_select（string sqlselect)
{
string dbpath = system.configuration.configurationsettings.appsettings[ "dbpath "];
string acconnstr = "provider=microsoft.jet.oledb.4.0;data source= " + httpcontext.current.server.mappath（dbpath);
oledbconnection acconn = new oledbconnection（acconnstr);
acconn.open（);
oledbcommand accomm = new oledbcommand（sqlselect, acconn);
oledbdatareader acdr = accomm.ＥＸＥＣutereader（);
if （acdr.read（))
{
v3 = convert.toint32（acdr[3].tostring（));
}
acdr.close（);
acconn.close（);
return v3;
}
public int ibm_sql（string sqlselect)
{
string dbpath = system.configuration.configurationsettings.appsettings[ "dbpath "];
string acconnstr = "provider=microsoft.jet.oledb.4.0;data source= " + httpcontext.current.server.mappath（dbpath);
oledbconnection acconn = new oledbconnection（acconnstr);
acconn.open（);
oledbcommand accomm = new oledbcommand（sqlselect, acconn);
ii = accomm.ＥＸＥＣutenonquery（);
acconn.close（);
return ii;
}
public datatable ibm_sqldataadapter（string sqlselect)
{
//取得web.config中定义的数据库连接字符串
string dbpath = system.configuration.configurationsettings.appsettings[ "dbpath "];
//定义数据库连接字符串
string acconnstr = "provider=microsoft.jet.oledb.4.0;data source= " + httpcontext.current.server.mappath（dbpath);
//创建数据库连接对象
oledbconnection acconn = new oledbconnection（acconnstr);
//创建dataadapter对像
oledbdataadapter acda = new oledbdataadapter（sqlselect, acconn);
//创建数据集
dataset ds = new dataset（);
//填充数据集
acda.fill（ds, "defaulttable ");
return ds.tables[ "defaulttable "];
}
public dataset ibm_dataset（string sqlselect)
{
//取得web.config中定义的数据库连接字符串
string dbpath = system.configuration.configurationsettings.appsettings[ "dbpath "];
//定义数据库连接字符串
string acconnstr = "provider=microsoft.jet.oledb.4.0;data source= " + httpcontext.current.server.mappath（dbpath);
//创建数据库连接对象
oledbconnection acconn = new oledbconnection（acconnstr);
//创建dataadapter对像
oledbdataadapter acda = new oledbdataadapter（sqlselect, acconn);
//创建数据集
dataset acds = new dataset（);
//填充数据集
return acds;
}
public int aＥＸＥＣutereader（string sqlselect)
{
//取得web.config中定义的数据库连接字符串
string dbpath = system.configuration.configurationsettings.appsettings[ "dbpath "];
//定义数据库连接字符串
string acconnstr = "provider=microsoft.jet.oledb.4.0;data source= " + httpcontext.current.server.mappath（dbpath);
//创建数据库连接对象
oledbconnection acconn = new oledbconnection（acconnstr);
//打开数据库
acconn.open（);
//创建command对象
oledbcommand accomm = new oledbcommand（sqlselect, acconn);
//实例化datareader对象
oledbdatareader acdr = accomm.ＥＸＥＣutereader（);
if （acdr.read（))
{
i = convert.toint32（acdr[0].tostring（));
}
acdr.close（);
//关闭数据库
acconn.close（);
return i;
}
}
}
谢谢各位了
|
|
|
|
|
