SpringMVC+Spring+Mybatis+Oracle 实现HR管理（CRUD）二

1.项目结构

2.实体类

对应数据库表（代码平凡无奇）

3.service层

一个接口、一个实现类（代码平凡无奇）

4.mappers层（重点）

package ssm.mappers;


import java.util.List;


import ssm.domain.Position;


public interface PositionMapper {


List<Position> find(Long id);
}

<?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="ssm.mappers.PositionMapper">


<select id="find" resultMap="findResult">
select  e.e_id,
                  e.e_name,
                  e.e_sex,
                  e.e_education,
                  e.e_phone,
                  e.e_entrytime,
                  e.e_salary,
                  p.p_name , 
                  d.d_name 
                  from positions p left join employees e on p.p_id = e.e_p_id 
                  left join departments d on p.p_d_id = d.d_id
                  where p.p_id = #{id}
</select>
<resultMap type="Position" id="findResult">
<id property="p_id" column="p_id" />
<result property="p_name" column="p_name" />

<association property="department" resultMap="departmentResult">
          
        </association>

<collection property="employee" ofType="Employee">
    <id property="e_id" column="e_id" />
    <result property="e_name" column="e_name" />
    <result property="e_sex" column="e_sex" />
    <result property="e_education" column="e_education" />
    <result property="e_phone" column="e_phone" />
    <result property="e_entryTime" column="e_entryTime" />
    <result property="e_salary" column="e_salary" />
    </collection>

</resultMap>

<resultMap type="Department" id="departmentResult">
        <id property="d_id" column="d_id" />
<result property="d_name" column="d_name"/>
   </resultMap>


</mapper>  

5.controller层（与jsp页面打交道）

package ssm.controller;




import java.util.List;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;


import ssm.domain.Position;
import ssm.service.PositionService;


@Controller //控制器专用注解
public class PositionController {


@Autowired
private PositionService positionServiceImpl;

Long positionid = null;

//进入主页面
@RequestMapping(value="/index")
public String mainPage(){
return "index";
}

//获得positionId
@RequestMapping(value="positionId{id}")
public String getpositionId(@RequestParam("id") Long id , Model model){
positionid = id;
System.out.println(positionid);

List<Position> positionlist = positionServiceImpl.find(positionid);
model.addAttribute("pList", positionlist);

return "index";
}
}

6./SSMHR/src/jdbc.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:XE
jdbc.username=mzd
jdbc.password=8341

7./SSMHR/src/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>
<!-- <properties resource="jdbc.properties">
</properties> -->

<typeAliases>
  <package name="ssm.domain"/>
</typeAliases>


<!-- <environments default="development">
<environment id="development">
<transactionManager type="JDBC" />


<dataSource type="POOLED">
<property name="driver" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>


<mappers>
<package name="ssm.mappers" />
</mappers> -->


</configuration>

8./SSMHR/src/ssm/AppConfig.java

package ssm;


import javax.sql.DataSource;


import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.core.io.ClassPathResource;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.web.servlet.ViewResolver;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;
import org.springframework.web.servlet.view.InternalResourceViewResolver;
import org.springframework.web.servlet.view.JstlView;


@Configuration
@ComponentScan("ssm")
@EnableTransactionManagement
@PropertySource("classpath:jdbc.properties")
@MapperScan("ssm.mappers")
//@EnableWebMvc
public class AppConfig extends WebMvcConfigurerAdapter {
 
@Bean
public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
factoryBean.setDataSource(dataSource);
return factoryBean;
}

@Bean                       // 依赖Environment
public DataSource dataSource(Environment env) {
DriverManagerDataSource ds = new DriverManagerDataSource();
// env.getProperty("someKey") 获得属性值
ds.setDriverClassName(env.getProperty("jdbc.driverClassName"));
ds.setUrl(env.getProperty("jdbc.url"));
ds.setUsername(env.getProperty("jdbc.username"));
ds.setPassword(env.getProperty("jdbc.password"));
return ds;
}

@Bean
public PlatformTransactionManager transactionManager(DataSource dataSource) {
DataSourceTransactionManager manager = new DataSourceTransactionManager();
manager.setDataSource(dataSource);
return manager;
}

@Bean // 负责将控制器方法返回的字符串映射到某个JSP
public ViewResolver viewResolver() {
InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
viewResolver.setViewClass(JstlView.class); // 支持jsp及标准taglib
// customers => /WEB-INF/jsp/customers.jsp
// xyz => /WEB-INF/jsp/ + xyz + .jsp
viewResolver.setPrefix("/WEB-INF/jsp/");
viewResolver.setSuffix(".jsp");
return viewResolver;
}

}

9.jsp页面（代码平凡无奇）

10./SSMHR/WebContent/WEB-INF/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_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>SSM_HR</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>
  
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextClass</param-name>
      <param-value>org.springframework.web.context.support.AnnotationConfigWebApplicationContext</param-value>
    </init-param>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>ssm.AppConfig</param-value>
    </init-param>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  
</web-app>

11.项目运行截图

项目源码（含jar包）下载地址：http://download.****.net/download/mzd8341/10164961