基于SSM的租赁管理系统1.0_20161225_框架搭建

时间：2023-03-09 15:25:41
基于SSM的租赁管理系统1.0_20161225_框架搭建

搭建SSM底层框架

基于SSM的租赁管理系统1.0_20161225_框架搭建

1. 利用mybatis反向工程generatorSqlmapCustom完成对数据库十表的映射

generatorConfig.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <!DOCTYPE generatorConfiguration

   PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"

   "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

 <generatorConfiguration>

     <context id="testTables" targetRuntime="MyBatis3">

         <commentGenerator>

             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->

             <property name="suppressAllComments" value="true" />

         </commentGenerator>

         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->

         <jdbcConnection driverClass="com.mysql.jdbc.Driver"

             connectionURL="jdbc:mysql://localhost:3306/test" userId="root"

             password="root">

         </jdbcConnection>

         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和

             NUMERIC 类型解析为java.math.BigDecimal -->

         <javaTypeResolver>

             <property name="forceBigDecimals" value="false" />

         </javaTypeResolver>

         <!-- targetProject:生成PO类的位置 -->

         <javaModelGenerator targetPackage="org.guangsoft.po"

             targetProject=".\src">

             <!-- enableSubPackages:是否让schema作为包的后缀 -->

             <property name="enableSubPackages" value="false" />

             <!-- 从数据库返回的值被清理前后的空格 -->

             <property name="trimStrings" value="true" />

         </javaModelGenerator>

         <!-- targetProject:mapper映射文件生成的位置 -->

         <sqlMapGenerator targetPackage="mybatis"

             targetProject=".\src">

             <!-- enableSubPackages:是否让schema作为包的后缀 -->

             <property name="enableSubPackages" value="false" />

         </sqlMapGenerator>

         <!-- targetPackage：mapper接口生成的位置 -->

         <javaClientGenerator type="XMLMAPPER"

             targetPackage="org.guangsoft.mapper"

             targetProject=".\src">

             <!-- enableSubPackages:是否让schema作为包的后缀 -->

             <property name="enableSubPackages" value="false" />

         </javaClientGenerator>

         <!-- 指定数据库表 -->

         <table schema="" tableName="users"></table>

         <table schema="" tableName="roles"></table>

         <table schema="" tableName="privileges"></table>

         <table schema="" tableName="items"></table>

         <table schema="" tableName="cars"></table>

         <table schema="" tableName="clients"></table>

         <table schema="" tableName="loginlog"></table>

         <table schema="" tableName="systemlog"></table>

         <table schema="" tableName="rents"></table>

         <table schema="" tableName="checks"></table>

     </context>

 </generatorConfiguration>

2. 配置mybatis

SqlMapperConfig.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <!DOCTYPE configuration

         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

         "http://mybatis.org/dtd/mybatis-3-config.dtd">

 <configuration>

 <!-- 配置分页插件 -->

     <plugins>

         <plugin interceptor="com.github.pagehelper.PageHelper">

             <!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->

             <property name="dialect" value="mysql"/>

         </plugin>

     </plugins>

 </configuration>

3. 配置spring-dao

db.properties

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf-8

jdbc.username=root

jdbc.password=root

applicationContext-dao.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <beans xmlns="http://www.springframework.org/schema/beans"

     xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd

     http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

     <!-- 解析properties文件的工具类 -->

     <context:property-placeholder location="classpath:resource/*.properties"/>

     <!-- 配置数据源 -->

     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">

         <!-- 数据库驱动 -->

         <property name="driverClassName" value="${jdbc.driver}" />

         <!-- 基本属性 url、user、password -->

         <property name="url" value="${jdbc.url}" />

         <property name="username" value="${jdbc.username}" />

         <property name="password" value="${jdbc.password}" />

         <!-- 配置初始化大小、最小、最大 -->

         <property name="initialSize" value="1" />

         <property name="minIdle" value="1" />

         <property name="maxActive" value="20" />

         <!-- 配置获取连接等待超时的时间 -->

         <property name="maxWait" value="60000" />

         <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->

         <property name="timeBetweenEvictionRunsMillis" value="60000" />

         <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->

         <property name="minEvictableIdleTimeMillis" value="300000" />

         <property name="validationQuery" value="SELECT 'x'" />

         <property name="testWhileIdle" value="true" />

         <property name="testOnBorrow" value="false" />

         <property name="testOnReturn" value="false" />

         <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->

         <property name="poolPreparedStatements" value="false" />

         <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />

         <!-- 配置监控统计拦截的filters -->

         <property name="filters" value="stat" />

     </bean>

     <!-- sqlSessionfactory -->

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

         <property name="configLocation" value="classpath:mybatis/SqlMapperConfig.xml"/>

         <property name="dataSource" ref="dataSource"/>

     </bean>

     <!-- 扫描代理类 -->

     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

         <property name="basePackage" value="mybatis"/>

     </bean>

 </beans>

applicationContext-service.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <beans xmlns="http://www.springframework.org/schema/beans"

     xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd

     http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

         <context:component-scan base-package="org.guangsoft.service"/>

 </beans>

applicationContext-tarns.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <beans xmlns="http://www.springframework.org/schema/beans"

     xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd

     http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

     <!-- 配置事物管理器的切面 -->

     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

         <property name="dataSource" ref="dataSource"/>

     </bean>

     <!-- 通知 -->

     <tx:advice id="Advice" transaction-manager="transactionManager">

         <!-- 事物传播行为 -->

         <tx:attributes>

             <!-- 传播行为 -->

             <tx:method name="save*" propagation="REQUIRED" />

             <tx:method name="insert*" propagation="REQUIRED" />

             <tx:method name="add*" propagation="REQUIRED" />

             <tx:method name="create*" propagation="REQUIRED" />

             <tx:method name="delete*" propagation="REQUIRED" />

             <tx:method name="update*" propagation="REQUIRED" />

             <tx:method name="drop*" propagation="REQUIRED" />

             <tx:method name="modify*" propagation="REQUIRED" />

             <tx:method name="find*" propagation="SUPPORTS" read-only="true" />

             <tx:method name="select*" propagation="SUPPORTS" read-only="true" />

             <tx:method name="get*" propagation="SUPPORTS" read-only="true" />

         </tx:attributes>

     </tx:advice>

     <aop:config>

         <aop:advisor advice-ref="Advice" pointcut="execution(* org.guangsoft.service.*.*(..))" />

     </aop:config>

 </beans>

springmvc.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:p="http://www.springframework.org/schema/p"

     xmlns:context="http://www.springframework.org/schema/context"

     xmlns:mvc="http://www.springframework.org/schema/mvc"

     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

         http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd

         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

         <!-- 扫描controller组件 -->

         <context:component-scan base-package="org.guangsoft.controller"/>

         <!-- 注册注解驱动 -->

         <mvc:annotation-driven></mvc:annotation-driven>

         <!-- 配置视图解析 -->

         <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

             <property name="prefix" value="/" />

             <property name="suffix" value=".jsp" />

         </bean>

         </beans>

4. 配置web.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"

     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

     http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

     <!-- 启动spring -->

     <context-param>

         <param-name>contextConfigLocation</param-name>

         <param-value>classpath:spring/applicationContext-*.xml</param-value>

     </context-param>

     <listener>

         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

     </listener>

     <!-- 解决post乱码 -->

     <filter>

         <filter-name>CharacterEncodingFilter</filter-name>

         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

         <init-param>

             <param-name>encoding</param-name>

             <param-value>utf-8</param-value>

         </init-param>

     </filter>

     <filter-mapping>

         <filter-name>CharacterEncodingFilter</filter-name>

         <url-pattern>/*</url-pattern>

     </filter-mapping>

     <!-- 启动springmvc -->

     <servlet>

         <servlet-name>guangsoft</servlet-name>

         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

         <!-- contextConfigLocation不是必须的， 如果不配置contextConfigLocation， springmvc的配置文件默认在：WEB-INF/servlet的name+"-servlet.xml" -->

         <init-param>

             <param-name>contextConfigLocation</param-name>

             <param-value>classpath:spring/springmvc.xml</param-value>

         </init-param>

         <load-on-startup>1</load-on-startup>

     </servlet>

     <servlet-mapping>

         <servlet-name>guangsoft</servlet-name>

         <url-pattern>*.do</url-pattern>

     </servlet-mapping>

     <welcome-file-list>

         <welcome-file>index.jsp</welcome-file>

     </welcome-file-list>

 </web-app>

相关文章