第一天（—2022/2/6—）

SSM框架搭建，编写配置文件，数据库属性文件
配置文件

pom文件（引入依赖）

<project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0modelVersion><packaging>warpackaging><groupId>org.examplegroupId><artifactId>FireartifactId><version>1.0-SNAPSHOTversion><properties><maven.compiler.source>8maven.compiler.source><maven.compiler.target>8maven.compiler.target>properties><dependencies><dependency><groupId>org.springframeworkgroupId><artifactId>spring-webmvcartifactId><version>5.3.14version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-jdbcartifactId><version>5.3.14version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-aspectsartifactId><version>5.3.14version>dependency><dependency><groupId>org.mybatisgroupId><artifactId>mybatisartifactId><version>3.5.3version>dependency><dependency><groupId>org.mybatisgroupId><artifactId>mybatis-springartifactId><version>2.0.2version>dependency><dependency><groupId>org.mybatis.generatorgroupId><artifactId>mybatis-generator-coreartifactId><version>1.4.0version>dependency><dependency><groupId>com.github.pagehelpergroupId><artifactId>pagehelperartifactId><version>5.0.0version>dependency><dependency><groupId>com.mchangegroupId><artifactId>c3p0artifactId><version>0.9.5.2version>dependency><dependency><groupId>mysqlgroupId><artifactId>mysql-connector-javaartifactId><version>5.1.47version>dependency><dependency><groupId>junitgroupId><artifactId>junitartifactId><version>4.12version><scope>testscope>dependency><dependency><groupId>javax.servletgroupId><artifactId>servlet-apiartifactId><version>2.5version><scope>providedscope>dependency><dependency><groupId>jstlgroupId><artifactId>jstlartifactId><version>1.2version>dependency>dependencies>project>

mybatis-config.xml

DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration><settings><setting name="mapUnderscoreToCamelCase" value="true"/>settings><typeAliases><package name="com.amao.pojo"/>typeAliases><plugins><plugin interceptor="com.github.pagehelper.PageInterceptor"><property name="reasonable" value="true"/>plugin>plugins>
configuration>

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<context:component-scan base-package="com.amao">
context:component-scan>
<context:property-placeholder location="classpath:dbconfig.properties"/><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="jdbcUrl" value="${jdbc.jdbcUrl}"/><property name="driverClass" value="${jdbc.driverClass}"/><property name="user" value="${jdbc.user}"/><property name="password" value="${jdbc.password}"/>bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="configLocation" value="classpath:mybatis-config.xml"/><property name="dataSource" ref="dataSource"/><property name="mapperLocations" value="classpath*:mapper/*.xml"/>bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.amao.mapper"/>bean><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/>bean>
<aop:config><aop:pointcut id="txPoint" expression="execution(* com.amao.service..*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/>aop:config><tx:advice id="txAdvice"><tx:attributes><tx:method name="*"/><tx:method name="get*" read-only="true"/>tx:attributes>tx:advice>beans>

dbconfig.properties

jdbc.jdbcUrl=jdbc:mysql://localhost:3306/book?useSSL=false&useUnicode=true&characterEncoding=utf-8
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=123456

springmvc-servlet.xml

<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"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/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd"><context:component-scan base-package="com.amao">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>context:component-scan><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/pages/"/><property name="suffix" value=".jsp"/>bean><mvc:default-servlet-handler/><mvc:annotation-driven/>
beans>

web.xml

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"version="4.0">
<context-param><param-name>contextConfigLocationparam-name><param-value>classpath:applicationContext.xmlparam-value>context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>listener><servlet><servlet-name>DispatcherServletservlet-name><servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class><init-param><param-name>contextConfigLocationparam-name><param-value>classpath:springmvc-servlet.xmlparam-value>init-param><load-on-startup>1load-on-startup>servlet><servlet-mapping><servlet-name>DispatcherServletservlet-name><url-pattern>/url-pattern>servlet-mapping><filter><filter-name>CharacterEncodingFilterfilter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class><init-param><param-name>encodingparam-name><param-value>utf-8param-value>init-param><init-param><param-name>forceRequestEncodingparam-name><param-value>trueparam-value>init-param><init-param><param-name>forceResponseEncodingparam-name><param-value>trueparam-value>init-param>filter><filter-mapping><filter-name>CharacterEncodingFilterfilter-name><url-pattern>/*url-pattern>filter-mapping><filter><filter-name>HiddenHttpMethodFilterfilter-name><filter-class>org.springframework.web.filter.HiddenHttpMethodFilterfilter-class>filter><filter-mapping><filter-name>HiddenHttpMethodFilterfilter-name><url-pattern>/*url-pattern>filter-mapping>web-app>

创建数据库（book）

使用MBG逆向工程

配置MBG.xml文件

DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration><context id="DB2Tables" targetRuntime="MyBatis3"><commentGenerator><property name="suppressDate" value="true"/><property name="suppressAllComments	" value="true"/>commentGenerator>
<jdbcConnection driverClass="com.mysql.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/book?useSSL=false"userId="root"password="123456">jdbcConnection><javaTypeResolver ><property name="forceBigDecimals" value="false" />javaTypeResolver><javaModelGenerator targetPackage="com.amao.pojo"targetProject=".\src\main\java"><property name="enableSubPackages" value="true" /><property name="trimStrings" value="true" />javaModelGenerator><sqlMapGenerator targetPackage="mapper"targetProject=".\src\main\resources"><property name="enableSubPackages" value="true" />sqlMapGenerator><javaClientGenerator type="XMLMAPPER" targetPackage="com.amao.mapper"targetProject=".\src\main\java"><property name="enableSubPackages" value="true" />javaClientGenerator><table tableName="tbl_emp" domainObjectName="Employee">table><table tableName="tbl_dept" domainObjectName="Department">table><table tableName="tbl_book" domainObjectName="Book">table><table tableName="tbl_order" domainObjectName="Order">table><table tableName="tbl_user" domainObjectName="User">table>context>
generatorConfiguration>

(测试)MBG

public class MBGTest {public static void main(String[] args) throws Exception {List<String> warnings = new ArrayList<String>();boolean overwrite = true;File configFile = new File("MBG.xml");ConfigurationParser cp = new ConfigurationParser(warnings);Configuration config = cp.parseConfiguration(configFile);DefaultShellCallback callback = new DefaultShellCallback(overwrite);MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);myBatisGenerator.generate(null);}
}

• 自动生成是成功的，但是mbg配置文件中设置不生产注释无效，未知原因。

搭建bootStrap环境

引入bootstrap文件和jQuery文件

编写首页

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！