안녕하세요
현재 jsp공부중인데
소스가있는데 DB가 오라클DB였습니다
근데 사정으로 mysql로 바꾸는데 문법때문에 고치려고하는데 힘드네요...ㅠ
1.
sql.append(" select count(*) from imgbbs ");
sql.append(" where refnum=? ");
2.
sql.append(" update imgbbs ");
sql.append(" set ansnum = ansnum + 1 ");
sql.append(" where grpno = ? and ansnum > ? ");
3.
sql.append(" INSERT INTO imgbbs(no, name, title, wdate, passwd, grpno, indent, ansnum, refnum)");
sql.append(" VALUES((SELECT ifnull(MAX(no), 0) + 1 as no FROM imgbbs), ?, ?,now(), ?, ?, ?, ?, ?)");
4.
sql.append(" INSERT INTO imgbbs(no, name, title, wdate, passwd, grpno, fname) ");
sql.append(" (select(select ifnull(max(no),0)+1 from imgbbs), ?, ?, now(), ?, ");
sql.append(" (SELECT ifnull(MAX(grpno), 0)+1 as grpno FROM imgbbs), ?) ");
5.
sql.append(" select no , name, title, wdate, passwd, fname, grpno, indent, ansnum ");
sql.append(" from (select(select no, name , title, wdate, passwd,fname,grpno,indent,ansnum, rownum as r");
sql.append(" from (select no, name , title, wdate, passwd,fname,grpno,indent,ansnum from imgbbs)) ");
if(word.length()>0){
sql.append(" where " + col + " like '%' || ? || '%' " );
}
sql.append(" order by grpno desc, ansnum asc ");
sql.append(" ) ");
sql.append(" )where r>= ? and r<= ? ");
//여기서 col이랑 word는 문자형 변수입니다
6.
sql.append(" select count(*) from imgbbs ");
if(word.length()>0)
sql.append(" WHERE "+col+" LIKE '%' || ? || '%' ");
--
Field Type Null Key Default Extra
------ ------------ ---- --- ----------- -----
no int(11) NO PRI NULL
name varchar(20) NO NULL
title varchar(50) NO NULL
wdate date NO NULL
passwd varchar(20) NO NULL
grpno int(11) YES 0
indent int(11) YES 0
ansnum int(11) YES 0
fname varchar(100) YES default.jpg
이게 테이블입니다
테이블명은 imgbbs입니다
오라클에서 mysql로 쿼리변환이 어렵네요
3,4번은 나름고친다고 고쳐본건데 혹시몰라서요..
부탁드립니다
