实验八 访问数据库应用实例

1、.实验八 访问数据库应用实例一. 实验目的：能够熟练运用某种高级语言进行数据库编程二. 实验内容：根据上次实验所使用的组件，编写一个访问数据库的程序，要求该程序具备查询、插入、删除、修改四个基本功能。三. 实验过程：（将程序的实验过程简单描述并将相关界面截图，关键代码附在文中）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=学生课程数据库;uid=login;pwd=123456); Console.WriteLine(-访问数据库系统-); 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(输入要查询的学生姓名：); 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(学号; + 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(输入要插入的学生学号：); string no =

6、string.Format(Console.ReadLine(); Console.Write(输入要插入的学生姓名：); string name = string.Format(Console.ReadLine(); Console.Write(输入要插入的学生年龄：); int age = Convert.ToInt32(Console.ReadLine(); Console.Write(输入要插入的学生系别：); string dept = string.Format(Console.ReadLine(); Console.Write(输入要插入的学生生日：); 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(成功添加学生信息！); else Console.WriteLine(添加学生信息失败！

8、); conn.Dispose(); static void Delect(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.WriteLine(删除关于学号为95009的学生的记录); comm.CommandText = string.Format(delete from student where sno=95009); comm.CommandType = Command

9、Type.Text; if (comm.ExecuteNonQuery() 0) Console.WriteLine(成功删除学号为95009的学生记录！); conn.Dispose(); static void Update(string s) SqlConnection conn = new SqlConnection(s); conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; Console.WriteLine(修改张三学生的记录); comm.CommandText = string.Format(update student set sage=19 where sname=张三); comm.CommandType = CommandType.Text; if (comm.ExecuteNonQuery() 0) Console.WriteLin