和

来源：互联网发布：威廉.菲德内尔知乎编辑：程序博客网时间：2024/04/27 02:39
string id = Request.QueryString["name"]; string website = Request.QueryString["website"]; 

SqlConnection conn; SqlCommand cmd; SqlDataReader rd; conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True"); conn.Open(); string sqlStr = @"SELECT * FROM [NetSchool].[dbo].[STUDENT] where USERNAME =" + "'" + name + "'" + "and PASSWORD =" + "'" + pass + "'"; cmd = new SqlCommand(sqlStr, conn); rd = cmd.ExecuteReader();

if (rd.HasRows) {                rd.Read();                Session["userName"] = rd["USERID"];                Response.Redirect("myhome.aspx");            }            else            {                Label1.Text = "请重新输入用户名和密码";            }            rd.Close();            conn.Close();
            if (Session["userName"] == null)            {                Response.Redirect("login.aspx");            }            else            {                Label1.Text = Session["userName"].ToString();                Label2.Text = System.DateTime.Now.ToString();            }
SqlConnection conn;                SqlCommand cmd;                SqlDataReader rd;                string name = Session["userName"].ToString();                conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True");                conn.Open();                string sqlStr = @"SELECT *                                FROM [NetSchool].[dbo].[STUDENT]                                where USERID =" + name;                cmd = new SqlCommand(sqlStr, conn);                rd = cmd.ExecuteReader();                if (rd.HasRows)                {                    Response.Write("<table>");                    Response.Write("<tr><td>编号</td><td>姓名</td><td>密码</td><td>性别</td><td>出生日期</td><td>注册时间</td><td>专业</td><td>备注</td></tr>");                    while (rd.Read())                    {                        Response.Write("<tr> <td>" + rd["USERID"] + "</td>" + "<td>" + rd["USERNAME"] + "</td>" + "<td>" + rd["PASSWORD"] + "</td>" + "<td>" + rd["SEX"] + "</td>" + "<td>" + rd["BIRTHDAY"] + "</td>" + "<td>" + rd["REGTIME"] + "</td>" + "<td>" + rd["SPECIALTY"] + "</td>" + "<td>" + rd["REMARK"] + "</td>" + "</tr>");                                        }                    Response.Write("</table>");                }                else                {                    Label1.Text = "请重新输入用户名和密码";                }                rd.Close();                conn.Close();

SqlConnection conn;SqlCommand cmd;SqlDataReader rd;string name = Session["userName"].ToString();conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True");conn.Open();string sqlStr = @"SELECT *FROM [NetSchool].[dbo].[STUDENT]where USERID =" + name;cmd = new SqlCommand(sqlStr, conn);rd = cmd.ExecuteReader();if (rd.HasRows){Response.Write("<table>");Response.Write("<tr><td>编号</td><td>姓名</td><td>密码</td><td>性别</td><td>出生日期</td><td>注册时间</td><td>专业</td><td>备注</td></tr>");while (rd.Read()){Response.Write("<tr> <td>" + rd["USERID"] + "</td>" + "<td>" + rd["USERNAME"] + "</td>" + "<td>" + rd["PASSWORD"] + "</td>" + "<td>" + rd["SEX"] + "</td>" + "<td>" + rd["BIRTHDAY"] + "</td>" + "<td>" + rd["REGTIME"] + "</td>" + "<td>" + rd["SPECIALTY"] + "</td>" + "<td>" + rd["REMARK"] + "</td>" + "</tr>");                    }    Response.Write("</table>");}else{Label1.Text = "请重新输入用户名和密码";}rd.Close();conn.Close();

string id = Request.QueryString["name"]; string website = Request.QueryString["website"];
阅读全文
0 0