# ssmbuild

**Repository Path**: mnmnwq/ssmbuild

## Basic Information

- **Project Name**: ssmbuild
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-07-30
- **Last Updated**: 2021-08-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: ssm学习, java学习

## README

## 项目

增删改查操作，带搜索

## 分支

#### master

#### basic : springmvc整个基础配置框架，配置带注释

## 笔记

#### sql

```sql
CREATE TABLE `books` (
  `bookID` int(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
  `bookName` varchar(100) NOT NULL COMMENT '书名',
  `bookCounts` int(11) NOT NULL COMMENT '数量',
  `detail` varchar(200) NOT NULL COMMENT '描述',
  PRIMARY KEY (`bookID`),
  KEY `bookID` (`bookID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
```



#### 数据库连接池介绍

1. dbcp：半自动化操作，不能自动连接

2. c3p0：自动化操作【自动化的加载配置文件，并且可以自动设置到对象中！】

   ```xml
   <?xml version="1.0" encoding="UTF-8"?>
   <beans xmlns="http://www.springframework.org/schema/beans"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xmlns:aop="http://www.springframework.org/schema/aop"
          xmlns:context="http://www.springframework.org/schema/context"
          xsi:schemaLocation="http://www.springframework.org/schema/beans
           https://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/aop
           https://www.springframework.org/schema/aop/spring-aop.xsd
           http://www.springframework.org/schema/context
           https://www.springframework.org/schema/context/spring-context.xsd">
   
   <context:property-placeholder location="classpath:database.properties"/>
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
           <property name="driverClass" value="${jdbc.driver}"/>
           <property name="jdbcUrl" value="${jdbc.url}"/>
           <property name="user" value="${jdbc.username}"/>
           <property name="password" value="${jdbc.password}"/>
           <!--c3p0连接池的私有属性-->
           <!--最大连接和最小连接-->
           <property name="maxPoolSize" value="30"/>
           <property name="minPoolSize" value="10"/>
           <!--关闭连接后不自动commit-->
           <property name="autoCommitOnClose" value="false"/>
           <!-- 获取连接超时时间 10s -->
           <property name="checkoutTimeout" value="10000"/>
           <!--当获取连接失败重试次数-->
           <property name="acquireRetryAttempts" value="2"/>
       </bean>
   	<!--配置dao接口扫描宝，动态实现Dao接口可以注入到Spring容器中！-->
       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
           <!--注入sqlSessionFactory-->
           <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
           <!--要扫描的dao包-->
           <property name="basePackage" value="com.test.data"/>
       </bean>
   </beans>
   ```

   

3. druid：

4. hikari：spring2.0默认自带