Java课程设计-基于Java swing带GUI界面的的超市管理系统（源码+数据库建表脚本+项目部署说明）.zip

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `employeeinfo` -- ---------------------------- DROP TABLE IF EXISTS `employeeinfo`; CREATE TABLE `employeeinfo` ( `SNumber` VARCHAR(8) NOT NULL, `SName` VARCHAR(10) NOT NULL, `SPrice` VARCHAR(8) NOT NULL, `SMuch` VARCHAR(10) NOT NULL, PRIMARY KEY (`SNumber`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of employeeinfo -- ---------------------------- INSERT INTO `employeeinfo` VALUES ('005', '旺仔qq糖', '23', '100'); INSERT INTO `employeeinfo` VALUES ('33', '乐事薯片', '26', '300'); INSERT INTO `employeeinfo` VALUES ('2', '喜之郎果冻', '26', '500'); INSERT INTO `employeeinfo` VALUES ('3', '妙脆角', '26', '50'); INSERT INTO `employeeinfo` VALUES ('4', '彩虹糖', '25', '10'); INSERT INTO `employeeinfo` VALUES ('5', '芒果干', '27', '200'); -- ---------------------------- -- Table structure for `userinfos` -- ---------------------------- DROP TABLE IF EXISTS `userinfos`; CREATE TABLE `userinfos` ( `username` VARCHAR(10) NOT NULL, `userpassword` VARCHAR(10) NOT NULL, PRIMARY KEY (`username`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of userinfos -- ---------------------------- INSERT INTO `userinfos` VALUES ('111', '111'); INSERT INTO `userinfos` VALUES ('222', '222'); INSERT INTO `userinfos` VALUES ('333', '333'); INSERT INTO `userinfos` VALUES ('zd', '110');