private void button1_Click(object sender, EventArgs e) { String str1 = 注册账号.Text; //form里面有输入账号密码的文本框,这一步是获取其内容; String str2 = 注册密码.Text; String str3 = 族谱号.Text; String str4 = null; if (str3.Length == 0) { str4 = "insert into [User] values('" + str1 + "','" + str2 + "',NULL)"; } else { str4 = "insert into [User] values('" + str1 + "','" + str2 + "','" + str3 + "')"; } gene r2 = new gene(); //用来连接数据库的类gene,所以用其创建对象; int d2 = r2.ExecuteUpdate(str4); //执行后会有返回值,是int类型,如果执行失败会返回0; if (d2 != 0) { MessageBox.Show("注册成功!", "添加结果", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); Form 登录 = new 登录界面(); //这两行代码是实现界面跳转; Hide(); } else { MessageBox.Show("信息错误,\n请重新输入!", "添加结果", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } }
private void 修改_Click(object sender, EventArgs e) { String str1 = 登录界面.form1.登录账号.Text; //form里面有输入账号密码的文本框,这一步是获取其内容; String str2 = 修改密码.Text; String str3 = 族谱号.Text; String str4 = "UPDATE [User] SET [key]='" + str2 + "',genealogy_ID='" + str3 + "' WHERE User_ID='" + str1 + "'"; //编写sql语句,赋值给一个string变量,然后传给ExecuteQuery来执行; gene r2 = new gene(); //用来连接数据库的类gene,所以用其创建对象; int d2 = r2.ExecuteUpdate(str4); //执行后会有返回值,是int类型,如果执行失败会返回0; if (d2 != 0) { MessageBox.Show("修改成功!", "修改结果", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); Form 登录 = new 登录界面(); //这两行代码是实现界面跳转; Hide(); } else { MessageBox.Show("信息错误,\n请重新输入!", "修改结果", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); } }
public 登录界面() { form1 = this; InitializeComponent(); }