강의

멘토링

커뮤니티

Inflearn Community Q&A

onetaek's profile image
onetaek

asked

JSP Web Shopping Mall Programming Basic Course (JSP WEB Programming)

Lecture 53: Board - View All Posts (Counter)

53강 mariadb나 mysql로 쓰신느 분들을 위한 sql문

Written on

·

477

·

Edited

0

select * from board order by ref desc, re_step asc limit ?, ?

쿼리문 이거 쓰시고

? 매핑할 때

pstmt.setInt(1, start-1);

pstmt.setInt(2, pageSize);

이런식으로 써주고 getAllBoard(startRow, pageSize) 메소드도 이런식으로 endRow대신 pagesSize를 매개변수로 넣어주면 됩니다.

endRow는 사용하지 않습니다.

jspjava

Answer

This question is waiting for answers
Be the first to answer!
onetaek's profile image
onetaek

asked

Ask a question