2023年6月21日发(作者：)
实验三 数据库操作
一、实验目的：略
二、实验内容
在SQl Sever 2005中建立数据表关系模式如下，完成后面操作：
mima(ID,UserName,Password)
字段类型参考：
ID：int 自增
UserName：nvarchar（50）；
Password：nvarchar（50）；
1、//输出多列
//采用连接方式直接操作数据库：
using System;
using c;
using ;
using ;
using ent;
namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT * FROM mima";
using (SqlDataReader reader = eReader())
while (())
{
//ine(ing(1));
//GetString(1)读第一列的值
String username =
ing(inal("UserName"));
int id = 32(inal("ID"));
String Password = ing(inal("Password"));
ine("ID={0},UserName={1},Password={2}", id,
username, Password);
}
}
}
}
}
}
2、//插入记录
ine("请输入要插入用户名");
string username = ne();
ine("请输入要插入密码");
string password = ne();
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand insertcmd = Command())
{
dText = "insert into mima(UserName,Password)
values(@UN,@PD)";
(new SqlParameter("UN", username));
(new SqlParameter("PD", password));
eNonQuery();
ine("插入成功！");
}
}
3、 //修改数据
ine("请输入要修改密码用户名");
string username = ne();
ine("请输入新密码");
string password = ne();
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{ ();
using (SqlCommand updatecmd = Command())
{
dText = "update mima set Password=@PD where UserName=@UN";
(new SqlParameter("UN", username));
(new SqlParameter("PD", password));
eNonQuery();
ine("成功修改密码！");
}
} }
4、//多个查询：
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT Sno FROM student";
SqlDataReader sdr = eReader();
while (())
{
ine(sdr[0]);
}
}
}
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT sname FROM student";
SqlDataReader sdr = eReader();
while (())
{
ine(sdr[0]);
}
}
}
2023年6月21日发(作者：)
实验三 数据库操作
一、实验目的：略
二、实验内容
在SQl Sever 2005中建立数据表关系模式如下，完成后面操作：
mima(ID,UserName,Password)
字段类型参考：
ID：int 自增
UserName：nvarchar（50）；
Password：nvarchar（50）；
1、//输出多列
//采用连接方式直接操作数据库：
using System;
using c;
using ;
using ;
using ent;
namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT * FROM mima";
using (SqlDataReader reader = eReader())
while (())
{
//ine(ing(1));
//GetString(1)读第一列的值
String username =
ing(inal("UserName"));
int id = 32(inal("ID"));
String Password = ing(inal("Password"));
ine("ID={0},UserName={1},Password={2}", id,
username, Password);
}
}
}
}
}
}
2、//插入记录
ine("请输入要插入用户名");
string username = ne();
ine("请输入要插入密码");
string password = ne();
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand insertcmd = Command())
{
dText = "insert into mima(UserName,Password)
values(@UN,@PD)";
(new SqlParameter("UN", username));
(new SqlParameter("PD", password));
eNonQuery();
ine("插入成功！");
}
}
3、 //修改数据
ine("请输入要修改密码用户名");
string username = ne();
ine("请输入新密码");
string password = ne();
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{ ();
using (SqlCommand updatecmd = Command())
{
dText = "update mima set Password=@PD where UserName=@UN";
(new SqlParameter("UN", username));
(new SqlParameter("PD", password));
eNonQuery();
ine("成功修改密码！");
}
} }
4、//多个查询：
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT Sno FROM student";
SqlDataReader sdr = eReader();
while (())
{
ine(sdr[0]);
}
}
}
using (SqlConnection con = new SqlConnection("Data Source=.;Initial
Catalog=xkxt;uid=sa;pwd=111111"))
{
();
using (SqlCommand cmd = Command())
{
dText = "SELECT sname FROM student";
SqlDataReader sdr = eReader();
while (())
{
ine(sdr[0]);
}
}
}
发布评论