跟大佬学的:2015华工复试数据库题目详细步骤
以下是2016年的题目:
一、数据库设计
手动打开SQL Server代理(从来记不住,总是等到Sqlserver连不上才打开)
(1)打开数据库后,新建数据库,新建查询,建表代码:
use Student2016;
-- 因为三张表之间的以来关系,建表顺序如下
create table Department
( deptNo varchar(2) primary key,
deptName varchar(30) not null
)
create table CLASS
( classNo varchar(5) primary key,
specName varchar(30) not null,
deptNo varchar(2) not null,
[year] int check([year]>0) not null,
num int check(num<=30 and num>=0)not null,
foreign key (deptNo) references Department(deptNo)
)
create table Student
( SNo varchar(5) primary key,
SName varchar(20) not null,
[Date] date,
classNo varchar(5),
foreign key (classNo) references CLASS(classNo)
)
因为题目非要给的列名有关键词,所以加上[]才行
(2)插入数据
insert into Department values('1','数学');
insert into Department values('2','计算机');
insert into Department values('3','化学');
insert into CLASS values('101','软件','2',2012,25);
insert into CLASS values('102','微电子','2',2013,28);
insert into CLASS values('111','无机化学','3',2012,20);
insert into CLASS values('112','高分子化学','3',2013,19);
insert into CLASS values('121','统计数学','1',2013,11);
insert into Student values('8101','张三','1996-7-9','101');
insert into Student values('8102','钱四','1996-2-6','121');
insert into Student values('8105','李飞','1994-1-21','102');
insert into Student values('8201','张飞','1996-2-25','111');
insert into Student values('8302','周瑜','1996-6-15','112');
insert into Student values('8203','王亮','1997-5-27','111');
insert into Student values('8305','董庆','1996-4-2','102');
insert into Student values('8409','赵龙','1995-6-1','101');
(3)全选,点击 执行完成后,右击建立的数据库->任务->备份,添加题目要求的路径,备份的文件类型是.bak
完成!不要关掉SQLServer
二、VS200 C#管理系统设计
(1)新建项目,填写题目中的路径。一共建了两个窗体,Form1是主窗体,Form2用来在数据维护功能传入学生信息
(2)Form1如下
右下角有Properties设置
Form1 设置
formBorder: fixedSingle
StartPosition: center
MaximizeBox = false
MinimizeBox = false
四个tabPage的 Text 依次设置为查询,统计1,统计2,数据维护
listView的设置是
View = Details
FullRowSelect=True
MultiSelect = false
gridLine =true
(3)Form2如下
(4)用来连接数据库的类DB.cs
server='值1' 值1是打开SqlServer时用的用户名
database='值2' 值2是连接的数据库的名字
using System;
using System.Collections.Generic;
using System.Text;
using System.Data; //添加
using System.Data.SqlClient; //添加
namespace Anita
{
class DB
{
private SqlConnection sqlConnection;
public DB()
{//连接
sqlConnection = new S