源碼及jar包:連結:http://pan.baidu.com/s/1kT3Lign 密碼:andu
資料庫:mysql5.1
jdk:1.7
tomcat:7
資料庫檔案:
/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50173
Source Host : localhost:3306
Source Database : stumng
Target Server Type : MYSQL
Target Server Version : 50173
File Encoding : 65001
Date: 2014-10-13 11:12:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `login_log`
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
`log_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`login_ip` varchar(30) NOT NULL,
`login_time` datetime NOT NULL,
`login_type` varchar(4) NOT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `stu_deeds_table`
-- ----------------------------
DROP TABLE IF EXISTS `stu_deeds_table`;
CREATE TABLE `stu_deeds_table` (
`deeds_id` int(11) NOT NULL AUTO_INCREMENT,
`stu_id` int(11) NOT NULL,
`deeds_time` datetime DEFAULT NULL,
`deeds_location` varchar(100) DEFAULT NULL,
`photos` varchar(200) DEFAULT NULL,
`deeds_content` text,
PRIMARY KEY (`deeds_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of stu_deeds_table
-- ----------------------------
-- ----------------------------
-- Table structure for `stu_table`
-- ----------------------------
DROP TABLE IF EXISTS `stu_table`;
CREATE TABLE `stu_table` (
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`sex` varchar(10) NOT NULL,
`stu_number` varchar(15) NOT NULL,
`birthday` date NOT NULL,
`photo` varchar(100) NOT NULL,
`introduce` text NOT NULL,
`state` int(1) unsigned zerofill NOT NULL DEFAULT '0',
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `user_table`
-- ----------------------------
DROP TABLE IF EXISTS `user_table`;
CREATE TABLE `user_table` (
`user_id` int(11) NOT NULL,
`account` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`rights` varchar(50) DEFAULT NULL,
`opt_module` varchar(100) DEFAULT NULL,
`introduce` varchar(1000) DEFAULT NULL,
`telnum` varchar(20) DEFAULT NULL,
`mng_level` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user_table
-- ----------------------------
INSERT INTO `user_table` VALUES ('1', 'tom', '1234', null, null, null, '123456789', '1');