天天看點

利用java實作資料庫資料随機生成

import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
import java.util.List;
import java.util.Random;

import util.RandomName;

public class StringBuilderUtil {

    public static void main(String[] args) {
        try {
            //指定檔案(手寫吧這個路徑,我也不知道為啥複制的不行)
            FileOutputStream fos = new FileOutputStream("D:/bms_insert_data.txt");
            //建立檔案io流
            BufferedOutputStream bos = new BufferedOutputStream(fos);
            
            String content = "";
            
            //資料
            int numMax=9999;
            int nummin=0000;
            //循環建立一百條
            int[] grade= {2016,2017,2018,2019,2020};
            String[] pro= {"漢語言文學","文秘","思想政治教育","曆史教育","英語","商務日語","學前教育","國小教育",
                    "旅遊管理與服務教育","财務會計教育","工商企業管理","數學與應用數學","計算機科學與技術","電子資訊工程",
                    "電氣工程與自動化","生物科學","地理科學","化學","數學與應用數學","思想政治教育","環境設計"};
            for (int i = 0; i < 100; i++) {
                String sex=(new Random().nextBoolean()? "男" : "女");
                String sql="INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES"
                        + " ("+((int) (Math.random()*(numMax-nummin)+nummin)+Integer.valueOf(grade[new Random().nextInt(4)]*10000).intValue())+", "
                                + "'"+RandomName.randomName(true, 3)+"',"
                                + " '"+sex+"'"
                                + ", "+((int) (System.currentTimeMillis()%(25-18)+18))+", "
                                + "'"+pro[new Random().nextInt(pro.length)]+"',"
                                + " '"+grade[new Random().nextInt(grade.length)]+"');\n";                
                content+=sql;
            }
            bos.write(content.getBytes(), 0, content.getBytes().length);
            bos.flush();
            bos.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

           
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20163820, '廖辰待', '女', 18, '旅遊管理與服務教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20166155, '巫殿愛', '女', 18, '環境設計', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176740, '蔡罰青', '女', 18, '國小教育', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20187934, '茅個糞', '女', 18, '生物科學', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20174813, '虞雄介', '男', 19, '數學與應用數學', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20173227, '虞毯驚', '男', 19, '漢語言文學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176937, '季禍滔', '男', 19, '商務日語', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20191374, '譚鞋主', '男', 19, '電氣工程與自動化', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20161212, '谯氧昨', '男', 19, '環境設計', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20189156, '阙揉效', '女', 19, '學前教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20179472, '隆傍魄', '男', 19, '電子資訊工程', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20162247, '和飯特', '男', 19, '電氣工程與自動化', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20180046, '苗續粥', '女', 19, '文秘', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199458, '韓差匠', '男', 19, '電氣工程與自動化', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176869, '窦達罵', '女', 19, '工商企業管理', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20181174, '常賣闖', '男', 19, '電氣工程與自動化', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20197500, '敖字呈', '女', 19, '曆史教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20181869, '越純售', '女', 19, '環境設計', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20185586, '後汪間', '女', 19, '思想政治教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20191532, '養欠湧', '女', 19, '學前教育', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199407, '公薄破', '男', 19, '旅遊管理與服務教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20190865, '奚彎滅', '男', 19, '工商企業管理', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176432, '伍蝕酒', '女', 19, '曆史教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20160960, '法膀液', '女', 19, '國小教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20161536, '笪逆以', '女', 19, '電子資訊工程', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20193893, '戚完狸', '女', 19, '化學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20190791, '夔脅每', '女', 19, '漢語言文學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20177122, '簡央觀', '男', 19, '漢語言文學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20173441, '阙底劇', '男', 20, '漢語言文學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20181362, '逑槐鞏', '女', 20, '數學與應用數學', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176765, '蔚接袍', '女', 20, '思想政治教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20179664, '魏尿憂', '男', 20, '地理科學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20164756, '曾告絲', '女', 20, '化學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199826, '顧旅考', '女', 20, '數學與應用數學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20194644, '甘炸乳', '男', 20, '旅遊管理與服務教育', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20164175, '危憤啞', '男', 20, '數學與應用數學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20190822, '麻法雖', '男', 20, '财務會計教育', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20170611, '琴捧項', '男', 20, '生物科學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20174255, '郏墨朝', '男', 20, '工商企業管理', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20188092, '從吓鍬', '女', 20, '财務會計教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20185325, '鄧塗冠', '女', 20, '數學與應用數學', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20164096, '衡絹逆', '女', 20, '地理科學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20187692, '亢賺出', '女', 24, '電子資訊工程', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20162966, '姚寶攪', '女', 24, '數學與應用數學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20191220, '宦賣房', '女', 24, '工商企業管理', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20193340, '孟糞蝕', '女', 24, '生物科學', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20189686, '畢州爐', '女', 24, '曆史教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20182259, '應澆耐', '男', 24, '工商企業管理', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20167624, '程任劣', '女', 24, '電氣工程與自動化', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199320, '厲口怪', '男', 24, '曆史教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20164441, '黨競稼', '男', 24, '文秘', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20198968, '禹陝金', '男', 24, '思想政治教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199624, '蒯芬罵', '男', 24, '學前教育', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20194113, '崔囊呆', '男', 18, '地理科學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20182155, '符片襲', '女', 18, '工商企業管理', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20192724, '益蛛襪', '女', 18, '思想政治教育', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20189937, '嶽氧驕', '男', 18, '化學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20177639, '魯臂袋', '女', 18, '旅遊管理與服務教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20190639, '鄢蜻勞', '男', 18, '工商企業管理', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20181764, '趙唐求', '女', 18, '電子資訊工程', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20196247, '程爆挖', '女', 18, '思想政治教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20188187, '閻異爸', '女', 19, '商務日語', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20187456, '後渣皂', '女', 19, '旅遊管理與服務教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20161198, '池币華', '女', 19, '思想政治教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20175709, '廉惕債', '女', 19, '電氣工程與自動化', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176904, '暨拖密', '男', 19, '生物科學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20165831, '車三紹', '男', 19, '電子資訊工程', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20165300, '東妹止', '男', 19, '環境設計', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20178575, '陳密拼', '女', 19, '财務會計教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20161642, '餘冊熔', '女', 19, '化學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20193191, '宓轟還', '男', 19, '數學與應用數學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20188232, '顔遠柔', '女', 19, '化學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20166190, '柏鏽烤', '男', 19, '商務日語', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20186151, '黨鴨湯', '女', 20, '數學與應用數學', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20184693, '鞏歎膠', '女', 20, '化學', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20194569, '養稅衛', '女', 20, '電子資訊工程', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20174716, '惠屋鐵', '女', 20, '地理科學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176430, '楚雪尺', '女', 20, '思想政治教育', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20165302, '暨融覺', '女', 20, '思想政治教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20188252, '平兔習', '男', 20, '數學與應用數學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20174859, '班承跟', '男', 20, '計算機科學與技術', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20177275, '法棕榴', '男', 20, '思想政治教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20163086, '洪世脆', '女', 20, '旅遊管理與服務教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176210, '蒲炭乙', '男', 20, '數學與應用數學', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20199596, '黃竟披', '女', 20, '國小教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20178523, '侯縣倉', '女', 20, '計算機科學與技術', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20163276, '益昏唯', '男', 21, '英語', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20180754, '車壇媽', '女', 21, '漢語言文學', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20176440, '柳種揪', '女', 21, '思想政治教育', '2017');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20192314, '晉化村', '男', 21, '漢語言文學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20167328, '陶綠膜', '男', 21, '旅遊管理與服務教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20163106, '薄必偵', '女', 21, '财務會計教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20198141, '蒯宴揀', '女', 21, '曆史教育', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20169812, '蒼泰住', '女', 21, '漢語言文學', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20173734, '滕止色', '女', 21, '商務日語', '2018');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20188920, '甘籮歎', '女', 21, '國小教育', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20175888, '郏船應', '男', 21, '英語', '2020');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20198253, '栾暢就', '女', 21, '數學與應用數學', '2019');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20167663, '汪乏振', '男', 21, '學前教育', '2016');
INSERT INTO `bms`.`student` (`stu_id`, `stu_name`, `stu_sex`, `stu_age`, `stu_pro`, `stu_grade`) VALUES (20185487, '紅濫筝', '男', 22, '曆史教育', '2016');