Spring.MyBatis.table column 명과 VO의 instance변수 명이 다른 경우

as를 사용한다

package org.kosta.model.vo;

public class ProductVO {
	private String productNo;// 실재 db 컬럼명은 product_no, 인스턴스 변수명과 일치하지 않음
	private String name;
	private String maker;
	private int price;

	public ProductVO() {
		super();
	}

	public ProductVO(String name, String maker, int price) {
		super();
		this.name = name;
		this.maker = maker;
		this.price = price;
	}

	public String getProductNo() {
		return productNo;
	}

	public void setProductNo(String productNo) {
		this.productNo = productNo;
	}

	public String getName() {
		return name;
	}

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

	public String getMaker() {
		return maker;
	}

	public void setMaker(String maker) {
		this.maker = maker;
	}

	public int getPrice() {
		return price;
	}

	public void setPrice(int price) {
		this.price = price;
	}

}

<?xml version="1.0" encoding="UTF-8"?>
<!-- Sql Mapper -->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="product">
	<select id="findProductByNo" parameterType=" String"
		resultType="productVO">
		select product_no as productNo, name, maker, price
		from
		spring_product
		where product_no=#{value}
	</select>
</mapper>