MVC模式的网上银行管理系统（源码）

/* Navicat MySQL Data Transfer Source Server : -1908 Source Server Version : 50045 Source Host : localhost:3306 Source Database : sxnd Target Server Type : MYSQL Target Server Version : 50045 File Encoding : 65001 Date: 2021-07-14 16:23:15 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `tbbill` -- ---------------------------- DROP TABLE IF EXISTS `tbbill`; CREATE TABLE `tbbill` ( `bid` int(11) NOT NULL, `goodsname` varchar(255) NOT NULL, `amount` int(11) NOT NULL, `price` double NOT NULL, `ispay` int(11) NOT NULL, `goodsdesc` varchar(225) NOT NULL, `createdate` date NOT NULL, PRIMARY KEY (`bid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 ROW_FORMAT=COMPACT; -- ---------------------------- -- Records of tbbill -- ---------------------------- INSERT INTO `tbbill` VALUES ('1', 'AD钙奶', '20', '5', '1', 'AD钙奶', '2021-07-13'); INSERT INTO `tbbill` VALUES ('2', '卫龙', '10', '10', '0', '卫龙', '2021-07-14'); -- ---------------------------- -- Table structure for `tbprovider` -- ---------------------------- DROP TABLE IF EXISTS `tbprovider`; CREATE TABLE `tbprovider` ( `pid` int(11) NOT NULL, `proname` varchar(255) NOT NULL, `prodesc` varchar(255) NOT NULL, `linkman` varchar(255) NOT NULL, `tel` varchar(255) NOT NULL, `loc` varchar(255) NOT NULL, PRIMARY KEY (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of tbprovider -- ---------------------------- INSERT INTO `tbprovider` VALUES ('1', '娃哈哈有限公司', '娃哈哈', '李先生', '15546987523', '北京'); INSERT INTO `tbprovider` VALUES ('2', '今麦郎公司', '今麦郎矿泉水', '张先生', '15346547865', '上海'); INSERT INTO `tbprovider` VALUES ('3', '卫龙食品公司', '卫龙', '李先生', '15243654897', '北京'); INSERT INTO `tbprovider` VALUES ('4', '娃哈哈有限公司', '娃哈哈', '李先生', '15546985647', '北京'); INSERT INTO `tbprovider` VALUES ('5', '今麦郎公司', '今麦郎矿泉水', '张先生', '15364562453', '上海'); INSERT INTO `tbprovider` VALUES ('6', '卫龙食品有限公司', '卫龙', '李先生', '152465485978', '北京'); INSERT INTO `tbprovider` VALUES ('7', '汾酒有限公司', '汾酒', '刘先生', '15548795648', '上海'); INSERT INTO `tbprovider` VALUES ('8', '今麦郎有限公司', '今麦郎矿泉水', '张先生', '14578945687', '上海'); INSERT INTO `tbprovider` VALUES ('9', '汾酒有限公司', '汾酒', '李先生', '15478945634', '北京'); INSERT INTO `tbprovider` VALUES ('10', '卫龙食品有限公司', '卫龙', '王先生', '1234578546', '北京'); INSERT INTO `tbprovider` VALUES ('12', '娃哈哈有限公司', '娃哈哈', '张先生', '115487954685', '上海'); -- ---------------------------- -- Table structure for `tbuser` -- ---------------------------- DROP TABLE IF EXISTS `tbuser`; CREATE TABLE `tbuser` ( `id` int(11) NOT NULL default '0', `username` varchar(255) NOT NULL, `pwd` varchar(255) NOT NULL, `sex` int(11) NOT NULL, `age` int(11) NOT NULL, `tel` varchar(255) NOT NULL, `loc` varchar(255) NOT NULL, `role` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of tbuser -- ---------------------------- INSERT INTO `tbuser` VALUES ('1', 'admin', '123', '0', '20', '18536496549', '山西', '1'); INSERT INTO `tbuser` VALUES ('2', 'denghui', '123', '1', '20', '18536496549', '北京', '2');