Programming/JSP

[Beginner] MySql Connection Test

deverexpert 2011. 8. 25. 22:12
DBConnection.jsp

<%@ page import="java.sql.*" contentType="text/html;charset=utf-8"%>
<%
String DB_URL = "jdbc:mysql://SERVER_ID/DB_NAME";
String DB_USER = "DB_USER";
String DB_PASSWORD= "DB_PASSWORD";
 
Connection conn;
Statement stmt;
 
try {
     Class.forName("com.mysql.jdbc.Driver");
     conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
     stmt = conn.createStatement();
     conn.close();
     out.println("mysql jdbc test: connect ok!!");
} catch(Exception e) {
     out.println(e.getMessage());
}
%>