Java Database Connectivity

Posted at 2009. 2. 25. 00:54 | Posted in Java+
반응형
Oracle - http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Class.forName("oracle.jdbc.driver.OracleDriver");

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", "*****");


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=****;");


AS400 -

jdbc:as400:10.240.200.181;prompt=false
반응형

'Java+' 카테고리의 다른 글

Find class in jar files  (0) 2018.02.19
web.xml 서블릿 버전별 DTD  (1) 2013.03.03
Maven Repository for Oracle Library  (0) 2012.12.18
<jsp:forward page="url" /><jsp:include /> <%@ include %>  (0) 2010.04.25
TortoiseSVN 사용하기  (2) 2009.11.16
썸네일(Thumbnail) 만들기  (1) 2009.08.09
Java2Html  (0) 2009.07.19
Jad + JadClipse  (6) 2009.07.11
Java with SQLite  (1) 2009.06.29
//