【安卓毕业设计】智慧园区管理系统的设计与实现源码（完整前后端+mysql+说明文档+LW）.zip

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2021 年 03 月 24 日 13:32 -- 服务器版本: 5.5.53 -- PHP 版本: 5.4.45 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `enterprise_management_system` -- CREATE DATABASE `enterprise_management_system` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `enterprise_management_system`; -- -------------------------------------------------------- -- -- 表的结构 `think_comentinfor` -- CREATE TABLE IF NOT EXISTS `think_comentinfor` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `coment` text NOT NULL, `date` text NOT NULL, `postid` int(11) NOT NULL, `postname` text NOT NULL, `like` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- 转存表中的数据 `think_comentinfor` -- INSERT INTO `think_comentinfor` (`id`, `username`, `coment`, `date`, `postid`, `postname`, `like`) VALUES (1, 'aaa', 'dsadsad', '2021-03-21 15:01', 1, 'ASD', '7'), (2, 'bbb', 'ASD', '2021-03-21 15:09', 1, 'ASD', '6'), (3, 'ccc', 'yfyhy', '2021-03-21 15:17', 1, 'ASD', '4'), (4, 'ddd', 'afdggf', '2021-03-23 12:40', 2, 'ASD', '1'), (5, 'bbb', 'ddd', '2021-03-23 13:25', 1, 'ASD', '1'), (6, 'ccc', 'dhfbh', '2021-03-23 13:27', 1, 'ASD', ''), (7, 'root', 'hello world', '2021-03-23 13:49', 0, 'AGH', ''), (8, 'aaa', 'fghghfg', '2021-03-24 13:05', 3, 'AGH', ''), (9, 'aaa', 'DSFDSF', '2021-03-24 13:14', 3, 'AGH', ''); -- -------------------------------------------------------- -- -- 表的结构 `think_good` -- CREATE TABLE IF NOT EXISTS `think_good` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `price` text NOT NULL, `photo` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- 转存表中的数据 `think_good` -- INSERT INTO `think_good` (`id`, `name`, `price`, `photo`) VALUES (1, '苹果', '15', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235110.jpg'), (2, '圣女果', '20', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235111.jpg'), (3, '游世界', '35', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235114.jpg'), (4, '良品铺子', '30', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235116.jpg'), (5, '哈密瓜', '10', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235112.jpg'), (6, '冰雪奇缘', '50', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235115.jpg'), (7, '牛肉干', '60', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235117.jpg'), (8, '荔枝', '80', 'http://192.168.101.6/enterprise_management_system/Uploads/6038baf235113.jpg'); -- -------------------------------------------------------- -- -- 表的结构 `think_goodcostrecord` -- CREATE TABLE IF NOT EXISTS `think_goodcostrecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `price` text NOT NULL, `count` text NOT NULL, `cost` text NOT NULL, `date` text NOT NULL, `username` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- 转存表中的数据 `think_goodcostrecord` -- INSERT INTO `think_goodcostrecord` (`id`, `name`, `price`, `count`, `cost`, `date`, `username`) VALUES (1, '苹果', '15', '1', '15', '2021-03-21 06:10', 'aaa'), (2, '苹果', '15', '1', '15', '2021-03-21 06:36', 'aaa'), (3, '圣女果', '20', '2', '40', '2021-03-23 12:23', 'bbb'), (4, '苹果', '15', '2', '30', '2021-03-23 13:24', 'ccc'), (5, '哈密瓜', '10', '1', '10', '2021-03-23 13:25', 'ccc'), (6, '牛肉干', '60', '1', '60', '2021-03-23 13:26', 'aaa'), (7, '苹果', '15', '1', '15', '2021-03-23 13:30', 'root'), (8, '牛肉干', '60', '1', '60', '2021-03-23 13:30', 'bbb'), (9, '冰雪奇缘', '50', '1', '50', '2021-03-23 13:30', 'ddd'), (10, '哈密瓜', '10', '1', '10', '2021-03-24 13:05', 'root'), (11, '圣女果', '20', '1', '20', '2021-03-24 13:14', 'ddd'), (12, '游世界', '35', '1', '35', '2021-03-24 13:14', 'aaa'); -- -------------------------------------------------------- -- -- 表的结构 `think_leaveinfor` -- CREATE TABLE IF NOT EXISTS `think_leaveinfor` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `name` text NOT NULL, `identity` text NOT NULL, `department` text NOT NULL, `position` text NOT NULL, `phone` text NOT NULL, `reason` text NOT NULL, `status` text NOT NULL, `date` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- 转存表中的数据 `think_leaveinfor` -- INSERT INTO `think_leaveinfor` (`id`, `username`, `name`, `identity`, `department`, `position`, `phone`, `reason`, `status`, `date`) VALUES (1, 'aaa', 'asd', '123456', 'GSH', 'ADER', '123456789', 'ASDASA', '已批准', '2021-03-20 08:20'), (2, 'aaa', 'asd', '123456', 'GSH', 'ADER', '123456789', 'jgjjj', '已批准', '2021-03-20 08:06'), (3, 'aaa', 'asd', '123456', 'GSH', 'ADER', '123456789', 'tryy', '已批准', '2021-03-20 08:09'), (4, 'aaa', '张三', '54245655', 'HGH', '科长', '5545522', 'FDSDFGGDF', '已批准', '2021-03-23 13:02'), (5, 'bbb', '秋小丽', '57985565', 'ROM', '职工', '455868858', 'hgffg', '未批准', '2021-03-23 13:23'), (6, 'ccc', '孙大红', '858975', 'OS', '组长', '8758856', 'jgjbb', '未批准', '2021-03-23 13:26'), (7, 'ccc', '孙大红', '858975', 'OS', '组长', '8758856', 'vjfwggoy', '已批准', '2021-03-23 13:26'), (8, 'ddd', '夏侯惇', '5759855', 'OS', '职工', '55588855', 'fhgh', '未批准', '2021-03-23 13:28'), (9, 'aaa', '张三', '54245655', 'HGH', '科长', '5545522', 'dsadsdafs', '未批准', '2021-03-24 13:11'); -- -------------------------------------------------------- -- -- 表的结构 `think_parkcostrecord` -- CREATE TABLE IF NOT EXISTS `think_parkcostrecord` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `price` text NOT NULL, `carnumber` text NOT NULL, `startdate` text NOT NULL, `enddate` text NOT NULL, `cost` text NOT NULL, `costdate` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- 转存表中的数据 `think_parkcostrecord` -- INSERT INTO `think_parkcostrecord` (`id`, `name`, `price`, `carnumber`, `startdate`, `enddate`, `cost`, `costdate`) VALUES (10, 'AF001', '5', 'AG231', '2021-03-24 13:13', '2021-03-25 13:13', '120', '2021-03-24 13:13'), (1, 'AF002', '5', 'AG836', '2021-03-23 13:27', '2021-03-23 15:27', '10', '2021-03-23 13:27'), (2, 'AF001', '5', 'AG888', '2021-03-23 13:29', '2021-03-23 20:29', '35', '2021-03-23 13:29'); -- -------------------------------------------------------- -- -- 表的结构 `think_parkinfor` -- CREATE TABLE IF NOT EXISTS `think_parkinfor` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `status` text NOT NULL, `price` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `think_parkinfor` -- INSERT INTO `think_parkinfor` (`id`, `name`, `status`, `price`) VALUES (1, 'AF001', '空置', '5'), (2, 'AF002', '空置', '5'); -- -------------------------------------------------------- -- -- 表的结构 `think_postinfor` -- CREATE TABLE IF NOT EXISTS `think_postinfor` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `content` text NOT NULL, `time` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `think_postinfor` -- INSERT INTO `think_postinfor` (`id`, `name`, `content`, `time`) VALUES (1, 'ASD', 'JTHFGREDDRGFDGFD', '2021-03-21 04:43'), (3, 'AGH', 'FDDFGWEG