c#第四次作业

来源：互联网发布：js 获取file文件路径编辑：程序博客网时间：2024/06/05 14:32

MySQL安装配置过程讲解：

首先，在http://dev.mysql.com/downloads/mysql/网址上下载对应电脑版本的mysql压缩包（如：mysql-5.6.24-winx64.zip）。下面以windows64位mysql安装为例说明mysql的安装配置过程。

1.将下载到的mysql-5.6.24-x64.zip进行解压；

2.将解压得到的文件夹复制到相应的地方，如：D:\Mysql;

3..进入文件夹内复制my-default.ini文件，并重命名为my.ini；

4.在my.ini文件内修改如下几行；

basedir = D:\Mysql #mysql的位置，替换为自己的

datadir = D:\Mysql\data #data的位置，替换为自己的

character-set-server = utf-8 #服务端字符集

default-storage-engine = INNODB #存储模式

5.安装mysql服务

以管理员身份运行cmd，进入dos后进入到mysql/bin/目录下，输入mysqld install

如果有以上提示证明mysql已经安装成功；

6.启动mysql，继续输入net start mysql

如果有以上提示证明mysql已经启动成功

7.进入mysql，输入mysql -uroot -p(如果没有设置密码，可直接回车使用mysql)

到此结束，mysql的安装过程就配置完成，这样就可以使用mysql数据库了。

创建数据库、数据表、增删改查操作：

创建数据库：

create database Yan

创建两张数据表：

List_Class1表：

DROP TABLE IF EXISTS `list_class1`;CREATE TABLE `list_class1` (  `id` int(11) NOT NULL,  `学号` varchar(20) NOT NULL,  `姓名` varchar(20) NOT NULL,  `班级` varchar(20) NOT NULL,  `性别` char(4) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

list_class_submit表:

DROP TABLE IF EXISTS `list_class_submit`;CREATE TABLE `list_class_submit` (  `学号` varchar(255) NOT NULL,  `姓名` varchar(255) NOT NULL,  `组别` varchar(255) NOT NULL,  `作业网址` varchar(255) NOT NULL,  PRIMARY KEY (`学号`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

增删改查操作:

插入数据到List_Class1表：

INSERT INTO `list_class1` VALUES ('1', '201111671125', '王康安', '信管1111', '男');INSERT INTO `list_class1` VALUES ('2', '201111671103', '陈特广', '信管1121', '男');INSERT INTO `list_class1` VALUES ('3', '201211671101', '蔡济屹', '信管1121', '男');INSERT INTO `list_class1` VALUES ('4', '201211671102', '蔡小莹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('5', '201211671103', '陈柏安', '信管1121', '男');INSERT INTO `list_class1` VALUES ('6', '201211671105', '冯黄怡', '信管1121', '女');INSERT INTO `list_class1` VALUES ('7', '201211671106', '何慧敏', '信管1121', '女');INSERT INTO `list_class1` VALUES ('8', '201211671107', '何燕玲', '信管1121', '女');INSERT INTO `list_class1` VALUES ('9', '201211671108', '黄春妹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('10', '201211671109', '黄立沛', '信管1121', '男');INSERT INTO `list_class1` VALUES ('11', '201211671110', '赖嘉仁', '信管1121', '男');INSERT INTO `list_class1` VALUES ('12', '201211671111', '黎绮霞', '信管1121', '女');INSERT INTO `list_class1` VALUES ('13', '201211671112', '李思婷', '信管1121', '女');INSERT INTO `list_class1` VALUES ('14', '201211671113', '练晓发', '信管1121', '男');INSERT INTO `list_class1` VALUES ('15', '201211671115', '刘仙妹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('16', '201211671116', '卢泳蓬', '信管1121', '男');INSERT INTO `list_class1` VALUES ('17', '201211671117', '聂双燕', '信管1121', '女');INSERT INTO `list_class1` VALUES ('18', '201211671118', '宋晓茹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('19', '201211671119', '谭玉梅', '信管1121', '女');INSERT INTO `list_class1` VALUES ('20', '201211671120', '汤梓苡', '信管1121', '男');INSERT INTO `list_class1` VALUES ('21', '201211671121', '王晓俊', '信管1121', '男');INSERT INTO `list_class1` VALUES ('22', '201211671122', '吴丹妮', '信管1121', '女');INSERT INTO `list_class1` VALUES ('23', '201211671124', '吴明辉', '信管1121', '男');INSERT INTO `list_class1` VALUES ('24', '201211671125', '严登辉', '信管1121', '男');INSERT INTO `list_class1` VALUES ('25', '201211671126', '余姣', '信管1121', '女');INSERT INTO `list_class1` VALUES ('26', '201211671127', '曾婷', '信管1121', '女');INSERT INTO `list_class1` VALUES ('27', '201211671131', '朱嘉颖', '信管1121', '女');INSERT INTO `list_class1` VALUES ('28', '201211671132', '朱文婷', '信管1121', '');INSERT INTO `list_class1` VALUES ('id', '学号', '姓名', '班级', '性别');INSERT INTO `list_class1` VALUES ('1', '201111671125', '王康安', '信管1111', '男');INSERT INTO `list_class1` VALUES ('2', '201111671103', '陈特广', '信管1121', '男');INSERT INTO `list_class1` VALUES ('3', '201211671101', '蔡济屹', '信管1121', '男');INSERT INTO `list_class1` VALUES ('4', '201211671102', '蔡小莹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('5', '201211671103', '陈柏安', '信管1121', '男');INSERT INTO `list_class1` VALUES ('6', '201211671105', '冯黄怡', '信管1121', '女');INSERT INTO `list_class1` VALUES ('7', '201211671106', '何慧敏', '信管1121', '女');INSERT INTO `list_class1` VALUES ('8', '201211671107', '何燕玲', '信管1121', '女');INSERT INTO `list_class1` VALUES ('9', '201211671108', '黄春妹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('10', '201211671109', '黄立沛', '信管1121', '男');INSERT INTO `list_class1` VALUES ('11', '201211671110', '赖嘉仁', '信管1121', '男');INSERT INTO `list_class1` VALUES ('12', '201211671111', '黎绮霞', '信管1121', '女');INSERT INTO `list_class1` VALUES ('13', '201211671112', '李思婷', '信管1121', '女');INSERT INTO `list_class1` VALUES ('14', '201211671113', '练晓发', '信管1121', '男');INSERT INTO `list_class1` VALUES ('15', '201211671115', '刘仙妹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('16', '201211671116', '卢泳蓬', '信管1121', '男');INSERT INTO `list_class1` VALUES ('17', '201211671117', '聂双燕', '信管1121', '女');INSERT INTO `list_class1` VALUES ('18', '201211671118', '宋晓茹', '信管1121', '女');INSERT INTO `list_class1` VALUES ('19', '201211671119', '谭玉梅', '信管1121', '女');INSERT INTO `list_class1` VALUES ('20', '201211671120', '汤梓苡', '信管1121', '男');INSERT INTO `list_class1` VALUES ('21', '201211671121', '王晓俊', '信管1121', '男');INSERT INTO `list_class1` VALUES ('22', '201211671122', '吴丹妮', '信管1121', '女');INSERT INTO `list_class1` VALUES ('23', '201211671124', '吴明辉', '信管1121', '男');INSERT INTO `list_class1` VALUES ('24', '201211671125', '严登辉', '信管1121', '男');INSERT INTO `list_class1` VALUES ('25', '201211671126', '余姣', '信管1121', '女');INSERT INTO `list_class1` VALUES ('26', '201211671127', '曾婷', '信管1121', '女');INSERT INTO `list_class1` VALUES ('27', '201211671131', '朱嘉颖', '信管1121', '女');INSERT INTO `list_class1` VALUES ('28', '201211671132', '朱文婷', '信管1121', '');

插入数据到list_class_submit表：

INSERT INTO `list_class_submit` VALUES ('201111671103', '陈特广', '1', 'http://blog.csdn.net/wmctg');INSERT INTO `list_class_submit` VALUES ('201211671101', '蔡济屹', '1', 'http://user.qzone.qq.com/455284214/2');INSERT INTO `list_class_submit` VALUES ('201211671102', '蔡小莹', '2', 'http://user.qzone.qq.com/875845926/2');INSERT INTO `list_class_submit` VALUES ('201211671105', '冯黄怡', '2', 'http://user.qzone.qq.com/1084307334/2');INSERT INTO `list_class_submit` VALUES ('201211671106', '何慧敏', '2', 'http://user.qzone.qq.com/972692752/blog/1429881102');INSERT INTO `list_class_submit` VALUES ('201211671107', '何燕玲', '2', 'http://user.qzone.qq.com/464526648/2');INSERT INTO `list_class_submit` VALUES ('201211671108', '黄春妹', '1', 'http://user.qzone.qq.com/441924163/2');INSERT INTO `list_class_submit` VALUES ('201211671109', '黄立沛', '2', 'http://user.qzone.qq.com/505979562/blog/1429674155');INSERT INTO `list_class_submit` VALUES ('201211671110', '赖嘉仁', '2', 'http://user.qzone.qq.com/1006005105/2');INSERT INTO `list_class_submit` VALUES ('201211671111', '黎绮霞', '2', 'http://user.qzone.qq.com/872690037/2');INSERT INTO `list_class_submit` VALUES ('201211671113', '练晓发', '2', 'http://user.qzone.qq.com/3172847284/2');INSERT INTO `list_class_submit` VALUES ('201211671115', '刘仙妹', '2', 'http://blog.sina.com.cn/s/articlelist_3103209883_0_1.html');INSERT INTO `list_class_submit` VALUES ('201211671116', '卢泳蓬', '2', 'http://user.qzone.qq.com/562522461/infocenter?ptsig=jj1diPyK1T66wENiUEvdl5iUgzJ7Wmt77T82WCN1dfk_');INSERT INTO `list_class_submit` VALUES ('201211671117', '聂双燕', '1', 'http://blog.csdn.net/sunshinegyan');INSERT INTO `list_class_submit` VALUES ('201211671118', '宋晓茹', '2', 'http://user.qzone.qq.com/2990793957/2');INSERT INTO `list_class_submit` VALUES ('201211671119', '谭玉梅', '2', 'http://user.qzone.qq.com/775283604/2');INSERT INTO `list_class_submit` VALUES ('201211671120', '汤梓苡', '2', 'http://user.qzone.qq.com/2936587896/blog/1428413844');INSERT INTO `list_class_submit` VALUES ('201211671121', '王晓俊', '1', 'http://blog.csdn.net/wxj416313490');INSERT INTO `list_class_submit` VALUES ('201211671122', '吴丹妮', '2', 'http://user.qzone.qq.com/765455471/2');INSERT INTO `list_class_submit` VALUES ('201211671124', '吴明辉', '2', 'http://user.qzone.qq.com/3178137745?ptlang=2052');INSERT INTO `list_class_submit` VALUES ('201211671125', '严登辉', '2', 'http://user.qzone.qq.com/1304809765/blog/1429442799');INSERT INTO `list_class_submit` VALUES ('201211671126', '余姣', '2', 'http://user.qzone.qq.com/1253608680/2');INSERT INTO `list_class_submit` VALUES ('201211671127', '曾婷', '2', 'http://user.qzone.qq.com/2977875161/2');INSERT INTO `list_class_submit` VALUES ('201211671131', '朱嘉颖', '2', 'http://blog.163.com/yingying8013@126/blog/#m=0');INSERT INTO `list_class_submit` VALUES ('201211671132', '朱文婷', '2', 'http://user.qzone.qq.com/465293182/2');INSERT INTO `list_class_submit` VALUES ('学号', '姓名', '组别', '作业网址');

查找所有出现在“List_Class1”中，未出现在“list_class_submit” 的学生名单

SELECTtest2.`学号`,test2.`姓名`FROMtest2WHEREtest2.`姓名` NOT IN (SELECT `姓名` from list_class_submit) ;

0 0