Struts2实现的吊炸天留言板系统（包含完整源+mysql数据库+bootstraps3）

/* Navicat MySQL Data Transfer Source Server : fm Source Server Version : 50532 Source Host : localhost:3306 Source Database : messageboard Target Server Type : MYSQL Target Server Version : 50532 File Encoding : 65001 Date: 2016-11-24 17:11:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for t_comment -- ---------------------------- DROP TABLE IF EXISTS `t_comment`; CREATE TABLE `t_comment` ( `commentId` int(11) NOT NULL AUTO_INCREMENT, `messageId` int(11) DEFAULT NULL, `content` varchar(200) DEFAULT NULL, `userIP` varchar(40) DEFAULT NULL, `commentDate` datetime DEFAULT NULL, PRIMARY KEY (`commentId`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_comment -- ---------------------------- INSERT INTO `t_comment` VALUES ('1', '2', 'hahaha', '192.168.1.1', '2016-11-21 20:49:23'); INSERT INTO `t_comment` VALUES ('21', '3', '111', '0:0:0:0:0:0:0:1', '2016-11-21 21:22:28'); INSERT INTO `t_comment` VALUES ('22', '3', '1234', '0:0:0:0:0:0:0:1', '2016-11-21 21:30:46'); INSERT INTO `t_comment` VALUES ('23', '3', '2345', '0:0:0:0:0:0:0:1', '2016-11-21 21:32:16'); INSERT INTO `t_comment` VALUES ('24', '2', '132eqwd', '0:0:0:0:0:0:0:1', '2016-11-21 21:33:10'); INSERT INTO `t_comment` VALUES ('25', '3', 'asddas', '0:0:0:0:0:0:0:1', '2016-11-21 21:33:38'); INSERT INTO `t_comment` VALUES ('26', '3', 'asds', '0:0:0:0:0:0:0:1', '2016-11-21 21:34:52'); INSERT INTO `t_comment` VALUES ('27', '3', 'ewqew', '0:0:0:0:0:0:0:1', '2016-11-21 21:35:44'); INSERT INTO `t_comment` VALUES ('28', '3', 'sdd', '0:0:0:0:0:0:0:1', '2016-11-21 21:37:51'); INSERT INTO `t_comment` VALUES ('29', '2', 'dasdas', '0:0:0:0:0:0:0:1', '2016-11-21 21:39:48'); INSERT INTO `t_comment` VALUES ('30', '3', 'dasdsa', '0:0:0:0:0:0:0:1', '2016-11-21 21:40:34'); INSERT INTO `t_comment` VALUES ('31', '3', '阿斯顿的', '0:0:0:0:0:0:0:1', '2016-11-21 21:43:29'); INSERT INTO `t_comment` VALUES ('32', '3', '111', '0:0:0:0:0:0:0:1', '2016-11-21 22:50:44'); INSERT INTO `t_comment` VALUES ('33', '3', '123', '0:0:0:0:0:0:0:1', '2016-11-21 22:55:11'); INSERT INTO `t_comment` VALUES ('34', '3', '范铭', '0:0:0:0:0:0:0:1', '2016-11-21 22:56:42'); INSERT INTO `t_comment` VALUES ('35', '6', '当一艘船沉入海底，当一个人成了迷。', '0:0:0:0:0:0:0:1', '2016-11-23 23:21:32'); INSERT INTO `t_comment` VALUES ('36', '6', '111', '169.254.122.89', '2016-11-23 23:25:57'); INSERT INTO `t_comment` VALUES ('37', '6', '测试', '169.254.122.89', '2016-11-23 23:26:09'); INSERT INTO `t_comment` VALUES ('38', '2', '可以很强势', '169.254.122.89', '2016-11-23 23:26:22'); INSERT INTO `t_comment` VALUES ('39', '7', '对哦，好怀念高三', '169.254.122.89', '2016-11-23 23:28:18'); INSERT INTO `t_comment` VALUES ('40', '8', '123', '0:0:0:0:0:0:0:1', '2016-11-23 23:34:56'); INSERT INTO `t_comment` VALUES ('41', '8', '234', '169.254.122.89', '2016-11-23 23:35:08'); INSERT INTO `t_comment` VALUES ('42', '2', '123', '0:0:0:0:0:0:0:1', '2016-11-24 14:49:07'); -- ---------------------------- -- Table structure for t_message -- ---------------------------- DROP TABLE IF EXISTS `t_message`; CREATE TABLE `t_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `content` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `date` datetime DEFAULT NULL, `userName` varchar(20) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_message -- ---------------------------- INSERT INTO `t_message` VALUES ('2', 'to小明', '<p>从李荣浩的喜剧之王到薛之谦的演员，或许我也是这种风格/微笑12</p>\r\n', '2016-11-24 14:31:15', 'fm'); INSERT INTO `t_message` VALUES ('6', 'from 活鱼~', '<div>如同悲伤被下载了两次，<br />\r\n三行诗的幽默加倍讽刺。&nbsp;</div>\r\n\r\n<div>1</div>\r\n', '2016-11-24 14:13:13', 'fm'); INSERT INTO `t_message` VALUES ('7', '大登哥的', '<p>每星期等着看屌丝男士都能想起来当年高三晚上去后面蹭WiFi等着看重要的是手机还是石阿哥的!1</p>\r\n', '2016-11-24 14:12:58', 'fm'); INSERT INTO `t_message` VALUES ('8', 'gyf', '<p>除了我谁都不可能这么爱你<br />\r\n不管她平时讲话多么爷们<br />\r\n当她脸红娇羞的看着我时我心里就十分满足<br />\r\n好兄弟问我为什么喜欢她时<br />\r\n我会说&nbsp;我也不知道</p>\r\n', '2016-11-23 23:34:48', 'xiaoming'); INSERT INTO `t_message` VALUES ('9', '测试', '<p>123</p>\r\n', '2016-11-23 23:35:50', '123'); INSERT INTO `t_message` VALUES ('10', '测试2', '<p>222</p>\r\n', '2016-11-23 23:36:14', '222'); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userName` varchar(20) DEFAULT NULL, `password` varchar(20) DEFAULT NULL, `trueName` varchar(20) CHARACTER SET utf8 DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `email` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES ('1', 'fm', '123456', '123', '123', '[email protected]'); INSERT INTO `t_user` VALUES ('2', '123', '123', null, null, null); INSERT INTO `t_user` VALUES ('3', '1234', '123', '123', '123', '123'); INSERT INTO `t_user` VALUES ('4', 'kk', '123', '1234', '454', '1234'); INSERT INTO `t_user` VALUES ('5', 'xiaoming', '123', '范铭', '123', '[email protected]'); INSERT INTO `t_user` VALUES ('6', 'qwe', '12', '12', '12', '12');