Extjs+SSH 实例 Extjs+SSH 实例

# MySQL-Front 3.2 (Build 13.46) /*!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 gbk */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='SYSTEM' */; /*!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' */; # Host: localhost Database: stuclass # ------------------------------------------------------ # Server version 5.1.6-alpha-nt-max DROP DATABASE IF EXISTS `stuclass`; CREATE DATABASE `stuclass` /*!40100 DEFAULT CHARACTER SET gbk */; USE `stuclass`; # # Table structure for table app_user # CREATE TABLE `app_user` ( `id` bigint(20) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; # # Dumping data for table app_user # # # Table structure for table classinfo # CREATE TABLE `classinfo` ( `classId` int(11) NOT NULL auto_increment, `className` varchar(255) default NULL, PRIMARY KEY (`classId`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; # # Dumping data for table classinfo # # # Table structure for table employee # CREATE TABLE `employee` ( `ID` int(11) NOT NULL auto_increment, `EMP_NAME` varchar(20) default NULL, `EMP_SEX` varchar(2) default NULL, `EMP_AGE` int(11) default NULL, `EMP_DATE` datetime default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; # # Dumping data for table employee # INSERT INTO `employee` VALUES (1,'a001','男',23,'1984-03-09 00:00:00'); INSERT INTO `employee` VALUES (2,'a002','男',22,'1985-04-09 00:00:00'); INSERT INTO `employee` VALUES (3,'a003','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (4,'a004','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (5,'a005','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (6,'a006','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (7,'a007','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (8,'a008','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (9,'a009','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (10,'a010','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (11,'a011','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (12,'a012','男',20,'1988-03-04 00:00:00'); INSERT INTO `employee` VALUES (13,'a013','男',20,'1988-03-04 00:00:00'); # # Table structure for table studentinfo # CREATE TABLE `studentinfo` ( `studentId` int(11) NOT NULL auto_increment, `studentName` varchar(255) default NULL, `classId` int(11) default NULL, PRIMARY KEY (`studentId`), KEY `FK8C4FC58932E134B3` (`classId`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; # # Dumping data for table studentinfo # # # Foreign keys for table studentinfo # ALTER TABLE `studentinfo` ADD FOREIGN KEY (`classId`) REFERENCES `classinfo` (`classId`); /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */;