목록JSP/GuestBook (14)
WON.dev
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; impor..
SELECT * FROM GUESTBOOK ORDER BY IDX DESC insert into GUESTBOOK values(guestbook_seq.nextval, #{writer}, #{email}, #{pw}, #{filename}, #{title},#{content} ,sysdate) select * from GUESTBOOK where idx=#{idx} DELETE FROM GUESTBOOK WHERE idx=#{idx} update GUESTBOOK set email=#{email}, title=#{title}, content=#{content} where idx=#{idx}
package org.joonzis.mybatis; import java.io.InputStream; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class DBService {// factory를 만드는게 목적 // 필드 private static SqlSessionFactory factory = null; // 싱글톤 static { try { String resource = "org/joonzis/mybatis/sqlmap.xml";//에러가 나지 않는다(오타) In..