헤르메스 LIFE

[Source] JDBC Connection Test && JDBC Version 확인 본문

JSP&JavaScript&HTML

[Source] JDBC Connection Test && JDBC Version 확인

헤르메스의날개 2022. 8. 16. 00:11
728x90

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 <html>
<head>
<meta http-equiv ="Content-Type" content="text/html; charset=UTF-8" >
<title>DB Connection Test</title>
</head>
<body>
<%
String DB_URL = "jdbc:oracle:thin:@localhost:1524:SDI";
String DB_USER = "유저ID";
String DB_PASSWORD= "패스워드";
Connection conn;
Statement stmt;
try {
 Class.forName("oracle.jdbc.driver.OracleDriver");
 conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
 
 DatabaseMetaData dbmd = conn.getMetaData();
 
 out.println("=== Database Info ====</br>");
 out.println("dbmd.getDatabaseProductName() :: " + dbmd.getDatabaseProductName() + "</br>" );
 out.println("dbmd.getDatabaseProductVersion() :: " + dbmd.getDatabaseProductVersion() + "</br>" );
 out.println("dbmd.getDatabaseMajorVersion() :: " + dbmd.getDatabaseMajorVersion() + "</br>" );
 out.println("dbmd.getDatabaseMinorVersion() :: " + dbmd.getDatabaseMinorVersion() + "</br>" );
 out.println("</br></br></br></br></br>");
 out.println("=== JDBC Info ====</br>");
 out.println("dbmd.getDriverName() :: " + dbmd.getDriverName() + "</br>");
 out.println("dbmd.getDriverVersion() :: " + dbmd.getDriverVersion() + "</br>");
 out.println("dbmd.getDriverMinorVersion() :: " + dbmd.getDriverMinorVersion() + "</br>" );
 out.println("dbmd.getDriverMajorVersion() :: " + dbmd.getDriverMajorVersion() + "</br>" );
 
 conn.close();
 out.println("Oracle jdbc test: connect ok!!");
} catch(Exception e) {
 out.println(e.getMessage());
}
%>
</body>
</html>

https://hermeslog.tistory.com/171?category=307167 

 

[Source] Connection Test

<%@ page contentType="text/html; charset=euc-kr" %> <%@ page import="java.sql.*,java.text.*,java.util.*,java.text.Format.*"%> <%@ page import="javax.naming.*,javax.sql.*" %> <% String strsql = "sele..

hermeslog.tistory.com

 

728x90

'JSP&JavaScript&HTML' 카테고리의 다른 글

Ajax data를 Controller에서 받는 두 가지 방법 : Vo / Map  (0) 2023.06.05
[Modal] Javascript, jQuery 기반의 Open Source Modal Plugin  (0) 2023.05.06
[jQuery] 클립보드 복사 & 붙여넣기  (0) 2021.02.15
[JSON] 문자열을 JSON 변환, JSON 을 문자열 변환  (0) 2021.01.26
오른쪽 마우스 금지  (0) 2020.12.17
'JSP&JavaScript&HTML' Related Articles more