.net连接mysql数据库
作业为 ：
针对LearDB数据库实现一个菜单，菜单项包括
1、显示所有学生:每个学生的信息占一行:每个学生的信息项包括学号姓名、性别、出生日期、班级名称、联系电话，各项以Tab分隔
2、按姓名查询成绩:输入学生姓名，显示学生成绩，包括学号、姓名、班级名称、课程名称、期末成绩(score1)，各项以Tab分隔,分行显示
3、输入学生信息:输入学生各项信息
4、输入一个学号，修改其姓名为“张三”，电话改为10088
5、输入学号，删除该同学的成绩记录
0、退出系统:程序退出
数据库sql（mysql）（备注：sqlserver就不提供了）
---------------------------------------------------------------------------------------------------------------sql
/*
Navicat MySQL Data Transfer
Source Server : wang
Source Server Version : 50720
Source Host : 127.0.0.1:3306
Source Database : learndb
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2018-11-04 22:18:40
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`emp_id` varchar(4) DEFAULT NULL,
`fname` varchar(5) DEFAULT NULL,
`sexy` varchar(2) DEFAULT NULL,
`lname` varchar(4) DEFAULT NULL,
`job_id` smallint(6) DEFAULT NULL,
`job_lvl` int(11) DEFAULT NULL,
`pub_id` varchar(4) DEFAULT NULL,
`hire_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of employee
-- ----------------------------
-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`sid` varchar(12) DEFAULT NULL,
`Sname` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('12005001', '李山 ');
INSERT INTO `test` VALUES ('12005002', '张飞 ');
INSERT INTO `test` VALUES ('12005003', '李玉和 ');
INSERT INTO `test` VALUES ('12005004', '王一飞 ');
INSERT INTO `test` VALUES ('12006001', '韦宝 ');
INSERT INTO `test` VALUES ('12006002', '李飞 ');
INSERT INTO `test` VALUES ('12006003', '冯玉 ');
INSERT INTO `test` VALUES ('12006004', '马观 ');
INSERT INTO `test` VALUES ('12007001', '李知 ');
INSERT INTO `test` VALUES ('12007002', '吴飞 ');
INSERT INTO `test` VALUES ('12007003', '李凡 ');
INSERT INTO `test` VALUES ('12007004', '王一飞 ');
INSERT INTO `test` VALUES ('32005005', '徐红 ');
INSERT INTO `test` VALUES ('32005006', '刘和 ');
INSERT INTO `test` VALUES ('32005007', '刘山 ');
INSERT INTO `test` VALUES ('32006005', '徐一红 ');
INSERT INTO `test` VALUES ('32006006', '刘一和 ');
INSERT INTO `test` VALUES ('32006007', '马西 ');
INSERT INTO `test` VALUES ('32007005', '王红 ');
INSERT INTO `test` VALUES ('32007006', '王一红 ');
INSERT INTO `test` VALUES ('32007007', '丁西 ');
INSERT INTO `test` VALUES ('82005008', '刘去山 ');
INSERT INTO `test` VALUES ('82005009', '白云飞 ');
INSERT INTO `test` VALUES ('82006008', '刘问计 ');
INSERT INTO `test` VALUES ('82006009', '白问礼 ');
INSERT INTO `test` VALUES ('82007008', '刘红丽 ');
INSERT INTO `test` VALUES ('82007009', '沈学云 ');
INSERT INTO `test` VALUES ('92005010', '白云 ');
INSERT INTO `test` VALUES ('92006010', '白云 ');
INSERT INTO `test` VALUES ('92007010', '李风 ');
INSERT INTO `test` VALUES ('112005011', '李红 ');
INSERT INTO `test` VALUES ('112005012', '周磊 ');
INSERT INTO `test` VALUES ('112005013', '冯圭 ');
INSERT INTO `test` VALUES ('112006011', '李玉红 ');
INSERT INTO `test` VALUES ('112006012', '冯磊 ');
INSERT INTO `test` VALUES ('112006013', '冯由 ');
INSERT INTO `test` VALUES ('112007011', '刘好 ');
INSERT INTO `test` VALUES ('112007012', '周成 ');
INSERT INTO `test` VALUES ('112007013', '文成 ');
-- ----------------------------
-- Table structure for ucourse
-- ----------------------------
DROP TABLE IF EXISTS `ucourse`;
CREATE TABLE `ucourse` (
`Cid` char(4) DEFAULT NULL,
`Cname` char(20) DEFAULT NULL,
`credit` double DEFAULT NULL,
`pcid` char(4) DEFAULT NULL,
`chour` smallint(6) DEFAULT NULL,
`cattr` char(6) DEFAULT NULL,
`cnum` int(11) DEFAULT NULL,
`did` char(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ucourse
-- ----------------------------
INSERT INTO `ucourse` VALUES ('1', '数据库', '4', '5', '72', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('10', '统计与审计', '5', '9', '90', '必修', '90', 'EM');
INSERT INTO `ucourse` VALUES ('11', '刺绣', '1', null, '18', '选修', '50', 'EL');
INSERT INTO `ucourse` VALUES ('12', '家庭保健', '1', null, '18', '选修', '30', 'EL');
INSERT INTO `ucourse` VALUES ('2', '数学', '3', null, '54', '必修', '90', 'SD');
INSERT INTO `ucourse` VALUES ('3', '信息系统与数据库', '3', '1', '54', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('4', '操作系统', '4', '6', '72', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('5', '数据结构', '5', '7', '90', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('6', '计算机基础', '3', null, '54', '必修', '70', 'CS');
INSERT INTO `ucourse` VALUES ('7', 'C语言', '2', '6', '36', '必修', '70', 'CS');
INSERT INTO `ucourse` VALUES ('8', '计算机组成原理', '3', null, '54', '选修', '120', 'CS');
INSERT INTO `ucourse` VALUES ('9', '会计学原理', '5', '2', '90', '必修', '90', 'EM');
-- ----------------------------
-- Table structure for udept
-- ----------------------------
DROP TABLE IF EXISTS `udept`;
CREATE TABLE `udept` (
`did` char(2) DEFAULT NULL,
`dname` varchar(20) DEFAULT NULL,
`daddr` varchar(20) DEFAULT NULL,
`dtele` varchar(16) DEFAULT NULL,
`demail` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of udept
-- ----------------------------
INSERT INTO `udept` VALUES ('CS', '计算机科学与技术系', 'SL604', '87678976', 'cs@nit.com');
INSERT INTO `udept` VALUES ('EL', '外校', null, '62765678', null);
INSERT INTO `udept` VALUES ('EM', '经济管理系', 'SC302', '87464789', 'em@nit.com');
INSERT INTO `udept` VALUES ('FD', '外语分院', 'SA401', '65656798', 'fd@nit.com');
INSERT INTO `udept` VALUES ('IT', '信息科学与技术系', 'SL704', '88767864', 'it@nit.com');
INSERT INTO `udept` VALUES ('SD', '理学院', 'NB309', '67536387', 'sd@nit.com');
-- ----------------------------
-- Table structure for ugrade
-- ----------------------------
DROP TABLE IF EXISTS `ugrade`;
CREATE TABLE `ugrade` (
`gid` char(2) DEFAULT NULL,
`gname` char(20) DEFAULT NULL,
`gyear` int(11) DEFAULT NULL,
`did` char(2) DEFAULT NULL,
`tid` char(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ugrade
-- ----------------------------
INSERT INTO `ugrade` VALUES ('01', '计算机科学与技术1班', '2006', 'CS', '02008');
INSERT INTO `ugrade` VALUES ('02', '计算机科学与技术2班', '2006', 'CS', '02008');
INSERT INTO `ugrade` VALUES ('03', '计算机科学与技术3班', '2006', 'CS', '02008');
INSERT INTO `ugrade` VALUES ('04', '软件工程1班', '2007', 'CS', '02009');
INSERT INTO `ugrade` VALUES ('05', '软件工程2班', '2007', 'CS', null);
INSERT INTO `ugrade` VALUES ('06', '自动化1班', '2008', 'IT', '03014');
INSERT INTO `ugrade` VALUES ('07', '自动化2班', '2008', 'IT', '03014');
INSERT INTO `ugrade` VALUES ('08', '电子信息1班', '2008', 'IT', '02006');
INSERT INTO `ugrade` VALUES ('09', '电子信息2班', '2008', 'IT', null);
INSERT INTO `ugrade` VALUES ('10', '电子信息3班', '2008', 'IT', null);
INSERT INTO `ugrade` VALUES ('11', '财务管理', '2006', 'EM', '03010');
INSERT INTO `ugrade` VALUES ('12', '旅游管理', '2006', 'EM', '03011');
INSERT INTO `ugrade` VALUES ('13', '营销管理', '2006', 'EM', null);
INSERT INTO `ugrade` VALUES ('14', '信息管理', '2006', 'EM', null);
INSERT INTO `ugrade` VALUES ('15', '日语', '2005', 'FD', '03012');
INSERT INTO `ugrade` VALUES ('16', '德语1班', '2005', 'FD', '03013');
INSERT INTO `ugrade` VALUES ('17', '德语2班', '2005', 'FD', '03013');
INSERT INTO `ugrade` VALUES ('18', '应用数学1班', '2008', 'SD', null);
INSERT INTO `ugrade` VALUES ('Z0', '选修混合', null, null, null);
-- ----------------------------
-- Table structure for ujobtable
-- ----------------------------
DROP TABLE IF EXISTS `ujobtable`;
CREATE TABLE `ujobtable` (
`jid` int(11) DEFAULT NULL,
`cid` char(4) DEFAULT NULL,
`room` char(10) DEFAULT NULL,
`tid` char(5) DEFAULT NULL,
`week` int(11) DEFAULT NULL,
`timeseg` char(8) DEFAULT NULL,
`gid` char(2) DEFAULT NULL,
`term` char(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ujobtable
-- ----------------------------
INSERT INTO `ujobtable` VALUES ('1', '1', 'NB222', '02001', '4', '123', '01', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('2', '1', 'NB222', '02002', '2', '345', '01', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('3', '2', 'NB222', '02003', '1', '34', '03', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('4', '3', 'NB223', '02004', '5', '678', '01', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('5', '5', 'NB224', '02005', '3', '34', '05', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('6', '6', 'NB225', '02006', '1', '67', '05', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('7', '7', 'NB226', '02007', '4', '89', '03', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('8', '9', 'NB227', '02008', '4', '678', '08', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('9', '11', 'NB228', '02009', '2', 'AB', '09', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('10', '2', 'NB229', '03010', '1', '123', '02', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('11', '4', 'NB230', '02001', '5', '345', '02', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('12', '5', 'NB231', '02002', '3', '123', '03', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('13', '6', 'NB222', '02003', '1', '89', '09', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('14', '7', 'NB223', '02004', '4', '67', '13', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('15', '9', 'NB224', '02005', '4', '345', '15', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('16', '3', 'NB225', '02006', '2', '89', '13', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('17', '4', 'NB226', '02007', '2', '12', '15', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('18', '10', 'NB227', '02008', '5', '123', '03', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('19', '10', 'NB228', '02009', '3', 'AB', 'Z0', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('20', '12', 'NB229', '03010', '1', 'AB', 'Z0', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('21', '4', 'NB230', '02001', '2', '34', '12', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('22', '3', 'NB231', '02002', '4', '345', '09', '2008-2009-1');
INSERT INTO `ujobtable` VALUES ('24', '1', 'NB222', '02003', '5', '12', '09', '2008-2009-1');
-- ----------------------------
-- Table structure for usc
-- ----------------------------
DROP TABLE IF EXISTS `usc`;
CREATE TABLE `usc` (
`scid` bigint(20) DEFAULT NULL,
`sid` char(9) DEFAULT NULL,
`cid` char(4) DEFAULT NULL,
`term` char(12) DEFAULT NULL,
`score1` double DEFAULT NULL,
`score2` double DEFAULT NULL,
`score3` double DEFAULT NULL,
`score` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usc
-- ----------------------------
INSERT INTO `usc` VALUES ('1', '012005001', '1', '2008-2009-1', '93', '90', '0', '0');
INSERT INTO `usc` VALUES ('2', '012005002', '1', '2008-2009-1', '72', '89', '0', '0');
INSERT INTO `usc` VALUES ('3', '012005003', '1', '2008-2009-1', '89', '89', '0', '0');
INSERT INTO `usc` VALUES ('4', '012005004', '1', '2008-2009-1', '86', '78', '0', '0');
INSERT INTO `usc` VALUES ('5', '032005005', '1', '2008-2009-1', '80', '65', '0', '0');
INSERT INTO `usc` VALUES ('6', '032005006', '1', '2008-2009-1', '88', '76', '0', '0');
INSERT INTO `usc` VALUES ('7', '032005007', '1', '2008-2009-1', '67', '56', '0', '0');
INSERT INTO `usc` VALUES ('8', '012005001', '4', '2008-2009-1', '67', '50', '0', '0');
INSERT INTO `usc` VALUES ('9', '012005002', '4', '2008-2009-1', '36', '78', '0', '0');
INSERT INTO `usc` VALUES ('10', '012005004', '4', '2008-2009-1', '87', '98', '0', '0');
INSERT INTO `usc` VALUES ('11', '032005007', '4', '2008-2009-1', '54', '79', '0', '0');
INSERT INTO `usc` VALUES ('12', '012005001', '3', '2008-2009-2', '45', '93', '0', '0');
INSERT INTO `usc` VALUES ('13', '012005002', '3', '2008-2009-2', '78', '48', '0', '0');
INSERT INTO `usc` VALUES ('14', '012005003', '3', '2008-2009-2', '72', '89', '0', '0');
INSERT INTO `usc` VALUES ('15', '012005004', '3', '2008-2009-2', '60', '86', '0', '0');
INSERT INTO `usc` VALUES ('16', '032005005', '8', '2008-2009-2', '60', '80', '0', '0');
INSERT INTO `usc` VALUES ('17', '032005006', '8', '2008-2009-2', '90', '88', '0', '0');
INSERT INTO `usc` VALUES ('18', '032005007', '8', '2008-2009-2', '89', '67', '0', '0');
INSERT INTO `usc` VALUES ('19', '082005008', '8', '2008-2009-2', '93', '65', '0', '0');
INSERT INTO `usc` VALUES ('20', '082005009', '5', '2008-2009-2', '72', '78', '0', '0');
INSERT INTO `usc` VALUES ('21', '092005010', '5', '2008-2009-2', '89', '77', '0', '0');
INSERT INTO `usc` VALUES ('22', '112005011', '5', '2008-2009-2', '86', '90', '0', '0');
INSERT INTO `usc` VALUES ('23', '112005012', '5', '2008-2009-2', '80', '45', '0', '0');
INSERT INTO `usc` VALUES ('24', '112005013', '5', '2008-2009-2', '88', '89', '0', '0');
INSERT INTO `usc` VALUES ('25', '012006001', '10', '2008-2009-2', '67', '67', '0', '0');
INSERT INTO `usc` VALUES ('26', '012006002', '10', '2008-2009-2', '67', '36', '0', '0');
INSERT INTO `usc` VALUES ('27', '012006003', '10', '2008-2009-2', '36', '87', '0', '0');
INSERT INTO `usc` VALUES ('28', '012006004', '10', '2008-2009-2', '87', '54', '0', '0');
INSERT INTO `usc` VALUES ('29', '032006005', '10', '2008-2009-2', '54', '45', '0', '0');
INSERT INTO `usc` VALUES ('30', '032006006', '10', '2008-2009-2', '45', '78', '0', '0');
INSERT INTO `usc` VALUES ('31', '032006007', '10', '2008-2009-2', '78', '72', '0', '0');
INSERT INTO `usc` VALUES ('32', '082006008', '10', '2007-2008-2', '72', '60', '0', '0');
INSERT INTO `usc` VALUES ('33', '082006009', '12', '2007-2008-2', '60', '60', '0', '0');
INSERT INTO `usc` VALUES ('34', '092006010', '12', '2007-2008-2', '60', '90', '0', '0');
INSERT INTO `usc` VALUES ('35', '112006011', '12', '2007-2008-2', '90', '89', '0', '0');
INSERT INTO `usc` VALUES ('36', '112006012', '12', '2007-2008-2', '89', '89', '0', '0');
INSERT INTO `usc` VALUES ('37', '112006013', '12', '2007-2008-2', '93', '78', '0', '0');
INSERT INTO `usc` VALUES ('38', '012007001', '11', '2007-2008-2', '72', '65', '0', '0');
INSERT INTO `usc` VALUES ('39', '012007002', '11', '2007-2008-2', '89', '76', '0', '0');
INSERT INTO `usc` VALUES ('40', '012007003', '11', '2007-2008-2', '86', '56', '0', '0');
INSERT INTO `usc` VALUES ('41', '012007004', '11', '2007-2008-2', '80', '50', '0', '0');
INSERT INTO `usc` VALUES ('42', '032007005', '11', '2007-2008-2', '88', '78', '0', '0');
INSERT INTO `usc` VALUES ('43', '032007006', '11', '2007-2008-2', '67', '98', '0', '0');
INSERT INTO `usc` VALUES ('44', '032007007', '11', '2007-2008-2', '67', '79', '0', '0');
INSERT INTO `usc` VALUES ('45', '082007008', '9', '2007-2008-2', '36', '93', '0', '0');
INSERT INTO `usc` VALUES ('46', '082007009', '9', '2007-2008-2', '87', '72', '0', '0');
INSERT INTO `usc` VALUES ('47', '092007010', '9', '2008-2009-1', '54', '89', '0', '0');
INSERT INTO `usc` VALUES ('48', '112007011', '9', '2008-2009-1', '45', '86', '0', '0');
INSERT INTO `usc` VALUES ('49', '112007012', '9', '2008-2009-1', '78', '80', '0', '0');
INSERT INTO `usc` VALUES ('50', '112007013', '9', '2008-2009-1', '72', '88', '0', '0');
INSERT INTO `usc` VALUES ('51', '012005001', '9', '2008-2009-1', '60', '67', '0', '0');
INSERT INTO `usc` VALUES ('52', '012005002', '9', '2008-2009-1', '60', '54', '0', '0');
INSERT INTO `usc` VALUES ('53', '012005003', '9', '2008-2009-1', '90', '78', '0', '0');
INSERT INTO `usc` VALUES ('54', '012005004', '9', '2008-2009-1', '89', '77', '0', '0');
INSERT INTO `usc` VALUES ('55', '032005005', '2', '2008-2009-1', '93', '90', '0', '0');
INSERT INTO `usc` VALUES ('56', '032005006', '2', '2008-2009-1', '72', '45', '0', '0');
INSERT INTO `usc` VALUES ('57', '032005007', '2', '2008-2009-1', '89', '89', '0', '0');
INSERT INTO `usc` VALUES ('58', '082005008', '2', '2008-2009-1', '86', '67', '0', '0');
INSERT INTO `usc` VALUES ('59', '082005009', '2', '2008-2009-1', '80', '36', '0', '0');
INSERT INTO `usc` VALUES ('60', '092005010', '2', '2008-2009-1', '88', '87', '0', '0');
INSERT INTO `usc` VALUES ('61', '112005011', '2', '2008-2009-1', '67', '54', '0', '0');
INSERT INTO `usc` VALUES ('62', '112005012', '2', '2008-2009-1', '67', '45', '0', '0');
INSERT INTO `usc` VALUES ('63', '112005013', '2', '2008-2009-1', '36', '78', '0', '0');
INSERT INTO `usc` VALUES ('64', '012006001', '2', '2008-2009-1', '87', '72', '0', '0');
INSERT INTO `usc` VALUES ('65', '012006002', '6', '2008-2009-1', '54', '60', '0', '0');
INSERT INTO `usc` VALUES ('66', '012006003', '6', '2008-2009-1', '45', '60', '0', '0');
INSERT INTO `usc` VALUES ('67', '012006004', '6', '2008-2009-1', '78', '90', '0', '0');
INSERT INTO `usc` VALUES ('68', '032006005', '6', '2008-2009-1', '72', '89', '0', '0');
INSERT INTO `usc` VALUES ('69', '032006006', '6', '2008-2009-1', '60', '89', '0', '0');
INSERT INTO `usc` VALUES ('70', '032006007', '6', '2008-2009-1', '60', '78', '0', '0');
INSERT INTO `usc` VALUES ('71', '082006008', '6', '2008-2009-1', '90', '65', '0', '0');
INSERT INTO `usc` VALUES ('72', '082006009', '6', '2008-2009-1', '89', '76', '0', '0');
INSERT INTO `usc` VALUES ('73', '092006010', '6', '2007-2008-1', '93', '56', '0', '0');
INSERT INTO `usc` VALUES ('74', '112006011', '6', '2007-2008-1', '72', '50', '0', '0');
INSERT INTO `usc` VALUES ('75', '112006012', '6', '2007-2008-1', '89', '78', '0', '0');
INSERT INTO `usc` VALUES ('76', '112006013', '6', '2007-2008-1', '86', '98', '0', '0');
INSERT INTO `usc` VALUES ('77', '012007001', '7', '2007-2008-1', '80', '79', '0', '0');
INSERT INTO `usc` VALUES ('78', '012007002', '7', '2007-2008-1', '88', '93', '0', '0');
INSERT INTO `usc` VALUES ('79', '012007003', '7', '2007-2008-1', '67', '72', '0', '0');
INSERT INTO `usc` VALUES ('80', '012007004', '7', '2007-2008-1', '67', '89', '0', '0');
INSERT INTO `usc` VALUES ('81', '032007005', '7', '2007-2008-1', '36', '86', '0', '0');
INSERT INTO `usc` VALUES ('82', '032007006', '7', '2007-2008-1', '87', '80', '0', '0');
INSERT INTO `usc` VALUES ('83', '032007007', '7', '2007-2008-1', '54', '88', '0', '0');
INSERT INTO `usc` VALUES ('84', '082007008', '7', '2007-2008-1', '45', '67', '0', '0');
INSERT INTO `usc` VALUES ('85', '082007009', '7', '2007-2008-1', '78', '65', '0', '0');
INSERT INTO `usc` VALUES ('86', '092007010', '7', '2007-2008-1', '72', '78', '0', '0');
INSERT INTO `usc` VALUES ('87', '112007011', '7', '2007-2008-1', '60', '77', '0', '0');
INSERT INTO `usc` VALUES ('88', '112007012', '7', '2007-2008-1', '60', '90', '0', '0');
INSERT INTO `usc` VALUES ('89', '112007013', '7', '2007-2008-1', '90', '45', '0', '0');
-- ----------------------------
-- Table structure for ustudent
-- ----------------------------
DROP TABLE IF EXISTS `ustudent`;
CREATE TABLE `ustudent` (
`Sid` char(9) DEFAULT NULL,
`Sname` char(8) DEFAULT NULL,
`Ssexy` char(2) DEFAULT NULL,
`Sbdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`gid` char(2) DEFAULT NULL,
`stele` char(11) DEFAULT NULL,
`QQ` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ustudent
-- ----------------------------
INSERT INTO `ustudent` VALUES ('012005001', '李山', '男', '1988-10-11 00:00:00', '01', '660780', '000');
INSERT INTO `ustudent` VALUES ('012005002', '张飞', '男', '1987-10-11 00:00:00', '01', '660781', '000');
INSERT INTO `ustudent` VALUES ('012005003', '李玉和', '女', '1989-10-11 00:00:00', '01', '660782', '000');
INSERT INTO `ustudent` VALUES ('012005004', '王一飞', '女', '1990-10-11 00:00:00', '01', '660783', '000');
INSERT INTO `ustudent` VALUES ('012006001', '韦宝', '男', '1988-10-11 00:00:00', '01', '660780', '000');
INSERT INTO `ustudent` VALUES ('012006002', '李飞', '男', '1987-10-11 00:00:00', '01', '660781', '000');
INSERT INTO `ustudent` VALUES ('012006003', '冯玉', '女', '1989-10-11 00:00:00', '01', '660782', '000');
INSERT INTO `ustudent` VALUES ('012006004', '马观', '女', '1990-10-11 00:00:00', '01', '660783', '000');
INSERT INTO `ustudent` VALUES ('012007001', '李知', '男', '1988-10-11 00:00:00', '01', '660780', '000');
INSERT INTO `ustudent` VALUES ('012007002', '吴飞', '男', '1987-10-11 00:00:00', '01', '660781', '000');
INSERT INTO `ustudent` VALUES ('012007003', '李凡', '女', '1989-10-11 00:00:00', '01', '660782', '000');
INSERT INTO `ustudent` VALUES ('012007004', '王一飞', '女', '1990-10-11 00:00:00', '01', '660783', '000');
INSERT INTO `ustudent` VALUES ('032005005', '徐红', '女', '1988-01-11 00:00:00', '03', '660784', '000');
INSERT INTO `ustudent` VALUES ('032005006', '刘和', '男', '1988-12-11 00:00:00', '03', '660785', '000');
INSERT INTO `ustudent` VALUES ('032005007', '刘山', '男', '1989-10-01 00:00:00', '03', '660786', '000');
INSERT INTO `ustudent` VALUES ('032006005', '徐一红', '女', '1988-01-11 00:00:00', '03', '660784', '000');
INSERT INTO `ustudent` VALUES ('032006006', '刘一和', '男', '1988-12-11 00:00:00', '03', '660785', '000');
INSERT INTO `ustudent` VALUES ('032006007', '马西', '男', '1989-10-01 00:00:00', '03', '660786', '000');
INSERT INTO `ustudent` VALUES ('032007005', '王红', '女', '1988-01-11 00:00:00', '03', '660784', '000');
INSERT INTO `ustudent` VALUES ('032007006', '王一红', '男', '1988-12-11 00:00:00', '03', '660785', '000');
INSERT INTO `ustudent` VALUES ('032007007', '丁西', '男', '1989-10-01 00:00:00', '03', '660786', '000');
INSERT INTO `ustudent` VALUES ('082005008', '刘去山', '女', '1990-01-11 00:00:00', '08', '660787', '000');
INSERT INTO `ustudent` VALUES ('082005009', '白云飞', '女', '1992-10-11 00:00:00', '08', '660788', '000');
INSERT INTO `ustudent` VALUES ('082006008', '刘问计', '女', '1990-01-11 00:00:00', '08', '660787', '000');
INSERT INTO `ustudent` VALUES ('082006009', '白问礼', '女', '1992-10-11 00:00:00', '08', '660788', '000');
INSERT INTO `ustudent` VALUES ('082007008', '刘红丽', '女', '1990-01-11 00:00:00', '08', '660787', '000');
INSERT INTO `ustudent` VALUES ('082007009', '沈学云', '女', '1992-10-11 00:00:00', '08', '660788', '000');
INSERT INTO `ustudent` VALUES ('092005010', '白云', '女', '1988-11-11 00:00:00', '08', '660789', '000');
INSERT INTO `ustudent` VALUES ('092006010', '白云', '女', '1988-12-11 00:00:00', '09', '660788', '000');
INSERT INTO `ustudent` VALUES ('092007010', '李风', '女', '1988-11-11 00:00:00', '09', '660789', '000');
INSERT INTO `ustudent` VALUES ('112005011', '李红', '女', '1987-12-11 00:00:00', '11', '660790', '000');
INSERT INTO `ustudent` VALUES ('112005012', '周磊', '男', '1986-06-11 00:00:00', '11', '660791', '000');
INSERT INTO `ustudent` VALUES ('112005013', '冯圭', '女', '1987-08-11 00:00:00', '11', '660792', '000');
INSERT INTO `ustudent` VALUES ('112006011', '李玉红', '女', '1987-12-11 00:00:00', '11', '660790', '000');
INSERT INTO `ustudent` VALUES ('112006012', '冯磊', '男', '1996-06-11 00:00:00', '11', '660791', '000');
INSERT INTO `ustudent` VALUES ('112006013', '冯由', '女', '1997-08-11 00:00:00', '11', '660792', '000');
INSERT INTO `ustudent` VALUES ('112007011', '刘好', '女', '1987-12-11 00:00:00', '11', '660790', '000');
INSERT INTO `ustudent` VALUES ('112007012', '周成', '男', '1986-06-11 00:00:00', '11', '660791', '000');
INSERT INTO `ustudent` VALUES ('112007013', '文成', '女', '1987-08-11 00:00:00', '11', '660792', '000');
INSERT INTO `ustudent` VALUES ('112007014', '霍去病', '男', '1989-05-09 00:00:00', '11', '660793', '000');
-- ----------------------------
-- Table structure for uteacher
-- ----------------------------
DROP TABLE IF EXISTS `uteacher`;
CREATE TABLE `uteacher` (
`tid` char(5) DEFAULT NULL,
`tname` char(8) DEFAULT NULL,
`tsexy` char(2) DEFAULT NULL,
`tbdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`tfield` char(50) DEFAULT NULL,
`tprof` char(10) DEFAULT NULL,
`tele` char(16) DEFAULT NULL,
`qq` char(12) DEFAULT NULL,
`email` char(30) DEFAULT NULL,
`msn` char(30) DEFAULT NULL,
`did` char(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of uteacher
-- ----------------------------
INSERT INTO `uteacher` VALUES ('02001', '李飞', '男', '1986-05-05 00:00:00', '数据库', '讲师', '660001', null, null, null, 'CS');
INSERT INTO `uteacher` VALUES ('02002', '郭山', '男', '1980/6/9 0:00:00', '数据库', '副教授', '660002',NULL,NULL,NULL, 'CS');
INSERT INTO `uteacher` VALUES ('02003', '马骊', '女', '1967/12/6 0:00:00', '网络技术与数据库', '教授','660003',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02004', '徐守', '女', '1967/7/14 0:00:00', '面向对象编程', '助教', '660004',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02005', '金贵', '女', '1983/3/8 0:00:00', '财务管理', '助教', '660005',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02006','成山云', '男', '1984/11/2 0:00:00', '金融学', '教授', '660006',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02007', '张田下', '男', '1977/1/7 0:00:00', '新能源技术', '研究员', '660007',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02008', '王一钱', '女', '1965/3/3 0:00:00', '信息管理与数据库', '讲师', '660008',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02009', '李远', '女', '1963/9/23 0:00:00', '电工学', '实验师', '660009',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('03010', '吴天贵', '女', '1984/4/26 0:00:00', '中医学', '主治医师', '660010',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('03011', '刘了了', '女', '1972/6/12 0:00:00', '近代史', '研究员', '660220',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03012', '洪玉飞', '男', '1967/9/29 0:00:00', '哲学', '教授', '660222',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03013', '划计成', '女', '1962/9/1 0:00:00', '应用数学', '教授', '660223',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03014', '李丽青', '男', '1968/5/9 0:00:00', '应用物理', '讲师', '660233',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03015', '李员', '男', '1971/9/15 0:00:00', '统计学', '研究员', '660234',NULL,NULL,NULL,'FD');
INSERT INTO `uteacher` VALUES ('03016', '国威', '女', '1965/4/30 0:00:00', '政治学', '研究员', '660123',NULL,NULL,NULL,'FD');
INSERT INTO `uteacher` VALUES ('03017', '国华', '女', '1989/5/29 0:00:00', '证券投资', '研究员', '660987',NULL,NULL,NULL,'FD');
INSERT INTO `uteacher` VALUES ('05022', '后羿', '女', '1983/6/16 0:00:00', '护理与营养', '主任护理师', '660909',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05023', '王飞红', '男', '1975/11/20 0:00:00', '多媒体技术', '讲师', '660938',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05024', '李丽青', '男', '1969/3/30 0:00:00', '理论力学', '副教授', '660323',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05025', '王红', '女', '1970/6/15 0:00:00', '建筑学', '副教授', '660099',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05026', '李飞', '女', '1963/12/22 0:00:00', '流体力学', '讲师', '660987',NULL,NULL,NULL,'SD');
--------------------------------------------------------------------------------------------sql
c#代码放下面了：
自己的方法比较笨的方法，可以使用更好的方法，自己在写的时候已经发现了，但是写作业嘛，就不改了
using MySql.Data.MySqlClient;
namespace database
{
class program
{
static void show()
{
Console.WriteLine("---------------------");
Console.WriteLine("1.显示所有学生信息");
Console.WriteLine("2.按姓名查询成绩");
Console.WriteLine("3.输入学生信息");
Console.WriteLine("4.输入一个学号，修改其姓名为张三，电话改为10088");
Console.WriteLine("5.输入学号，删除该同学的成绩记录");
Console.WriteLine("提示：输入其他将要退出！");
Console.WriteLine("-------------------");
}
static void Main(string[] args)
{
//获取输入
var builder = new MySqlConnectionStringBuilder();
builder.Server = "localhost";
builder.Port = 3306;
builder.UserID = "root";
builder.Password = "你的数据密码";
builder.Database = "目标数据库记得更改，不然跑不起来哦";
//初始化
var connect = new MySqlConnection(builder.ConnectionString);
connect.Open();
int a;
string cmd;
int flag = 1;
while (flag!=-1)
{
show();
a = Convert.ToInt32(Console.ReadLine());
switch (a)
{
case 1:
cmd = "Select * from ustudent;";
MySqlCommand command = new MySqlCommand(cmd,connect);
MySqlDataReader reader = command.ExecuteReader();
Console.WriteLine("学号\t\t姓名\t性别\t\t出生日期\t班级名称\t联系电话");
while (reader.Read())
{
Console.WriteLine(reader[0] +"\t"+ reader[1] +"\t"+ reader[2] + "\t" + reader[3] + "\t" + reader[4] + " \t" + reader[5]);
}
reader.Close();
break;
case 2:
Console.WriteLine("请输入要查询的姓名");
string in_name=Console.ReadLine();
//查询ustudent 中是否有信息
Console.WriteLine("学号\t\t姓名\t班级名称\t\t\t课程名称\t\t\t期末成绩(score1)");
cmd = "Select * from ustudent where Sname=\"" + in_name.ToString()+ "\"";//成功
// Console.WriteLine(cmd);
MySqlCommand command2 = new MySqlCommand(cmd, connect);
MySqlDataReader reader2 = command2.ExecuteReader();
string sid="1";
string grade="01";
string gname;
string[] cid=new string[10];//最多10个
string[] score1 = new string[10];//分数
while (reader2.Read())
{
sid = reader2[0].ToString();//学号
grade = reader2[4].ToString();//班级编号
Console.Write(reader2[0] + "\t" + reader2[1] + "\t");
}
reader2.Close();
//查对应班级
cmd = "Select gname,did from ugrade where gid=\"" +grade + "\"";//成功
MySqlCommand command4 = new MySqlCommand(cmd, connect);
MySqlDataReader reader4 = command4.ExecuteReader();
while (reader4.Read())
{
gname = reader4[0].ToString();
Console.Write(gname+"\t");
}
reader4.Close();
//查 usc中的对应sid 的score！
cmd = "Select cid,score1 from usc where sid=\"" + sid + "\"";//成功
//Console.WriteLine(sid);
// Console.WriteLine(cmd);
MySqlCommand command3 = new MySqlCommand(cmd, connect);
MySqlDataReader reader3 = command3.ExecuteReader();
int count = 0;
while (reader3.Read())
{
cid[count] = reader3[0].ToString();
score1[count] = reader3[1].ToString();
count++;
//Console.Write(reader3[1]+"\t");
}
reader3.Close();
//查询cid对应的课程名称
for(int i=0;i<cid.Length;i++)
{
cmd = "Select Cname from ucourse where Cid=\"" + cid[i] + "\"";//成功
MySqlCommand command5 = new MySqlCommand(cmd, connect);
MySqlDataReader reader5 = command5.ExecuteReader();
while (reader5.Read())
{
Console.Write(reader5[0]+" ");
}
reader5.Close();
}
for(int i=0;i<score1.Length;i++)
{
Console.Write(score1[i]+" ");
}
Console.WriteLine();
//Console.WriteLine(in_name);
break;
case 3:
//输入学生信息
Console.WriteLine("请输入要插入学生信息");
Console.WriteLine("学号sid?");
string sid_inchar= Console.ReadLine();
Console.WriteLine("姓名sname?");
string Sname_inchar= Console.ReadLine();
Console.WriteLine("性别ssexy?");
string ssexy = Console.ReadLine();
Console.WriteLine("出生日期sbdate? 格式1988-01-11");
DateTime sbdate_inchar = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("班级gid?");
string gid_inchar= Console.ReadLine();
Console.WriteLine("联系方式？stele");
string stele_inchar=Console.ReadLine();
Console.WriteLine("qq？qq");
string qq_inchar = Console.ReadLine();
//读入完毕
// A string t = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cmd = "insert into ustudent(Sid,Sname,Ssexy,Sbdate,gid,stele,QQ) values(" + "\""+ sid_inchar+ "\""+","+ "\"" + Sname_inchar + "\"" + "," + "\"" + ssexy + "\"" + "," + "\"" + sbdate_inchar+ "\"" + "," + "\"" + gid_inchar + "\"" + "," + "\"" + stele_inchar + "\"" + "," + "\"" + qq_inchar + "\"" +")";
Console.WriteLine(cmd);
MySqlCommand command6 = new MySqlCommand(cmd, connect);
MySqlDataReader reader6 = command6.ExecuteReader();
reader6.Close();
break;
case 4:
//修改
Console.WriteLine("输入一个学号");
string sid_update = Console.ReadLine();
cmd = "update ustudent set Sname = '张三' , stele = '10088' where Sid ="+ "\"" + sid_update + "\"";
MySqlCommand command7 = new MySqlCommand(cmd, connect);
MySqlDataReader reader7 = command7.ExecuteReader();
//
Console.WriteLine("完成");
reader7.Close();
break;
case 5:
//输入学号，删除该同学的成绩记录
Console.WriteLine("输入一个学号");
string sid_delete= Console.ReadLine();
cmd = "delete from ustudent where Sid=" + "\"" + sid_delete + "\"";
MySqlCommand command8 = new MySqlCommand(cmd, connect);
MySqlDataReader reader8 = command8.ExecuteReader();
//
Console.WriteLine("删除完成");
reader8.Close();
break;
default:
flag = -1;
break;
}
}
}
}
}
---------
注意！该代码偷懒并没有设置异常处理，所以健壮性没有那么高
一些运行截图：
end
