본문 바로가기
Tech Story/IoT

MySQL 접속테스트

MySQL접속테스트 (mysql_conn.jsp)


Tomcat-mysql 설치후 연결테스트


<%@ page import="java.sql.*" contentType="text/html;charset=utf-8"%>


 <%

         String DB_URL = "jdbc:mysql://localhost/mysql";

         String DB_USER = "ID";

         String DB_PASSWORD= "PASSWD";

         Connection conn;

         Statement stmt;


         try {

              Class.forName("org.gjt.mm.mysql.Driver");     // CLASSPATH에 mysql-connector.jar 를 복사하여 넣어줘야 함

              conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

              stmt = conn.createStatement();

              conn.close();

              out.println("MySQL Connection Success!");

         }

         catch(Exception e){

              out.println(e);

         }

 %>



[해당파일]

https://github.com/e3jake/DustProject