SSM初級整合

SSM整合

圖片.png
圖片.png

依賴

** <dependency>

<groupId>com.fasterxml.jackson.core</groupId>

<artifactId>jackson-databind</artifactId>

<version>2.10.5.1</version>
</dependency> ** <dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.30</version>
</dependency> ** <dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency> ** <dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency> ** <dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency> ** <dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.4</version>
</dependency> ** <dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>

<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.1.2</version>
</dependency> ** <dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency> ** <dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.3.5</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.5</version>
</dependency> ** <dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.6</version>
</dependency>

**

<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>/.properties</include>
<include>/.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>/.properties</include>
<include>/.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>

applicationContext.xml

<pre style="background:white"><?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.xsd">

<import resource="spring-dao.xml"/>

<import resource="spring-service.xml"/>

<import resource="springmvc.xml"/>

<import resource="spring-trans.xml"/>

</beans></pre>

spring-dao.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" 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"> ** <context:property-placeholder location="classpath:conf/*.properties"/> ** <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
<property name="url" value="{jdbc.url}"/> <property name="username" value="{jdbc.username}"/>
<property name="password" value="{jdbc.password}"/> <property name="driverClassName" value="{jdbc.driver}"/>
<property name="maxActive" value="10"/>
<property name="minIdle" value="5"/>
</bean> ** <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> ** <property name="dataSource" ref="dataSource"/> *
*<property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ma.mapper"/>
</bean>

</beans>

spring-service.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" 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"> ** <context:component-scan base-package="com.ma.service"/>

</beans>

spring-trans.xml

<beans xmlns="http://www.springframework.org/schema/beans" 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.2.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd"> ** <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> ** <property name="dataSource" ref="dataSource" />
</bean> ** <tx:advice id="txAdvice" 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="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="txAdvice" pointcut="execution( com.ma.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: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
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
https://www.springframework.org/schema/mvc/spring-mvc.xsd"> ** <context:property-placeholder location="classpath:conf/*.properties"/> ** <context:component-scan base-package="com.ma.controller" /> *
* <mvc:annotation-driven>
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<constructor-arg value="UTF-8"/>
</bean>
<bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="objectMapper">
<bean class="org.springframework.http.converter.json.Jackson2ObjectMapperFactoryBean">
<property name="failOnEmptyBeans" value="false"/>
</bean>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven> ** <mvc:default-servlet-handler/> ** <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>

</beans>

database.properties

jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/smmbulid?useUnicode=true&characterEncoding=UTF-8&useSSL=false jdbc.username=root jdbc.password=123456

web.xml

<?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">
<display-name>springmvc</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list> ** <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> ** <filter>
<filter-name>HiddenHttpMethodFilter</filter-name>
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HiddenHttpMethodFilter</filter-name>
<servlet-name>springmvc</servlet-name>
</filter-mapping> ** <servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> ** <init-param>
<param-name>contextConfigLocation</param-name> ** <param-value>classpath:spring/.xml</param-value>
</init-param> ** <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>

</web-app>

mybatis-config.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> ** <settings>
<setting name="logImpl" value="STDOUT_LOGGING"/> ** <setting name="mapUnderscoreToCamelCase" value="true"/> ** <setting name="cacheEnabled" value="true"/>
</settings>

<typeAliases>
<package name="com.ma.pojo"/>
</typeAliases>

<mappers>
<package name="com.ma.mapper"/>
</mappers>

</configuration>

BookMapper.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.ma.mapper.BookMapper">
<insert id="add" parameterType="com.ma.pojo.Books">
INSERT INTO books (bookID,bookName,bookCounts,detail)VALUES(#{bookID},#{bookName},#{bookCounts},#{detail})
</insert>

<delete id="delted" parameterType="int">
DELETE FROM books WHERE bookID=#{bookID}
</delete>

<update id="update" parameterType="com.ma.pojo.Books">
UPDATE books SET bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail} WHERE bookID=#{bookID}
</update>
<select id="getByID" parameterType="int" resultType="com.ma.pojo.Books">
SELECT *** FROM books WHERE bookID= #{bookID}
</select>
<select id="seletct" parameterType="com.ma.pojo.Books" resultType="com.ma.pojo.Books">
SELECT *** FROM books
</select>
</mapper>

<td><a href="/toupdate?id=${book.bookID}">更新</a> </td>

@RequestMapping("/toupdate")
public String toupdate(int id,Model model){
model.addAttribute("book",bookService.getByID(id));
return "update";
}

<td><a href="/delted/${book.bookID}">刪除</a> </td>
@RequestMapping(value = "/delted/{bookID}",method = RequestMethod.GET)
public String delted(@PathVariable int bookID){
bookService.delted(bookID);
return "redirect:/success";
}

最后編輯于 ：
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
  • 人面猴
    序言：七十年代末盈蛮，一起剝皮案震驚了整個濱河市，隨后出現(xiàn)的幾起案子技矮，更是在濱河造成了極大的恐慌抖誉，老刑警劉巖，帶你破解...
    沈念sama閱讀 217,277評論 6贊 503
  • 死咒
    序言：濱河連續(xù)發(fā)生了三起死亡事件衰倦，死亡現(xiàn)場離奇詭異袒炉，居然都是意外死亡，警方通過查閱死者的電腦和手機樊零，發(fā)現(xiàn)死者居然都...
    沈念sama閱讀 92,689評論 3贊 393
  • 救了他兩次的神仙讓他今天三更去死
    文/潘曉璐 我一進店門我磁，熙熙樓的掌柜王于貴愁眉苦臉地迎上來，“玉大人驻襟，你說我怎么就攤上這事夺艰。” “怎么了沉衣？”我有些...
    開封第一講書人閱讀 163,624評論 0贊 353
  • 道士緝兇錄：失蹤的賣姜人
    文/不壞的土叔 我叫張陵郁副，是天一觀的道長。 經(jīng)常有香客問我豌习，道長存谎，這世上最難降的妖魔是什么拔疚？ 我笑而不...
    開封第一講書人閱讀 58,356評論 1贊 293
  • ?港島之戀（遺憾婚禮）
    正文 為了忘掉前任，我火速辦了婚禮既荚，結(jié)果婚禮上稚失，老公的妹妹穿的比我還像新娘。我一直安慰自己恰聘，他們只是感情好句各，可當我...
    茶點故事閱讀 67,402評論 6贊 392
  • 惡毒庶女頂嫁案：這布局不是一般人想出來的
    文/花漫 我一把揭開白布。 她就那樣靜靜地躺著憨琳，像睡著了一般诫钓。 火紅的嫁衣襯著肌膚如雪。 梳的紋絲不亂的頭發(fā)上篙螟，一...
    開封第一講書人閱讀 51,292評論 1贊 301
  • 城市分裂傳說
    那天，我揣著相機與錄音问拘，去河邊找鬼遍略。 笑死，一個胖子當著我的面吹牛骤坐，可吹牛的內(nèi)容都是我干的绪杏。 我是一名探鬼主播，決...
    沈念sama閱讀 40,135評論 3贊 418
  • 雙鴛鴦連環(huán)套：你想象不到人心有多黑
    文/蒼蘭香墨 我猛地睜開眼纽绍，長吁一口氣：“原來是場噩夢啊……” “哼蕾久！你這毒婦竟也來了？” 一聲冷哼從身側(cè)響起拌夏，我...
    開封第一講書人閱讀 38,992評論 0贊 275
  • 萬榮殺人案實錄
    序言：老撾萬榮一對情侶失蹤僧著，失蹤者是張志新（化名）和其女友劉穎，沒想到半個月后障簿，有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體盹愚，經(jīng)...
    沈念sama閱讀 45,429評論 1贊 314
  • ?護林員之死
    正文 獨居荒郊野嶺守林人離奇死亡，尸身上長有42處帶血的膿包…… 初始之章·張勛 以下內(nèi)容為張勛視角 年9月15日...
    茶點故事閱讀 37,636評論 3贊 334
  • ?白月光啟示錄
    正文 我和宋清朗相戀三年站故，在試婚紗的時候發(fā)現(xiàn)自己被綠了皆怕。 大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
    茶點故事閱讀 39,785評論 1贊 348
  • 活死人
    序言：一個原本活蹦亂跳的男人離奇死亡西篓，死狀恐怖愈腾，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情岂津，我是刑警寧澤虱黄，帶...
    沈念sama閱讀 35,492評論 5贊 345
  • ?日本核電站爆炸內(nèi)幕
    正文 年R本政府宣布，位于F島的核電站寸爆，受9級特大地震影響礁鲁，放射性物質(zhì)發(fā)生泄漏盐欺。R本人自食惡果不足惜，卻給世界環(huán)境...
    茶點故事閱讀 41,092評論 3贊 328
  • 男人毒藥：我在死后第九天來索命
    文/蒙蒙 一仅醇、第九天 我趴在偏房一處隱蔽的房頂上張望冗美。 院中可真熱鬧，春花似錦析二、人聲如沸粉洼。這莊子的主人今日做“春日...
    開封第一講書人閱讀 31,723評論 0贊 22
  • 一樁弒父案叶摄，背后竟有這般陰謀
    文/蒼蘭香墨 我抬頭看了看天上的太陽属韧。三九已至，卻和暖如春蛤吓，著一層夾襖步出監(jiān)牢的瞬間宵喂，已是汗流浹背。 一陣腳步聲響...
    開封第一講書人閱讀 32,858評論 1贊 269
  • 情欲美人皮
    我被黑心中介騙來泰國打工会傲， 沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留锅棕，地道東北人。 一個月前我還...
    沈念sama閱讀 47,891評論 2贊 370
  • 代替公主和親
    正文 我出身青樓淌山，卻偏偏與公主長得像裸燎，于是被迫代替她去往敵國和親。 傳聞我的和親對象是個殘疾皇子泼疑，可洞房花燭夜當晚...
    茶點故事閱讀 44,713評論 2贊 354