Tomcat + DB 연동

DB 는 AWS RDS 로 생성!

​

Tomcat 이랑 DB 를 연동하기 위해서는 Mysql-connector 필요하다.

 

Was 서버에서 진행

Mysql-connector 설치

1. cd /usr/locar/src
2. Tomcat + DB를 연동 할때 mysql-connector 필요!

- wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-j-8.1.0.tar.gz

3. tar xvzf mysql-connector-j-8.1.0.tar.gz

4. cd mysql-connector-j-8.1.0

5. cp -a mysql-connector-j-8.1.0.jar /usr/local/src/apache-tomcat-8.5.91/lib/

6. tomcat 재시작

​

Tomcat+DB 연동 test

1. cd /usr/local/src/apache-tomcat-8.5.91/webapps/ROOT
2. vi mysql.jsp
   

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=utf-8" %>
<%
String DB_URL = "jdbc:mysql://'DB 주소':3306";
String DB_USER = "DB_user_name";
String DB_PASSWORD= "DB_user_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 Connection Success!");
   }
   catch(Exception e){
   out.println(e);
   }
%>

3. http://’web 서버’/mysql.jsp 접속 후 Success! 출력 되면 성공!

​