| DataBase 별 jdbc 사용법 |
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
ojdbc14.jar
Class.forName("oracle.jdbc.OracleDriver");
connector = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:DB명",USERID,USERPASSWORD);
MSSQL 2005
JDBC 관련 jar : http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5&DisplayLang=en
msutil.jar, msbase.jar, mssqlserver.jar
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
connector = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DB명",USERID,USERPASSWORD);
MSSQL 2000
JDBC 관련 jar : http://www.microsoft.com/downloads/details.aspx?familyid=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en
sqljdbc.jar
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connector = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=DB명",USERID,USERPASSWORD);
MySQL
JDBC 관련 jar : http://dev.mysql.com/downloads/connector/j/5.0.html
Class.forName("com.mysql.jdbc.Driver");
connector = DriverManager.getConnection("jdbc:mysql://localhost:3306/DB명",USERID,USERPASSWORD);