JAVA & TOMCAT & MySQL 연동

OS 환경

CentOS 7.7

Apache 2.4

MySQL 5.1 (utf-8)

JAVA 1.8

TOMCAT 8.5

[JAVA & TOMCAT 설치]

1. 기존 JAVA 삭제

# yum remove JAVA 또는 # rpm -e JAVA

2. JAVA 다운로드

다운로드 URL : https://www.oracle.com/technetwork/es/java/javase/downloads/jdk8-downloads-2133151.html?printOnly=1

# cd /usr/local/src

# tar zxvf jdk-8u231-linux-x64.tar.gz

# mv jdk-8u231-linux-x64 /usr/local/java

3. JAVA classpath 설정

# vi /etc/profile

export JAVA_HOME=/usr/local/java

export CLASSPATH="."

PATH=$PATH:$JAVA_HOME/bin:

4. JAVA 설치 확인

# java -version

java version "1.8.0_191"

Java(TM) SE Runtime Environment (build 1.8.0_191-b12)

Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)

# javac -version

javac 1.8.0_191

5. MySQL 연동 connector 설치

다운로드 URL : https://dev.mysql.com/downloads/connector/j/

# cd /usr/local/src

# wget http://ris.smileserv.com/source/java_tomcat/mysql-connector-java-5.1.47.tar.gz

# cp -a mysql-connector-java-5.1.47/mysql-connector-java-5.1.47.jar /usr/local/java/jre/lib/ext/

# cp -a mysql-connector-java-5.1.47/mysql-connector-java-5.1.47-bin.jar /usr/local/java/jre/lib/ext/

6. TOMCAT 설치

# wget https://archive.apache.org/dist/tomcat/tomcat-8/v8.5.35/bin/apache-tomcat-8.5.35.tar.gz

# tar zxvf apache-tomcat-8.5.35.tar.gz

# mv apache-tomcat-8.5.35 /usr/local/tomcat

# vi /etc/profile

export JAVA_HOME=/usr/local/java

export CATALINA_HOME=/usr/local/tomcat

export CLASSPATH=.:$JAVA_HOME/jre/lib/ext:$JAVA_HOME/lib/tools.jar:$CATALINA_HOME/lib/jsp-api.jar:$CATALINA_HOME/lib/servlet-api.jar

PATH=$PATH:$JAVA_HOME/bin:$CATALINA_HOME/bin

# source /etc/profile

7. iptables 룰 추가

\\ 8005, 8009, 8080 룰 추가

# iptables -nL

ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:8005

ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:8009

ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:8080

8 .웹페이지 확인

[TOMCAT 설정]

1. tomcat virtual host 설정

사용자 : itsyou

사용자 홈소스 위치 : /home/itsyou/html

# vi /usr/local/tomcat/conf/server.xml \\ </host> 뒤에 내용추가

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"

prefix="tom.itsyou.cf_access_log" suffix=".txt"

pattern="%h %l %u %t %r %s %b" />

</Host>

2. WEB-INF 폴더 복사 및 퍼미션 수정

# cp -a /usr/local/tomcat/webapps/ROOT/ /home/itsyou/html/

# chmod 755 /home/itsyou/html/WEB-INF/

# chmod 644 /home/itsyou/html/WEB-INF/web.xml

3. tomcat 재시작

# catalina.sh stop

# catalina.sh start

4. jsp 연동 테스트 페이지 생성

# cd /home/itsyou/html

# vi test.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<title>JSP Test scriptlet.jsp</title>

</head>

<body>

<% int i = 24; %>

out.println("하루는 " +i +"시간이며,<BR>");

out.println("하루는 " + i * 60+" 분 입니다.");

</body>

</html

5. test.jsp 페이지 출력 확인

[MySQL 연동 설정]

1. 데이터베이스 및 테이블 생성

mysql> create database itsyou;

mysql> grant all on itsyou.* to root@localhost identified by '[패스워드]';

mysql> use itsyou;

mysql> create table idol ( groupname varchar(50), membername varchar(50) );

mysql> create table Users (id int(3) primary key, name varchar(20), email varchar(20), country varchar(20), password varchar(20));

mysql> INSERT INTO Users (id, name, email, country, password) VALUES (1, 'Pankaj', 'pankaj@apple.com', 'India', 'pankaj123');

mysql> INSERT INTO Users (id, name, email, country, password) VALUES (4, 'David', 'david@gmail.com', 'USA', 'david123');

mysql> INSERT INTO Users (id, name, email, country, password) VALUES(5, 'Raman', 'raman@google.com', 'UK', 'raman123');

mysql> quit

2. mysql 연동 테스트 페이지 생성

# cd /home/itsyou/html

# vi dbtest.jsp

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

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

String DB_USER = "root";

String DB_PASSWORD= "password@";

Connection conn;

Statement stmt;

try

{

Class.forName("org.gjt.mm.mysql.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());

}

3. dbtest.jsp 페이지 출력 확인

4. 테이블 데이터 확인 페이지 생성

# cd /home/itsyou/html

# vi select.jsp

<%@page import="java.sql.*"%>

<%@page import="com.mysql.jdbc.PreparedStatement"%>

<%@page import="com.mysql.jdbc.Connection"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

Connection con;

Class.forName("com.mysql.jdbc.Driver");

con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/itsyou", "root", "password@");

PreparedStatement ps=(PreparedStatement)con.prepareStatement("SELECT * from Users");

ResultSet rs=ps.executeQuery();

while(rs.next()){

String name=rs.getString("name");

String email=rs.getString("email");

String country=rs.getString("country");

out.println(" NAME : "+name+" EMAIL : "+email+" COUNTRY :"+country+" <hr>");

}

</body>

</html>

5. MySQL 데이터 출력 페이지 확인

저작자표시 비영리 변경금지

'서버 & 시스템 > Linux' 카테고리의 다른 글

와인(wine) 4.0 설치 (0)	2020.01.30
LibreOffice 언어 한국어 설정 (0)	2020.01.30
우분투 단축키 (0)	2019.10.08
메일 클라이언트 mutt (0)	2019.08.23
lsof 사용법 (1)	2019.03.06

에블바디 잇츠유!