mybatis-spring

 

https://mvnrepository.com/artifact/org.mybatis/mybatis-spring/1.3.0

 

pom.xml

		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>

 

 

root-context.xml

<?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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd">
	
	<!-- Root Context: defines shared resources visible to all other web components -->
	<import resource="/appServlet/applicationContext.xml"/>
	
	<bean id="localValidator"
    class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />

	
	<bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
		<property name="basename" value="messages" />
		<property name="defaultEncoding" value="UTF-8" />
	</bean>
	
	
	
	
</beans>

 

 

applicationContext.xml

<?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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://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:annotation-config />

	<!-- mySQL DB연결위한 작업 -->
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy">
		</property>
		<property name="url" value="jdbc:log4jdbc:mysql://127.0.0.1:3306/team4"></property>
		<property name="username" value="wjheo"></property>
		<property name="password" value="1111"></property>
	</bean>


<!-- 	<bean id="userDao" class="com.java.dao.users.JdbcUserDao">
		<property name="dataSource" ref="dataSource"></property>
	</bean> 
	
	-->

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:/mybatis-config.xml"/>
		<property name="mapperLocations" value="classpath:mappers/**/*Mapper.xml"/>
	</bean>

	
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="clearCache">
		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
	</bean>


<!-- 	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" value="org.mybatis.spring.sample.mapper.UserMapper" />
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>
 -->




</beans>

 

 

 

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>




</configuration>

 

 

UserMapper.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="UserMapper">
  
  <select id="findById" resultType="com.java.dto.User">
  	select * from USERS where userId=#{userId}
  </select>
  
  
  <insert id="create">
  	insert into USERS values(#{userId}, #{password} , #{name} , #{email})
  </insert>
  
</mapper>

 

interface IUserDao

package com.java.dao.users;

import com.java.dto.User;

public interface IUserDao {

	User findById(String userId);

	void create(User user);

	void update(User user);

}

 

 

class MyBatisUserDao

package com.java.dao.users;

import org.apache.ibatis.session.SqlSession;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.java.dto.User;

@Repository
public class MyBatisUserDao implements IUserDao {

	private static final Logger log = LoggerFactory.getLogger(MyBatisUserDao.class);
		
	@Autowired	
	private SqlSession sqlsession;
	
	private static String namespace="UserMapper.";
	
	
	@Override
	public User findById(String userId) {
		User user =sqlsession.selectOne(namespace+"findById", userId);
		return user;
	}

	
	
	@Override
	public void create(User user) {
		

	}

	@Override
	public void update(User user) {
		

	}

	
	
	
}