<div><br><%@ page contentType="text/html;charset=utf-8" %><br><%@ page import="thinkonweb.util.ConnectionContext" %><br><%@ page import="java.sql.*" %><br><html><br><head><title>JDBC 예제-1</title></head><br><body><br><%<br> Connection conn = ConnectionContext.getConnection();<br> Statement stmt = conn.createStatement();<br> try {<br> stmt.executeUpdate("INSERT INTO Student (ID, Age, Major, Name) VALUES ('200910001', 20,'comp','김송이')");//여기서 exception<br> }catch(Exception e){e.printStackTrace(); <br> }finally<br> {<br> stmt.close();<br> conn.close();<br> }<br> ResultSet rs = stmt.executeQuery("SELECT * FROM Student");<br> String id, name, major;<br> int age;<br> while(rs.next()){<br> id = rs.getString("ID");<br> name = rs.getString("Name");<br> age = rs.getInt("Age");<br> major = rs.getString("Major");<br> out.println(id + ": " + name + ", " + age + ", " + major + "</br>");<br> }<br>%><br></body><br></html></div> <div><br></div> <div><br></div> <div>전에도 stmt.executeUpdate() 메소드가 안되서 질문 올린적 있는데 댓글에 try catch문을 썼더니 인터넷이 연결안되는거마냥 로딩 빙빙 돌기만 해요ㅠㅠ</div> <div><br></div> <div> <div style="text-align:left;"><img width="461" height="173" style="border:medium;" alt="꽃같은jsp.JPG" src="http://thimg.todayhumor.co.kr/upfile/201611/1479711140eac1fab738ab420685800334cc24fa65__w461__h173__f9390__Ym201611.jpg" filesize="9390"></div> <div style="text-align:left;"><br></div> <div style="text-align:left;">요런식으로 하루종일 로딩만 해요ㅠㅠㅠ</div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><br></div> <div style="text-align:left;"><img width="800" height="478" class="chimg_photo" style="border:medium;" alt="꽃같은jsp2.JPG" src="http://thimg.todayhumor.co.kr/upfile/201611/147971114742cc4658b68b4cda8a72a3a5ade8988a__w1440__h861__f165049__Ym201611.jpg" filesize="165049"></div> <div style="text-align:left;"><br></div> <div style="text-align:left;">이건 try catch문을 안넣었을때의 exception 메시지</div> <div style="text-align:left;"><br></div> <div style="text-align:left;">참고로 db에 저 sql 쿼리를 직접 넣었을때는 잘 되요ㅠㅠ</div> <div style="text-align:left;">저 11번줄을 지우고 있는 db 출력하는거도 잘 되고...</div> <div style="text-align:left;">왜이러는걸까요 도대체ㅠㅠㅠ 옆자리사람은 그냥 잘 되던데</div></div> <div><br></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.