-
[Project] 쇼핑몰 상품 등록하기카테고리 없음 2022. 11. 10. 18:29
상품은 user와 분리된 패키지에 작성한다. [pdDAO]
public int productUplode(pdDTO pdDTO) {
String sql = "INSERT INTO productinformation VALUES (?, ?, ?, ?, ?)";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, pdDTO.getPdcode());
pstmt.setString(2, pdDTO.getPdname());
pstmt.setInt(3, pdDTO.getPdprice());
pstmt.setInt(4, pdDTO.getStock());
pstmt.setString(5, pdDTO.getPdsize());
return pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return -1; // 데이터베이스 오류
} // end of 상품등록()[productAction]
<%@page import="product.pdDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%><%@page import="java.io.PrintWriter"%>
<%
request.setCharacterEncoding("UTF-8");
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="pdDAO" class="product.pdDAO" scope="page"></jsp:useBean>
<jsp:useBean id="pdDTO" class="product.pdDTO" scope="page"></jsp:useBean>
<jsp:setProperty name="pdDTO" property="pdcode"></jsp:setProperty>
<jsp:setProperty name="pdDTO" property="pdname"></jsp:setProperty>
<jsp:setProperty name="pdDTO" property="pdprice"></jsp:setProperty>
<jsp:setProperty name="pdDTO" property="stock"></jsp:setProperty>
<jsp:setProperty name="pdDTO" property="pdsize"></jsp:setProperty>
<%
String pdname = null;
if (pdDTO.getPdcode() == null || pdDTO.getPdname() == null || pdDTO.getPdprice() == 0
|| pdDTO.getPdsize() == null || pdDTO.getStock() == 0) {
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('빈칸있음')");
script.println("history.back()");
script.println("</script>");
} else {
pdDAO dao = new pdDAO();
int result = dao.productUplode(pdDTO);
session.setAttribute("pdname", pdDTO.getPdname());
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('상품이 등록되었습니다.')");
script.println("location.href = 'product.jsp'");
script.println("</script>");
}
%>
</body>
</html>
해당화면에 모든 빈칸을 작성한다면 상품이 등록됨. 
워크밴치에서 등록된 상품 확인 페이지