private void button1_Click(object sender, EventArgs e)
{
string n = Form1.name;
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Users\\zhongbo\\Documents\\Visual Studio 2013\\Projects\\学生选课登陆系统\\学生选课登陆系统\\Resources\\学生选课.mdb"); //创建连接
conn.Open(); //打开连接
OleDbCommand comm = new OleDbCommand(); //创建OleDbCommand对象
comm.Connection = conn; //以上代码连接并打开数据库
comm.CommandText = "select * from 登录 where 用户名='" + n + "'"; //根据登录界面输入的信息去查询数据库内容
OleDbDataReader dr;
dr = comm.ExecuteReader();//执行连接
if (dr.Read() == true)
{
if (dr["角色"].ToString() == "学生")//若为学生用户则返回学生用户主界面
{
this.Hide();
StudentForm aa = new StudentForm();
aa.Show();
}
else if (dr["角色"].ToString() == "教师")//若为教师用户则返回学生用户主界面
{
this.Hide();
TeacherForm aa = new TeacherForm();
aa.Show();
}
}
else
{
MessageBox.Show("出错了哦!");
}
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
/* SqlConnection conn = new SqlConnection();
* conn.ConnectionString = "server=.;database=db_Person;uid=sa;pwd=123456";
* conn.Open(); //打开连接
* SqlCommand comm = new SqlCommand();
* comm.Connection = conn;//以上代码连接并打开数据库
* comm.CommandType = CommandType.Text;
* comm.CommandText = "select * from login where username='******'";//根据登录界面输入的信息去查询数据库内容
* SqlDataReader dr;
* dr = comm.ExecuteReader();*/
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Users\\zhongbo\\Documents\\Visual Studio 2013\\Projects\\学生选课登陆系统\\学生选课登陆系统\\Resources\\学生选课.mdb"); //创建连接
conn.Open(); //打开连接
OleDbCommand comm = new OleDbCommand(); //创建OleDbCommand对象
comm.Connection = conn; //以上代码连接并打开数据库
comm.CommandText = "select * from 登录 where 用户名='" + textBox1.Text + "'"; //根据登录界面输入的信息去查询数据库内容
OleDbDataReader dr;
dr = comm.ExecuteReader();//执行连接
if (dr.Read() == true)
{
if (dr["密码"].ToString() == textBox2.Text && dr["角色"].ToString() == comboBox1.Text)
{
name = textBox1.Text;
if (dr["角色"].ToString() == "学生")
{
this.Hide();
StudentForm stu = new StudentForm();
stu.Show();
}
else if (dr["角色"].ToString() == "教师")
{
this.Hide();
TeacherForm tea = new TeacherForm();
tea.Show();
}
}
else
{
MessageBox.Show("登陆角色错误或密码错误！");
}
}
else
{
MessageBox.Show("无此用户！");
}
conn.Close();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string n = Form1.name;
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Users\\zhongbo\\Documents\\Visual Studio 2013\\Projects\\学生选课登陆系统\\学生选课登陆系统\\Resources\\学生选课.mdb"); //创建连接
conn.Open(); //打开连接
OleDbCommand comm = new OleDbCommand(); //创建OleDbCommand对象
comm.Connection = conn; //以上代码连接并打开数据库
// comm.CommandText = "INSERT INTO xuanke(用户名,CID) VALUES('"+n+"','"+dataGridView1[0,dataGridView1.CurrentCell.RowIndex].Value+"')";
string strSQL = "INSERT INTO xuanke(用户名,CID) " +
"VALUES ( '" + n + "','" + dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value + "')";
comm = new OleDbCommand(strSQL, conn);
comm.ExecuteNonQuery();
this.Hide();
comm.CommandText = "select * from 登录 where 用户名='" + n + "'";//根据登录界面输入的信息去查询数据库内容
OleDbDataReader dr;
dr = comm.ExecuteReader();//执行连接
if (dr.Read() == true)
{
if (dr["角色"].ToString() == "学生")//若为学生用户则返回学生用户主界面
{
this.Hide();
StudentForm aa = new StudentForm();
aa.Show();
}
else if (dr["角色"].ToString() == "教师")//若为教师用户则返回学生用户主界面
{
this.Hide();
TeacherForm aa = new TeacherForm();
aa.Show();
}
}
else
{
MessageBox.Show("出错了哦!");
}
conn.Close();
}