/*
SQLyog Professional v12.08 (32 bit)
MySQL - 5.5.27 : Database - testdb
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`testdb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `testdb`;
/*Table structure for table `dept` */
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`loc` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*Data for the table `dept` */
insert into `dept`(`id`,`name`,`loc`) values (1,'开发部','山东济南'),(2,'测试部1','山西吕梁'),(3,'开发部3','山东济南3'),(4,'开发部4','山东济南4'),(5,'研发部','山东淄博'),(6,'开发部6','山东济南6'),(7,'开发部7','山东济南7'),(8,'开发部8','山东济南8'),(14,'前端部','山西运城');
/*Table structure for table `emp` */
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp` (
`eid` int(11) NOT NULL AUTO_INCREMENT,
`ename` varchar(50) DEFAULT NULL,
`eage` int(11) DEFAULT NULL,
`edate` datetime DEFAULT NULL,
`did` int(11) DEFAULT NULL,
PRIMARY KEY (`eid`),
KEY `fk_dept` (`did`),
CONSTRAINT `fk_dept` FOREIGN KEY (`did`) REFERENCES `dept` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*Data for the table `emp` */
insert into `emp`(`eid`,`ename`,`eage`,`edate`,`did`) values (-1736410136,'李四',23,'2017-12-12 00:00:00',4),(-1733917077,'1111的博客',25,'2017-12-15 00:00:00',5),(1,'朱元璋',62,'2017-12-14 00:00:00',4),(2,'祖冲之',36,'2015-02-09 00:00:00',2),(3,'李世明',34,'2013-02-09 00:00:00',3),(4,'徐达',43,'2016-02-09 00:00:00',4),(5,'常遇春',23,'2712-02-09 00:00:00',1),(6,'李达康',45,'2018-02-09 00:00:00',2),(7,'沙瑞金',65,'2019-02-09 00:00:00',1);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
ssh.rar_SSH增删改查_SSH完整版_ssh_ssh sql_ssh 增删改查
版权申诉
112 浏览量
2022-09-20
10:18:57
上传
评论
收藏 17.78MB RAR 举报
ssh.rar （63个子文件） 
ssh ssh的配置文件 
applicationContext-action.xml 593B applicationContext-dao.xml 691B struts.xml 549B applicationContext-service.xml 664B hibernate.cfg.xml 1KB applicationContext.xml 2KB ssh的jar包 
org.springframework.instrument.tomcat-3.1.1.RELEASE.jar 11KB oro-2.0.8.jar 64KB org.springframework.instrument-3.1.1.RELEASE.jar 7KB xwork-core-2.3.15.1.jar 625KB dom4j-1.6.1.jar 307KB commons-collections-3.2.1.jar 562KB org.springframework.beans-3.1.1.RELEASE.jar 576KB org.springframework.orm-3.1.1.RELEASE.jar 370KB commons-beanutils-1.7.0.jar 184KB struts2-json-plugin-2.3.15.1.jar 69KB junit.jar 215KB cglib-nodep-2.2.3.jar 315KB org.springframework.context-3.1.1.RELEASE.jar 812KB org.springframework.asm-3.1.1.RELEASE.jar 52KB commons-chain-1.2.jar 90KB struts2-core-2.3.15.1.jar 783KB freemarker-2.3.19.jar 909KB mysql-connector-java-5.1.0-bin.jar 553KB commons-httpclient-3.1.jar 298KB org.springframework.aspects-3.1.1.RELEASE.jar 49KB ezmorph-1.0.3.jar 76KB commons-digester-2.0.jar 145KB commons-logging-1.1.1.jar 59KB json-lib-2.2.3-jdk15.jar 145KB ojdbc6.jar 2.01MB org.springframework.core-3.1.1.RELEASE.jar 439KB dwr.jar 478KB commons-dbcp-1.4.jar 157KB org.springframework.jdbc-3.1.1.RELEASE.jar 395KB ognl-3.0.6.jar 223KB javassist-3.9.0.GA.jar 583KB aspectjweaver.jar 1.74MB org.springframework.context.support-3.1.1.RELEASE.jar 105KB org.springframework.expression-3.1.1.RELEASE.jar 172KB aopalliance.jar 4KB commons-fileupload-1.2.1.jar 56KB slf4j-api-1.5.8.jar 23KB ehcache-1.2.3.jar 203KB commons-logging-api-1.1.jar 44KB commons-lang-2.4.jar 256KB commons-validator-1.3.1.jar 136KB org.springframework.transaction-3.1.1.RELEASE.jar 241KB org.springframework.aop-3.1.1.RELEASE.jar 324KB slf4j-log4j12-1.5.8.jar 9KB log4j-1.2.17.jar 478KB jta-1.1.jar 13KB struts2-embeddedjsp-plugin-2.2.1.jar 662KB struts2-spring-plugin-2.3.15.1.jar 21KB commons-io-2.4.jar 181KB commons-pool-1.6.jar 109KB commons-lang3-3.1.jar 308KB org.hamcrest.core_1.1.0.v20090501071000.jar 27KB org.springframework.web-3.1.1.RELEASE.jar 532KB sslext-1.2-0.jar 26KB antlr-2.7.6.jar 433KB hibernate3.jar 2.31MB 数据库文件mysql的 database.sql 2KB
alvarocfc
- 粉丝: 109
- 资源: 1万+
评论0