📄 default.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Security.Cryptography;
using System.Text;
using System.Data.SqlClient;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
//检测用户名是否存在
public int CheckUser()
{
SqlConnection sqlconn = new SqlConnection("server=(local);uid=sa;pwd=;database=db_08");
int intCount = 0;
if (txtLoginName.Text == "")
{
Response.Write("<script language='javascript'>alert('会员登录名不能为空!');</script>");
return intCount = 2;
}
else
{
string sqlstr = "select * from tb_02 where Name='" + this.txtLoginName.Text + "'";
sqlconn.Open();
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
intCount = Convert.ToInt32(sqlcom.ExecuteScalar());
sqlconn.Close();
}
return intCount;
}
//检测用户名
protected void btnTest_Click(object sender, EventArgs e)
{
int intCount = CheckUser();//调用方法检测用户名是否存在
if (intCount == 2)
{ return; }
if (intCount != 0)
{
Response.Write("<script language='javascript'>alert('该会员已经注册过');</script>");
return;
}
else
{
Response.Write("<script language='javascript'>alert('您可以进行正常注册');</script>");
}
}
//加密字符串
public string Encrypting(string strSource)
{
try
{
//把字符串放到byte数组中
byte[] bytIn = System.Text.Encoding.Default.GetBytes(strSource);
//建立加密对象的密钥和偏移量对TripleDES,采取24字节或192位的密钥和初始向量
byte[] key ={ 42, 16, 93, 156, 78, 4, 218, 32, 15, 167, 44, 80, 26, 20, 155, 112, 2, 94, 11, 204, 119, 35, 184, 197 };
byte[] IV ={ 55, 103, 246, 79, 36, 99, 167, 3 };
// ,42,5,62,83,184,7,209,13};
// ,145,23,200,58,173,10,121,22};
//,123,2,1,25,35,24,26,35,35,123,214,125,128,129,32,219,159,168,147,158,169};
//实例 TripleDESCryptoServiceProvider类将字符串写入流中
TripleDESCryptoServiceProvider TripleDES = new TripleDESCryptoServiceProvider();
TripleDES.IV = IV;
TripleDES.Key = key;
//加密符串
ICryptoTransform encrypto = TripleDES.CreateEncryptor();
System.IO.MemoryStream ms = new System.IO.MemoryStream();
CryptoStream cs = new CryptoStream(ms, encrypto, CryptoStreamMode.Write);
cs.Write(bytIn, 0, bytIn.Length);
cs.FlushFinalBlock();
byte[] bytOut = ms.ToArray();
return System.Convert.ToBase64String(bytOut);
}
catch (Exception ex)
{
throw new Exception("在文件加密的时候出现错误!错误提示: \n" + ex.Message);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
int intCount = CheckUser();//调用方法检测用户名是否存在
if (intCount != 0)
{
Response.Write("<script language='javascript'>alert('该会员已经注册过');</script>");
return;
}
//调用方法将注册信息加密
string sqlstr = "insert into tb_02 "
+ "values('" + txtLoginName.Text + "','" + ddlSex.SelectedValue
+ "','" + Encrypting(txtPwd.Text.Trim()) + "','" + txtQuePwd.Text
+ "','" + Encrypting(txtAnsPwd.Text.Trim()) + "','" + Encrypting(txtEmail.Text.Trim()) + "')";
SqlConnection sqlconn = new SqlConnection("server=(local);uid=sa;pwd=;database=db_08");
sqlconn.Open();
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
sqlcom.ExecuteNonQuery();
sqlconn.Close();
Response.Write("<script>alert('注册成功!');</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Write("<script>window.close();</script>");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -