- 博客(10)
- 收藏
- 关注
原创 数据库的创建与插入
//数据库的插入--在数据库中根据上述表的定义创建上述数据库,同时需建立相应的约束关系create table [EMPLOYEE]( [EmpNo] varchar(8) not null primary key, [EmpName] varchar(50) not null, [EmpSex] varchar(2) check([EmpSex]='男' or [EmpSex]='女...
2019-03-31 22:57:06 195
原创 前期准备
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;...
2019-03-31 22:52:05 129
原创 统计同时具有两个以上工作员工的总工资
private void button5_Click(object sender, EventArgs e) { string s = "select workers.wnum as 员工号,workers.wname as 员工名,"; s += "sum(relate.wage) as 总工资 from worke...
2019-03-31 22:41:35 222
原创 统计每个老师的总薪酬
private void button6_Click(object sender, EventArgs e) { string s = "select teachers.tname as 姓名,sum(remunerations.wage*courses.ctime) as 总薪酬 "; s += "from cour...
2019-03-31 22:37:16 286
原创 统计只上一门课的老师
private void button5_Click(object sender, EventArgs e) { string s = "select teachers.tname as 姓名,courses.cnum as 课程号,courses.cname as 课程名,"; s += "courses.ctime...
2019-03-31 22:34:56 117
原创 查询至少具有两份工作员工的姓名和其公司名
private void button6_Click(object sender, EventArgs e) { string s = "select employee.empname as 姓名,company.cmpname as 公司名 "; s += "from employee,works,company "; s += "where...
2019-03-31 22:29:39 416
原创 统计限定条件下某数据的总和
private void button5_Click(object sender, EventArgs e) { string s = "select employee.empno as 员工号,employee.empname as 姓名,"; s += "employee.empage as 年龄,sum(work...
2019-03-31 22:25:49 144
原创 统计每个分类人数
//直接按钮搜索 private void button5_Click(object sender, EventArgs e) { string s = "select department.deptno as 系号,department.deptname as 系名,"; s += "sum(class.num) as 人数 "; s += "from clas...
2019-03-31 22:18:15 542
原创 单条件,组合条件查询
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string s = "select department.deptname as 系名称, class1.specname as 专业名称,"; s += "studen...
2019-03-31 22:09:12 468
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人