수다닷컴

package ch14;
import com.oreilly.servlet.*;
import com.oreilly.servlet.multipart.DefaultFileRenamePolicy;
import javax.servlet.http.HttpServletRequest;
import java.sql.*;
import java.util.Vector;

public class ProductMgr {
private DBConnectionMgr pool = null;
public ProductMgr() {
try {
pool = DBConnectionMgr.getInstance();
} catch (Exception e) {
System.out.println(Error : 커넥션 가져오기 실패!!);
}
}
public boolean insertProduct(HttpServletRequest req) {
Connection con = null;
PreparedStatement pstmt = null;
boolean result = false;
try {
String uploadDir = c:/Program Files/Apache Tomcat 7.0/webapps/myapp/ch14/data/;
MultipartRequest multi = new MultipartRequest(req, uploadDir, 5 * 1024 * 1024, euc-kr, new DefaultFileRenamePolicy());
con = pool.getConnection();
String query = insert into product(title, author, Publisher, price, detail, date, image)
+ values(?, ?, ?, ?, ?, now(), ?);
pstmt = con.prepareStatement(query);
pstmt.setString(1, multi.getParameter(title));
pstmt.setString(2, multi.getParameter(author));
pstmt.setString(3, multi.getParameter(Publisher));
pstmt.setString(4, multi.getParameter(price));
pstmt.setString(5, multi.getParameter(detail));

if (multi.getFilesystemName(image) == null) {
pstmt.setString(6, ready.gif);
} else {
pstmt.setString(6, multi.getFilesystemName(image));
}
int count = pstmt.executeUpdate();
if (count == 1) result = true;
} catch (Exception ex) {
System.out.println(Exception : + ex);
} finally {
pool.freeConnection(con, pstmt);
}
return result;
}

왜 이런 오류가 나는건가요?

신청하기