微机接口与原理期末整理

namespace WindowsApplication3{ public partial class Form1 : Form{ public Form1(){ InitializeComponent();}private void button1_Click(object sender, EventArgs e)//添加按钮{ SqlConnection conn = new SqlConnection("server=.;database=st;Integrated Security=SSPI");//连接对象st是表的名称int Sex = 1;if (radioButton2.Checked)Sex = 0;String sqlString=String.Format("insert into St values('{0}','{1}',{2},'{3}')",textBox1.Text,textBox2.Text,Sex,textBox3.Text);SqlCommand cmd = new SqlCommand(sqlString,conn);//try{ conn.Open();//打开连接会出现异常int row= cmd.ExecuteNonQuery();if (row == 0)MessageBox.Show("success");else MessageBox.Show("fail");}catch ( Exception ex){ MessageBox.Show(ex.Message.ToString());//捕捉异常}finally{ conn.Close();//只要出现异常就关闭连接}}private void button2_Click(object sender, EventArgs e)//查找按钮{ SqlConnection conn = new SqlConnection("server=.;database=st;Integrated Security=SSPI");string sqlString = "select* from st where stu='"+textBox1.Text+"'";SqlCommand cmd2 = new SqlCommand(sqlString,conn);conn.Open();SqlDataReader sdr = cmd2.ExecuteReader();if (sdr.HasRows){ sdr.Read();textBox2.Text=sdr["Name"].ToString();textBox3.Text = sdr["birthday"].ToString();if (bool.Parse(sdr["Sex"].ToString()))//转换成布尔类型判断radioButton1.Checked = true;else radioButton2.Checked = true;// sdr.Close();}else MessageBox.Show("没有查询到该学生");conn.Close();}}}{public partial class Form1 : Form{public Form1(){InitializeComponent();}private void ntsmenu_Click(object sender, EventArgs e){richTextBox1.Clear();//新建}private void opsmenu_Click(object sender, EventArgs e){ if (openFileDialog1.ShowDialog() == DialogResult.OK && openFileDialog1.FileName != ""){richTextBox1.LoadFile(openFileDialog1.FileName, RichTextBoxStreamType.PlainText);//打开}}private void stsmenu_Click(object sender, EventArgs e){if (saveFileDialog1.ShowDialog() == DialogResult.OK && saveFileDialog1.FileName != ""){ richTextBox1.SaveFile(saveFileDialog1.FileName, RichTextBoxStreamType.PlainText);//保存} }private void atsmennu_Click(object sender, EventArgs e){ if (saveFileDialog1.ShowDialog() == DialogResult.OK && saveFileDialog1.FileName != ""){ richTextBox1.SaveFile(saveFileDialog1.FileName, RichTextBoxStreamType.PlainText);//另保存} }private void xtsmenu_Click(object sender, EventArgs e){ this.Close();//退出}private void utsmenu_Click(object sender, EventArgs e){ //撤销richTextBox1.Undo();}private void rtsmenu_Click(object sender, EventArgs e){ //重复}private void ttsmenu_Click(object sender, EventArgs e){ //剪切richTextBox1.Cut();}private void ctsmenu_Click(object sender, EventArgs e){ richTextBox1.Copy();//复制}private void ptsmitem_Click(object sender, EventArgs e){ ////粘帖richTextBox1.Paste(); }private void atsmenu_Click(object sender, EventArgs e){ //全选richTextBox1.SelectAll(); }private void tsmbady_Click(object sender, EventArgs e){ //字体设置fontDialog1.ShowColor = true;if(fontDialog1.ShowDialog()==DialogResult.OK){richTextBox1.Font = fontDialog1.Font;richTextBox1.ForeColor = fontDialog1.Color;} }private void tsmauto_Click(object sender, EventArgs e){ //自动换行richTextBox1.WordWrap = false; }private void time_Click(object sender, EventArgs e){ richTextBox1.AppendText(DateTime.Now.ToLocalTime().ToString());//显示日期时间richTextBox1.AppendText(DateTime.Now.DayOfWeek.ToString());//显示星期} }}{ class Program{ static void Main(string[] args){ Hashtable ht = new Hashtable ();string key;string val;Console.WriteLine("欢迎使用2009级学生管理系统");Console.WriteLine("============================================");Console.WriteLine("请选择如下操作：");Console.WriteLine("A;添加B：查询C：删除D：修改E：退出系统");Console.WriteLine("********************************************");string r = Console.ReadLine();while (r!="e"){ switch (r){ case "a":Console .WriteLine ("请输入学生学号：");key= Console .ReadLine ();Console .Write ("请输入学生姓名：");val=Console .ReadLine ();ht.Add (key,val);break;case "b":Console .WriteLine ("请输入要查询的学号：");key= Console .ReadLine ();if(ht.Contains(key))Console .WriteLine ("学生姓名为：{0}",ht[key]);else Console.WriteLine("您输入的学生学号不存在");break;case "c":Console .WriteLine ("请输入要删除的学号：");key= Console .ReadLine ();ht.Remove(key);break;case "d":Console .WriteLine ("请输入要修改的学号：");key= Console .ReadLine ();Console .WriteLine ("请输入修改后学生姓名：");ht[key] = Console.ReadLine();break;}Console.WriteLine("请选择如下操作：");Console.WriteLine("A;添加B：查询C：删除D：修改E：退出系统");Console.WriteLine("********************************************");r = Console.ReadLine();}}}}{ /// <summary>/// 此示例演示使用Split()和Join()方法分割和连接字符串/// </summary>class Program{ static void Main(string[] args){ string inputString; // 输入的字符串string[] splitStrings; // 分割后的字符串数组string joinString; // 连接后的新字符串// 输入提示Console.WriteLine("请输入一串字符串，用空格分隔单词：");inputString = Console.ReadLine();// 接收输入splitStrings = inputString.Split(' '); // 以空格作为分隔符分割字符串// 将分割后的字符串输出Console.WriteLine("\n分割后的字符串为：");foreach (string s in splitStrings){ Console.WriteLine(s);}// 将分割后的字符串使用下划线连接在一起joinString = string.Join("_", splitStrings);// 将连接后的字符串输出Console.WriteLine("\n连接后的新字符串为：{0}", joinString);Console.ReadLine();}}}BinarySerch方法反回其中的元素5的下标namespace ConsoleApplication5{class Program{static void Main(string[] args){int[] myArr ={8,7,6,5,4,3,2,1};Array.Sort(myArr);int target = 5;int result = Array.BinarySearch(myArr, target);Console.WriteLine("{0}的下标为{1}",target,result);} }}Array类的Sort方法按从小到达顺序输出namespace ConsoleApplication4{class Program{static void Main(string[] args){ int[] array = new int[] {8,7,6,5,4,3,2,1};Console.WriteLine("原始数组：");for (int i = 0; i < array.Length; i++)Console.Write("{0}->",array[i]);Console.WriteLine();//换行Array.Sort(array);Console.WriteLine("排序后的数组：");for (int i = 0; i < array.Length; i++)namespace ConsoleApplication7{class Program{static void Main(string[] args){int[] SortArray = new int[] {78,89,90,56,79,345,217,5,13,88};Console.WriteLine("待排序序列：");for (int i = 0; i < SortArray.Length; i++)Console.Write("{0} ", SortArray[i]);Console.WriteLine();for(int i=SortArray.Length-1;i>=0;i--)for (int j = 0; j < i; j++){if (SortArray[j] > SortArray[j + 1]){int temp = SortArray[j];SortArray[j] = SortArray[j + 1];SortArray[j + 1] = temp;}}Console.WriteLine("排序后序列：");for (int i = 0; i < SortArray.Length; i++)Console.Write("{0} ",SortArray[i]); } }}8个数：87654321将这些数存在数组中，按从小到大输出namespace ConsoleApplication3{class Program{static void Main(string[] args){ int i, j, temp, m;int[] array = new int[] {8,7,6,5,4,3,2,1};for (j = 0; j < array.Length; j++){ temp = j;for (j = 0; j < array.Length; i++){ if (array[i] < array[temp])temp = i;}if (temp != j){ m = array[j];array[j] = array[temp];array[temp] = m;}}Console.WriteLine("");for (j = 0; j < array.Length; j++)Console.WriteLine("{0} ",array[j]);{class Program{static void Main(string[] args){ string[] arrSname ={"大宝","张三","李四","赵六","赵二","麻子"};//判断是否含某值string target = "赵六";bool result = ((System.Collections.IList)arrSname).Contains(target);包含{0}？{1}",target,result);//true }}}{ class Time{ public int nHour, nMinute, nSecond;public Time()//构造函数{ nHour = nMinute = nSecond = 0;}public Time(int Hour){ nHour = Hour;nMinute = nSecond = 0;}public Time(int Hour, int Minute)//重载2{ nHour = Hour;nMinute = Minute;nSecond = 0;}public Time(int Hour, int Minute, int Second)//重载3{ nHour = Hour;nMinute = Minute;nSecond = Second;}}class Text//程序入口{ static void Main(){ Time t1,t2,t3,t4;t1 = new Time();t2 = new Time(10);t3 = new Time(10,20);t4 = new Time(10,20,30);Console.WriteLine("t1时间为：{0}时{1}分钟{2}秒",t1.nHour,t1.nMinute,t1.nSecond);Console.WriteLine("t2时间为：{0}时{1}分钟{2}秒",t2.nHour, t2.nMinute, t2.nSecond);Console.WriteLine("t3时间为：{0}时{1}分钟{2}秒",t3.nHour, t3.nMinute, t3.nSecond);Console.WriteLine("t4时间为：{0}时{1}分钟{2}秒",t4.nHour, t4.nMinute, t4.nSecond);}} }{ //学生类public class student{ public string strName;public int nAge;public void SetAge(int age){ this.nAge = age;}public int GetAge(){ return this.nAge;}}class Program{ static void Main(string[] args){ student s = new student();s.SetAge(20);//赋值Console.WriteLine(s.GetAge());//获取}}{ public class Student{ public string strName;public int nAge;//长了一岁public void Grow(){ this.nAge++;}//长age岁public void Grow(int age){ this.nAge+=age;}class Program{ static void Main(string[] args){ Student s=new Student();s.strName="张三";s.nAge=20;s.Grow();Console.WriteLine(s.nAge);s.Grow(2);Console.WriteLine(s.nAge);{ //学生类public class Student{ public string strName;public int nAge;}public class CollegeStudent:Student{ public string xi;}public class Program{ static void Main(string[] args){ Student s = new Student();s.strName = "小明";s.nAge = 18;Console.WriteLine("姓名：{0}，年龄：{1}",s.strName,s.nAge);CollegeStudent c = new CollegeStudent();c.strName = "孙立娟";c.nAge = 22;c.xi = "信息学院";Console.WriteLine("姓名：{0}，年龄：{1},所在系：{2}", c.strName, c.nAge,c.xi);Console.ReadKey();} }}namespace ConsoleApplication3{ class Circle{ static void Main(){ const double PI = 3.14159;double R, S;Console.WriteLine("请输入圆的半径");R = double.Parse(Console.ReadLine());S = PI * R * R;Console.WriteLine("圆的面积是：{0}，S");}}}class Program{ static void Main(string[] args){ int i = 1, Oddsum = 0;do{ Oddsum += i;i+=2; }while(i<=100);Console.WriteLine("1到100的奇数和是：{0}",Oddsum);}}class Program{ static void Main(string[] args){ int i = 1, Oddsum = 0;do{ Oddsum += i;i+=2; }while(i<=100);Console.WriteLine("1到100的奇数和是：{0}",Oddsum); } }class TextScore{ static void Main(){ int InputScore;string OutputScore;Console.WriteLine("请输入学生百分制分数：");InputScore=consoif (Score >= 60) {Console.WriteLine("该成绩合格。