private static void addDefault() { String checkName = "select * from loginInfo where userName='******'" ; DBOperation op = new DBOperation(); DataTable checkDefault = op.getDataTable(checkName, "loginInfo"); if (checkDefault.Rows.Count == 0) { String defpass = AddAccount.MD5("123456"); String addDefault = "insert into loginInfo(userName, password, privilege) values('default', '" + defpass + "', 0)"; op.singleOperation(addDefault); MessageBox.Show("已添加默认账号"); } }
private void button1_Click(object sender, EventArgs e) { if(this.addname.Text == "") { MessageBox.Show("请输入用户名"); return; } if(this.addpass.Text == "") { MessageBox.Show("请输入密码"); return; } if (this.addrepass.Text == "") { MessageBox.Show("请输入密码"); return; } if (this.privilege.Text == "") { MessageBox.Show("请选择权限"); return; } if (this.addname.Text.Length > 16 || this.addname.Text.Length < 6) { MessageBox.Show("用户名应为6至16位"); return; } if (this.addpass.Text.Length > 20 || this.addpass.Text.Length < 6) { MessageBox.Show("密码应为6至20位"); return; } if(!this.addpass.Text.Equals(this.addrepass.Text)) { MessageBox.Show("两次输入密码不匹配"); return; } op = new DBOperation(); String check = "select * from loginInfo where userName='******'"; DataTable search = op.getDataTable(check, "loginInfo"); if (search.Rows.Count != 0) { MessageBox.Show("该用户名已存在"); return; } String md5 = MD5(this.addpass.Text); op = new DBOperation(); String addAccount = "insert into loginInfo(userName, password, privilege) values('" + this.addname.Text + "', '" + md5 + "', " + this.addPri.Text + ")"; MessageBox.Show(md5); if (op.singleOperation(addAccount)) { this.addname.Text = ""; this.addpass.Text = ""; this.addPri.Text = ""; MessageBox.Show("添加成功"); } }