Spring miniプロジェクト設定

0.プロジェクトの作成
1.TABLEの作成
2. VO
3.dao(repository)-MYBATIS設定-マッパー.xml
4. component-scan - controller , service(interface) , dao(repository)(interface)
スプリング継承項目
プロジェクト作成名MemberBoard
JAva 1.8版
スプリング5.0.7バージョン
右クリック項目->properties->projectfacet->java 1.8
既存のoracleで作成したアカウントとともに使用します.
jdbc設定リンクを移動!
モバイルMy百色設定リンク!
jdbctempleteではなくmybatisとして使用します!
TABLEの作成

MemberVO<-TABLEカスタム

package com.spring.myapp.member.vo;
import com.google.protobuf.Timestamp;

public class MemberVO {
	
	private String id;
	private String pw;
	private String name;
	private String email;
	private String address;
	private Timestamp rdate;
	
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPw() {
		return pw;
	}
	public void setPw(String pw) {
		this.pw = pw;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public Timestamp getRdate() {
		return rdate;
	}
	public void setRdate(Timestamp rdate) {
		this.rdate = rdate;
	}
		
	@Override
	public String toString() {
		return "MemberVO [id=" + id + ", pw=" + pw + ", name=" + name + ", email=" + email + ", address=" + address
				+ ", rdate=" + rdate + "]";
	}
    
    }

root-context mybatis設定、component-scan

<?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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	
	<context:property-placeholder location="classpath:database/jdbc.properties"/>
	
	<bean id = "dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="${jdbc.driverClassName}"></property>
		<property name="url" value = "${jdbc.url}"></property>
		<property name="username" value ="${jdbc.username}"></property>
		<property name="password" value = "${jdbc.password}"></property>
	
	</bean>
	
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource" />
	<property name="mapperLocations" value="classpath:/mappers/**/*Mapper.xml" />
	</bean>
	
	
	<mybatis-spring:scan base-package="com.spring.myapp.member.dao"/>
	
	
<context:component-scan base-package="com.spring.myapp.member"/>
	
	
		
</beans>

mapper.xml
resources.mappers.Member.MemberMapper.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.spring.myapp.member.dao.IMemberDAO">
    
    </mapper>

controller

package com.spring.myapp.member.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;

import com.spring.myapp.member.service.IMemberService;

@Controller
public class MemberController {
	
	@Autowired
	IMemberService service;

}

service

package com.spring.myapp.member.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.spring.myapp.member.dao.IMemberDAO;

@Service
public class MemberService implements IMemberService {
	
	@Autowired
	IMemberDAO dao;

}