CREATE DATABASE MVCLession31
GO
USE MVCLession31
GO
CREATE TABLE Dept (
DeptId int IDENTITY(1,1) PRIMARY KEY NOT NULL,
DeptName varchar(50) NOT NULL
);
GO
CREATE TABLE Employee (
EmpId int IDENTITY(1,1) PRIMARY KEY NOT NULL,
DeptId int NOT NULL,
EmpName varchar(50) NOT NULL,
EmpPhone varchar(50) NOT NULL,
EmpArea varchar(50) NOT NULL,
EmpSalary decimal(18,2) NOT NULL
);
GO
CREATE TABLE UserInfo
(
UserId int identity(1,1) primary key,
UserName varchar(20)not null,
PassWord varchar(20)not null
)
go
insert into UserInfo values ('admin','123456')
insert into Dept values('测试部'),('开发部'),('学习部')
insert into Employee values('1','张三','152989445511','西安','500'),('2','李四','15298944156352','宝鸡','900')
,('3','王五','15299445522','兰州','8500')
ASP.NET-MVC 实现增删改查sql数据库
最新推荐文章于 2023-04-15 19:01:25 发布