實驗八 訪問數(shù)據(jù)庫應(yīng)用實例

1、.實驗八 訪問數(shù)據(jù)庫應(yīng)用實例一. 實驗?zāi)康模耗軌蚴炀氝\用某種高級語言進(jìn)行數(shù)據(jù)庫編程二. 實驗內(nèi)容：根據(jù)上次實驗所使用的組件，編寫一個訪問數(shù)據(jù)庫的程序，要求該程序具備查詢、插入、刪除、修改四個基本功能。三. 實驗過程：（將程序的實驗過程簡單描述并將相關(guān)界面截圖，關(guān)鍵代碼附在文中）using System;using System.Data;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;namespace ConsoleApplication2 cla

2、ss Program static void Main(string args) string connstr = string.Format(server= LIUYANSQLEXPRESS;database=學(xué)生課程數(shù)據(jù)庫;uid=login;pwd=123456); Console.WriteLine(-訪問數(shù)據(jù)庫系統(tǒng)-); Console.Write(-請輸入操作：); int Operator = Convert.ToInt32(Console.ReadLine(); switch (Operator) case 1: Select(connstr); break; case 2:

3、Add(connstr); break; case 3: Delect(connstr); break; case 4: Update(connstr); break; default: break; static void Select(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.Write(輸入要查詢的學(xué)生姓名：); string name = string.Forma

4、t(Console.ReadLine(); comm.CommandText = string.Format(select * from student where sname = 0,name); comm.CommandType = CommandType.Text; SqlDataReader sdr = comm.ExecuteReader(); while (sdr.Read() Console.WriteLine(學(xué)號; + sdr0.ToString(); Console.WriteLine(姓名; + sdr1.ToString(); Console.WriteLine(年齡;

5、 + sdr2.ToString(); Console.WriteLine(院系; + sdr3.ToString(); Console.WriteLine(生日; + sdr4.ToString(); conn.Dispose(); static void Add(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.Write(輸入要插入的學(xué)生學(xué)號：); string no =

6、string.Format(Console.ReadLine(); Console.Write(輸入要插入的學(xué)生姓名：); string name = string.Format(Console.ReadLine(); Console.Write(輸入要插入的學(xué)生年齡：); int age = Convert.ToInt32(Console.ReadLine(); Console.Write(輸入要插入的學(xué)生系別：); string dept = string.Format(Console.ReadLine(); Console.Write(輸入要插入的學(xué)生生日：); string birth

7、day = string.Format(Console.ReadLine(); comm.CommandText = string.Format(Insert Into student(sno,sname,sage,sdept,sbirthday) values(0,1,2,3,4),no,name,age,dept,birthday); comm.CommandType = CommandType.Text; if (comm.ExecuteNonQuery() 0) Console.WriteLine(成功添加學(xué)生信息！); else Console.WriteLine(添加學(xué)生信息失??！

8、); conn.Dispose(); static void Delect(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.WriteLine(刪除關(guān)于學(xué)號為95009的學(xué)生的記錄); comm.CommandText = string.Format(delete from student where sno=95009); comm.CommandType = Command

9、Type.Text; if (comm.ExecuteNonQuery() 0) Console.WriteLine(成功刪除學(xué)號為95009的學(xué)生記錄！); conn.Dispose(); static void Update(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.WriteLine(修改張三學(xué)生的記錄); comm.CommandText = string.Format(update student set sage=19 where sname=張三); comm.CommandType = CommandType.Text; if (comm.ExecuteNonQuery() 0) Console.WriteLin