基于IDEA的SSM整合

最新推荐文章于 2020-12-09 20:25:52 发布

Lin_xiaobai

最新推荐文章于 2020-12-09 20:25:52 发布

阅读量204

点赞数

文章标签： java

本文链接：https://blog.csdn.net/Lin_xiaobai/article/details/109155768

版权

首先我们需要导入相关的pom依赖(这里直接提供)

<!--配置资源过滤：读取java文件下的xml文件-->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>

    <properties>
                 <!-- spring版本号 -->
                 <spring.version>4.1.6.RELEASE</spring.version>
                 <!-- mybatis版本号 -->
                 <mybatis.version>3.2.6</mybatis.version>
                 <!-- log4j日志文件管理包版本 -->
                 <slf4j.version>1.7.7</slf4j.version>
                 <log4j.version>1.2.17</log4j.version>
      </properties>
         <dependencies>
             <dependency>
                 <groupId>junit</groupId>
                 <artifactId>junit</artifactId>
                 <version>4.11</version>
                 <!-- 表示开发的时候引入，发布的时候不会加载此包 -->
                 <scope>test</scope>
             </dependency>
             <dependency>
                 <groupId>org.projectlombok</groupId>
                 <artifactId>lombok</artifactId>
                 <version>1.18.14</version>
                 <scope>provided</scope>
             </dependency>
             <!-- spring核心包 -->
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-core</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-web</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-oxm</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-tx</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-jdbc</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-webmvc</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-aop</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-context-support</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-test</artifactId>
                 <version>${spring.version}</version>
             </dependency>
             <!-- mybatis核心包 -->
             <dependency>
                 <groupId>org.mybatis</groupId>
                 <artifactId>mybatis</artifactId>
                 <version>${mybatis.version}</version>
             </dependency>
             <!-- mybatis/spring包 -->
             <dependency>
                 <groupId>org.mybatis</groupId>
                 <artifactId>mybatis-spring</artifactId>
                 <version>1.2.2</version>
             </dependency>
             <!-- 导入java ee jar 包 -->
             <dependency>
                 <groupId>javax</groupId>
                 <artifactId>javaee-api</artifactId>
                 <version>7.0</version>
             </dependency>
             <!-- 导入Mysql数据库链接jar包 -->
             <dependency>
                 <groupId>mysql</groupId>
                 <artifactId>mysql-connector-java</artifactId>
                 <version>5.1.39</version>
             </dependency>
             <!-- c3p0连接池jar -->
             <dependency>
                 <groupId>c3p0</groupId>
                 <artifactId>c3p0</artifactId>
                 <version>0.9.1.2</version>
             </dependency>
             <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
             <dependency>
                 <groupId>commons-dbcp</groupId>
                 <artifactId>commons-dbcp</artifactId>
                 <version>1.2.2</version>
             </dependency>
             <!-- JSTL标签类 -->
             <dependency>
                 <groupId>jstl</groupId>
                 <artifactId>jstl</artifactId>
                 <version>1.2</version>
             </dependency>
             <!-- 日志文件管理包 -->
             <!-- log start -->
             <dependency>
                 <groupId>log4j</groupId>
                 <artifactId>log4j</artifactId>
                 <version>${log4j.version}</version>
             </dependency>
             <!-- 格式化对象，方便输出日志 -->
             <dependency>
                 <groupId>com.alibaba</groupId>
                 <artifactId>fastjson</artifactId>
                 <version>1.1.41</version>
             </dependency>
             <dependency>
                 <groupId>org.slf4j</groupId>
                 <artifactId>slf4j-api</artifactId>
                 <version>${slf4j.version}</version>
             </dependency>
             <dependency>
                 <groupId>org.slf4j</groupId>
                 <artifactId>slf4j-log4j12</artifactId>
                 <version>${slf4j.version}</version>
             </dependency>
             <!-- log end -->
             <!-- 映入JSON -->
             <dependency>
                 <groupId>org.codehaus.jackson</groupId>
                 <artifactId>jackson-mapper-asl</artifactId>
                 <version>1.9.13</version>
             </dependency>
             <!-- 上传组件包 -->
             <dependency>
                 <groupId>commons-fileupload</groupId>
                 <artifactId>commons-fileupload</artifactId>
                 <version>1.3.1</version>
             </dependency>
             <dependency>
                 <groupId>commons-io</groupId>
                 <artifactId>commons-io</artifactId>
                 <version>2.4</version>
             </dependency>
             <dependency>
                 <groupId>commons-codec</groupId>
                 <artifactId>commons-codec</artifactId>
                 <version>1.9</version>
             </dependency>
         </dependencies>

搭建工程结构

在这里插入图片描述

下边我们先把相关的xml文件配置好，有报红的地方不用担心，因为还没有对应的类或者mapper.xml文件

1.数据库配置文件 jdbc.properties

jdbc.url=jdbc:mysql:///lin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
jdbc.driver=com.mysql.jdbc.Driver
jdbc.username=lin
jdbc.password=123456

2.spring_mybatis.xml

<!--导入资源文件-->
	<context:property-placeholder location="classpath:jdbc.properties"/>

	<!--配置数据库连接池    这里使用c3p0-->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driver}"/>
		<property name="jdbcUrl" value="${jdbc.url}"/>
		<property name="user" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
		<!--c3p0的私有属性配置-->
		<property name="maxPoolSize" value="30"/>
		<property name="minPoolSize" value="10"/>
		<!--关闭后不自动commit-->
		<property name="autoCommitOnClose" value="false"/>
		<!--获取当前超时时间-->
		<property name="checkoutTimeout" value="10000"/>
	</bean>
	<!--配置sqlSessionFactoryBean对象-->
	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!--注入数据库连接池-->
		<property name="dataSource" ref="dataSource"/>
		<!--指定映射文件-->
		<property name="mapperLocations" value="classpath:com/lin/mapper/*.xml"/>
		<!--给实体类起别名-->
		<property name="typeAliasesPackage" value="com.lin.entity"/>
	</bean>
	<!--配置mapperScannerConfigurer-->
	<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!--指定扫描包的路径-->
		<property name="basePackage" value="com.lin.dao"/>
		<!--指定SqlSessionFactory    不指定也能自动注入-->
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
	</bean>
	<!--过滤静态资源-->
	<mvc:default-servlet-handler/>
	<!--开启MVC注解支持-->
	<mvc:annotation-driven/>

3.spring_mvc.xml

<!--通过 InternalResourceViewResolver 配置视图解析对象-->
	<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/"/>
		<property name="suffix" value=".jsp"/>
	</bean>
	<!--过滤静态资源-->
	<mvc:default-servlet-handler/>
	<!--开启MVC注解支持-->
	<mvc:annotation-driven/>

4.applicationContext.xml(主配置文件)

<!--开启注解扫描-->
	<context:component-scan base-package="com.lin"/>

	<!--关联其它配置文件-->
	<import resource="spring_mvc.xml"/>
	<import resource="spring_mybatis.xml"/>

	<!--配合事务-->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"/>
	</bean>

5.最后的配置就是web.xml文件的配置了

<servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:applicationContext.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
</servlet-mapping>
    <!--处理post请求中文乱码问题-->
<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><!--过滤不包括jsp-->
</filter-mapping>

到这里为止，我们的配置就都完成啦~

接下来就是对实体和业务进行编写了，这里只写对员工数据的查询操作。

这里需要同学们根据实体类自行建表！！！！

先在看一下工程的结构吧！
在这里插入图片描述

1.entity实体类

@Data     //这个注解需要导入lombok依赖能使用
public class Emp {
  private Integer id;
  private String name;
  private Double salary;
  private Double bonus;
  private Date hiredate;
  private Integer deptno;
}

2.dao层

public interface EmpDao {
  List<Emp> findAll();
}

3.mepper中的EmpMapper.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.lin.dao.EmpDao"><!--这里要注意，使用的是dao层下的接口-->
	<resultMap id="empMap" type="Emp">
		<id property="id" column="e_id"/>
		<result property="name" column="e_name"/>
		<result property="salary" column="e_salary"/>
		<result property="bonus" column="e_bonus"/>
		<result property="hiredate" column="e_hiredate"/>
		<result property="deptno" column="e_deptno"/>
	</resultMap>
	<select id="findAll" resultMap="empMap">
		select * from t_emp;
	</select>
</mapper>

4.service

public interface EmpService {
  List<Emp> findAll();
}

4.1、serviceImpl（注意！！ @Service这个注解不能忘）

@Service
public class EmpServiceImpl implements EmpService {
  @Autowired  //将到dao层的接口注入进来
  EmpDao empDao;
  @Override
  public List<Emp> findAll() {
    return empDao.findAll();
  }
}

6.controller

@Controller
@RequestMapping("/emp")
public class EmpController {
  @Autowired
  EmpService empService;
  @RequestMapping("/findAll")
  public String findAll(Model model){
    List<Emp> emps = empService.findAll();
    model.addAttribute("emps",emps);//将数据绑定发送到前端页面
    return "emp_list";//返回的响应页面（省去.jsp后缀）
  }
}

7.前端代码

<body>
<table width="60%" align="center" border="1" cellspacing="2" cellpadding="2">
    <tr>
        <th>员工号</th>
        <th>姓名</th>
        <th>薪水</th>
        <th>奖金</th>
        <th>入职日期</th>
        <th>部门号</th>
        <th>操作</th>
    </tr>

    <c:forEach items="${emps}" var="emp">
        <tr>
            <td>${emp.id}</td>
            <td>${emp.name}</td>
            <td>${emp.salary}</td>
            <td>${emp.bonus}</td>
            <td><fmt:formatDate value="${emp.hiredate}" type="date"/></td>
            <td>${emp.deptno}</td>
           <td>
               <a href="${pageContext.request.contextPath}/emp/toUpdate?id=${emp.id}">修改</a>
               <a href="${pageContext.request.contextPath}/emp/delete?id=${emp.id}">删除</a>
           </td>
        </tr>
    </c:forEach>

    <div align="center">
        <input type="button" value="添加" οnclick="location.href='${pageContext.request.contextPath}/emp/toAdd'">
    </div>
</table>
</body>

运行结果我就不截图啦~~~希望能帮到同学们~

在下退了

Lin_xiaobai

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于IDEA的SSM整合

首先我们需要导入相关的pom依赖(这里直接提供) <build> <resources> <resource> <directory>src/main/java</directory> <includes> <
复制链接

扫一扫