之前的時候寫過一篇文章,因為各種原因,需要搭建一套ssm框架,上次的時候就是搭建了一套框架,但是其中相應的代碼實作并沒有添加進去,今天咱就完整起來,搭建一個測驗代碼,當然大家不需要非要用我的,再網上有很多相應的代碼文章,只不過我的這個有點傻瓜式的,直接cv代碼即可,不出問題是可以直接運行的
好了,話不多說,看正文吧,公眾號:Java架構師聯盟,原始碼再最后有獲取方式
配置spring容器等相關組態檔
\1. 在pom.xml(位置:專案的根目錄下)中引入必要的pom依賴(其中包括了spring、springmvc、jdbc、mysql、druid連接池、mybatis、lombok插件、juni他、其他工具包 ),相關的代碼我在之前的文章中已經公布,大家可以自行下載
如果想要自己添加jar包,可以在WEB-INF中新建lib檔案夾,然后放入你的jar包(poom依賴下載的jar包編譯過后其實也就是在編譯包下的lib檔案夾中)
每次更改pom依賴后,記得更新jar包,一般右下角都會彈出更新提示
\2. 配置web.xml檔案(位置:webapp下的WEB-INF中) tomcat啟動時,會加載此檔案,從而掃描加載其他的組態檔
<?xml version="1.0" encoding="UTF-8"?>
<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">
</web-app>
其中包括了編碼過濾、監聽器、springmvc配置、spring容器中其他配置包括mybatis等、log4j配置、專案訪問默認歡迎頁,如需添加自定義過濾器,也許在此配置
\3. 新建其他組態檔(位置:resoures下) applicationContext.xml、springmvc.xml、mybatis.xml、jdbc.properties、日志配置(log4j.properties和log4j.xml二選一,我用的log4j.xml)
spring-mvc.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:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:task="http://www.springframework.org/schema/task"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/task
http://www.springframework.org/schema/task/spring-task-3.0.xsd">
<!--開啟springMVC注解模式-->
<mvc:annotation-driven />
<aop:aspectj-autoproxy proxy-target-/>
<!-- 自動掃描,完成bean創建和自動依賴注入-->
<context:component-scan base-package="com.biws" />
<!--避免IE執行AJAX時,回傳JSON出現下載檔案 -->
<bean id="mappingJacksonHttpMessageConverter"
>
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
<!-- 啟動SpringMVC的注解功能,完成請求和注解POJO的映射 -->
<bean >
<property name="messageConverters">
<list>
<bean />
<ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON轉換器 -->
</list>
</property>
</bean>
<!-- 對模型視圖名稱的決議,即在模型視圖名稱添加前后綴 -->
<bean id="viewResolver" >
<!-- 查找視圖頁面的前綴和后綴 -->
<property name="prefix" value="https://www.cnblogs.com/" />
<property name="suffix" value="https://www.cnblogs.com/biwz/p/.html" />
</bean>
<!--<!–對上傳檔案的支持,springMVC其實是用common-upload來實作 –>
<bean id="multipartResolver" >
<!–設定上傳檔案的最大值,這里是位元組–>
<property name="maxUploadSize" value="https://www.cnblogs.com/biwz/p/102400000"></property> <!– 100M –>
<property name="defaultEncoding" value="https://www.cnblogs.com/biwz/p/utf-8"></property>
</bean>-->
<!-- 總錯誤處理-->
<bean id="exceptionResolver" >
<!--<property name="defaultErrorView">
<value>/base/error</value>
</property>-->
<property name="defaultStatusCode">
<value>500</value>
</property>
<property name="warnLogCategory">
<value>org.springframework.web.servlet.handler.SimpleMappingExceptionResolver</value>
</property>
</bean>
<!--靜態資源配置-->
<mvc:default-servlet-handler/>
<!--定時器配置-->
<task:executor id="executor" pool-size="5" />
<task:scheduler id="scheduler" pool-size="10" />
<task:annotation-driven executor="executor" scheduler="scheduler" />
</beans>
spring-applicationContext
后來的其他組態檔也可以在這個里邊引入比如:shiro、redis集群、cache-redis快取、自定義組件等等(優點:不用再去動web.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
<!--mybatis配置-->
<import resource="classpath*:spring-mybatis.xml"/>
</beans>
spring-mybatis.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:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
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/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd">
<!-- 自動掃描,Bean注入 -->
<context:component-scan base-package="com.biws"/>
<!-- 讀取組態檔資訊 -->
<context:property-placeholder ignore-unresolvable="true" location="classpath:jdbc.properties"/>
<bean name="dataSource" init-method="init" destroy-method="close">
<!-- 資料庫基本配置 -->
<property name="driverClassName" value="https://www.cnblogs.com/biwz/p/${jdbc.driver}" />
<property name="url" value="https://www.cnblogs.com/biwz/p/${jdbc.url}" />
<property name="username" value="https://www.cnblogs.com/biwz/p/${jdbc.username}" />
<property name="password" value="https://www.cnblogs.com/biwz/p/${jdbc.password}" />
<!-- 初始化連接數量 -->
<property name="initialSize" value="https://www.cnblogs.com/biwz/p/${jdbc.initialSize}"/>
<!-- 最大并發連接數量 -->
<property name="maxActive" value="https://www.cnblogs.com/biwz/p/${jdbc.maxActive}"/>
<!-- 最小空閑連接數 -->
<property name="minIdle" value="https://www.cnblogs.com/biwz/p/${jdbc.minIdle}"/>
<!-- 配置獲取連接等待超時的時間 -->
<property name="maxWait" value="https://www.cnblogs.com/biwz/p/${jdbc.maxWait}" />
<!-- 超過時間限制是否回收 -->
<property name="removeAbandoned" value="https://www.cnblogs.com/biwz/p/${jdbc.removeAbandoned}" />
<!-- 超過時間限制多長 -->
<property name="removeAbandonedTimeout" value="https://www.cnblogs.com/biwz/p/${jdbc.removeAbandonedTimeout}" />
<!-- 配置間隔多久才進行一次檢測,檢測需要關閉的空閑連接,單位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="https://www.cnblogs.com/biwz/p/${jdbc.timeBetweenEvictionRunsMillis}" />
<!-- 配置一個連接在池中最小生存的時間,單位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="https://www.cnblogs.com/biwz/p/${jdbc.minEvictableIdleTimeMillis}" />
<!-- 用來檢測連接是否有效的sql,要求是一個查詢陳述句-->
<property name="validationQuery" value="https://www.cnblogs.com/biwz/p/${jdbc.validationQuery}" />
<!-- 申請連接的時候檢測 -->
<property name="testWhileIdle" value="https://www.cnblogs.com/biwz/p/${jdbc.testWhileIdle}" />
<!-- 申請連接時執行validationQuery檢測連接是否有效,配置為true會降低性能 -->
<property name="testOnBorrow" value="https://www.cnblogs.com/biwz/p/${jdbc.testOnBorrow}" />
<!-- 歸還連接時執行validationQuery檢測連接是否有效,配置為true會降低性能 -->
<property name="testOnReturn" value="https://www.cnblogs.com/biwz/p/${jdbc.testOnReturn}" />
<property name="logAbandoned" value="https://www.cnblogs.com/biwz/p/true" />
<!-- 配置監控統計攔截的filters,wall用于防止sql注入,stat用于統計分析 -->
<property name="filters" value="https://www.cnblogs.com/biwz/p/stat" />
</bean>
<!-- MyBatis SqlSessionFactoryBean 配置 -->
<bean id="sqlSessionFactory" >
<property name="dataSource" ref="dataSource"/>
<!-- 自動掃描Mapping.xml檔案 -->
<property name="mapperLocations" value="https://www.cnblogs.com/biwz/p/classpath:com/biws/mapper/xml/*.xml"/>
<!-- 配置MyBaties全域組態檔:mybatis-config.xml -->
<property name="configLocation" value="https://www.cnblogs.com/biwz/p/classpath:mybatis-config.xml"/>
<!-- 掃描model包 xml中parameterType就可以使用類名,不用全路徑 -->
<property name="typeAliasesPackage" value="https://www.cnblogs.com/biwz/p/com.biws.model"/>
</bean>
<!-- 加載 mapper.xml對應的介面 組態檔 -->
<bean id="mapperScannerConfigurer" >
<!-- 給出需要掃描mapper介面包 -->
<property name="basePackage" value="https://www.cnblogs.com/biwz/p/com.biws.mapper"/>
<!-- 注入sqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="https://www.cnblogs.com/biwz/p/sqlSessionFactory" />
</bean>
<!-- (事務管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager" >
<property name="dataSource" ref="dataSource" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--
| plugins在組態檔中的位置必須符合要求,否則會報錯,順序如下:
| properties?, settings?,
| typeAliases?, typeHandlers?,
| objectFactory?,objectWrapperFactory?,
| plugins?,
| environments?, databaseIdProvider?, mappers?
|-->
<configuration>
<!--
| 全域配置設定
|
| 可配置選項 默認值, 描述
|
| aggressiveLazyLoading true, 當設定為‘true’的時候,懶加載的物件可能被任何懶屬性全部加載,否則,每個屬性都按需加載,
| multipleResultSetsEnabled true, 允許和不允許單條陳述句回傳多個資料集(取決于驅動需求)
| useColumnLabel true, 使用列標簽代替列名稱,不同的驅動器有不同的作法,參考一下驅動器檔案,或者用這兩個不同的選項進行測驗一下,
| useGeneratedKeys false, 允許JDBC 生成主鍵,需要驅動器支持,如果設為了true,這個設定將強制使用被生成的主鍵,有一些驅動器不兼容不過仍然可以執行,
| autoMappingBehavior PARTIAL, 指定MyBatis 是否并且如何來自動映射資料表欄位與物件的屬性,PARTIAL將只自動映射簡單的,沒有嵌套的結果,FULL 將自動映射所有復雜的結果,
| defaultExecutorType SIMPLE, 配置和設定執行器,SIMPLE 執行器執行其它陳述句,REUSE 執行器可能重復使用prepared statements 陳述句,BATCH執行器可以重復執行陳述句和批量更新,
| defaultStatementTimeout null, 設定一個時限,以決定讓驅動器等待資料庫回應的多長時間為超時
| -->
<settings>
<!-- 這個配置使全域的映射器啟用或禁用快取 -->
<setting name="cacheEnabled" value="https://www.cnblogs.com/biwz/p/true"/>
<!-- 全域啟用或禁用延遲加載,當禁用時,所有關聯物件都會即時加載 -->
<setting name="lazyLoadingEnabled" value="https://www.cnblogs.com/biwz/p/true"/>
<setting name="multipleResultSetsEnabled" value="https://www.cnblogs.com/biwz/p/true"/>
<setting name="useColumnLabel" value="https://www.cnblogs.com/biwz/p/true"/>
<setting name="defaultExecutorType" value="https://www.cnblogs.com/biwz/p/REUSE"/>
<setting name="defaultStatementTimeout" value="https://www.cnblogs.com/biwz/p/25000"/>
<!-- 讓控制臺列印sql陳述句,注釋掉則沒有 -->
<setting name="logImpl" value="https://www.cnblogs.com/biwz/p/STDOUT_LOGGING" />
<setting name="callSettersOnNulls" value="https://www.cnblogs.com/biwz/p/true" />
</settings>
</configuration>
jdbc.properties
創建這個組態檔的時候一定要注意自己的資料庫的ip鏈接,賬號和密碼,我這邊使用的虛擬機的資料庫,本地沒有安裝,所以這個地方我用的是我虛擬機的ip地址
#mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://192.168.79.7:3306/test?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
jdbc.initialSize=3
jdbc.maxActive=1000
jdbc.minIdle=0
jdbc.maxWait=6000
jdbc.removeAbandoned=true
jdbc.removeAbandonedTimeout=1800
jdbc.timeBetweenEvictionRunsMillis=60000
jdbc.minEvictableIdleTimeMillis=25200000
jdbc.validationQuery=select getdate()
jdbc.testWhileIdle=false
jdbc.testOnBorrow=false
jdbc.testOnReturn=false
log4j.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>
<!--ConsoleAppender:輸出到控制臺-->
<appender name="STDOUT" >
<!--<param name="encoding" value="https://www.cnblogs.com/biwz/p/UTF-8"/>-->
<layout >
<param name="ConversionPattern" value="https://www.cnblogs.com/biwz/p/%d [%t] %p - %m%n"/>
</layout>
<filter >
<!-- 設定日志輸出的最小級別 -->
<param name="levelMin" value="https://www.cnblogs.com/biwz/p/DEBUG"/>
<!-- 設定日志輸出的最大級別 -->
<param name="levelMax" value="https://www.cnblogs.com/biwz/p/FATAL"/>
<!-- 設定日志輸出的xxx,默認是false -->
<param name="AcceptOnMatch" value="https://www.cnblogs.com/biwz/p/true"/>
</filter>
</appender>
<!--輸出到日志檔案-->
<appender name="PROJECT" >
<!-- 設定日志資訊輸出檔案全路徑名 -->
<param name="file" value="https://www.cnblogs.com/biwz/p/${catalina.home}/logs/ceshi/info.log"/>
<!--日志檔案編碼-->
<param name="encoding" value="https://www.cnblogs.com/biwz/p/UTF-8"/>
<!--此日志檔案級別-->
<param name="threshold" value="https://www.cnblogs.com/biwz/p/info"/>
<!-- 設定是否在重新啟動服務時,在原有日志的基礎添加新日志 -->
<param name="Append" value="https://www.cnblogs.com/biwz/p/true"/>
<!-- 設定保存備份回滾日志的最大個數 -->
<param name="MaxBackupIndex" value="https://www.cnblogs.com/biwz/p/10"/>
<!-- 設定當日志檔案達到此閾值的時候自動回滾,單位可以是KB,MB,GB,默認單位是KB -->
<param name="MaxFileSize" value="https://www.cnblogs.com/biwz/p/50MB"/>
<!-- 設定日志輸出的樣式 -->
<layout >
<param name="ConversionPattern" value="https://www.cnblogs.com/biwz/p/%d [%X{requestURIWithQueryString}] %-5p %c{2} - %m%n"/>
</layout>
</appender>
<appender name="PROJECT-ERROR" >
<param name="file" value="https://www.cnblogs.com/biwz/p/${catalina.home}/logs/ceshi/error.log"/>
<param name="append" value="https://www.cnblogs.com/biwz/p/true"/>
<param name="encoding" value="https://www.cnblogs.com/biwz/p/UTF-8"/>
<param name="threshold" value="https://www.cnblogs.com/biwz/p/error"/>
<param name="MaxBackupIndex" value="https://www.cnblogs.com/biwz/p/10"/>
<param name="MaxFileSize" value="https://www.cnblogs.com/biwz/p/50MB"/>
<layout >
<param name="ConversionPattern" value="https://www.cnblogs.com/biwz/p/%d [%X{requestURIWithQueryString}] %-5p %c{2} - %m%n"/>
</layout>
</appender>
<!--開發測驗使用debug級別-->
<appender name="PROJECT-DEBUG" >
<param name="file" value="https://www.cnblogs.com/biwz/p/${catalina.home}/logs/ceshi/debug.log"/>
<param name="append" value="https://www.cnblogs.com/biwz/p/false"/>
<param name="encoding" value="https://www.cnblogs.com/biwz/p/UTF-8"/>
<param name="threshold" value="https://www.cnblogs.com/biwz/p/debug"/>
<param name="MaxBackupIndex" value="https://www.cnblogs.com/biwz/p/10"/>
<param name="MaxFileSize" value="https://www.cnblogs.com/biwz/p/50MB"/>
<layout >
<param name="ConversionPattern" value="https://www.cnblogs.com/biwz/p/%d [%X{requestURIWithQueryString}] %-5p %c{2} - %m%n"/>
</layout>
</appender>
<!--總的日志級別-->
<root>
<level value="https://www.cnblogs.com/biwz/p/DEBUG"/>
<appender-ref ref="PROJECT"/>
<appender-ref ref="PROJECT-DEBUG"/>
<appender-ref ref="PROJECT-ERROR"/>
<appender-ref ref="STDOUT"/>
</root>
</log4j:configuration>
好了,經過以上一套噼里啪啦的操作,配置基本算是好了,接下來讓我們寫代碼檢驗一下我們的配置到底對不對呢,激動人心的時刻就要來了
六、撰寫代碼測驗
\1. java檔案夾下,新建package包com.biws,另外再新建包括controller、mapper、model、service的四個包
創建包,然后創建對應的類,這是我創建完成之后的一個目錄結構,這個地方先創建包結構,然后再去創建了,按照我下面的步驟創建類,不然會報錯
\2. 在每個包下分別新建代碼檔案:TestController.java、TpmTestLogService.java、TpmTestLogServiceImpl.java、TpmTestLogMapper.java、TpmTestLogMapper.xml、TpmTestLog
物體類:TpmTestLog.java
package com.biws.model;
import lombok.Data;
import java.io.Serializable;
/**
* @author :biws
* @date :Created in 2020/12/19 21:59
* @description:
*/
@Data
public class TpmTestLog implements Serializable{
/**
* @備注: 主鍵
* @欄位:LOG_UUID bigint
*/
private Long logUuid;
/**
* @備注:
* @欄位:TESTMAIN_UUID CHAR(32)
*/
private String testmainUuid;
/**
* @備注:
* @欄位:OPERATION VARCHAR(20)
*/
private String operation;
/**
* @備注:
* @欄位:SYSCREATEDATE VARCHAR(25)
*/
private String syscreatedate;
public Long getLogUuid() {
return logUuid;
}
public void setLogUuid(Long logUuid) {
this.logUuid = logUuid;
}
public String getTestmainUuid() {
return testmainUuid;
}
public void setTestmainUuid(String testmainUuid) {
this.testmainUuid = testmainUuid;
}
public String getOperation() {
return operation;
}
public void setOperation(String operation) {
this.operation = operation;
}
public String getSyscreatedate() {
return syscreatedate;
}
public void setSyscreatedate(String syscreatedate) {
this.syscreatedate = syscreatedate;
}
@Override
public String toString() {
return "TpmTestLog{" +
"logUuid=" + logUuid +
", testmainUuid='" + testmainUuid + '\'' +
", operation='" + operation + '\'' +
", syscreatedate='" + syscreatedate + '\'' +
'}';
}
}
資料庫互動層dao介面:TpmTestLogMapper.java
package com.biws.mapper;
import com.biws.model.TpmTestLog;
/**
* @author :biws
* @date :Created in 2020/12/19 21:56
* @description:
*/
public interface TpmTestLogMapper {
Long insert(TpmTestLog tpmTestLog);
}
對應的xml:TpmTestLogMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.mapper.TpmTestLogMapper">
<resultMap type="com.test.model.TpmTestLog" id="mTpmTestLog" autoMapping="true">
</resultMap>
<sql id="mTpmTestLogSql">
LOG_UUID AS logUuid,
TESTMAIN_UUID AS testmainUuid,
OPERATION AS operation,
SYSCREATEDATE AS syscreatedate
</sql>
<insert id="insert" parameterType="TpmTestLog" useGeneratedKeys="true" keyProperty="logUuid">
INSERT INTO TPM_TEST_LOG (LOG_UUID,
TESTMAIN_UUID,
OPERATION,
SYSCREATEDATE)
VALUES (#{logUuid},
#{testmainUuid},
#{operation},
#{syscreatedate})
</insert>
</mapper>
業務層介面類sercice:TpmTestLogService.java
package com.biws.service;
import com.biws.model.TpmTestLog;
/**
* @author :biws
* @date :Created in 2020/12/19 21:55
* @description:
*/
public interface TpmTestLogService {
Long ceshi(TpmTestLog tpmTestLog);
}
業務層的實作類impl:TpmTestLogServiceImpl.java
package com.biws.service.impl;
import com.biws.mapper.TpmTestLogMapper;
import com.biws.model.TpmTestLog;
import com.biws.service.TpmTestLogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
/**
* @author :biws
* @date :Created in 2020/12/19 21:59
* @description:
*/
@Service
@Transactional
public class TmpTestLogServiceImpl implements TpmTestLogService {
@Autowired
private TpmTestLogMapper tpmTestLogMapper;
@Override
public Long ceshi(TpmTestLog tpmTestLog) {
return tpmTestLogMapper.insert(tpmTestLog);
}
}
介面邏輯層controller:TestController.java
package com.biws.controller;
import com.alibaba.fastjson.JSONObject;
import com.biws.model.TpmTestLog;
import com.biws.service.TpmTestLogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* @author :biws
* @date :Created in 2020/12/19 21:55
* @description:
*/
@RestController
@RequestMapping("/api")
public class TestController {
@Autowired
private TpmTestLogService tpmTestLogService;
@GetMapping("/test")
public JSONObject test(){
JSONObject jsonObject = new JSONObject();
TpmTestLog tpmTestLog = new TpmTestLog();
tpmTestLog.setSyscreatedate("asfasgags");
tpmTestLog.setTestmainUuid("fdasgassfsarew");
tpmTestLog.setOperation("新增");
tpmTestLogService.ceshi(tpmTestLog);
jsonObject.put("title", "測驗成功" + tpmTestLog.getLogUuid());
return jsonObject;
}
}
\3. 資料庫互動,測驗表以及資料庫連接檔案jdbc中的配置(文中5.3已有組態檔) Table:TPM_TEST_LOG
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `TPM_TEST_LOG`
-- ----------------------------
DROP TABLE IF EXISTS `TPM_TEST_LOG`;
CREATE TABLE `TPM_TEST_LOG` (
`LOG_UUID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
`TESTMAIN_UUID` varchar(32) COLLATE utf8_bin DEFAULT NULL,
`OPERATION` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`SYSCREATEDATE` varchar(25) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`LOG_UUID`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET FOREIGN_KEY_CHECKS = 1;
\4. 測驗介面 因為是寫的測驗是get請求,所以可以直接在瀏覽器中測驗,地址欄輸入介面地址(4.4中你配置的地址),回車訪問,如下圖
七、前端頁面和介面互動測驗
\1. 撰寫前端頁面測驗代碼(不要說你是后臺,不會寫前端代碼,不會也沒關系,直接copy吧,有問題找google)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<p>執行到這里了</p>
<script>
window.onload = function () {
//步驟一:創建異步物件
var ajax = new XMLHttpRequest();
//步驟二:設定請求的url引數,引數一是請求的型別,引數二是請求的url,可以帶引數,動態的傳遞引數starName到服務端
ajax.open('get', '/api/test');
//步驟三:發送請求
ajax.send();
//步驟四:注冊事件 onreadystatechange 狀態改變就會呼叫
ajax.onreadystatechange = function () {
if (ajax.readyState == 4 && ajax.status == 200) {
//步驟五 如果能夠進到這個判斷 說明 資料 完美的回來了,并且請求的頁面是存在的
console.log(ajax.responseText);//輸入相應的內容
console.log(JSON.parse(ajax.responseText).title);
console.log(document.getElementsByTagName("h2")[0])
document.getElementsByTagName("h2")[0].innerText = JSON.parse(ajax.responseText).title;
}
}
}
</script>
</body>
</html>
\2. 接下來見證奇跡,打開頁面地址:http://localhost:8085/index.html
后臺經過與資料庫互動后,把插入資料庫后生成的主鍵4回傳給前端,前端顯示在頁面中
到這里這個簡單的ssm框架就算搭建完成了,看起來程序很長,但實際操作起來應該是很快的,有問題歡迎留言,大家可以一起探討!
原始碼地址:https://gitee.com/biwangsheng/java.git有需要的朋友可以自行獲取
碼字不易,且行且珍惜,如發現問題,歡迎指正,java深似海,小白在路上!
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/238865.html
標籤:Java
