IDEA 手动搭建SSM项目（非maven）

1、项目结构

2、搭建步骤

2.1、新建spring-web项目

2.2、添加mybatis依赖jar包

mybatis的jar可从官网 https://mybatis.org/mybatis-3/zh/getting-started.html 找到下载入口

2.3、将自己添加的jar包加到工程构建路径

2.4、创建类包

2.5、编写数据库配置文件db.properties

#以本机Oracle数据库为例
db.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
db.password=scott
db.username=scott
db.driverClassName=oracle.jdbc.driver.OracleDriver

2.6、编写spring配置文件

采用这种方式创建的项目，在web/WEB-INF下，已经为我们创建好了web和spring、springMVC的配置文件，且在web.xml中已经自动为我们配置好了spring和springMVC。所以，我们只需从自定义spring配置文件开始。

2.6.1、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">
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>*.form</url-pattern>
    </servlet-mapping>
</web-app>

2.6.2、spring配置文件内容

<?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:tx="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
       https://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:org/silence/properties/db.properties"/>
    <!--spring扫描包-->
    <context:component-scan base-package="org.silence"/>
    <!--开启注解-->
    <tx:annotation-driven/>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
        <property name="url" value="${db.url}"/>
        <property name="driverClassName" value="${db.driverClassName}"/>
        <property name="username" value="${db.username}"/>
        <property name="password" value="${db.password}"/>
    </bean>

    <!--配置sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--指定数据源-->
        <property name="dataSource" ref="dataSource"/>
        <!--指定mybatis配置文件-->
        <property name="configLocation" value="WEB-INF/sqlMapper.xml"/>
        <!--当mybatis的dao接口与mapper xml文件不在同一个包下时，需配置此属性用以指定xml文件-->
        <property name="mapperLocations" value="classpath:org/silence/mapper/*.xml"/>
    </bean>

    <!--配置mybatis扫描包路径-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--当有多个包时，使用逗号分隔-->
        <property name="basePackage" value="org.silence.dao"/>
        <!--SqlSessionFactoryBean配置的ID值-->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

</beans>

2.7、编写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:mvc="http://www.springframework.org/schema/mvc"
       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/mvc
       https://www.springframework.org/schema/mvc/spring-mvc.xsd
       http://www.springframework.org/schema/context
       https://www.springframework.org/schema/context/spring-context.xsd">

    <!--开启注解-->
    <mvc:annotation-driven/>
    <!--配置扫描包路径-->
    <context:component-scan base-package="org.silence"/>

    <!--视图解析器前后缀配置-->
    <!--<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"/>
        <property name="suffix" value=".html"/>
    </bean>-->
</beans>

2.8、编写mybatis配置文件

2.8.1、在WEB-INF下，创建sqlMapper.xml

2.8.2、添加如下内容

<?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>
    <mappers>
        <!--指定dao接口目录-->
        <package name="org.silence.dao"/>
    </mappers>
</configuration>

3、编写业务代码

3.1、数据库实体映射类

package org.silence.entities;

public class Emp {
    private String empNo;
    private String eName;
    private String job;
    private String mgr;
    private String hireDate;
    private String sal;
    private String comm;
    private String deptNo;

    public String getEmpNo() {
        return empNo;
    }

    public void setEmpNo(String empNo) {
        this.empNo = empNo;
    }

    public String geteName() {
        return eName;
    }

    public void seteName(String eName) {
        this.eName = eName;
    }

    public String getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }

    public String getMgr() {
        return mgr;
    }

    public void setMgr(String mgr) {
        this.mgr = mgr;
    }

    public String getHireDate() {
        return hireDate;
    }

    public void setHireDate(String hireDate) {
        this.hireDate = hireDate;
    }

    public String getSal() {
        return sal;
    }

    public void setSal(String sal) {
        this.sal = sal;
    }

    public String getComm() {
        return comm;
    }

    public void setComm(String comm) {
        this.comm = comm;
    }

    public String getDeptNo() {
        return deptNo;
    }

    public void setDeptNo(String deptNo) {
        this.deptNo = deptNo;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "empNo='" + empNo + '\'' +
                ", eName='" + eName + '\'' +
                ", job='" + job + '\'' +
                ", mgr='" + mgr + '\'' +
                ", hireDate='" + hireDate + '\'' +
                ", sal='" + sal + '\'' +
                ", comm='" + comm + '\'' +
                ", deptNo='" + deptNo + '\'' +
                '}';
    }
}

3.2、dao接口和mapper xml文件

3.2.1、dao接口

package org.silence.dao;

import org.silence.entities.Emp;

import java.util.List;

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

3.2.2、mapper 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="org.silence.dao.EmpDao">
    <select id="queryEmp" resultType="org.silence.entities.Emp">
        select * from emp
    </select>
</mapper>

3.3、service接口及其实现类

package org.silence.servie;

import org.silence.entities.Emp;

import java.util.List;

public interface IEmpService {
    List<Emp> getAllEmp();
}

package org.silence.servie.impl;

import org.silence.dao.EmpDao;
import org.silence.entities.Emp;
import org.silence.servie.IEmpService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class EmpService implements IEmpService {
    @Autowired
    private EmpDao dao;

    @Override
    public List<Emp> getAllEmp() {
        return dao.queryEmp();
    }
}

3.4、controller控制器

package org.silence.controller;

import org.silence.entities.Emp;
import org.silence.servie.IEmpService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
public class EmpController {
    @Autowired
    private IEmpService service;

    @RequestMapping("/getAllEmp")
    @ResponseBody
    public List<Emp> getAllEmp() {
        System.out.println("----------EmpController.getAllEmp----------");
        List<Emp> empList = service.getAllEmp();
        empList.forEach(emp -> System.out.println(emp.toString()));
        return empList;
    }
}

3.5、添加json依赖包（当controller中采用json方式返回时）

注：记得加入工程路径

4、测试