[삽질표류기/DB] JDBC와 DB연결 설정

- MySQL

 

JDBC.Driver=com.mysql.jdbc.Driver

 

JDBC.ConnectionURL=jdbc:mysql://URL주소:포트번호/DB명

 

JDBC.Username=계정명

 

JDBC.Password=비밀번호

 

 

 

 

EX) 

 

JDBC.Driver=com.mysql.jdbc.Driver

 

JDBC.ConnectionURL=jdbc:mysql://localhost:5555/dbname

 

JDBC.Username=id

 

JDBC.Password=1234

 

 

 

 

 

- Oracle

 

JDBC.DriverClassName=oracle.jdbc.driver.OracleDriver

 

JDBC.url=jdbc:oracle:thin@URL주소:1521:xe

 

JDBC:Username=계정명

 

JDBC:password=비밀번호

 

 

 

EX)

 

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

 

jdbc.url=jdbc:oracle:thin:@localhost:1521:xe

 

jdbc.username=id

 

jdbc.password=1234

 

 

 

 

 

- MS-SQL

 

JDBC.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

 

JDBC.url=jdbc:sqlserver://로컬명;DatabaseName="DB명"

 

JDBC.Username=계정명

 

JDBC.password=비밀번호

 

 

 

Ex)

 

jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

 

jdbc.url=jdbc:sqlserver://127.0.0.1;DatabaseName=dbname

 

jdbc.username=id

 

jdbc.password=1234