Java
-
[Project] 게시글 수정 / 게시글 삭제 DAO카테고리 없음 2022. 11. 14. 14:38
//게시글 수정 메소드 public int update(int bbsID, String bbsTitle, String bbsContent) { String sql = "update bbs set bbsTitle = ?, bbsContent = ? where bbsID = ?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, bbsTitle); pstmt.setString(2, bbsContent); pstmt.setInt(3, bbsID); return pstmt.executeUpdate(); }catch (Exception e) { e.printStackTrace(); } return -1; //데이터베이스 ..
-
[Project] 상품 목록 불러오기카테고리 없음 2022. 11. 11. 17:30
public List pdList() { ArrayList dtos = new ArrayList(); // 리스트 작성 try { String sql = "SELECT pdcode,pdname,pdprice,stock,pdsize FROM productinformation"; // sql문 stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { pdDTO dto = new pdDTO(); dto.setPdcode(rs.getString("pdcode")); dto.setPdname(rs.getString("pdname")); dto.setPdprice(rs.getInt("pdprice")); dto...
-
[Project] 쇼핑몰 상품 등록하기카테고리 없음 2022. 11. 10. 18:29
[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 ..
-
[Project] joinAction.jsp카테고리 없음 2022. 11. 9. 20:24
pageEncoding="UTF-8"%> 한국어 안되던거 해결됨. --> if (user.getUserID() == null || user.getUserPassword() == null || user.getUserName() == null || user.getUserGender() == null || user.getUserEmail() == null) { PrintWriter script = response.getWriter(); script.println(""); } else { UserDAO userDAO = new UserDAO(); int result = userDAO.join(user); if (result == -1) { PrintWriter script = respo..