[Spring] 6. Spring Mybatis 실습

package myspring.user.dao;

import java.util.List;

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

import myspring.user.vo.UserVO;


@Repository
public class UserDAOImpl implements IUserDAO {

	
	//@Autowired
	//	private  SqlSession session;
	
	
	//@Autowired 말고 이렇게 써도 된다..
	private final SqlSession session;
	
	public UserDAOImpl(SqlSession session) {
		this.session = session;
		// TODO Auto-generated constructor stub
	}
	
	
	
	
	
	
	// User 1건 조회
	@Override
	public UserVO getUser(String userid) {
		return session.selectOne("userNS.selectUserByUserid", userid);
	}
	
	// UserList
	@Override
	public List<UserVO> getUsers() {
		return null;
	}
	
	@Override
	public int deleteUser(int id) {
		return 0;	
	}

	@Override
	public int updateUser(UserVO user) {
		return 0;
	}

	@Override
	public int insertUser(UserVO user) {
		return 0;
	}

}

이제 우리가 전에 했던 것 처럼...

DAO, VO만들어서 DB연동해서 CRUD해볼것이다.

 

 

VO부터 생성..

package myspring.user.vo;

import java.util.*;
/**
 * VO(Value Object)
 * DTO(Data Transfer Object), JavaBeans, Entity, 
 */
public class UserVO {

   
    /**
     * id
     */
    private int id;

    /**
     * userid
     */
    private String userid;

    /**
     * name
     */
    private String name;

    /**
     * gender
     */
    private String gender;

    /**
     * city
     */
    private String city;

    /**
     * date
     */
    private Date regdate;

    /**
     * Default constructor
     */
    public UserVO() {
    }

	public UserVO(String userid, String name, String gender, String city) {
		super();
		this.userid = userid;
		this.name = name;
		this.gender = gender;
		this.city = city;
	}

	public UserVO(int id, String userid, String name, String gender, String city) {
		this(userid,name,gender,city);
		this.id = id;
	}
	
	public UserVO(int id, String userid, String name, String gender, String city, Date regdate) {
		this(id,userid,name,gender,city);
		this.regdate = regdate;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUserid() {
		return userid;
	}

	public void setUserid(String userid) {
		this.userid = userid;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public Date getRegdate() {
		return regdate;
	}

	public void setRegdate(Date regdate) {
		this.regdate = regdate;
	}

	@Override
	public String toString() {
		return "UserVO [id=" + id + ", userid=" + userid + ", name=" + name + ", gender=" + gender + ", city=" + city
				+ ", regdate=" + regdate + "]";
	}
	
	
    
	
	
    
    

}

 

 

DAO생성..

우선 클래스명을 UserVOImpl로 생성한다. 그리고 인터페이스를 만들어줄것이다...

 

UserDAOImpl

package myspring.user.dao;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.springframework.stereotype.Repository;

import myspring.user.vo.UserVO;


@Repository
public class UserDAOImpl implements IUserDAO {
	
	private SqlSessionFactory sqlSessionFactory;

	@Override
	public int deleteUser(int id) {
		return 0;
	}

	@Override
	public int updateUser(UserVO user) {
		return 0;
	}

	@Override
	public int insertUser(UserVO user) {
		return 0;
	}

	// UserList
	@Override
	public List<UserVO> getUsers() {
		return null;
	}

	// User 1건 조회
	@Override
	public UserVO getUser(String userid) {
		return null;
	}

}

 

IUserDAO(인터페이스)

package myspring.user.dao;

import java.util.List;

import myspring.user.vo.UserVO;

public interface IUserDAO {

	// User 1건 조회
	UserVO getUser(String userid);
	
	// UserList
	List<UserVO> getUsers();

	int insertUser(UserVO user);
	int updateUser(UserVO user);
	int deleteUser(int id);
	
}

 

 

테스트 소스