jsp DB 저장질문

Question

생략````<%} %>

상품등록

판매자
상품명
판매단가
실시간 여부
이미지	2

----------------------------------------<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*" import="java.util.*"%> <%@ page import="com.oreilly.servlet.MultipartRequest" %> <%@ page import="com.oreilly.servlet.multipart.DefaultFileRenamePolicy"%> <% request.setCharacterEncoding("UTF-8");%> <% Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");String connectionURL = "jdbc:sqlserver://localhost:1433; databaseName=JSP_BOOK;user=JSP;password=1234";Connection con=DriverManager.getConnection(connectionURL);String realFolder="";String saveFolder="main/images";String encType ="utf-8";int sizeLimit = 10*1024*1024;realFolder = application.getRealPath(saveFolder);MultipartRequest multi = new MultipartRequest(request,realFolder,sizeLimit,encType);PreparedStatement pstmt = null;Statement stmt = con.createStatement();try{String userid = multi.getParameter("userid");String goodsnm = multi.getParameter("goodsnm");String unitprice = multi.getParameter("unitprice");String best_yn = multi.getParameter("best_yn");if(best_yn != null && best_yn.equals("on"))best_yn ="Y";elsebest_yn = "N";String fileName1 = multi.getFilesystemName("goodsimg1");String sql = "insert into goodsinfo(userid,goodsnm,unitprice,best_yn,goodsimg1,useflag) valuse(?,?,?,?,?,'Y')";pstmt = con.prepareStatement(sql);pstmt.setString(1,userid);pstmt.setString(2,goodsnm);pstmt.setInt(3,Integer.parseInt(unitprice));pstmt.setString(4,best_yn);pstmt.setString(5,fileName1);pstmt.executeUpdate();}catch(SQLException e1){e1.printStackTrace();}catch(Exception e2){e2.printStackTrace();}finally{if(pstmt != null)pstmt.close();if(stmt != null)stmt.close();if(con != null)con.close();}%>등록됨-------------------BD-------------goodsnm varchar(50) Uncheckedunitprice decimal(7, 0) Checkedbest_yn char(1) Checkedgoodsimg1 varchar(50) Checkeduseflag char(1) Checkedregdtm date Checkeduserid varbinary(50) Unchecked--------------------------------------------다음과 같이 등록을했을때 등록이 됬다고 오류는 안 뜨는데 DB를 보면 저장이 안되있습니다. 어떤곳에서 잘못됬는지 혹시 알수있나요/

kenu,전독시 · Accepted Answer

log file을 열어보세요.

jsp DB 저장질문

1개의 답변

#eclips 목록