一迹卢。數(shù)據(jù)庫(kù)基本概念:
數(shù)據(jù)、數(shù)據(jù)庫(kù)徒仓。數(shù)據(jù)模型/DBMS(數(shù)據(jù)庫(kù)管理系統(tǒng))/DBS(數(shù)據(jù)庫(kù)系統(tǒng))
二腐碱。數(shù)據(jù)庫(kù)內(nèi)部組成
二維表、視圖,索引
三症见,數(shù)據(jù)庫(kù)管理系統(tǒng)主要功能:
六大功能
四數(shù)據(jù)庫(kù)操作語(yǔ)言:
SQL語(yǔ)言實(shí)現(xiàn)增刪查改*一喂走。數(shù)據(jù)庫(kù)基本概念:
數(shù)據(jù)、數(shù)據(jù)庫(kù)谋作。數(shù)據(jù)模型/DBMS(數(shù)據(jù)庫(kù)管理系統(tǒng))/DBS(數(shù)據(jù)庫(kù)系統(tǒng))
二芋肠。數(shù)據(jù)庫(kù)內(nèi)部組成
二維表、視圖遵蚜,索引
三帖池,數(shù)據(jù)庫(kù)管理系統(tǒng)主要功能:
六大功能
四數(shù)據(jù)庫(kù)操作語(yǔ)言:
SQL語(yǔ)言實(shí)現(xiàn)增刪查改
實(shí)驗(yàn)內(nèi)容:
1.用VS2010創(chuàng)建名為
insert into T_Student(sno,sname,ssex,sage,sdept) values('','','','','')
select * from T_Student
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2001','李勇','男','20','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2002','劉晨','女','18','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2003','王敏','女','19','MA')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2004','張立','男','22','IS')
insert into T_Course(Cno,Cname,Ccode) values ('1','數(shù)據(jù)庫(kù)','1')
insert into T_Course(Cno,Cname,Ccode) values ('2','英語(yǔ)','4')
insert into T_SC(Cno,Sno,Grade) values ('1','2001','88')
insert into T_SC(Cno,Sno,Grade) values ('2','2002','80')
增加一條學(xué)號(hào)為2006,姓名為張揚(yáng)
insert into T_student(sno,sname,ssex) values ('','','')
(sno,sname,ssex,sage,sdept) ('','','','','')空字符串
select * from t_student where sname='李勇'
select * from t_student where ssex='女'
select sdept from t_student where sname='張立'
select count() from T_student
select max() from t_student
update t_student set ssex='女' where sno='2001'
update t_student set sage='22' where sname='王敏'
update t_student sdept='MA' where ssex='男'
insert into T_Student (sno,sname,ssex) values ('2006','張揚(yáng)','男')
delete from t_student where sno='2006'
delete from t_student where sage=22
create table t_course(
cno int primary key,
cname varchar(10),
ccode int
);
create view as(
select sno,sname,cno,cname,grade from t_student,t_sc,t_course where t_student.sno=t_sc.sno and
t_sc. cno=t_course.cno
);
一吭净。數(shù)據(jù)庫(kù)基本概念:
數(shù)據(jù)睡汹、數(shù)據(jù)庫(kù)。數(shù)據(jù)模型/DBMS(數(shù)據(jù)庫(kù)管理系統(tǒng))/DBS(數(shù)據(jù)庫(kù)系統(tǒng))
二攒钳。數(shù)據(jù)庫(kù)內(nèi)部組成
二維表帮孔、視圖,索引
三不撑,數(shù)據(jù)庫(kù)管理系統(tǒng)主要功能:
六大功能
四數(shù)據(jù)庫(kù)操作語(yǔ)言:
SQL語(yǔ)言實(shí)現(xiàn)增刪查改
實(shí)驗(yàn)內(nèi)容:
1.用VS2010創(chuàng)建名為
insert into T_Student(sno,sname,ssex,sage,sdept) values('','','','','')
select * from T_Student
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2001','李勇','男','20','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2002','劉晨','女','18','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2003','王敏','女','19','MA')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2004','張立','男','22','IS')
insert into T_Course(Cno,Cname,Ccode) values ('1','數(shù)據(jù)庫(kù)','1')
insert into T_Course(Cno,Cname,Ccode) values ('2','英語(yǔ)','4')
insert into T_SC(Cno,Sno,Grade) values ('1','2001','88')
insert into T_SC(Cno,Sno,Grade) values ('2','2002','80')
增加一條學(xué)號(hào)為2006文兢,姓名為張揚(yáng)
insert into T_student(sno,sname,ssex) values ('','','')
(sno,sname,ssex,sage,sdept) ('','','','','')空字符串
select * from t_student where sname='李勇'
select * from t_student where ssex='女'
select sdept from t_student where sname='張立'
select count() from T_student
select max() from t_student
update t_student set ssex='女' where sno='2001'
update t_student set sage='22' where sname='王敏'
update t_student sdept='MA' where ssex='男'
insert into T_Student (sno,sname,ssex) values ('2006','張揚(yáng)','男')
delete from t_student where sno='2006'
delete from t_student where sage=22
create table t_course(
cno int primary key,
cname varchar(10),
ccode int
);
create view as(
select sno,sname,cno,cname,grade from t_student,t_sc,t_course where t_student.sno=t_sc.sno and
t_sc. cno=t_course.cno
);
一。數(shù)據(jù)庫(kù)基本概念:
數(shù)據(jù)焕檬、數(shù)據(jù)庫(kù)姆坚。數(shù)據(jù)模型/DBMS(數(shù)據(jù)庫(kù)管理系統(tǒng))/DBS(數(shù)據(jù)庫(kù)系統(tǒng))
二。數(shù)據(jù)庫(kù)內(nèi)部組成
二維表实愚、視圖兼呵,索引
三,數(shù)據(jù)庫(kù)管理系統(tǒng)主要功能:
六大功能
四數(shù)據(jù)庫(kù)操作語(yǔ)言:
SQL語(yǔ)言實(shí)現(xiàn)增刪查改
實(shí)驗(yàn)內(nèi)容:
1.用VS2010創(chuàng)建名為
insert into T_Student(sno,sname,ssex,sage,sdept) values('','','','','')
select * from T_Student
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2001','李勇','男','20','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2002','劉晨','女','18','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2003','王敏','女','19','MA')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2004','張立','男','22','IS')
insert into T_Course(Cno,Cname,Ccode) values ('1','數(shù)據(jù)庫(kù)','1')
insert into T_Course(Cno,Cname,Ccode) values ('2','英語(yǔ)','4')
insert into T_SC(Cno,Sno,Grade) values ('1','2001','88')
insert into T_SC(Cno,Sno,Grade) values ('2','2002','80')
增加一條學(xué)號(hào)為2006腊敲,姓名為張揚(yáng)
insert into T_student(sno,sname,ssex) values ('','','')
(sno,sname,ssex,sage,sdept) ('','','','','')空字符串
select * from t_student where sname='李勇'
select * from t_student where ssex='女'
select sdept from t_student where sname='張立'
select count() from T_student
select max() from t_student
update t_student set ssex='女' where sno='2001'
update t_student set sage='22' where sname='王敏'
update t_student sdept='MA' where ssex='男'
insert into T_Student (sno,sname,ssex) values ('2006','張揚(yáng)','男')
delete from t_student where sno='2006'
delete from t_student where sage=22
create table t_course(
cno int primary key,
cname varchar(10),
ccode int
);
create view as(
select sno,sname,cno,cname,grade from t_student,t_sc,t_course where t_student.sno=t_sc.sno and
t_sc. cno=t_course.cno
);
一击喂。數(shù)據(jù)庫(kù)基本概念:
數(shù)據(jù)、數(shù)據(jù)庫(kù)碰辅。數(shù)據(jù)模型/DBMS(數(shù)據(jù)庫(kù)管理系統(tǒng))/DBS(數(shù)據(jù)庫(kù)系統(tǒng))
二懂昂。數(shù)據(jù)庫(kù)內(nèi)部組成
二維表、視圖没宾,索引
三凌彬,數(shù)據(jù)庫(kù)管理系統(tǒng)主要功能:
六大功能
四數(shù)據(jù)庫(kù)操作語(yǔ)言:
SQL語(yǔ)言實(shí)現(xiàn)增刪查改
實(shí)驗(yàn)內(nèi)容:
1.用VS2010創(chuàng)建名為
insert into T_Student(sno,sname,ssex,sage,sdept) values('','','','','')
select * from T_Student
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2001','李勇','男','20','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2002','劉晨','女','18','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2003','王敏','女','19','MA')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2004','張立','男','22','IS')
insert into T_Course(Cno,Cname,Ccode) values ('1','數(shù)據(jù)庫(kù)','1')
insert into T_Course(Cno,Cname,Ccode) values ('2','英語(yǔ)','4')
insert into T_SC(Cno,Sno,Grade) values ('1','2001','88')
insert into T_SC(Cno,Sno,Grade) values ('2','2002','80')
增加一條學(xué)號(hào)為2006,姓名為張揚(yáng)
insert into T_student(sno,sname,ssex) values ('','','')
(sno,sname,ssex,sage,sdept) ('','','','','')空字符串
select * from t_student where sname='李勇'
select * from t_student where ssex='女'
select sdept from t_student where sname='張立'
select count() from T_student
select max() from t_student
update t_student set ssex='女' where sno='2001'
update t_student set sage='22' where sname='王敏'
update t_student sdept='MA' where ssex='男'
insert into T_Student (sno,sname,ssex) values ('2006','張揚(yáng)','男')
delete from t_student where sno='2006'
delete from t_student where sage=22
create table t_course(
cno int primary key,
cname varchar(10),
ccode int
);
create view as(
select sno,sname,cno,cname,grade from t_student,t_sc,t_course where t_student.sno=t_sc.sno and
t_sc. cno=t_course.cno
);
``*
實(shí)驗(yàn)內(nèi)容:
1.用VS2010創(chuàng)建名為
insert into T_Student(sno,sname,ssex,sage,sdept) values('','','','','')
select * from T_Student
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2001','李勇','男','20','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2002','劉晨','女','18','CS')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2003','王敏','女','19','MA')
insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('2004','張立','男','22','IS')
insert into T_Course(Cno,Cname,Ccode) values ('1','數(shù)據(jù)庫(kù)','1')
insert into T_Course(Cno,Cname,Ccode) values ('2','英語(yǔ)','4')
insert into T_SC(Cno,Sno,Grade) values ('1','2001','88')
insert into T_SC(Cno,Sno,Grade) values ('2','2002','80')
增加一條學(xué)號(hào)為2006循衰,姓名為張揚(yáng)
insert into T_student(sno,sname,ssex) values ('','','')
(sno,sname,ssex,sage,sdept) ('','','','','')空字符串
select * from t_student where sname='李勇'
select * from t_student where ssex='女'
select sdept from t_student where sname='張立'
select count() from T_student
select max() from t_student
update t_student set ssex='女' where sno='2001'
update t_student set sage='22' where sname='王敏'
update t_student sdept='MA' where ssex='男'
insert into T_Student (sno,sname,ssex) values ('2006','張揚(yáng)','男')
delete from t_student where sno='2006'
delete from t_student where sage=22
create table t_course(
cno int primary key,
cname varchar(10),
ccode int
);
create view as(
select sno,sname,cno,cname,grade from t_student,t_sc,t_course where t_student.sno=t_sc.sno and
t_sc. cno=t_course.cno
);
課程二:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
string strCon = "Data Source =.\\sqlexpress;Initial Catalog=XSGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
string StrUpd = "update T_Student set sage='25' where sname='張立'";
SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
mycmd.ExecuteNonQuery();
string strSel = "select sno as 學(xué)號(hào),sname as 姓名,ssex as 性別,sage as 年齡,sdept as 專業(yè) from T_Student";
SqlDataAdapter myda = new SqlDataAdapter(strSel, mycon);
DataTable dt = new DataTable();
myda.Fill(dt);
dataGridView1.DataSource = dt;
MessageBox.Show("update sucess!");
mycon.Close();
}
//MessageBox.Show("update sucess!");
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
直接界面能改
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace shujuku
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
string strCon = "Data Source =.\\sqlexpress;Initial Catalog=XSGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
//string StrUpd = "update T_Student set sage='25' where sname='張立'";
//SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
//mycmd.ExecuteNonQuery();
string strSel = "select sno as 學(xué)號(hào),sname as 姓名,ssex as 性別,sage as 年齡,sdept as 專業(yè) from T_Student";
SqlDataAdapter myda = new SqlDataAdapter(strSel, mycon);
DataTable dt = new DataTable();
myda.Fill(dt);
dataGridView1.DataSource = dt;
//string StrUpd = "update T_Student set sname='李晨' where sno='2001'";
//SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
//mycmd.ExecuteNonQuery();
//MessageBox.Show("update sucess!");
mycon.Close();
}
//MessageBox.Show("update sucess!");
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
string strCon = "Data Source =.\\sqlexpress;Initial Catalog=XSGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
string sname = textBox1.Text;
string sage = textBox2.Text;
string StrUpd = "update T_Student set sage='" + sage + "' where sname='" + sname + "'";
SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
mycmd.ExecuteNonQuery();
string strSel = "select sno as 學(xué)號(hào),sname as 姓名,ssex as 性別,sage as 年齡,sdept as 專業(yè) from T_Student";
SqlDataAdapter myda = new SqlDataAdapter(strSel, mycon);
DataTable dt = new DataTable();
myda.Fill(dt);
dataGridView1.DataSource = dt;
MessageBox.Show("update sucess!");
mycon.Close();
}
private void richTextBox1_TextChanged(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
}
}
}
界面添加信息
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace shujuku
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
string strCon = "Data Source =.\\sqlexpress;Initial Catalog=XSGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
//string StrUpd = "update T_Student set sage='25' where sname='張立'";
//SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
//mycmd.ExecuteNonQuery();
string strSel = "select sno as 學(xué)號(hào),sname as 姓名,ssex as 性別,sage as 年齡,sdept as 專業(yè) from T_Student";
SqlDataAdapter myda = new SqlDataAdapter(strSel, mycon);
DataTable dt = new DataTable();
myda.Fill(dt);
dataGridView1.DataSource = dt;
//string StrUpd = "update T_Student set sname='李晨' where sno='2001'";
//SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
//mycmd.ExecuteNonQuery();
//MessageBox.Show("update sucess!");
mycon.Close();
}
//MessageBox.Show("update sucess!");
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
string strCon = "Data Source =.\\sqlexpress;Initial Catalog=XSGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
string sname = textBox1.Text;
string sage = textBox2.Text;
string sno = textBox3.Text;
string ssex = textBox4.Text;
string sdept = textBox5.Text;
//string StrUpd = "update T_Student set sage='" + sage + "' where sname='" + sname + "'";
string StrUpd = "insert into T_Student(Sno,Sname,Ssex,Sage,Sdept) values ('"+sno+"','"+sname+"','"+ssex+"','"+sage+"','"+sdept+"')";
SqlCommand mycmd = new SqlCommand(StrUpd, mycon);
mycmd.ExecuteNonQuery();
string strSel = "select sno as 學(xué)號(hào),sname as 姓名,ssex as 性別,sage as 年齡,sdept as 專業(yè) from T_Student";
SqlDataAdapter myda = new SqlDataAdapter(strSel, mycon);
DataTable dt = new DataTable();
myda.Fill(dt);
dataGridView1.DataSource = dt;
MessageBox.Show("update sucess!");
mycon.Close();
}
private void richTextBox1_TextChanged(object sender, EventArgs e)
{
}
private void button3_Click(object sender, EventArgs e)
{
}
}
}
==================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================