物流管理系统 基于JSP

-- MySQL dump 10.11 -- -- Host: localhost Database: wuliu -- ------------------------------------------------------ -- Server version 5.0.67-community-nt /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `active` -- DROP TABLE IF EXISTS `active`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `active` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(45) character set gb2312 default NULL, `content` text character set gb2312, `author` varchar(45) character set gb2312 default NULL, `addtime` varchar(45) character set gb2312 default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `active` -- LOCK TABLES `active` WRITE; /*!40000 ALTER TABLE `active` DISABLE KEYS */; INSERT INTO `active` VALUES (2,'物流管理交流会','2009-02-15日\r\n全国物流管理交流会将于郑州博览中心举行。','acc','2009-02-12 14:56:58'),(5,'国际物流交流会','呵呵。','acc','2009-02-23 16:26:18'),(6,'现代物流特征','现代物流特征','acc','2009-02-23 16:26:48'),(7,'电子商务物流','电子商务物流','acc','2009-02-23 16:27:03'); /*!40000 ALTER TABLE `active` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `admin` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(45) character set gb2312 default NULL, `password` varchar(45) character set gb2312 default NULL, `tel` varchar(45) character set gb2312 default NULL, `email` varchar(255) character set gb2312 default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `admin` -- LOCK TABLES `admin` WRITE; /*!40000 ALTER TABLE `admin` DISABLE KEYS */; INSERT INTO `admin` VALUES (1,'acc','acccc','acc','acc'); /*!40000 ALTER TABLE `admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bbs` -- DROP TABLE IF EXISTS `bbs`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `bbs` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(45) default NULL, `content` text, `author` varchar(45) default NULL, `contact` varchar(45) default NULL, `addtime` varchar(45) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `bbs` -- LOCK TABLES `bbs` WRITE; /*!40000 ALTER TABLE `bbs` DISABLE KEYS */; INSERT INTO `bbs` VALUES (1,'花木成畦手自栽','aaaaaaaaaaaaaaaa在花木成畦手自栽','acc','aaaaaaaaaaaaaaaa','2009-02-13 09:25:48'),(2,'老树春深更著花','ewryy','acc','yewry','2009-02-13 09:28:06'),(3,'网站做的不错哈！','网站做的不错哈，是用JSP做的吗？','acc','电话：xxxx-xxxxxxx','2009-02-13 15:01:42'),(4,'路漫漫其修远兮，吾将上下而求索。','路漫漫其修远兮，吾将上下而求索。\r\n','acc','手机：15x 3xxx 3xxx','2009-02-13 15:02:58'),(5,'天时不如地利，地利不如人和。','天时不如地利，地利不如人和。\r\nd在','acc','QQ：8x3x3x9x7','2009-02-13 15:11:00'),(6,'O!网站好好看噢！','实在太好看了，拜你为师吧。^_^','acc','姓名：acc','2009-02-13 15:12:23'),(7,'你们公司在哪啊？','想去你们公司参观一下，不知可否告知地址。','acc','昵称：acc','2009-02-13 15:14:53'); /*!40000 ALTER TABLE `bbs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bulletin` -- DROP TABLE IF EXISTS `bulletin`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `bulletin` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(45) default NULL, `content` text, `author` varchar(45) default NULL, `addtime` varchar(45) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `bulletin` -- LOCK TABLES `bulletin` WRITE; /*!40000 ALTER TABLE `bulletin` DISABLE KEYS */; INSERT INTO `bulletin` VALUES (10,'基材花木成畦手自栽花木成畦手自栽','花木成畦手自栽花木成畦手自栽','acc','2009-02-13 13:52:45'),(11,'时传物流管理系统正式上线！','经过严谨的思考和策划，时传物流管理系统终于问世了，得到大家的同意和支持，时传物流系统将于明天，也即2009-02-14号08点30分00秒隆重上线，届时将有丰厚大礼相送，在此谢谢各位捧场先。','acc','2009-02-13 15:22:19'),(12,'参于时传物流项目成员一览！','需求分析：acc\r\n项目设计：acc\r\n项目实现：acc\r\n项目测试：acc\r\n项目指导：acc\r\n项目顾问：acc\r\n...（待续）','acc','2009-02-13 15:28:21'),(13,'时传物流公测计划','经过认真计算和规划，时传物流将于明天正式上线，同时也代表该系统开始公测。\r\n公测时间：2009-02-14 08:30:00至2009-02-14 12:00:00。\r\n如发现一个BUG，请在意见反馈中留言，或直接BO打我们的HOTLINE:0371-66202195.将有重礼相送。\r\n ----时传物流项目管理中心\r\n 2009/02/13','acc','2009-02-13 15:35:24'),(14,'时传物流项目扩展计划','路漫漫其修远兮，吾将上下而求索。\r\n路上都漫成水了，而且还特别长啊这路，\r\n没办法，我只能找干的地方走，结果就是左走走，右走走，寻找更好的路。我想屈原也是这样吧。不过我不明白他为什么是上上下下的寻求呢。索是绳子吗？难道他在找绳子，哎！怪不得屈原跳河，估计是因为找不到绳子吧！\r\n说了这么多我只想告诉大家，我对该项目的扩展的良好未来充满信息，我一定会做的很好。','acc','2009-02-13 15:44:02'),(15,'关于时传物流项目修正BUG计划','一个两个三四个，\r\n五个六个七八个。\r\n九个十个十一个，\r\n去掉测试无BUG。','acc','2009-02-13 15:53:59'); /*!40000 ALTER TABLE `bulletin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cars` -- DROP TABLE IF EXISTS `cars`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `cars` ( `id` int(10) unsigned NOT NULL auto_increment, `trademark` varchar(45) default NULL, `brand` varchar(45) default NULL, `type` varchar(45) default NULL, `carload` varchar(45) default NULL, `usedtime` varchar(45) default NULL, `drivername` varchar(45) default NULL, `drivertime` varchar(45) default NULL, `licencenumber` varchar(45) default NULL, `licencetype` varchar(45) default NULL, `transporttype` varchar(45) default NULL, `linkman` varchar(45) default NULL, `tel` varchar(45) default NULL, `remark` text, `username` varchar(45) default NULL, `addtime` varchar(45) character set gb2312 default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8; SET character_set_client