WinForm简单的登陆窗体
要求:
- 编写一个窗体，往Users表中添加一条数据
- UserName 不能为空，不能重复
- PassWord 两次密码，一致才行
- NickName 如果没填，自动填入“这家伙很懒”
- Sex 用单选按钮来让用户选择
- Birthday 生日
- Nation 下拉列表，显示所有民族的名称，默认选中一个
- 通过用户选择的民族名称 ，填入相应的民族编号
- 注册按钮，只要上面有一项未按照规定填写，那么注册按钮就不会将数据保存至数据库
成品样式:
代码:
主要是数据访问类代码:
using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Text; namespace WindowsFormsApplication1.App_Code { public class UsersData { SqlConnection conn = null; SqlCommand cmd = null; public UsersData() { conn = new SqlConnection("server=.;database=ODA;user=sa;pwd=123;"); cmd = conn.CreateCommand(); } //检测用户名是否重复 public bool SeleNa(string a) { bool b = false; cmd.CommandText = "select * from Users where UserName=@a"; conn.Open(); cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@a", a); SqlDataReader dr = cmd.ExecuteReader(); if (!dr.HasRows) { b = true; } conn.Close(); return b; } //获取民族编号 public string Code(string a) { string b; cmd.CommandText = "select NationCode from Nation where NationName=@a"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@a", a); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); b = dr[0].ToString(); conn.Close(); return b; } //提交数据 public bool Submit(string a, string b, string c, bool d, DateTime e, string f) { bool h = false; cmd.CommandText = "insert into Users values(@a,@b,@c,@d,@e,@f)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@a", a); cmd.Parameters.AddWithValue("@b", b); cmd.Parameters.AddWithValue("@c", c); cmd.Parameters.AddWithValue("@d", d); cmd.Parameters.AddWithValue("@e", e); cmd.Parameters.AddWithValue("@f", f); conn.Open(); int z = cmd.ExecuteNonQuery(); conn.Close(); if (z == 1) { h = true; } return h; } } }
Form代码:
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using WindowsFormsApplication1.App_Code; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } //总判断条件 //1.用户名判断: bool Na = false; //(1)如果用户名不为空才能 private void textBox1_Leave(object sender, EventArgs e) { //如果为空 if (textBox1.Text == "") { label8.Text = "用户名不能为空"; pictureBox1.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wrong.png"); label8.Visible = true; pictureBox1.Visible = true; Na = false; } else { pictureBox1.Visible = false; } } //(2)查询有没有该用户 private void button1_Click(object sender, EventArgs e) { //如果不为空 if (textBox1.Text != "") { //如果用户不存在 if (new UsersData().SeleNa(textBox1.Text)) { //错号变对号 pictureBox1.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wright.png"); pictureBox1.Visible = true; label8.Visible = false; // name条件成立 Na = true; } else { //错号出现 pictureBox1.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wrong.png"); pictureBox1.Visible = true; //提示用户 label8.Text = "用户名重复"; label8.Visible = true; //用户名判断 Na = false; } } } //2.密码判断 bool Pwd = false; private void textBox3_Leave(object sender, EventArgs e) { //密码不为空 if (textBox3.Text != "" || textBox2.Text != "") { //密码相同 if (textBox2.Text == textBox3.Text) { //显示对号 pictureBox3.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wright.png"); pictureBox3.Visible = true; //隐藏文字 label9.Visible = false; //Pwd条件成立 Pwd = true; } else { //显示错号 pictureBox3.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wrong.png"); pictureBox3.Visible = true; //提示文字 label9.Text = "两次密码不一致"; label9.Visible = true; //密码判断 Pwd = false; } } else { //显示错号 pictureBox3.BackgroundImage = Image.FromFile(@"F:/XXXX/WindowsFormsApplication1/jpg/wrong.png"); pictureBox3.Visible = true; //提示文字 label9.Visible = true; label9.Text = "密码不能为空"; //密码判断 Pwd = false; } } //3.昵称判断 private void textBox4_Leave(object sender, EventArgs e) { //如果昵称为空 if (textBox4.Text == "") { //提示文字显示,感叹号显示 label10.Visible = true; pictureBox2.Visible = true; //出现默认昵称 textBox4.Text = "这家伙很懒"; //提交按钮可用 if (Na == true && Pwd == true) { button2.Enabled = true; } else { button2.Enabled = false; } } else { //提示文字隐藏,感叹号隐藏 label10.Visible = false; pictureBox2.Visible = false; //提交按钮可用 if (Na == true && Pwd == true) { button2.Enabled = true; } else { button2.Enabled = false; } } } //生日不能超过今天 private void dateTimePicker1_Enter(object sender, EventArgs e) { dateTimePicker1.MaxDate = DateTime.Now; } //鼠标移入提交按钮 bool Sex; string Nation; private void button2_MouseEnter(object sender, EventArgs e) { //性别转换bool值 if (radioButton1.Checked) { Sex = true; } else { Sex = false; } Nation = new UsersData().Code(comboBox1.Text); } //点击提交按钮 private void button2_Click(object sender, EventArgs e) { if (new UsersData().Submit(textBox1.Text, textBox3.Text, textBox4.Text, Sex, Convert.ToDateTime((dateTimePicker1.Text)), Nation)) { MessageBox.Show("注册成功"); } else { MessageBox.Show("注册失败"); } } } }
