이클립스랑 Mysql을 연동해야 하는데 <div>연동은 했는데 결과값이 출력이 안 됩니다...뭐가 문제일까요?</div> <div>고수님들 도와주시면 감사하겠습니다.</div> <div><br></div> <div>코드 : </div> <div><div>package databaseLab;</div> <div><br></div> <div>import java.sql.*;</div> <div><br></div> <div>public class jdbctext {</div> <div><br></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; </div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>static final String DB_URL = "jdbc:mysql://127.0.0.1:3306/sakila";</div> <div><br></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>static final String USERNAME = "root";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>static final String PASSWORD = "0000"; //비밀번호는 알맞게 넣었습니다..ㅎㅎ</div> <div><br></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>public static void main(String[] args) {</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>Connection conn = null;</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>Statement stmt = null;</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>try{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>Class.forName(JDBC_DRIVER);</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>conn = DriverManager.getConnection(DB_URL,USERNAME,PASSWORD);</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>System.out.println("\n- MySQL Connection");</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>stmt = conn.createStatement();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>String sql;</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>sql = "SELECT groupname, membername FROM idol";</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>ResultSet rs = stmt.executeQuery(sql);</div> <div><br></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>while(rs.next()){</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>String groupName = rs.getString("groupName");</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>String memberName = rs.getString("memberName");</div> <div><br></div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>System.out.print("\n** Group : " + groupName);</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>System.out.print("\n -> Member: " + memberName);</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>rs.close();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>stmt.close();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>conn.close();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}catch(SQLException se1){</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>se1.printStackTrace();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}catch(Exception ex){</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>ex.printStackTrace();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}finally{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>try{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>if(stmt!=null)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>stmt.close();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}catch(SQLException se2){</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>try{</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>if(conn!=null)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>conn.close();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}catch(SQLException se){</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>se.printStackTrace();</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>System.out.println("\n\n- MySQL Connection Close");</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>}</div> <div>}</div></div> <div><br></div> <div><br></div> <div>결과값:</div> <div><div>Tue May 03 22:11:56 KST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.</div> <div><br></div> <div>- MySQL Connection</div> <div><br></div> <div><br></div> <div>- MySQL Connection Close</div></div> <div><br></div> <div>원래 저 사이에</div> <div><pre style="padding:8.5px;font-family:Monaco, Menlo, Consolas, 'Courier New', monospace;color:#333333;margin-top:0px;margin-bottom:9px;white-space:pre-wrap;border:1px solid;background-color:#f5f5f5;">** Group : ses -> Member: vada ** Group : sistar -> Member: dasom<span style="color:#000000;font-family:'굴림';font-size:9pt;line-height:1.5;background-color:#ffffff;"> </span></pre></div> <div><span style="color:#000000;font-family:'굴림';font-size:9pt;line-height:1.5;background-color:#ffffff;">요래 떠야되는데...뭐가 문제인지 모르겠습니다 ㅠㅠ</span></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.