注意：這里使用jdk1.7版本檔案報錯是因為jdk版本太高jdk1.7版本就不報錯

框架搭建

一、web.xml配置

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
 3   <display-name>SSM03</display-name>
 4   <!-- 運行歡迎頁 -->
 5   <welcome-file-list>
 6     <welcome-file>index.jsp</welcome-file>
 7   </welcome-file-list>
 8   
 9   <!--SSM整合框架  -->
10   <!-- spring的核心配置 -->
11       <!--配置spring背景關系 -->
12           <context-param>
13                 <param-name>contextConfigLocation</param-name>
14                   <!-- 這里要掃描spring設定 和spring里mybatis的設定-->
15                 <param-value>classpath:applicationContext.xml</param-value>
16             </context-param>        
17         <!-- 配置spring監聽器 -->
18               <listener>
19                 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
20             </listener>
21     <!-- SpringMVC核心配置 -->
22         <!--  配置SpringMVC核心控制器  -->
23         <servlet>
24                
25                 <servlet-name>springmvc</servlet-name>
26                 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
27             
28             
29                 <!-- contextConfigLocation配置springmvc加載的組態檔（配置處理器映射器、配接器等等） 
30                    如果不配置contextConfigLocation，默認加載的是/WEB-INF/servlet名稱-serlvet.xml（springmvc-servlet.xml） -->
31                
32                 <init-param>
33                     <param-name>contextConfigLocation</param-name>
34                                  <!-- 這里要掃描springmvc的跳轉和傳輸設定 -->
35                              
36                     <param-value>classpath:spring-mvc.xml</param-value>
37                 </init-param>
38                 <!-- 優先等及 -->
39                         <load-on-startup>1</load-on-startup>
40             </servlet> 
41         
42         <servlet-mapping>
43                 <servlet-name>springmvc</servlet-name>
44                 <url-pattern>*.do</url-pattern>
45         </servlet-mapping>
46         
47          <!-- post亂碼過慮器 -->
48         <filter>
49             <filter-name>CharacterEncodingFilter</filter-name>
50             <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
51             <init-param>
52                 <param-name>encoding</param-name>
53                 <param-value>utf-8</param-value>
54             </init-param>
55         </filter>
56         <filter-mapping>
57             <filter-name>CharacterEncodingFilter</filter-name>
58             <url-pattern>/*</url-pattern>
59         </filter-mapping>
60 
61 
62     
63     <!-- Mybatis核心配置 -->
64     <!-- 對于資料持久層的框架而言，都交給spring處理 -->
65 
66   
67   
68 </web-app>

二、配置spring-mvc.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    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-3.2.xsd 
        http://www.springframework.org/schema/mvc 
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
        http://www.springframework.org/schema/context 
        http://www.springframework.org/schema/context/spring-context-3.2.xsd 
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
        http://www.springframework.org/schema/tx 
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
        
    <!-- 開啟springmvc -->                      
    <context:annotation-config />
    <!-- 注解掃描包 -->
    <context:component-scan base-package="com.ssm.controller" />
    <context:component-scan base-package="com.ssm.service" />
     <!-- 定義跳轉的檔案的前后綴 ，視圖模式配置-->
    <bean  class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/jsp/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
        
        
</beans>

三、配置spring(applicationContext.xml)

 1 <beans xmlns="http://www.springframework.org/schema/beans"
 2     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
 3     xmlns:context="http://www.springframework.org/schema/context"
 4     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
 5     xsi:schemaLocation="http://www.springframework.org/schema/beans 
 6         http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
 7         http://www.springframework.org/schema/mvc 
 8         http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
 9         http://www.springframework.org/schema/context 
10         http://www.springframework.org/schema/context/spring-context-3.2.xsd 
11         http://www.springframework.org/schema/aop 
12         http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
13         http://www.springframework.org/schema/tx 
14         http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
15         
16         
17         <!-- IOC -->
18         <!-- web.xml交給spring配置的東西 -->
19         <!-- 配置mybatis -->
20         <!-- 匯入資料源 ，dbcp -->
21         <context:property-placeholder location="classpath:db.properties" />
22         <!-- 配置資料源 ，dbcp -->
23     
24         <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
25             destroy-method="close">
26             <property name="driverClassName" value="${jdbc.driver}" />
27             <property name="url" value="${jdbc.url}" />
28             <property name="username" value="${jdbc.username}" />
29             <property name="password" value="${jdbc.password}" />
30         </bean>
31 
32         <!-- 創建sqlSessionFactory -->
33         <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
34             <!-- 資料源（資料庫連接池） -->
35             <property name="dataSource" ref="dataSource" />
36             <!-- 加載mybatis的全域組態檔 -->
37             <property name="configLocation" value="classpath:mybatis-Config.xml" />
38         </bean>
39         
40         <!-- mapper掃描器 -->
41         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
42             <!-- 掃描包路徑，如果需要掃描多個包，中間使用半角逗號隔開 -->
43             <property name="basePackage" value="com.ssm.mapper"></property>
44             <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
45         </bean>
46 
47         <!-- AOP:16個字 -->
48         <!-- 事務管理 -->
49         <!-- 創建事務管理器 -->
50         <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
51             <!-- 資料源  -->
52             <property name="dataSource" ref="dataSource"/>
53         </bean>
54 
55         <!-- 創建通知：事務管理器管理通知 -->
56         <tx:advice id="txAdvice" transaction-manager="transactionManager">
57             <tx:attributes>
58                 <!-- 傳播行為 -->
59                 <tx:method name="save*" propagation="REQUIRED"/>
60                 <tx:method name="delete*" propagation="REQUIRED"/>
61                 <tx:method name="insert*" propagation="REQUIRED"/>
62                 <tx:method name="update*" propagation="REQUIRED"/>
63                 <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
64                 <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
65                 <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
66             </tx:attributes>
67         </tx:advice>
68 
69         <!-- 要掃描的serviceImpl包 aop -->
70         <aop:config>
71             <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.ssm.service.*.*(..))"/>
72         </aop:config>
73         
74 </beans>

四、

1.創建db.properties，并賦值

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/hahaha
jdbc.username=root
jdbc.password=123456

2.mybatis的全域組態檔（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>

    <!-- 全域setting配置，根據需要添加 -->

    <!-- 配置別名 -->
    <typeAliases>
        <!-- 批量掃描別名 -->
        <package name="com.ssm.po"/>
    </typeAliases>

    <!-- 配置mapper
    由于使用spring和mybatis的整合包進行mapper掃描，這里不需要配置了，
    必須遵循：mapper.xml和mapper.java檔案同名且在一個目錄 
     -->

    <!-- <mappers>

    </mappers> --> 
</configuration>

寫入專案

如圖

一、創建實體物件（t_role.java）

 1 package com.ssm.entity;
 2 
 3 public class t_role {
 4     private int id;
 5     private String tname;
 6     private String phon;
 7     private String endtimes;
 8     private String sname;
 9     public int getId() {
10         return id;
11     }
12     public void setId(int id) {
13         this.id = id;
14     }
15     public String getTname() {
16         return tname;
17     }
18     public void setTname(String tname) {
19         this.tname = tname;
20     }
21     public String getPhon() {
22         return phon;
23     }
24     public void setPhon(String phon) {
25         this.phon = phon;
26     }
27     public String getEndtimes() {
28         return endtimes;
29     }
30     public void setEndtimes(String endtimes) {
31         this.endtimes = endtimes;
32     }
33     public String getSname() {
34         return sname;
35     }
36     public void setSname(String sname) {
37         this.sname = sname;
38     }
39     public t_role() {
40         
41     }
42     public t_role(int id, String tname, String phon, String endtimes, String sname) {
43         this.id = id;
44         this.tname = tname;
45         this.phon = phon;
46         this.endtimes = endtimes;
47         this.sname = sname;
48     }
49     @Override
50     public String toString() {
51         return "t_role [id=" + id + ", tname=" + tname + ", phon=" + phon + ", endtimes=" + endtimes + ", sname="
52                 + sname + "]";
53     }
54     
55     
56     
57     
58    
59 }

二、創建tMapper.java和tMapper.xml

tMapper.java

package com.ssm.mapper;

import java.util.List;

import com.ssm.entity.t_role;


public interface tMapper {
    void save(t_role t_role); 
    int update(t_role t_role);
    boolean delete(int id);
    t_role findById(int id);
    List<t_role> findAll();
}

tMapper.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.ssm.mapper.tMapper">
    <!-- 添加 -->
    <insert id="save" parameterType="com.ssm.entity.t_role">
        INSERT INTO t_role(id,tname,phon,endtimes,sname) VALUES(#{id},#{tname},#{phon},#{endtimes},#{sname})
    </insert>
    <!-- 修改 -->
    <update id="update" parameterType="com.ssm.entity.t_role">
        UPDATE t_role SET tname=#{tname},phon=#{phon},endtimes=#{endtimes},sname=#{sname} where id=#{id}
    </update>
    <!-- 洗掉 -->
    <delete id="delete" parameterType="int">
        DELETE FROM t_role WHERE id=#{id}
    </delete>
    <!-- 查詢 -->
    <select id="findById" parameterType="int" resultType="com.ssm.entity.t_role">
        SELECT * FROM t_role WHERE id=#{id}
    </select>
    <!-- 查詢 -->
    <select id="findAll" resultType="com.ssm.entity.t_role">
        SELECT * FROM t_role
    </select>
    <!-- 分頁 -->
    <select id="selectUsersByPage" parameterType="int" resultType="com.ssm.entity.t_role">
           SELECT TOP 10 * FROM
        (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ROWNUMBER,* FROM t_role )
        AS A WHERE ROWNUMBER>10*(#{page}-1)
    </select>
</mapper>

三、創建tservice.java和tserviceImpl.java

tservice.java

package com.ssm.service;

import java.util.List;

import com.ssm.entity.t_role;

public interface tservice {
         void save(t_role t_role); 
        int update(t_role t_role);
        boolean delete(int id);
        t_role findById(int id);
        List<t_role> findAll();
}

tserviceImpl.java

 1 package com.ssm.service;
 2 
 3 import java.util.List;
 4 
 5 import javax.annotation.Resource;
 6 
 7 import org.springframework.beans.factory.annotation.Autowired;
 8 import org.springframework.stereotype.Service;
 9 import org.springframework.transaction.annotation.Transactional;
10 
11 import com.ssm.entity.t_role;
12 import com.ssm.mapper.tMapper;
13 //宣告是service層
14 @Service
15 public class tserviceImpl implements tservice {
16     @Autowired
17  //相當于servlet的 service service=new service();
18     private tMapper tMapper;
19     public void save(t_role t_role) {
20         tMapper.save(t_role);
21         
22     }
23 
24     @Override
25     public int update(t_role t_role) {
26         
27         return tMapper.update(t_role);
28     }
29 
30     @Override
31     public boolean delete(int id) {
32 
33         return tMapper.delete(id);
34         
35     }
36 
37     @Override
38     public t_role findById(int id) {
39         
40         return tMapper.findById(id);
41     }
42 
43     @Override
44     public List<t_role> findAll() {
45         
46         return tMapper.findAll();
47     }
48 
49 }

四、tcontroller.java

 1 package com.ssm.controller;
 2 
 3 import java.io.IOException;
 4 import java.io.PrintWriter;
 5 import java.util.List;
 6 
 7 import javax.servlet.http.HttpServletRequest;
 8 import javax.servlet.http.HttpServletResponse;
 9 
10 import org.springframework.beans.factory.annotation.Autowired;
11 import org.springframework.stereotype.Controller;
12 import org.springframework.ui.Model;
13 import org.springframework.web.bind.annotation.RequestMapping;
14 
15 import com.ssm.entity.t_role;
16 import com.ssm.service.tservice;
17 //宣告是控制層
18 @Controller
19 public class tcontroller {
20     //相當于servlet的 service service=new service();
21     @Autowired
22     private tservice tservice;
23     @RequestMapping("/findall.do")
24      public String getAllUser(HttpServletRequest request,Model model){
25         List<t_role> tlist=tservice.findAll();
26         model.addAttribute("List",tlist);
27         request.setAttribute("List",tlist);
28         return "/findall";
29     }
30     @RequestMapping("/toadd.do")
31     public String toAddUser()
32     {
33         return "/toadd";
34     }
35     @RequestMapping("/add.do")
36     public String add(t_role t_role){
37         tservice.save(t_role);
38         return "redirect:/findall.do";
39     }
40     @RequestMapping("/toupdate.do")
41     public String toupdate(t_role t_role,HttpServletRequest request,Model model){
42         
43             t_role=tservice.findById(t_role.getId());
44             request.setAttribute("t_role",t_role);
45             model.addAttribute("t_role",t_role);
46             return "toupdate";
47        
48     }
49     @RequestMapping("/update.do")
50     public String update(t_role t_role,HttpServletRequest request,Model model){
51         if(tservice.update(t_role)!=0)
52         {
53             t_role=tservice.findById(t_role.getId());
54             request.setAttribute("t_role",t_role);
55             model.addAttribute("t_role",t_role);
56             return "redirect:/findall.do";
57         }
58         else {
59             return "/error";                    
60         }
61     }
62     @RequestMapping("/delete.do")
63     public void delUser(int id,HttpServletRequest request,HttpServletResponse response){
64         String result="{\"result\":\"error\"}";
65         if(tservice.delete(id))
66         {
67             result="{\"result\":\"success\"}";
68         }else {
69             result="{\"result\":\"error\"}";
70         }
71         response.setContentType("application/json");
72         try {
73             PrintWriter out=response.getWriter();
74             out.write(result);
75         } catch (IOException e) {
76             // TODO Auto-generated catch block
77             e.printStackTrace();
78         }
79     }
80     
81 
82 }

五、jsp檔案和index歡迎頁

findall.jsp

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%
 3 String path = request.getContextPath();
 4 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
 5 %>
 6 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
 7 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 8 <html>
 9   <head>
10     <base href="<%=basePath%>">
11     
12     <title>My JSP 'allUser.jsp' starting page</title>
13     
14     <meta http-equiv="pragma" content="no-cache">
15     <meta http-equiv="cache-control" content="no-cache">
16     <meta http-equiv="expires" content="0">    
17     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
18     <meta http-equiv="description" content="This is my page">
19     <!--
20     <link rel="stylesheet" type="text/css" href="https://www.cnblogs.com/laogao2333/p/styles.css">
21     -->
22     <script type="text/javascript" src="/js/jquery-1.8.2.min.js"></script>
23     <script type="text/javascript">  
24       
25       </script>
26   </head>
27   
28   <body>
29     <h6><a href="<%=basePath%>toadd.do">添加用戶</a></h6>
30     <table border="1">
31         <tbody>
32             <tr>
33                 <th>id</th>
34                 <th>登錄名</th>
35                 <th>手機號</th>
36                 <th>最后一次修改時間</th>
37                 <th>所屬角色</th>
38                 <th>操作</th>
39                 
40                
41             </tr>
42             <c:if test="${!empty List}">
43                 <c:forEach items="${List}" var="List">
44                     <tr>
45                         <td>${List.id}</td>
46                         <td>${List.tname}</td>
47                         <td>${List.phon}</td>
48                         <td>${List.endtimes}</td>
49                         <td>${List.sname}</td>
50                         <td>  
51                             <a href="<%=basePath%>toupdate.do?id=${List.id}">編輯</a>  
52                             <a href="javascript:del('${List.id}')">洗掉</a>  
53                         </td>
54                     </tr>
55                 </c:forEach>
56             </c:if>
57         </tbody>
58     </table>
59   </body>
60 </html>

toadd.jsp

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 2 <%
 3 String path = request.getContextPath();
 4 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
 5 %>
 6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 7 <html>
 8   <head>
 9     <base href="<%=basePath%>">
10     
11     <title>My JSP 'addUser.jsp' starting page</title>
12     
13     <meta http-equiv="pragma" content="no-cache">
14     <meta http-equiv="cache-control" content="no-cache">
15     <meta http-equiv="expires" content="0">    
16     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
17     <meta http-equiv="description" content="This is my page">
18     <!--
19     <link rel="stylesheet" type="text/css" href="https://www.cnblogs.com/laogao2333/p/styles.css">
20     -->
21     <script type="text/javascript" src="../js/jquery-1.8.2.min.js"></script>
22     <script type="text/javascript">
23             function add(){  
24             var form = document.forms[0];  
25             form.action = "<%=basePath%>add.do";  
26             form.method="post";  
27             form.submit();
28         }
29     </script>
30   </head>
31   
32   <body>
33     <h1><%=path%>添加用戶<%=basePath%></h1>  
34     <form action="" name="userForm">  
35         ID：<input type="text" name="id">  
36         登錄名：<input type="text" name="tname">  
37         手機號：<input type="text" name="phon">  
38         最后一次修改時間：<input type="text" name="endtimes"> 
39         所屬角色<input type="text" name="sname"> 
40         <input type="button" value="添加" onclick="add()">  
41     </form> 
42   </body>
43 </html>

toupdate.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'editUser.jsp' starting page</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="https://www.cnblogs.com/laogao2333/p/styles.css">
    -->
    <script type="text/javascript" src="../js/jquery-1.8.2.min.js"></script>
    <script type="text/javascript">  
        function update(){ 
            var form=document.forms[0];
            form.action="<%=basePath%>update.do";
            form.method="post";  
            form.submit() ; 
        }  
    </script>
    </head>
  
  <body>
  <h1>修改用戶</h1>  
    <form action="" name="userForm">  
        <input type="hidden" name="id" value="${t_role.id}"/> 
        ID：<a>${t_role.id}</a> 
        登錄名：<input type="text" name="tname" value="${t_role.tname}"/>  
        手機號：<input type="text" name="phon" value="${t_role.phon}"/>  
        最后一次修改時間：<input type="text" name="endtimes" value="${t_role.endtimes}"/> 
        所屬角色：<input type="text" name="sname" value="${t_role.sname}"/> 
        <input type="button" value="編輯" onclick="update()"/>  
    </form> 
  </body>
</html>

index.jsp

 1 <%@ page language="java" contentType="text/html; charset=utf-8"
 2     pageEncoding="utf-8"%>
 3 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 4 <html>
 5 <head>
 6 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 7 <title>Insert title here</title>
 8 </head>
 9 <body>
10      <form action="findall.do">
11          <input type="submit" value="查詢">
12      </form>
13 
14 </body>
15 </html>

轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/287522.html

標籤：Java

上一篇：Mybatis-學習筆記

下一篇：醒酒菜：影片圖解核心記憶體區--堆

eclipse-SSM框架整合及實作增刪改查

框架搭建

一、web.xml配置

二、配置spring-mvc.xml

三、配置spring(applicationContext.xml)

四、

1.創建db.properties，并賦值

2.mybatis的全域組態檔（mybatis-config.xml）

寫入專案

一、創建實體物件（t_role.java）

二、創建tMapper.java和tMapper.xml

tMapper.java

tMapper.xml

三、創建tservice.java和tserviceImpl.java

tservice.java

tserviceImpl.java

四、tcontroller.java

五、jsp檔案和index歡迎頁

findall.jsp

toadd.jsp

toupdate.jsp

index.jsp