private void skinButton1_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string time = DateTime.Now.ToString();
string ip = Method.GetIp();
string mac = Method.GetMacAddress();
if (skinTextBox1.Text == "" || skinTextBox2.Text == "" || skinTextBox3.Text == "" || skinTextBox4.Text == "")
{
MessageBox.Show("请完善账号信息！");
return;
}
if (skinTextBox3.Text.Length < 11)
{
MessageBox.Show("请输入十一位有效手机号！");
return;
}
if (skinTextBox4.Text.Trim() != Method.RandomKey())
{
MessageBox.Show("您的注册码错误！");
return;
}
try
{
string constr = "Host =116.62.62.62;Database=vip;Username=root;Password=zhoukaige";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
string username = skinTextBox1.Text.Trim();
string password = skinTextBox2.Text.Trim();
string phone = skinTextBox3.Text.Trim();
MySqlCommand cmd = new MySqlCommand("INSERT INTO vip_points (username,password,phone,register_t,ip,mac)VALUES('" + username + " ', '" + password + " ','" + phone + " ', '" + time + " ', '" + ip + " ', '" + mac + " ')", mycon); //SQL语句读取textbox的值'"+skinTextBox1.Text+"'
// MySqlDataReader reader = cmd.ExecuteReader(); //读取数据库数据信息，注册不需要读取，直接执行SQL语句即可
int count = cmd.ExecuteNonQuery(); //count就是受影响的行数,如果count>0说明执行成功,如果=0说明没有成功.
if (count > 0)
{
MessageBox.Show("注册成功！");
this.Close();
mycon.Close();
// reader.Close();
}
else
{
MessageBox.Show("连接失败！");
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
