.net連接mysql數(shù)據(jù)庫
作業(yè)為?：
針對LearDB數(shù)據(jù)庫實現(xiàn)一個菜單，菜單項包括
1、顯示所有學(xué)生:每個學(xué)生的信息占一行:每個學(xué)生的信息項包括學(xué)號姓名、性別、出生日期、班級名稱、聯(lián)系電話，各項以Tab分隔
2、按姓名查詢成績:輸入學(xué)生姓名，顯示學(xué)生成績，包括學(xué)號、姓名、班級名稱、課程名稱、期末成績(score1)，各項以Tab分隔,分行顯示
3、輸入學(xué)生信息:輸入學(xué)生各項信息
4、輸入一個學(xué)號，修改其姓名為“張三”，電話改為10088
5、輸入學(xué)號，刪除該同學(xué)的成績記錄
0、退出系統(tǒng):程序退出
數(shù)據(jù)庫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', '沈?qū)W云? ');
INSERT INTO `test` VALUES ('92005010', '白云? ? ');
INSERT INTO `test` VALUES ('92006010', '白云? ? ');
INSERT INTO `test` VALUES ('92007010', '李風(fēng)? ? ');
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', '數(shù)據(jù)庫', '4', '5', '72', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('10', '統(tǒng)計與審計', '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', '數(shù)學(xué)', '3', null, '54', '必修', '90', 'SD');
INSERT INTO `ucourse` VALUES ('3', '信息系統(tǒng)與數(shù)據(jù)庫', '3', '1', '54', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('4', '操作系統(tǒng)', '4', '6', '72', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('5', '數(shù)據(jù)結(jié)構(gòu)', '5', '7', '90', '必修', '50', 'CS');
INSERT INTO `ucourse` VALUES ('6', '計算機基礎(chǔ)', '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', '會計學(xué)原理', '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', '計算機科學(xué)與技術(shù)系', 'SL604', '87678976', 'cs@nit.com');
INSERT INTO `udept` VALUES ('EL', '外校', null, '62765678', null);
INSERT INTO `udept` VALUES ('EM', '經(jīng)濟管理系', 'SC302', '87464789', 'em@nit.com');
INSERT INTO `udept` VALUES ('FD', '外語分院', 'SA401', '65656798', 'fd@nit.com');
INSERT INTO `udept` VALUES ('IT', '信息科學(xué)與技術(shù)系', 'SL704', '88767864', 'it@nit.com');
INSERT INTO `udept` VALUES ('SD', '理學(xué)院', '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', '計算機科學(xué)與技術(shù)1班', '2006', 'CS', '02008');
INSERT INTO `ugrade` VALUES ('02', '計算機科學(xué)與技術(shù)2班', '2006', 'CS', '02008');
INSERT INTO `ugrade` VALUES ('03', '計算機科學(xué)與技術(shù)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', '財務(wù)管理', '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', '應(yīng)用數(shù)學(xué)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', '沈?qū)W云', '女', '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', '李風(fēng)', '女', '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', '數(shù)據(jù)庫', '講師', '660001', null, null, null, 'CS');
INSERT INTO `uteacher` VALUES ('02002', '郭山', '男', '1980/6/9 0:00:00', '數(shù)據(jù)庫', '副教授', '660002',NULL,NULL,NULL, 'CS');
INSERT INTO `uteacher` VALUES ('02003', '馬驪', '女', '1967/12/6 0:00:00', '網(wǎng)絡(luò)技術(shù)與數(shù)據(jù)庫', '教授','660003',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02004', '徐守', '女', '1967/7/14 0:00:00', '面向?qū)ο缶幊?#39;, '助教', '660004',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02005', '金貴', '女', '1983/3/8 0:00:00', '財務(wù)管理', '助教', '660005',NULL,NULL,NULL,'CS');
INSERT INTO `uteacher` VALUES ('02006','成山云', '男', '1984/11/2 0:00:00', '金融學(xué)', '教授', '660006',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02007', '張?zhí)锵?#39;, '男', '1977/1/7 0:00:00', '新能源技術(shù)', '研究員', '660007',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02008', '王一錢', '女', '1965/3/3 0:00:00', '信息管理與數(shù)據(jù)庫', '講師', '660008',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('02009', '李遠(yuǎn)', '女', '1963/9/23 0:00:00', '電工學(xué)', '實驗師', '660009',NULL,NULL,NULL,'IT');
INSERT INTO `uteacher` VALUES ('03010', '吳天貴', '女', '1984/4/26 0:00:00', '中醫(yī)學(xué)', '主治醫(yī)師', '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', '哲學(xué)', '教授', '660222',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03013', '劃計成', '女', '1962/9/1 0:00:00', '應(yīng)用數(shù)學(xué)', '教授', '660223',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03014', '李麗青', '男', '1968/5/9 0:00:00', '應(yīng)用物理', '講師', '660233',NULL,NULL,NULL,'EM');
INSERT INTO `uteacher` VALUES ('03015', '李員', '男', '1971/9/15 0:00:00', '統(tǒng)計學(xué)', '研究員', '660234',NULL,NULL,NULL,'FD');
INSERT INTO `uteacher` VALUES ('03016', '國威', '女', '1965/4/30 0:00:00', '政治學(xué)', '研究員', '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', '護理與營養(yǎng)', '主任護理師', '660909',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05023', '王飛紅', '男', '1975/11/20 0:00:00', '多媒體技術(shù)', '講師', '660938',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05024', '李麗青', '男', '1969/3/30 0:00:00', '理論力學(xué)', '副教授', '660323',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05025', '王紅', '女', '1970/6/15 0:00:00', '建筑學(xué)', '副教授', '660099',NULL,NULL,NULL,'SD');
INSERT INTO `uteacher` VALUES ('05026', '李飛', '女', '1963/12/22 0:00:00', '流體力學(xué)', '講師', '660987',NULL,NULL,NULL,'SD');
--------------------------------------------------------------------------------------------sql
c#代碼放下面了：
自己的方法比較笨的方法，可以使用更好的方法，自己在寫的時候已經(jīng)發(fā)現(xiàn)了，但是寫作業(yè)嘛，就不改了
using MySql.Data.MySqlClient;
namespace database
{
? ? class program
? ? {
? ? ? ? static void show()
? ? ? ? {
? ? ? ? ? ? Console.WriteLine("---------------------");
? ? ? ? ? ? Console.WriteLine("1.顯示所有學(xué)生信息");
? ? ? ? ? ? Console.WriteLine("2.按姓名查詢成績");
? ? ? ? ? ? Console.WriteLine("3.輸入學(xué)生信息");
? ? ? ? ? ? Console.WriteLine("4.輸入一個學(xué)號，修改其姓名為張三，電話改為10088");
? ? ? ? ? ? Console.WriteLine("5.輸入學(xué)號，刪除該同學(xué)的成績記錄");
? ? ? ? ? ? Console.WriteLine("提示：輸入其他將要退出！");
? ? ? ? ? ? Console.WriteLine("-------------------");
? ? ? ? }
? ? ? ? static void Main(string[] args)
? ? ? ? {
? ? ? ? ? ? //獲取輸入
? ? ? ? ? ? var builder = new MySqlConnectionStringBuilder();
? ? ? ? ? ? builder.Server = "localhost";
? ? ? ? ? ? builder.Port = 3306;
? ? ? ? ? ? builder.UserID = "root";
? ? ? ? ? ? builder.Password = "你的數(shù)據(jù)密碼";
? ? ? ? ? ? builder.Database = "目標(biāo)數(shù)據(jù)庫記得更改，不然跑不起來哦";
? ? ? ? ? ? //初始化
? ? ? ? ? ? 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("學(xué)號\t\t姓名\t性別\t\t出生日期\t班級名稱\t聯(lián)系電話");
? ? ? ? ? ? ? ? ? ? ? ? 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("學(xué)號\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];//分?jǐn)?shù)
? ? ? ? ? ? ? ? ? ? ? ??
? ? ? ? ? ? ? ? ? ? ? ? while (reader2.Read())
? ? ? ? ? ? ? ? ? ? ? ? {
? ? ? ? ? ? ? ? ? ? ? ? ? ? sid = reader2[0].ToString();//學(xué)號
? ? ? ? ? ? ? ? ? ? ? ? ? ? grade = reader2[4].ToString();//班級編號
? ? ? ? ? ? ? ? ? ? ? ? ? ? Console.Write(reader2[0] + "\t" + reader2[1] + "\t");
? ? ? ? ? ? ? ? ? ? ? ? }
? ? ? ? ? ? ? ? ? ? ? ? reader2.Close();
? ? ? ? ? ? ? ? ? ? ? ? //查對應(yīng)班級
? ? ? ? ? ? ? ? ? ? ? ? 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中的對應(yīng)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對應(yīng)的課程名稱
? ? ? ? ? ? ? ? ? ? ? ?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:
? ? ? ? ? ? ? ? ? ? ? ? //輸入學(xué)生信息
? ? ? ? ? ? ? ? ? ? ? ? Console.WriteLine("請輸入要插入學(xué)生信息");
? ? ? ? ? ? ? ? ? ? ? ? Console.WriteLine("學(xué)號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("聯(lián)系方式？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("輸入一個學(xué)號");
? ? ? ? ? ? ? ? ? ? ? ? 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:
? ? ? ? ? ? ? ? ? ? ? ? //輸入學(xué)號，刪除該同學(xué)的成績記錄
? ? ? ? ? ? ? ? ? ? ? ? Console.WriteLine("輸入一個學(xué)號");
? ? ? ? ? ? ? ? ? ? ? ? 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;
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
? ? ? ? ? ? ? ? }
? ? ? ? ? ? ? ? ? ??
? ? ? ? ? ? ? ??
? ? ? ? ? ? }
? ? ? ? ? ?
? ? ? ? }
? ? }
}
---------
注意！該代碼偷懶并沒有設(shè)置異常處理，所以健壯性沒有那么高
一些運行截圖：
end
