帆软V2练习题答案和常用案例.zip

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50723 Source Host : localhost:3306 Source Schema : finereport Target Server Type : MySQL Target Server Version : 50723 File Encoding : 65001 Date: 08/04/2021 15:43:28 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for coursegrage -- ---------------------------- DROP TABLE IF EXISTS `coursegrage`; CREATE TABLE `coursegrage` ( `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `studentno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `course` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `grade` float(20, 0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of coursegrage -- ---------------------------- INSERT INTO `coursegrage` VALUES ('', '1702211017', 'math', 10); INSERT INTO `coursegrage` VALUES ('1', '1702211017', 'math', 90); -- ---------------------------- -- Table structure for studentinfo -- ---------------------------- DROP TABLE IF EXISTS `studentinfo`; CREATE TABLE `studentinfo` ( `studentno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classno` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(12) NULL DEFAULT NULL, `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`studentno`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of studentinfo -- ---------------------------- INSERT INTO `studentinfo` VALUES ('1702211001', 'wlm', 'class1', 10, '女', '深圳市 宝安区 ', ''); INSERT INTO `studentinfo` VALUES ('1702211017', 'zll', 'class1', 10, '女', '深圳市 宝安区 ', 'https://ss0.bdstatic.com/70cFuHSh_Q1YnxGkpoWK1HF6hhy/it/u=2853553659,1775735885&fm=26&gp=0.jpg'); INSERT INTO `studentinfo` VALUES ('1702211018', 'lo', 'class1', 10, '女', 'c ds sd sd', ''); SET FOREIGN_KEY_CHECKS = 1;