JSP个人博客功能模板

# Host: localhost (Version: 5.5.25a) # Date: 2017-12-11 05:25:32 # Generator: MySQL-Front 5.3 (Build 2.42) /*!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 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */; /*!40014 SET UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */; /*!40014 SET FOREIGN_KEY_CHECKS=0 */; DROP DATABASE IF EXISTS `mydb`; CREATE DATABASE `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `mydb`; # # Source for table "blog" # DROP TABLE IF EXISTS `blog`; CREATE TABLE `blog` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `content` text, `type` varchar(255) DEFAULT NULL, `datetime` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; # # Data for table "blog" # # # Source for table "cart" # DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `pname` varchar(255) DEFAULT NULL, `pprice` varchar(255) DEFAULT NULL, `pnum` varchar(255) DEFAULT NULL, `pmode` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; # # Data for table "cart" # INSERT INTO `cart` VALUES (1,'zhangsan','鞋子','188','2','防水闪光'),(2,'zhangsan','鞋子','188','2','耐脏防水'),(3,'zhangsan','步步高运动鞋','200','1','防水闪光'),(4,'zhangsan','步步高运动鞋','200','1','动感'),(5,'zhangsan','三星运动鞋','200','3','动感耐脏'),(6,'zhangsan','耐克鞋','188','1','动感'),(7,'zhangsan','耐克鞋','188','1','动感耐脏防水'); # # Source for table "comment" # DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `content` text, `blog` varchar(255) DEFAULT NULL, `datetime` varchar(255) DEFAULT NULL, `user` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; # # Data for table "comment" # # # Source for table "myuser" # DROP TABLE IF EXISTS `myuser`; CREATE TABLE `myuser` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `type` int(11) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; # # Data for table "myuser" # INSERT INTO `myuser` VALUES (1,'zhangsan','456',0),(4,'呵呵','123',0),(5,'哈哈','123',0),(6,'我是谁 ','123',0),(9,'2','22',0),(10,'张三丰','123',1),(12,'zhangsan1','123',0),(14,'zaaaa','aaaa',0),(15,'zzzzzzz','zzzz',0),(16,'zzzz','4444',0),(17,'ssss','sssss',0),(18,'ddddd','dddd',0); # # Source for table "news" # DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `datetime` varchar(255) DEFAULT NULL, `times` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; # # Data for table "news" # INSERT INTO `news` VALUES (1,'ddd','dddddd','2017-11-21 13:35:22','0','ntk2503.jpg'),(2,'sss','ssss','2017-11-21 13:41:09','0','ninja148637318694673.jpg'); # # Source for table "product" # DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `pname` varchar(255) DEFAULT NULL, `pprice` varchar(255) DEFAULT NULL, `pnum` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; # # Data for table "product" # INSERT INTO `product` VALUES (1,'耐克鞋','188','20'),(2,'步步高运动鞋','200','50'),(3,'匹克鞋','100','40'),(4,'三星运动鞋','200','30'); /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;