using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Text;
using?System.Data.SqlClient;
using?System.Configuration;

namespace?DBConn
{
????public?class?Class1
????{
????????private?String?conn;

????????public?Class1（String?conn）
????????{
????????????this.conn?=?conn;
????????}

????????private?SqlConnection?getConn（）
????????{
????????????SqlConnection?connection?=?new?SqlConnection（this.conn）;
????????????return?connection;
????????}

????????public?Boolean?loginValidate（String?username?String?password）
????????{
????????????String?inputUsername?=?username;
????????????String?inputPassword?=?password;

????????????SqlConnection?connection?=?getConn（）;
????????????connection.Open（）;
????????????SqlCommand?command?=?new?SqlCommand（“select?*?from?userinfo“?connection）;
????????????SqlDataReader?reader?=?command.ExecuteReader（）;

????????????while?（reader.Read（））
????????????{
????????????????String?getUsername?=?reader.GetString（0）;
????????????????String?getPassword?=?reader.GetString（1）;
????????????????if?（inputUsername.Equals（getUsername）?&&?inputPassword.Equals（getPassword））
????????????????{
????????????????????return?true;
????????????????}
????????????????else
????????????????{???
????????????????}
????????????}
????????????connection.Close（）;
????????????return?false;
????????}

????????public?Boolean?isRegisted（String?getUserId）
????????{
????????????SqlConnection?connection?=?getConn（）;
????????????connection.Open（）;
????????????String?temp?=?null;
????????????SqlCommand?cmd?=?connection.CreateCommand（）;
????????????cmd.CommandText?=?“select?name?from?student?where?id?=?‘“?+?getUserId?+?“‘“;
????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????????if?（reader.Read（））
????????????{
????????????????temp?=?reader[0].ToString（）;
????????????}
????????????connection.Close（）;
????????????if?（temp?==?null）
????????????{
????????????????return?false;
????????????}
????????????else
????????????{
????????????????return?true;
????????????}
????????}

????????public?void?regist（String?id?String?name?String?password?String?sex?String?age?String?college?String?tel?String?email?String?qq?String?picture?String?intro）
????????{
????????????SqlConnection?connection?=?getConn（）;
????????????connection.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????cmd.Connection?=?connection;
????????????cmd.CommandText?=?“insert?into?student?values（‘“?+?id?+?“‘‘“?+?name?+?“‘‘“?+?password?+?“‘‘“?+?sex?+?“‘“?+?age?+?“‘“?+?college?+?“‘‘“?+?tel?+?“‘‘“?+?email?+?“‘‘“?+?qq?+?“‘‘“?+?picture?+?“‘‘“?+?intro?+?“‘）“;
????????????cmd.ExecuteNonQuery（）;
????????????connection.Close（）;
????????}

????????public?void?alterInfo（String?getUserId?String?name?String?sex?String?age?String?college?String?tel?String?email?String?qq?String?picture?String?intro）
????????{
????????????SqlConne

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????6525??2010-06-18?09:49??網站\WebSite2\App_Code\MakeThum.cs

?????文件???10485760??2010-06-10?21:51??網站\WebSite2\App_Data\ASPNETDB.MDF

?????文件?????516096??2010-06-10?21:51??網站\WebSite2\App_Data\aspnetdb_log.ldf

?????文件??????24576??2010-06-18?19:54??網站\WebSite2\Bin\DBConn.dll

?????文件??????26112??2010-06-18?19:54??網站\WebSite2\Bin\DBConn.pdb

?????文件???????1045??2010-06-18?11:50??網站\WebSite2\CSS\Twitter_Navi_link.css

?????文件????????438??2010-06-17?19:19??網站\WebSite2\Default.aspx

?????文件????????616??2010-06-18?18:01??網站\WebSite2\Default.aspx.cs

?????文件???????6116??2010-06-18?01:18??網站\WebSite2\Editor.aspx

?????文件???????5365??2010-06-18?10:21??網站\WebSite2\Editor.aspx.cs

?????文件???????2109??2010-06-18?18:27??網站\WebSite2\Friends.aspx

?????文件???????2551??2010-06-18?19:16??網站\WebSite2\Friends.aspx.cs

?????文件???????8201??2010-06-10?18:01??網站\WebSite2\Images\bg-clouds.png

?????文件???????6656??2010-06-13?11:55??網站\WebSite2\Images\twitter_logo_header.png

?????文件????????651??2010-06-18?18:34??網站\WebSite2\Login.aspx

?????文件????????406??2010-06-09?15:17??網站\WebSite2\Login.aspx.cs

?????文件???????1662??2010-06-17?22:11??網站\WebSite2\LoginControl.ascx

?????文件???????2185??2010-06-15?00:00??網站\WebSite2\LoginControl.ascx.cs

?????文件???????9122??2010-06-18?18:27??網站\WebSite2\Main.aspx

?????文件???????7101??2010-06-18?18:02??網站\WebSite2\Main.aspx.cs

?????文件???????4308??2010-06-18?18:27??網站\WebSite2\MyPage.aspx

?????文件???????7513??2010-06-18?09:22??網站\WebSite2\MyPage.aspx.cs

?????文件???????2253??2010-06-18?01:16??網站\WebSite2\ProfileEditor.aspx

?????文件???????3542??2010-06-18?09:23??網站\WebSite2\ProfileEditor.aspx.cs

?????文件???????3193??2010-06-18?18:22??網站\WebSite2\Regist.aspx

?????文件???????1391??2010-06-18?18:21??網站\WebSite2\Regist.aspx.cs

?????文件????????483??2010-06-18?11:57??網站\WebSite2\ShowOrigPic.aspx

?????文件???????1964??2010-06-18?11:47??網站\WebSite2\ShowOrigPic.aspx.cs

?????文件???????2121??2010-06-18?01:07??網站\WebSite2\ShowSearchRes.aspx

?????文件???????3431??2010-06-18?01:29??網站\WebSite2\ShowSearchRes.aspx.cs

............此處省略54個文件信息