05. 개발 : 프로젝트 생성 (Spring Starter Project 생성, 의존성, 환경설정, DB연결)

○ Spring Starter Project 생성

사용할 DB에 맞게 의존성 추가

 

○ pom.xml

    - 사용자 추가 라이브러리(의존성)

<!-- 뷰페이지를 JSP로 지정 -->
<dependency>
    <groupId>org.apache.tomcat.embed</groupId>
    <artifactId>tomcat-embed-jasper</artifactId>
</dependency>

<!-- 자바 웹메일 라이브러리 -->
<dependency>
    <groupId>javax.mail</groupId>
    <artifactId>mail</artifactId>
    <version>1.4.7</version>
</dependency>

<!-- json-simple 라이브러리 : AJAX 사용시 필요 -->
<dependency>
    <groupId>com.googlecode.json-simple</groupId>
    <artifactId>json-simple</artifactId>
    <version>1.1.1</version>
</dependency>

<!-- JSTL -->
<!-- https://mvnrepository.com/artifact/javax.servlet/jstl/1.2 -->
<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
</dependency>

<!-- 파일업로드/다운로드 관련 라이브러리 -->
<!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload/1.4 -->
<dependency>
    <groupId>commons-fileupload</groupId>
    <artifactId>commons-fileupload</artifactId>
    <version>1.4</version>
</dependency>

<!-- jQuery -->
<!-- https://mvnrepository.com/artifact/org.webjars.bower/jquery -->
<dependency>
    <groupId>org.webjars.bower</groupId>
    <artifactId>jquery</artifactId>
    <version>3.3.1</version>
</dependency>

<!-- GSON -->
<!-- https://mvnrepository.com/artifact/com.google.code.gson/gson -->
<dependency>
    <groupId>com.google.code.gson</groupId>
    <artifactId>gson</artifactId>
</dependency>

 

○ application.properties

    - 환경설정

server.port=9090
spring.mvc.view.prefix=/WEB-INF/views/
spring.mvc.view.suffix=.jsp

server.servlet.jsp.init-parameters.development=true

spring.datasource.url=jdbc:mariadb://localhost:3306
spring.datasource.username=opot
spring.datasource.password=DB비밀번호
spring.datasource.dbcp2.driver-class-name=org.mariadb.jdbc.Driver

spring.servlet.multipart.max-file-size=500MB
spring.servlet.multipart.max-request-size=500MB

server.servlet.session.timeout=1800

 

○ DB연결

    - DBopen.java

package net.utility;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBopen {
	
	//마리아 DB 연결 메소드	
	public Connection getConnection() {
		Connection con=null;
		try {			
	        String url      ="jdbc:mariadb://localhost:3306/opot";
	        String user     ="opot";
	        String password ="DB비밀번호";	
	        String driver   ="org.mariadb.jdbc.Driver"; 
	        Class.forName(driver);
			con =DriverManager.getConnection(url, user, password);		
		} catch (Exception e) {
			System.out.println("마리아DB연결실패: " + e);
		}//end		
		return con;		
	}//getConnection()

}//class end

    - DBclose.java

package net.utility;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DBclose {//DB연결 자원 반납
	
	public static void close(Connection con) {
		try {
			if(con!=null) {con.close();}
		} catch (Exception e) { }
	}//end
	
	public static void close(Connection con, PreparedStatement pstmt) {
		try {
			if(pstmt!=null) {pstmt.close();}
		} catch (Exception e) { }	
		try {
			if(con!=null) {con.close();}
		} catch (Exception e) { }
	}//end
	
	public static void close(Connection con, PreparedStatement pstmt, ResultSet rs) {
		try {
			if(rs!=null) {rs.close();}
		} catch (Exception e) { }	
		try {
			if(pstmt!=null) {pstmt.close();}
		} catch (Exception e) { }	
		try {
			if(con!=null) {con.close();}
		} catch (Exception e) { }
	}//end
	
}//class end