一,登录进入普通用户界面
此界面主要是要求用户完善个人信息
需要把登录人的姓名从登录界面传到个人界面,需要新建一个类用来传值
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace _112管理系统2._0
{
class Class1
{
public static string str1,str2;
}
}
新建一个数据表来存个人信息
界面所有功能的代码是
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace _112管理系统2._0
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
private void Form3_Load(object sender, EventArgs e)
{
label1.Text = Class1.str2;//用类来传递值
}
private void Form3_FormClosed(object sender, FormClosedEventArgs e)
{
Application.Exit();
}
public void Insert()
{
string Constr = "server=SC-201910241106;database=我的数据库;Trusted_Connection=SSPI";
SqlConnection con = new SqlConnection(Constr);
con.Open();//打开链接
//Console.WriteLine("数据库已连接");
//Console.WriteLine("请输入你要插入的学号和姓名");
string str1 = textBox1.Text;
string str2 = textBox2.Text;
string str3 = textBox3.Text;
string str4 = textBox4.Text;
string str5 = label1.Text;
if (str1 == "" || str2 == "" || str3 == "" || str4 == "")//注册信息不能为空
{
MessageBox.Show("信息不能为空");
}
else
{
string sql = string.Format("select count(*) from sss where 姓名='{0}' ", str5);
SqlCommand thiscommand = new SqlCommand(sql,con);//为上面的链接指定Command对象
int i = Convert.ToInt32(thiscommand.ExecuteScalar());
if(i>0)
{
MessageBox.Show("信息已存在");
}
else
{
string sqll = "insert into sss(姓名,身高,体重,床号,专业方向)values('" + str5 + "','" + str1 + "','" + str2 + "','" + str3 + "','" + str4 + "')";
SqlCommand cmd = new SqlCommand(sqll, con);
//cmd.Parameters.AddWithValue("学号", str1);
cmd.Parameters.AddWithValue("姓名", str5);
cmd.Parameters.AddWithValue("身高", str1);
cmd.Parameters.AddWithValue("体重", str2);
cmd.Parameters.AddWithValue("床号", str3);
cmd.Parameters.AddWithValue("专业方向", str4);
// cmd.Parameters.AddWithValue("密码", str3);
cmd.ExecuteNonQuery();
//Console.WriteLine("插入完成");
con.Close();
MessageBox.Show("完善成功");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Insert();//调用插入函数
//this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
string str = label1.Text;
string Constr = "server=SC-201910241106;database=我的数据库;Trusted_Connection=SSPI";
SqlConnection con = new SqlConnection(Constr);
con.Open();//打开链接
string sql = string.Format("select count(*) from sss where 姓名='{0}' ", str);
SqlCommand thiscommand = new SqlCommand(sql, con);//为上面的链接指定Command对象
int i = Convert.ToInt32(thiscommand.ExecuteScalar());
if(i>0)
{
this.Hide();
Form4 form4 = new Form4();
form4.Show();
Class1.str1 = label1.Text;
}
else
{
MessageBox.Show("你的信息还未完善,请先完善你的个人信息");
}
}
}
}
点击进入个人主窗体按钮进入主窗体界面
主窗体的功能主要有显示个人的注册信息和个人信息
有注销按钮,修改按钮,退出程序按钮
当你点击注销按钮式注册信息和个人信息一并从数据库删除,并退出程序
修改按钮可以修改个人的某个个人信息
界面代码为
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace _112管理系统2._0
{
public partial class Form4 : Form
{
public Form4()
{
InitializeComponent();
}
public void jiazai() //加载使用者的个人信息
{
label1.Text = Class1.str2 + "欢迎来到你的个人信息界面";
textBox1.Text = Class1.str2;
textBox2.Text = Class1.str1;
string Constr = "server=SC-201910241106;database=我的数据库;Trusted_Connection=SSPI";
SqlConnection con = new SqlConnection(Constr);
con.Open();//打开链接
SqlCommand thiscommand = con.CreateCommand();//为上面的链接指定Command对象
thiscommand.CommandText = "select 姓名,身高,体重,床号,专业方向 from sss";//数据库查询语句
SqlDataReader thisSqlDataReader = thiscommand.ExecuteReader();
while (thisSqlDataReader.Read())
{
string usename = thisSqlDataReader.GetString(thisSqlDataReader.GetOrdinal("姓名"));
string shengao = thisSqlDataReader.GetString(thisSqlDataReader.GetOrdinal("身高"));
string tizhong = thisSqlDataReader.GetString(thisSqlDataReader.GetOrdinal("体重"));
string chuanghao = thisSqlDataReader.GetString(thisSqlDataReader.GetOrdinal("床号"));
string zhuanye = thisSqlDataReader.GetString(thisSqlDataReader.GetOrdinal("专业方向"));
textBox3.Text = shengao;
textBox4.Text = tizhong;
textBox5.Text = chuanghao;
textBox6.Text = zhuanye;
if (usename == textBox1.Text)
{
break;
}
}
thisSqlDataReader.Close();
}
private void Form4_Load(object sender, EventArgs e)
{
jiazai();//调用函数,使个人信息加载到窗体
}
private void Form4_FormClosed(object sender, FormClosedEventArgs e)
{
Application.Exit();
}
private void button1_Click(object sender, EventArgs e)//修改数据信息
{
string Constr = "server=SC-201910241106;database=我的数据库;Trusted_Connection=SSPI";
SqlConnection con = new SqlConnection(Constr);
con.Open();//打开链接
SqlCommand com = con.CreateCommand();
string str = "update {0} set 身高='{1}',体重='{2}',床号='{3}',专业方向='{4}' where 姓名='{5}'";//更新数据,修改姓名为某个值的其他数据
com.CommandText = string.Format(str, "sss", textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text,textBox1.Text);
com.ExecuteNonQuery();//执行修改
MessageBox.Show("修改成功");
}
private void button2_Click(object sender, EventArgs e)
{
Application.Exit();//窗体关闭事件
}
private void button3_Click(object sender, EventArgs e)
{
string Constr = "server=SC-201910241106;database=我的数据库;Trusted_connection=SSPI";
SqlConnection con = new SqlConnection(Constr);
con.Open();
string str = textBox1.Text;
string sql1 = "delete from sss where 姓名=@NAME";//数据库删除语句
SqlCommand cmd_delete1 = new SqlCommand(sql1, con);
cmd_delete1.Parameters.AddWithValue("@NAME", str);
int r = cmd_delete1.ExecuteNonQuery();//执行删除操作
string str1 = textBox2.Text;
string sql = "delete from 学号 where 学号=@NAME";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@NAME", str1);
int k = cmd.ExecuteNonQuery();
if(k>0)
{
MessageBox.Show("注销成功");
Application.Exit();
}
else
{
MessageBox.Show("注销失败");
}
con.Close();
}
}
}
期待下次更新