홈 · 개발 참고자료

개발 참고자료

톰캣7 + Mysql5.7 + JDBC 테스트 test.jsp

작성자
관리자
작성일
2016-08-31
조회
7385
분류
기타
<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.*, java.sql.*" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>

<%
String DB_URL = "jdbc:mysql://localhost:3306/guess_ch?characterEncoding=utf-8";
String DB_USER = "guess_ch";
String DB_PASSWORD= "mnp0!234";
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());
}
%>

</body>
</html>