Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2013/07/20(12:22) from 180.65.248.176 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 3198 , ÁÙ¼ö : 41 |
Re: [MySQL-5.6] JDBC ¿¬°á Example |
---|
import java.sql.*; public class ConnectTestDB { public static void main(String[] args) { Connection conn; Statement stmt; try { Class.forName("com.mysql.jdbc.Driver");//µå¶óÀ̹ö ·Îµù: DriverManager¿¡ µî·Ï }catch(ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); } try { String jdbcUrl = "jdbc:mysql://localhost:3306/dbname";//»ç¿ëÇÏ´Â µ¥ÀÌÅͺ£À̽º¸íÀ» Æ÷ÇÔÇÑ url String userId = "gdhong";//»ç¿ëÀÚ°èÁ¤ String userPass = "gdhong";//»ç¿ëÀÚ Æнº¿öµå conn = DriverManager.getConnection(jdbcUrl, userId, userPass);//Connection °´Ã¼¸¦ ¾ò¾î³¿ stmt = conn.createStatement();//Statement °´Ã¼¸¦ ¾ò¾î³¿ System.out.println("Á¦´ë·Î ¿¬°áµÇ¾ú½À´Ï´Ù");//¼º°ø½Ã ȸ鿡 Ç¥½ÃµÊ stmt.close(); conn.close(); }catch(SQLException e) { System.out.println("SQLException: " + e.getMessage()); } } } |