# dmcminidao

**Repository Path**: domainchen/dmcminidao

## Basic Information

- **Project Name**: dmcminidao
- **Description**: hibernate 和mybatis 优势的集合
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2016-08-30
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#dmcminidao


minidao 持久层,系hibernate与mybatis优点的结合

一.数据库
/*
Navicat MySQL Data Transfer

Source Server         : dev_localhost
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : minidao

Target Server Type    : MYSQL
Target Server Version : 50527
File Encoding         : 65001

Date: 2016-08-30 17:09:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `USER_NO` varchar(20) DEFAULT NULL COMMENT '编号',
  `USER_NAME` varchar(50) DEFAULT NULL COMMENT '用户名',
  `AGE` int(3) DEFAULT NULL COMMENT '年龄',
  `SALARY` decimal(8,2) DEFAULT '0.00' COMMENT '工资',
  `BIRTHDAY` datetime DEFAULT NULL COMMENT '生日',
  `EMAIL` varchar(30) DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'A001', 'A001', '20', '0.00', '1989-08-30 09:49:04', 'cytxiamen@163.com');
INSERT INTO `sys_user` VALUES ('2', 'A002', 'A002', '25', '0.00', '1995-08-30 09:49:27', 'cytxiamen@163.com');
INSERT INTO `sys_user` VALUES ('3', 'A003', 'A003', '30', '0.00', '1997-08-30 09:49:41', 'cytxiamen@163.com');
INSERT INTO `sys_user` VALUES ('4', 'A004', 'A004', '40', '0.00', '1993-08-30 09:49:44', 'cytxiamen@163.com');
INSERT INTO `sys_user` VALUES ('6', 'A005', '丁满君', '55', '7890.00', '2016-08-30 16:47:19', '1010602131@qq.com');
INSERT INTO `sys_user` VALUES ('7', 'A006', '丁满君', '55', '7890.00', '2016-08-30 16:49:21', '1010602131@qq.com');


二.修改数据库参数
     src
        |--main
           |-resources
             |—-conf
               platform.properties


    
mysql database setting
connection.type=mysql
connection.url=jdbc:mysql://localhost:3306/minidao?autoReconnect=true&useUnicode=true&characterEncoding=utf-8
connection.username=root
connection.password=root

#pool settings
druid.initialSize=10
druid.minIdle=10
druid.maxActive=50
druid.maxWait=60000
druid.timeBetweenEvictionRunsMillis=60000
druid.minEvictableIdleTimeMillis=300000
druid.validationQuery=SELECT 'x'
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false
druid.poolPreparedStatements=false
druid.maxPoolPreparedStatementPerConnectionSize=20
druid.filters=wall,stat
#druid.connectionProperties=config.decrypt=true

说明:根据实际情况,修改数据库连接参数

三.配置minidao
  src
        |--main
           |-resources
             |—context
               |-applicationContext.xml

<!-- minidao拦截器 -->
	<bean name="minidaoInterceptor" class="com.domainchen.minidao.common.interceptor.DmcMinidaoInterceptor"></bean>
	<!-- MiniDao扫描类 -->
	<bean class="org.jeecgframework.minidao.factory.MiniDaoBeanScannerConfigurer">
		<!-- 是使用什么字母做关键字Map的关键字 默认值origin 即和sql保持一致,lower小写(推荐),upper 大写 -->
		<property name="keyType" value="lower"></property>
		<!-- 格式化sql -->
		<property name="formatSql" value="true"></property>
		<!-- 输出sql -->
		<property name="showSql" value="true"></property>
		<!-- 数据库类型 -->
		<property name="dbType" value="mysql"></property>
		<!-- dao地址,配置符合spring方式 -->
		<property name="basePackage" value="com.domainchen.minidao"></property>
		<!-- 使用的注解,默认是Minidao,推荐 Repository -->
		<property name="annotation" value="org.springframework.stereotype.Repository"></property>
		<!-- Minidao拦截器配置 <property name="emptyInterceptor" ref="minidaoInterceptor"></property> -->
	</bean>