2021年6月15日星期二

eclipse-SSM框架整合及实现增删改查

注意：这里使用jdk1.7版本
文件报错是因为jdk版本太高jdk1.7版本就不报错

框架搭建

一、web.

 1 <??> 2 <web-app ="http://www.w3.org/2001/ ="http://java.sun.com/ xsi:schemaLocation="http://java.sun.com/ 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.</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.-->31    32     <init-param>33      <param-name>contextConfigLocation</param-name>34         <!-- 这里要扫描springmvc的跳转和传输设置 -->35        36      <param-value>classpath:spring-mvc.</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.

<beans ="http://www.springframework.org/schema/beans" ="http://www.w3.org/2001/ ="http://www.springframework.org/schema/mvc" ="http://www.springframework.org/schema/context" ="http://www.springframework.org/schema/aop" ="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans                   ">   <!-- 开启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.

 1 <beans ="http://www.springframework.org/schema/beans" 2  ="http://www.w3.org/2001/ ="http://www.springframework.org/schema/mvc" 3  ="http://www.springframework.org/schema/context" 4  ="http://www.springframework.org/schema/aop" ="http://www.springframework.org/schema/tx" 5  xsi:schemaLocation="http://www.springframework.org/schema/beans  6    7    8    9   10   11   12   13   14   ">15   16   17   <!-- IOC -->18   <!-- web.-->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. />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.Driverjdbc.url=jdbc:mysql://localhost:3306/hahahajdbc.username=rootjdbc.password=123456

2.mybatis的全局配置文件（mybatis-config.

<??><!DOCTYPE configurationPUBLIC "-//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.--> <!-- <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  @Override50  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.

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.

<??><!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 @Service15 public class tserviceImpl implements tservice {16  @Autowired17 //相当于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  @Override25  public int update(t_role t_role) {26   27   return tMapper.update(t_role);28  }29 30  @Override31  public boolean delete(int id) {32 33   return tMapper.delete(id);34   35  }36 37  @Override38  public t_role findById(int id) {39   40   return tMapper.findById(id);41  }42 43  @Override44  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 @Controller19 public class tcontroller {20  //相当于servlet的 service service=new service();21  @Autowired22  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 block77    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="" 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="styles.css">21  -->22  <script type="text/javascript" src="https://www.cnblogs.com//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="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="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>

原文转载：http://www.shaoqun.com/a/802562.html

跨境电商：https://www.ikjzd.com/

贝恩资本：https://www.ikjzd.com/w/1336

myyearbook：https://www.ikjzd.com/w/726

wish：https://www.ikjzd.com/w/105

夸克：https://www.ikjzd.com/w/1237

注意：这里使用jdk1.7版本文件报错是因为jdk版本太高jdk1.7版本就不报错框架搭建一、web.1<??>2<web-app="http://www.w3.org/2001/="http://java.sun.com/xsi:schemaLocation="http://java.sun.com/id="WebApp_ID"
Orami：https://www.ikjzd.com/w/1501
Hepsiburada：https://www.ikjzd.com/w/1502
Yandex Market：https://www.ikjzd.com/w/1503
bonanza：https://www.ikjzd.com/w/275.html
马士基集团：https://www.ikjzd.com/w/1296
米谷：https://www.ikjzd.com/w/1788
纪委书记出书写反腐故事：落马高官自述与女明星情史：http://lady.shaoqun.com/m/a/274184.html
哥哥帮我照顾我让我很感激口述我与哥哥的那些事：http://lady.shaoqun.com/m/a/270119.html
后悔我主动把第一次献给了男家教：http://lady.shaoqun.com/a/271253.html
韶关乐奇水上世界需要带什么？准备什么东西？：http://www.30bags.com/a/390390.html
亚当和夏娃偷的"禁果"是什么？：http://www.30bags.com/a/390391.html
亚当和夏娃偷的"禁果"是什么？：http://lady.shaoqun.com/a/373158.html

没有评论:

发表评论

订阅：博文评论 (Atom)