프로젝트를 생성하고 한번 실행해본다. HelloWorld가 잘 나오는지!
pom.xml
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>4.2.0.Final</version>
</dependency>
<dependency>
<groupId>javax.xml.bind</groupId>
<artifactId>jaxb-api</artifactId>
<version>2.2.8</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>12.1.0.1</version>
</dependency>
<!-- datasource관련 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!-- mybatis관련 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.1.0</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.1.0</version>
</dependency>
<!-- 파일 업로드 관련 cos.jar 대신 사용-->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>1.3.2</version>
</dependency>이번에는 파일업로드와 관련된 dependency 설정도 같이 해준다.
web.xml로 이동하여, 한글설정과 servlet 매핑작업을 해준다.
web.xml
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 서블릿매핑설정 *.(여러가지요청한다.) -->
<servlet>
<servlet-name>product</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/prod-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>product</servlet-name>
<url-pattern>*.prd</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>member</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/member-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>member</servlet-name>
<url-pattern>*.mem</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>mall</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/mall-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>mall</servlet-name>
<url-pattern>*.mall</url-pattern>
</servlet-mapping>
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"
xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd">
<!-- Root Context: defines shared resources visible to all other web components -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="username" value="jspid"/>
<property name="password" value="jsppw"/>
</bean>
<bean id="sqlSessionFactoryBean"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="configLocation"
value="classpath:/mybatis/SqlMapConfig.xml"/>
</bean>
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg ref="sqlSessionFactoryBean"/>
</bean>
</beans>
<!-- mapper위치 없다. 테이블이 여러개 있으므로 SqlMapConfig.xml에 여러개의 mapper파일을 작성한다 -->
<property name="configLocation" value="classpath:/mybatis/SqlMapConfig.xml"/>
이 경로대로 mybatis/SqlMapConfig.xml 을 생성한다.
src/main/java를 선택하고, mybatis 패키지의 SqlMapConfig.xml 파일을 생성한다.
📁mybatis
💾 SqlMapConfig.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>
<typeAliases>
<typeAlias type="member.model.MemberBean" alias="MyMember"/>
<typeAlias type="product.model.ProductBean" alias="MyProduct"/>
</typeAliases>
<mappers>
<mapper resource="mybatis/product.xml"/>
<mapper resource="mybatis/member.xml"/>
</mappers>
</configuration><!-- SqlMapConfig.xml 여기서 매퍼파일 위치 설정한다. 보통 테이블이 많을때 여기다가 적는다. 테이블이 많으므로 root-contex.xml에 여러개를 안적음 -->
<!-- 별칭설정과 mapper를 지정하였으면 그 위치에 파일을 만들어주어야 한다. 파일이 존재하지 않으면 에러가 발생할수있음 -->
위에 별칭과 mapper를 지정하였으므로 패키지와 클래스를 생성한다.
src/main/java를 선택하고, member.model패키지의 MemberBean파일을 생성한다.
📁member.model
💾 MemberBean
src/main/java를 선택하고, product.model패키지의 ProductBean 파일을 생성한다.
📁 product.model
💾 ProductBean
src/main/java를 선택하고, mybatis 패키지의 product.xml 파일을 생성한다.
📁mybatis
💾 SqlMapConfig.xml
src/main/java를 선택하고, mybatis 패키지의 member.xml 파일을 생성한다.
mybatis/member.xml
📁mybatis
💾 member.xml
web.xml의 파일에 설정된 servlet매핑 경로에 따라서 xml파일을 생성한다.
📁 /WEB-INF/spring/appServlet
💾 member-servlet.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd
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-3.1.xsd">
<mvc:annotation-driven/>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/member"/>
<property name="suffix" value=".jsp"/>
</bean>
<context:component-scan base-package="member"></context:component-scan>
</beans><!--*mem 요청=> member-servlet.xml -->
<!-- mvc, context Namespace 설정한다. -->
📁 /WEB-INF/spring/appServlet
💾 prod-servlet.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:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd
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-3.1.xsd">
<mvc:annotation-driven/>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/product"/>
<property name="suffix" value=".jsp"/>
</bean>
<context:component-scan base-package="product"></context:component-scan>
<!-- 사진업로드할때 필요한것 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="10485760"/>
<property name="defaultEncoding" value="UTF-8"/>
</bean>
</beans><!-- *prd 요청 => prod-servlet.xml -->
<!--
<property name="maxUploadSize" value="10485760"/> value= "10485760" 사진의 크기 10메가
<property name="defaultEncoding" value="UTF-8"/> 인코딩한것. -->
📁 /WEB-INF/spring/appServlet
💾 mall-servlet.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd
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-3.1.xsd">
<mvc:annotation-driven/>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/mall"/>
<property name="suffix" value=".jsp"/>
</bean>
<context:component-scan base-package="mall"/>
<context:component-scan base-package="member"/>
<context:component-scan base-package="product"/>
</beans><!--*.mall=> mall-servlet.xml -->
<!-- 주문할때 요청
어떤 회원이 어떤 상품을 주문한다. 그러므로 회원의 정보, 상품의 정보가 필요하다. -> member, product 패키지도 갈수있도록 지정한다. -->
webapp 바로 밑에 start.jsp
start.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
start.jsp<br><br>
<%
String viewProduct = request.getContextPath() +"/list.prd";
String viewOrder = request.getContextPath() +"/order.mall";
%>
<a href="<%=viewProduct%>">상품 목록 보기</a><br><br>
<a href="<%=viewOrder%>">나의 주문 내역</a><br><br>
기본위치 : http://localhost:8080/ex/order.mall
String viewProduct = "list.prd"; 이렇게 사용해도 된다.
ex밑에서 요청이 들어가게 된다.
String viewProduct = "/list.prd";
사용하면 http://localhost:8080/order.mall
ex없는 경로로 나오게 되버린다.
📁 product.controller
💾 ProductListController.java
package product.controller;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import product.model.ProductBean;
import product.model.ProductDao;
import utility.Paging;
@Controller
public class ProductListController {
//상품명과 설명으로 검색기능 넣기
private final String command ="/list.prd";
private String getPage ="/ProductList";
@Autowired
private ProductDao pdao;
@RequestMapping(command)
public ModelAndView list(HttpServletRequest request,
@RequestParam(value="whatColumn", required=false) String whatColumn,
@RequestParam(value="keyword", required=false) String keyword,
@RequestParam(value="pageNumber", required=false) String pageNumber
) {
System.out.println("whatColumn:"+whatColumn);
System.out.println("keyword:"+keyword);
System.out.println("pageNumber:"+pageNumber);
//검색
Map<String,String> map = new HashMap<String,String>();
map.put("whatColumn", whatColumn);
map.put("keyword", "%"+keyword+"%");
//페이징
int totalCount = pdao.getProductCount(map);//검색어가 포함된 레코드를 가져온다.
System.out.println("totalCount:"+totalCount);//전체 레코드 개수를 paging에 넣는다.
String url = request.getContextPath()+command;
System.out.println("url:"+url);
Paging pageInfo = new Paging(pageNumber, null, totalCount, url, whatColumn, keyword, null);
ModelAndView mav = new ModelAndView();
List<ProductBean> lists = new ArrayList<ProductBean>();
lists = pdao.getProductList(pageInfo,map);
mav.addObject("lists", lists);
mav.addObject("pageInfo", pageInfo);
mav.addObject("totalCount", totalCount);
mav.setViewName(getPage);
return mav;
}
}
📁 product.model
💾 ProductDao.java
package product.model;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.RowBounds;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import utility.Paging;
@Component("ProductDao")
public class ProductDao {
private final String namespace="product.model.Product";
@Autowired
SqlSessionTemplate sqlSessionTemplate;
public List<ProductBean> getProductList(Paging pageInfo, Map<String,String> map) {
List<ProductBean> lists = new ArrayList<ProductBean>();
RowBounds rowBounds = new RowBounds(pageInfo.getOffset(),pageInfo.getLimit());
lists = sqlSessionTemplate.selectList(namespace+".GetProductList",map,rowBounds);
System.out.println("lists:"+lists.size());
return lists;
}
public int getProductCount(Map<String,String> map) {
int totalCount = sqlSessionTemplate.selectOne(namespace+".GetProductCount",map);
System.out.println("totalCount:"+totalCount);
return totalCount;
}
📁mybatis
💾 product.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="product.model.Product">
<select id="GetProductList" resultType="MyProduct">
select * from products
<if test="whatColumn == 'name'">
where name like #{keyword}
</if>
<if test="whatColumn == 'contents'">
where contents like #{keyword}
</if>
order by num desc
</select>
<select id="GetProductCount" resultType="int">
select count(*) from products
<if test="whatColumn == 'name'">
where name like #{keyword}
</if>
<if test="whatColumn == 'contents'">
where contents like #{keyword}
</if>
</select>
</mapper>
WEB-INF/product
📁 product
💾 ProductList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../common/common.jsp" %>
ProductList.jsp<br>
<a href="start.jsp">시작페이지</a>
<a>로그아웃</a>
<script type="text/javascript">
function insert(){
//alert(1);
location.href ="insert.prd";
}
</script>
<center>
<h2>상품 리스트 화면</h2>
<h2>ProductList.jsp</h2>
<form action ="list.prd" method="get">
<select name="whatColumn">
<option value="">전체검색</option>
<option value="name">상품명</option>
<option value="contents">설명</option>
</select>
<input type="text" name="keyword">
<input type="button" value="검색">
</form>
<table border="1" align="center">
<tr>
<td colspan=6 align="right">
<input type="button" value="추가하기" onclick="insert()">
</td>
</tr>
<tr align="center">
<th>상품번호</th>
<th>상품명</th>
<th>설명</th>
<th>가격</th>
<th>삭제</th>
<th>수정</th>
</tr>
<c:forEach var="pd" items="${lists }">
<tr align="center">
<td>${pd.num }</td>
<td>${pd.name }</td>
<td>${pd.contents }</td>
<td>${pd.price }</td>
<td>삭제</td>
<td>수정</td>
</tr>
</c:forEach>
</table>
</center>
<center>
${pageInfo.pagingHtml}
</center>
검색 기능
<form action ="list.prd" method="get">
<select name="whatColumn">
<option value="">전체검색</option>
<option value="name">상품명</option>
<option value="contents">설명</option>
</select>
<input type="text" name="keyword">
<input type="button" value="검색">
</form>
<script type="text/javascript">
function insert(){
//alert(1);
location.href ="insert.prd";
}
</script>
ProductList.jsp에서 추가버튼을 눌러서 insert.prd요청을 하여 추가할 수 있도록 한다
요청을 받아서 controller에서 form으로 이동
💾 ProductInsertForm.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@include file="/WEB-INF/common/common.jsp" %>
ProductInsertForm.jsp<br>
<style>
.err {
font-size: 9px;
font-weight: bold;
color: red;
}
</style>
<!-- 파일을 업로드할때,enctype을 꼭 지정한다. method="post"로 해야한다.-->
<form:form commandName="product" method="post" action="insert.prd" enctype="multipart/form-data">
<h1><span>상품 추가 화면</span></h1>
<p>
<label for="name">*상품명</label>
<input type="text" name="name" id="name" value="${product.name }">
<form:errors cssClass="err" path="name"/>
</p>
<p>
<label for="company">제조 회사</label>
<input type="text" name="company" id="company" value="${product.company }">
</p>
<p>
<label for="price">*가격</label>
<input type="text" name="price" id="price" value="${product.price }">
<form:errors cssClass="err" path="price"/>
</p>
<p>
<label for="stock">재고 수량</label>
<input type="text" name="stock" id="stock" value="${product.stock }">
</p>
<p>
<label for="point">적립 포인트</label>
<input type="text" name="point" id="point" value="${product.point }">
</p>
<p>
<label for="contents">*설명</label>
<input type="text" name="contents" id="contents" value="${product.contents }">
<form:errors cssClass="err" path="contents"/>
</p>
<p>
<label for="upload">*그림 파일</label><!-- upload = a.jpg -->
<input type="file" name="upload" id="upload" value="${product.image }">
<form:errors cssClass="err" path="image"/>
</p>
<p>
<label for="inputdate">입고 일자</label>
<input type="text" name="inputdate" id="inputdate" value="${product.inputdate }">
</p>
<p>
<input type="submit" value="추가하기" id="btnSubmit">
</p>
</form:form>
label for="upload">*그림 파일</label><!-- upload = a.jpg -->
<input type="file" name="upload" id="upload" value="${product.image }">
<form:errors cssClass="err" path="image"/>
<!-- 파일을 업로드할때,enctype을 꼭 지정한다. method="post"로 해야한다.-->
<form:form commandName="product" method="post" action="insert.prd" enctype="multipart/form-data">
📁 product.controller
💾 ProductInsertController.java
package product.controller;
import java.io.File;
import java.io.IOException;
import javax.servlet.ServletContext;
import javax.validation.Valid;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import product.model.ProductBean;
import product.model.ProductDao;
@Controller
public class ProductInsertController {
private final String command ="insert.prd";
private String getPage="/ProductInsertForm";
private String gotoPage="redirect:/list.prd";
//HttpServletRequest request
//ServletContext application :프로젝트당 하나가 만들어지는 appication 객체
@Autowired
ServletContext servletContext; //프로젝트당 하나 만들어지는
@Autowired
private ProductDao pdao;
@RequestMapping(value=command,method=RequestMethod.GET)
public String insert() {
return getPage;
}
@RequestMapping(value=command,method=RequestMethod.POST)
public ModelAndView insert(@ModelAttribute("product") @Valid ProductBean pbean , BindingResult result) {
//command 객체가 만들어질때 , setUpload(내가 선택한 파일)가 생성된다
System.out.println("ProductInsertController POST");
ModelAndView mav = new ModelAndView();
if(result.hasErrors()) {
mav.setViewName(getPage);
return mav;
}
MultipartFile multi = pbean.getUpload(); //내가 선택한 파일일의 정보가 multi에 들어감.
System.out.println("multi.getName():"+multi.getName()); //multi.getName():upload
System.out.println("multi.getOriginalFilename():"+multi.getOriginalFilename());
//multi.getOriginalFilename():a.jpg
System.out.println("pbean.getImage():"+pbean.getImage());
//pbean.getImage():a.jpg
int cnt = pdao.insertProduct(pbean); //DB테이블에 저장하는 것, 이미지를 sql에서 조회했을때 문자열로만 확인이 된다.
String uploadPath = servletContext.getRealPath("/resources"); //업로드할 위치를 설정한다.(로컬위치)
System.out.println("uploadPath:"+uploadPath);//파일이 올라가는 위치
//uploadPath:C:\Spring_hbr\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\16_Spring_Mybatis_Products\resources
File file = new File(uploadPath+"/"+multi.getOriginalFilename());//로컬위치에 이미지 파일을 올린다.
try {
multi.transferTo(file); //업로드할 위치에 file로 관리하는 uploadPath+"/"+multi.getOriginalFilename()를 올린다.
} catch (IllegalStateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
mav.setViewName(gotoPage);
return mav;
}
}
command 객체가 만들어질때 , setUpload(내가 선택한 파일)가 생성된다
MultipartFile multi = pbean.getUpload(); - 내가 선택한 파일일의 정보가 multi에 들어감.
System.out.println("multi.getName():"+multi.getName()); - multi.getName():upload
System.out.println("multi.getOriginalFilename():"+multi.getOriginalFilename());
- multi.getOriginalFilename():a.jpg
System.out.println("pbean.getImage():"+pbean.getImage());
- pbean.getImage():a.jpg
String uploadPath = servletContext.getRealPath("/resources"); - 업로드할 위치를 설정한다.(로컬위치)
System.out.println("uploadPath:"+uploadPath); - 파일이 올라가는 위치
- uploadPath :C:\Spring_hbr\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\16_Spring_Mybatis_Products\resources
File file = new File(uploadPath+"/"+multi.getOriginalFilename()); - 로컬위치에 이미지 파일을 올린다.
try {
multi.transferTo(file); - 업로드할 위치에 file로 관리하는 uploadPath+"/"+multi.getOriginalFilename()를 올린다.
} catch (IllegalStateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
📁 product.model
💾 ProductBean
import org.springframework.web.multipart.MultipartFile;
public class ProductBean {
private int num;
//@NotBlank(message="상품명 누락입니다.")
//@Range(min=3,max=10 ,message="상품이름은 최소 3자리,최대 10자리 입니다.")
//@Range는 숫자를 뜻한다. 3원에서 10원
@Size(min=3,max=10 ,message="상품이름은 최소 3자리,최대 10자리 입니다.")
private String name;
//@NotBlank(message="제조회사 누락입니다.")
private String company;
//@NotNull(message="사진 파일 선택 안함") //유효성 안된다.
//@NotBlank(message="사진 파일 선택 안함") //유효성 된다,
@NotEmpty(message="사진 파일 선택 안함")
private String image;
private int stock;
@Range(min = 3000, message="가격은 최소 3000원 이상입니다.") //값의 범위를 정한다.
private int price;
private String category;
@Length(min=5, max=10, message="상품 설명은 최소 5자리 최대10자리입니다.")
private String contents;
private int point;
private String inputdate;
//데이터베이스에는 없는 칼럼 추가
private MultipartFile upload; //MultipartFile에 내가 선택한 파일이 담긴다.
public MultipartFile getUpload() {
return upload;
}
public void setUpload(MultipartFile upload) {
this.upload = upload;
System.out.println("setUpload:"+upload);
//setUpload:org.springframework.web.multipart.commons.CommonsMultipartFile@52243d7d :CommonsMultipartFil의 객체형태로 가져온다.
System.out.println("upload.getName:"+upload.getName());//MultipartFile 클래스가 가지고있는 getName을 출력해본다.
//upload.getName:upload -getName은 파일이 담긴 곳을뜻함
System.out.println("upload.getOriginalFilename():"+upload.getOriginalFilename());
//upload.getOriginalFilename():cheese.jpg
this.image=upload.getOriginalFilename(); //진짜 넣은 이미지가 들어간다.
}
public int getNum() {
return num;
}
public void setNum(int num) {
this.num = num;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
public int getStock() {
return stock;
}
public void setStock(int stock) {
this.stock = stock;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
public String getCategory() {
return category;
}
public void setCategory(String category) {
this.category = category;
}
public String getContents() {
return contents;
}
public void setContents(String contents) {
this.contents = contents;
}
public int getPoint() {
return point;
}
public void setPoint(int point) {
this.point = point;
}
public String getInputdate() {
return inputdate;
}
public void setInputdate(String inputdate) {
this.inputdate = inputdate;
}
}
type=file 일때 유효성 검사
@NotNull(message="사진 파일 선택 안함") - 유효성 안된다.
@NotBlank(message="사진 파일 선택 안함") - 유효성 된다,
@NotEmpty(message="사진 파일 선택 안함") - 유효성 된다,
private String image;
//데이터베이스에는 없는 칼럼 추가
private MultipartFile upload;
- type: MultipartFile
- MultipartFile에 내가 선택한 파일이 담긴다.
//getter
public MultipartFile getUpload() {
return upload;
}
//setter
public void setUpload(MultipartFile upload) {
this.upload = upload;
System.out.println("setUpload:"+upload);
-setUpload:org.springframework.web.multipart.commons.CommonsMultipartFile@52243d7d
:CommonsMultipartFil의 객체형태로 가져온다.
System.out.println("upload.getName:"+upload.getName());
- MultipartFile 클래스가 가지고있는 getName을 출력해본다.
- upload.getName:upload -getName은 파일이 담긴 곳을뜻함
System.out.println("upload.getOriginalFilename():"+upload.getOriginalFilename());
- upload.getOriginalFilename():cheese.jpg
this.image=upload.getOriginalFilename(); -진짜 넣은 이미지가 들어간다.
}
📁 product.model
💾 ProductDao.java
public int insertProduct(ProductBean pbean) {
int cnt = sqlSessionTemplate.insert(namespace+".productInsert",pbean);
System.out.println("insert cnt:"+cnt);
return cnt;
}
📁mybatis
💾 product.xml
<insert id="productInsert">
insert into products
values(seqprod.nextval, #{name}, #{company}, #{image}, #{stock}, #{price},
#{category,jdbcType=VARCHAR}, #{contents}, #{point}, #{inputdate})
</insert>category 칼럼을 입력하지 않으므로 넣어주면 에러가 발생한다.
#{category,jdbcType=VARCHAR} 라고 작성해주면, 자동으로 String타입의 null로 들어가게 되어서 에러가발생하지 않는다.
상품명을 클릭하면, 상세보기로 가는 detail.prd를 요청하여 상세보기로페이지로 이동하게 한다.
WEB-INF/product
📁 product
💾 ProductList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="../common/common.jsp" %>
ProductList.jsp<br>
<a href="start.jsp">시작페이지</a>
<a>로그아웃</a>
<script type="text/javascript">
function insert(){
//alert(1);
location.href ="insert.prd";
}
</script>
<center>
<h2>상품 리스트 화면</h2>
<h2>ProductList.jsp</h2>
<form action ="list.prd" method="get">
<select name="whatColumn">
<option value="">전체검색</option>
<option value="name">상품명</option>
<option value="contents">설명</option>
</select>
<input type="text" name="keyword">
<input type="button" value="검색">
</form>
<table border="1" align="center">
<tr>
<td colspan=6 align="right">
<input type="button" value="추가하기" onclick="insert()">
</td>
</tr>
<tr align="center">
<th>상품번호</th>
<th>상품명</th>
<th>설명</th>
<th>가격</th>
<th>삭제</th>
<th>수정</th>
</tr>
<c:forEach var="pd" items="${lists }">
<tr align="center">
<td>${pd.num }</td>
<td><a href="detail.prd?num=${pd.num }&pageNumber=${pageInfo.pageNumber}">${pd.name }</a></td>
<td>${pd.contents }</td>
<td>${pd.price }</td>
<td>삭제</td>
<td>수정</td>
</tr>
</c:forEach>
</table>
</center>
<center>
${pageInfo.pagingHtml}
</center>
<td><a href="detail.prd?num=${pd.num }&pageNumber=${pageInfo.pageNumber}">${pd.name }</a></td>
가지고 넘어갈 상품의 번호와 현재페이지번호를 가지고 간다.
📁 product.controller
💾 ProductDetailController.java
package product.controller;
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 product.model.ProductBean;
import product.model.ProductDao;
@Controller
public class ProductDetailController {
private final String command ="detail.prd";
private String getPage="/ProductDetailView";
@Autowired
private ProductDao pdao;
@RequestMapping(command)
public String detail(@RequestParam("num") String num,
@RequestParam("pageNumber") String pageNumber,
Model model
) {
System.out.println("ProductDetailController");
ProductBean pbean = pdao.selectProductByNum(num);
model.addAttribute("pbean", pbean);
model.addAttribute("pageNumber", pageNumber);
return getPage;
}
}
📁 product.model
💾 ProductDao.java
public ProductBean selectProductByNum(String num) {
ProductBean pbean;
pbean = sqlSessionTemplate.selectOne(namespace+".GetProductByNum", num);
System.out.println("pbean.getNum():"+pbean.getNum());
return pbean;
}
📁mybatis
💾 product.xml
<select id="GetProductByNum" resultType="MyProduct">
select * from products
where num=#{num}
</select>
WEB-INF/product
📁 product
💾 ProductDetail.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
productDetail.jsp <br>
<%=application.getRealPath("/resources")%> <br>
<%=application.getContextPath()%><br> <!-- /ex request.getContextPath() 와 같다.-->
<%=request.getContextPath()%><br><br><!-- /ex application.getContextPath()와 같다.-->
<center>
<h1><span>상품 상세보기 화면</span></h1>
<table border="1" width="500" height="400">
<tr>
<td rowspan=6>
<img height=70 width=70
src="<%=application.getContextPath()%>/resources/${pbean.image}">
<!-- 웹서버에 접근하기위한 경로설정 -->
<!-- /ex/resources/a.jpg
-> ex에 포함되어 있는 내용 C:\Spring_hbr\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\16_Spring_Mybatis_Products\resources
-->
</td>
<td align=center>상품명</td>
<td> ${pbean.name}</td>
</tr>
<tr>
<td>가격</td>
<td> ${pbean.price}</td>
</tr>
<tr>
<td>재고 수량</td>
<td> ${pbean.stock}</td>
</tr>
<tr>
<td>설명</td>
<td> ${pbean.contents}</td>
</tr>
<tr>
<td>주문 수량</td>
<td>
<form action="" method="post">
<input type="text" name="ordstock"> <input type="submit" value="주문">
</form>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<a href="list.prd?pageNumber=${param.pageNumber}">상품 리스트</a>
</td>
</tr>
</table>
</center>
<tr>
<td rowspan=6> : 한 열을 합친다.
<img height=70 width=70
src="<%=application.getContextPath()%>/resources/${pbean.image}">
- 웹서버에 접근하기위한 경로설정
- /ex/resources/a.jpg
-ex에 포함되어 있는 내용 C:\Spring_hbr\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\16_Spring_Mybatis_Products\resources
<%=application.getContextPath()%> 경로를 출력했을 때, /ex 출력된다. (= request.getContextPath() 와 같다)
<%=request.getContextPath()%> 경로를 출력했을 때, /ex 출력된다. (=application.getContextPath() 와 같다.)
'BACK END > Spring' 카테고리의 다른 글
| 11일(08.31)Spring_MyBatis_Products (0) | 2022.09.01 |
|---|---|
| 11일(08.31)Spring_MyBatis_Products (삭제-이미지포함, 수정-이미지포함, 로그인세션) (0) | 2022.08.31 |
| 9일(08.29) Spring_Mybatis_Movie (추가하기 - select option값 가져오기, 입력 유효성검사, 중복체크(ajax), 수정하기 ) (0) | 2022.08.29 |
| 8일(08.26)Spring_Mybatis_Movie (목록보기, 페이지설정,검색기능) (0) | 2022.08.26 |
| 8일(08.26) Spring_Mybatis_Travel /상세보기, 삭제, 수정 (0) | 2022.08.26 |