Java+
Java Database Connectivity
Antop
2009. 2. 25. 00:54
반응형
Oracle - http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
MySQL - http://dev.mysql.com/downloads/connector/j/
MSSQL - http://msdn.microsoft.com/ko-kr/library/bb418503.aspx
AS400 -
jdbc:as400:10.240.200.181;prompt=false
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "id", "*****");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "id", "*****");
MySQL - http://dev.mysql.com/downloads/connector/j/
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql//localhost:3306/mydb", "id", "*****");
Connection conn = DriverManager.getConnection("jdbc:mysql//localhost:3306/mydb", "id", "*****");
MSSQL - http://msdn.microsoft.com/ko-kr/library/bb418503.aspx
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=mydb;user=id;password=****;");
DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=mydb;user=id;password=****;");
AS400 -
jdbc:as400:10.240.200.181;prompt=false
반응형