본문 바로가기
카테고리 없음

DB 연결 확인

by cook_code 2023. 4. 30.
반응형

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

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

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

 

 

반응형