You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
36 lines
1.3 KiB
Plaintext
36 lines
1.3 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
|
|
<%@ page import="java.sql.*, javax.naming.*, javax.sql.*" %><%
|
|
response.setContentType("text/html;charset=UTF-8");
|
|
Connection conn = null;
|
|
Statement stmt = null;
|
|
|
|
/*
|
|
ClassName
|
|
|
|
SQL_Server 2000 - com.microsoft.jdbc.sqlserver.SQLServerDriver
|
|
SQL_Server 2005, 2008, 2012 - com.microsoft.sqlserver.jdbc.SQLServerDriver
|
|
MySQL - com.mysql.jdbc.Driver
|
|
Oracle - oracle.jdbc.driver.OracleDriver
|
|
Tibero - com.tmax.tibero.jdbc.TbDriver
|
|
|
|
DB2(Universal JDBC Type 2, 4) - com.ibm.db2.jcc.DB2Driver
|
|
*/
|
|
|
|
String className = "";
|
|
|
|
String url = "";
|
|
String user = "";
|
|
String password = "";
|
|
try {
|
|
Class.forName(className);
|
|
conn = DriverManager.getConnection(url, user, password);
|
|
out.println("<h3> JDBC Connection Success</h5>");
|
|
out.println("<h5>- Product Name : " + conn.getMetaData().getDatabaseProductName() + "</h5>");
|
|
out.println("<h5>- Product Version : " + conn.getMetaData().getDatabaseProductVersion() + "</h5>");
|
|
out.println("<h5>- Driver Name : " + conn.getMetaData().getDriverName()+"</h5>");
|
|
out.println("<h5>- Driver Version : " + conn.getMetaData().getDriverVersion()+"</h5>");
|
|
} catch (Exception e) {
|
|
response.getWriter().append("<h5>Exception Message<h5><br>");
|
|
}
|
|
|
|
%> |