C#用戶登錄界面程序

一、數(shù)據(jù)庫連接方式由于使用Acess2000連接數(shù)據(jù)庫，所以要加上usingSystem.Data.OleDb;空間，可以使用如下方式連接至U數(shù)據(jù)庫stringstr=stringstr=@"Provider二Microsoft.Jet.0LEDB.4.0;DataSource二xsxx.mdb";程序總體如下：OleDbDataAdapteradapter;DataTabletable=newDataTable();stringstr=@"Provider=Microsoft.Jet.0LEDB.4.0;DataSource=liqi.mdb";OleDbConnectioncon=newOleDbConnection();二、界面設(shè)計：1、登入界面界面框圖如下：圖3-1登入界面2、注冊界面框圖如下：噲Form2ooe3、學(xué)生信息管理系統(tǒng)界面取消框圖如下：°：_FormJOOO瀏覽查詢恭加修改刪除刷新退出學(xué)生傳息管理系統(tǒng)圖3-3學(xué)生信息管理系統(tǒng)界面三、主要功能代碼1登入界面代碼：publicpartialclassForm1:Form{OleDbDataAdapteradapter;//數(shù)據(jù)庫連接DataTabletable=newDataTable();stringstr=@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=liqi.mdb";OleDbConnectioncon=newOleDbConnection();publicForm1(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(textBox1.Text!=""&&textBox2.Text!=""){stringsql="select*from信息where學(xué)號二'"+textBoxl.Text+"'and密碼='"+textBox2.Text+"'";adapter=newOleDbDataAdapter(sql,str);OleDbCommandBuilderbuider=newOleDbCommandBuilder(adapter);adapter.InsertCommand=buider.GetInsertCommand();table.Clear();adapter.Fill(table);if(table.Rows.Count>0){Formf3=newForm3();f3.Show();this.Hide();}}else{MessageBox.Show("用戶名或密碼不能空");}}//登入privatevoidbutton3_Click(objectsender,EventArgse){Formf2=newForm2();//打開注冊界面f2.Show();this.Hide();}privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}}功能分析：當在登入界面時，可以使用數(shù)據(jù)庫中有的數(shù)據(jù)登入學(xué)生信息管理系統(tǒng)，也可以進入注冊界面成為新的用戶。2、注冊界面代碼：publicpartialclassForm2:Form{OleDbDataAdapteradapter;//數(shù)據(jù)庫連接DataTabletable=newDataTable();stringstr=@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=liqi.mdb";OleDbConnectioncon=newOleDbConnection();publicForm2(){InitializeComponent();con.ConnectionString=str;}privatevoidbutton2_Click(objectsender,EventArgse){textBox1.Text="";textBox2.Text="";textBox4.Text="";textBox5.Text="";textBox3.Text="";}//取消注冊privatevoidbutton1_Click(objectsender,EventArgse){if(textBox2.Text==""&&textBox3.Text=="")label4.Text="請輸入密碼";word格式-可編輯-感謝下載支持elseif(textBox2.Text==textBox3.Text){stringb=textBox2.Text;stringc=textBox1.Text;stringa=textBox4.Text;stringd=textBox5.Text;OleDbCommandcmd=newOleDbCommand(@"insertinto信息(學(xué)號,姓名,專業(yè),密碼)values('"+c+"','"+a+"','"+d+"','"+b+"')",con);con.Open();cmd.Connection=con;cmd.ExecuteNonQuery();con.Close();Form1f3=newForm1();f3.Show();this.Hide();}//注冊新用戶}}功能分析：當不能登入學(xué)生管理系統(tǒng)時，可以使用注冊界面注冊成為用戶，而注冊的信息將會進入數(shù)據(jù)庫中。注冊成功后將會回到登入界面，可以使用新用戶登入。3、學(xué)生管理系統(tǒng)界面代碼：publicpartialclassForm3:Form{OleDbDataAdapteradapter;//數(shù)據(jù)庫連接DataTabletable=newDataTable();stringstr=@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=liqi.mdb";OleDbConnectioncon=newOleDbConnection();publicForm3(){InitializeComponent();}privatevoidForm3_Load(objectsender,EventArgse){stringsql="select*from信息";adapter=newOleDbDataAdapter(sql,str);}privatevoid瀏覽ToolStripMenuItem_Click(objectsender,EventArgse){con.ConnectionString=str;stringsql="select*from信息";adapter=newOleDbDataAdapter(sql,str);OleDbCommandBuilderbuider=newOleDbCommandBuilder(adapter);wordword格式-可編輯-感謝下載支持table.Clear();adapter.Fill(table);dataGridView1.DataSource=table;}//瀏覽功能，可以看到數(shù)據(jù)信息privatevoid精確查詢ToolStripMenuItem_Click(objectsender,EventArgse){adapter.SelectCommand.CommandText="Select*from信息where學(xué)號='"+textBox1.Text+"'";table.Clear();adapter.Fill(table);dataGridView1.DataSource=table;}//精確查詢功能，可輸入完整學(xué)號查詢信息privatevoid模糊查詢ToolStripMenuItem_Click(objectsender,EventArgse){adapter.SelectCommand.CommandText="Select*from信息where學(xué)號like'"+textBox1.Text+"%'";table.Clear();adapter.Fill(table);dataGridView1.DataSource=table;}//模糊查詢功能，輸入學(xué)號前幾個數(shù)字就可查詢privatevoid添加ToolStripMenuItem_Click(objectsender,EventArgse){OleDbConnectioncon=newOleDbConnection();con.ConnectionString=str;stringsex;if(radioButton1.Checked==true)sex="男";elsesex="女";OleDbCommandcmd=newOleDbCommand(@"insertinto信息(學(xué)號,姓名,性別,生日,籍貫,專業(yè),密碼)values('"+textBox1.Text+"','"+textBox2.Text+"',+sex+"','"+textBox3.Text+"','"+textBox4.Text+"','"+textBox5.Text+"','"+textBox6.Text+"')",con);con.Open();cmd.Connection=con;cmd.ExecuteNonQuery();con.Close();adapter.SelectCommand.CommandText="select*from信息";table.Clear();adapter.Fill(table);adapter.Update(table);}//可添加數(shù)據(jù)信息privatevoid修改ToolStripMenuItem_Click(objectsender,EventArgse){OleDbConnectioncon=newOleDbConnection();con.ConnectionString=str;stringsex;if(radioButton1.Checked==true)sex="男";elsesex="女";OleDbCommandcmd=newOleDbCommand(@"update信息set姓名='"+textBox2.Text+"',性別='"+sex+"',生日='"+textBox3.Text+"',籍貫='"+textBox4.Text+"',專業(yè)='"+textBox5.Text+"',密碼='"+textBox6.Text+"'where學(xué)號='"+textBox1.Text+"'",con);con.Open();cmd.Connection=con;cmd.ExecuteNonQuery();con.Close();adapter.SelectCommand.CommandText="select*from信息";table.Clear();adapter.Fill(table);adapter.Update(table);}//可修改數(shù)據(jù)信息privatevoid刪除ToolStripMenuItem_Click(objectsender,EventArgse){OleDbConnectioncon=newOleDbConnection();con.ConnectionString=str;OleDbCommandcmd=newOleDbCommand(@"deletefrom信息where學(xué)號='"+textBox1.Text+"'",con);con.Open();cmd.Connection=con;cmd.ExecuteNonQuery();con.Close();adapter.SelectCommand.CommandText="select*from信息";table.Clear();adapter.Fill(table);adapter.Update(table);}//可刪除數(shù)據(jù)信息privatevoid刷新ToolStripMenuItem_Click(objectsender,EventArgse){adapter.SelectCommand.CommandText="select*from信息";table.Clear();adapter.Fill(table);adapter.Update(table);}privatevoid退出ToolStripMenulte