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()); } %>