从零搭建ssm框架（eclipse）

最新推荐文章于 2022-04-27 10:23:53 发布

磕磕唠

最新推荐文章于 2022-04-27 10:23:53 发布

阅读量397

点赞数

文章标签： mybatis ssm java

本文链接：https://blog.csdn.net/qq_36397267/article/details/107145515

版权

1.创建web项目（web版本选择2.5）

2.添加所需要的的jar

3.创建sqlAndMap.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>
</configuration>

4.applicationContext-dao.xml（配置数据源、配置SqlSessionFactory、mapper扫描器。）

<context:property-placeholder location="classpath:datasource.properties" />
   
   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <property name="driverClassName" value="${jdbc.driver}" />
       <property name="url" value="${jdbc.url}" />
       <property name="username" value="${jdbc.username}" />
       <property name="password" value="${jdbc.password}" />
       <property name="maxActive" value="10" />
       <property name="maxIdle" value="5" />
   </bean>

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

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       
       <property name="dataSource" ref="dataSource" />
       
       <property name="typeAliasesPackage" value="com.springmvc.dao.pojo"></property>
       
       <property name="mapperLocations" value="classpath*:mapper/*Mapper.xml"></property>
       
       <property name="configLocation" value="classpath:sqlMapConfig.xml" />
   </bean>

</beans>

5.applicationContext-service.xml（扫描@service注解）

</beans>
6.applicationContext-transaction.xml（配置事务管理器）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:p="http://www.springframework.org/schema/p"
   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.0.xsd
   http://www.springframework.org/schema/context
   http://www.springframework.org/schema/context/spring-context-4.0.xsd
   http://www.springframework.org/schema/aop
   http://www.springframework.org/schema/aop/spring-aop-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/util
   http://www.springframework.org/schema/util/spring-util-4.0.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="delete*" propagation="REQUIRED"/>
           <tx:method name="update*" propagation="REQUIRED"/>
           <tx:method name="find*" 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.springmvc.service.*.*(..))"/>
   </aop:config>
</beans>

7.springmvc.xml（springmvc核心配置）

<?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:p="http://www.springframework.org/schema/p"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:dubbo="http://code.alibabatech.com/schema/dubbo"
   xmlns:mvc="http://www.springframework.org/schema/mvc"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
http://code.alibabatech.com/schema/dubbo
http://code.alibabatech.com/schema/dubbo/dubbo.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd">


<context:component-scan base-package="com.springmvc.controller"></context:component-scan>

   
   <mvc:annotation-driven></mvc:annotation-driven>


   
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
       
       
       <property name="prefix" value="/WEB-INF/jsp/"></property>
       
       <property name="suffix" value=".jsp"></property>
   </bean>
</beans>

8.web.xml

<?xml version="1.0" encoding="UTF-8"?>
<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_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>springmvc</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>


   <context-param>
       <param-name>contextConfigLocation</param-name>
       <param-value>classpath:applicationContext-*.xml</param-value>
   </context-param>
   <listener>
       <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
   </listener>


<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:springmvc.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>

9.配置数据源

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/study?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456

10.创建Student.java

public class Student {
   private Integer id;
   private String username;
   private String sex;
   @DateTimeFormat(pattern="yyyy-MM-dd")
   private Date birthdy;
   private String address;

   public Integer getId() {
       return id;
   }

   public void setId(Integer id) {
       this.id = id;
   }

   public String getUsername() {
       return username;
   }

   public void setUsername(String username) {
       this.username = username;
   }

   public String getSex() {
       return sex;
   }

   public void setSex(String sex) {
       this.sex = sex;
   }

   public Date getBirthdy() {
       return birthdy;
   }

   public void setBirthdy(Date birthdy) {
       this.birthdy = birthdy;
   }

   public String getAddress() {
       return address;
   }

   public void setAddress(String address) {
       this.address = address;
   }

   @Override
   public String toString() {
       SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
       // TODO Auto-generated method stub
       return username+sex+format.format(birthdy)+address;
   }
}

11.创建StudentController.java

@Controller
public class StudentController {

   @Resource
   StudentService studentService;

       @RequestMapping("/getStudentList")
       public ModelAndView getStudentList() {
           List<Student> list = studentService.getStudentList();
           System.out.println("list--->"+list.size());
           for(Student stu:list) {
               System.out.println(stu.toString());
           }
           ModelAndView modelAndView = new ModelAndView();
           modelAndView.addObject("stuList", list);
           modelAndView.setViewName("stuList");
           return modelAndView;
       }
}

12.创建接口类StudentService.java

public interface StudentService {
List<Student> getStudentList();
}

13.创建StudentServiceImpl.java

@Service
public class StudentServiceImpl implements StudentService{

   @Resource
   StudentMapper studentMapper;

   @Override
   public List<Student> getStudentList() {
       // TODO Auto-generated method stub
       return studentMapper.getStudentList();
   }

}

14.创建StudentMapper.java

public interface StudentMapper {
List<Student> getStudentList();
}

15.创建StudentMapper.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.springmvc.mapper.StudentMapper">

<select id="getStudentList" resultType="com.springmvc.dao.pojo.Student">
SELECT * from Student
</select>
</mapper>

16.创建stuList.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>学生列表</title>
</head>
<body>
学生列表：
<table width="100%" border=1>
<tr>
   <td>姓名</td>
   <td>性别</td>
   <td>生日</td>
   <td>地址</td>
</tr>
<c:forEach items="${stuList}" var="stu">
<tr>
   <td>${stu.username }</td>
   <td>${stu.sex }</td>
   <td><fmt:formatDate value="${stu.birthdy}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
   <td>${stu.address }</td>
</tr>
</c:forEach>
</table>
</body>
</html>

17.数据库脚本

create table `student` (
   `id` integer ,
   `username` varchar (90),
   `sex` varchar (9),
   `birthdy` date ,
   `address` varchar (90)
);
insert into `student` (`id`, `username`, `sex`, `birthdy`, `address`) values('1','李白','男','1362-01-01','唐');
insert into `student` (`id`, `username`, `sex`, `birthdy`, `address`) values('2','鲁班','男','1322-02-01','战国');
insert into `student` (`id`, `username`, `sex`, `birthdy`, `address`) values('3','韩信','男','1234-09-22','汉');
insert into `student` (`id`, `username`, `sex`, `birthdy`, `address`) values('4','嬴政','男','1234-09-22','秦');

18.启动项目，访问页面如下

OVER！

磕磕唠

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
从零搭建ssm框架（eclipse）

1.创建web项目（web版本选择2.5）2.添加所需要的的jar3.创建sqlAndMap.xml（空文件即可）<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>
复制链接

扫一扫