controller
package kr.co.gudi.Controller;
import java.text.DateFormat;
import java.util.Date;
import java.util.Locale;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import kr.co.gudi.Service.HomeService;
@Controller
public class HomeController {
Logger logger = LoggerFactory.getLogger(HomeController.class);
@RequestMapping(value = "/", method = RequestMethod.GET)
public String home( Model model) {
logger.info("컨트롤러 접근");
//db 에 접근해서 접속이 성공되었는지 확인
//1. service에게 일을 시킨다
HomeService service = new HomeService();
boolean success = service.dbConnect(); // dbConnect() 메서드를 만들어준다
logger.info("/"+success);// 이름이 달라졌다
model.addAttribute("result",success);
//성공여부를 VIEW에 전송
return "home";
}
}
HomeDAO
package kr.co.gudi.DAO;
import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import kr.co.gudi.Service.HomeService;
public class HomeDAO {
Logger logger = LoggerFactory.getLogger(HomeDAO.class); // 자기클래스 명시
//요청명에 따라 컨트롤러 메서드 명을 정하고 service dao 의 메서드도 통일 시켜주자 == dbConnect() 메서드를 통일시킨다
public boolean dbConnect() {
logger.info("DAO 접근 완료");
//DB 접근 순서
//1.db접근을 위한 정보를 준비
String username = "web_user";
String pw = "pass";
String url = "jdbc:mariadb://localhost:3306/gdj70";
String driver = "org.mariadb.jdbc.Driver";
boolean success = false;
try {
//2.DriveManager 에게 전달할 내용을 전달 한다
Class.forName(driver);// db 접속시 사용할 라이브러리 클래스를 알려준다
//3. 데이터베이스를 다룰 권한을 가져온다 =Connection 인터페이스를 사용해야 수정이가능하다
Connection conn= DriverManager.getConnection(url,username,pw); // 커넥션객체의 뭔가있으면 true이다
//Connection 객체를 얻어온다면 접속 성공
if(conn != null) {
success = true;
logger.info("접속 성공 :"+ conn);
//4. 할일을 다 하면 자원을 반납 한다
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
//예외가 발새 하면 실패
}
return success;
}
}
3.homeservice
package kr.co.gudi.Service;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import kr.co.gudi.DAO.HomeDAO;
public class HomeService {
//로거에 로그를 찍는 대상 클래스(HomeService.class)를 지정해 줘야 한다
Logger logger = LoggerFactory.getLogger(HomeService.class);
public boolean dbConnect() {
logger.info("서비스가 명령 받음");
//DB를 사용해야 하는 일인가?
//DAO를 객체화
HomeDAO dao = new HomeDAO();
return dao.dbConnect();// 서비스에서는 DAO에게 접속후 성공여부를 받아서 바로 controller에게 던진다
//dao.dbConnect();으로 참인지 거짓인지 구별
}
}
home.jsp
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page session="false" %>
<html>
<head>
<title>Home</title>
</head>
<body>
<P> ${result} </P>
</body>
</html>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>kr.co</groupId>
<artifactId>gudi</artifactId>
<name>04_JDBC</name>
<packaging>war</packaging>
<version>1.0.0-BUILD-SNAPSHOT</version>
<properties>
<java-version>1.8</java-version>
<org.springframework-version>4.3.14.RELEASE</org.springframework-version>
<org.aspectj-version>1.6.10</org.aspectj-version>
<org.slf4j-version>1.6.6</org.slf4j-version>
</properties>
<dependencies>
<!-- Spring -->
<dependency><!--dependency는 하나의 라이브러리 -->
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${org.springframework-version}</version>
<exclusions>
<!-- Exclude Commons Logging in favor of SLF4j -->
<exclusion>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- 필요한 라이브러리 추가 -->
<!-- mariadb-java -->
<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.7.3</version>
</dependency>
<!-- AspectJ -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>${org.aspectj-version}</version>
</dependency>
<!-- Logging -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${org.slf4j-version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jcl-over-slf4j</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.15</version>
<exclusions>
<exclusion>
<groupId>javax.mail</groupId>
<artifactId>mail</artifactId>
</exclusion>
<exclusion>
<groupId>javax.jms</groupId>
<artifactId>jms</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jdmk</groupId>
<artifactId>jmxtools</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jmx</groupId>
<artifactId>jmxri</artifactId>
</exclusion>
</exclusions>
<scope>runtime</scope>
</dependency>
<!-- @Inject -->
<dependency>
<groupId>javax.inject</groupId>
<artifactId>javax.inject</artifactId>
<version>1</version>
</dependency>
<!-- Servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- Test -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.7</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-eclipse-plugin</artifactId>
<version>2.9</version>
<configuration>
<additionalProjectnatures>
<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
</additionalProjectnatures>
<additionalBuildcommands>
<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
</additionalBuildcommands>
<downloadSources>true</downloadSources>
<downloadJavadocs>true</downloadJavadocs>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version> <!-- 버전 바뀌는걸 방지하기위해 사용한다 -->
<configuration>
<source>1.8</source>
<target>1.8</target>
<compilerArgument>-Xlint:all</compilerArgument>
<showWarnings>true</showWarnings>
<showDeprecation>true</showDeprecation>
</configuration>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>1.2.1</version>
<configuration>
<mainClass>org.test.int1.Main</mainClass>
</configuration>
</plugin>
</plugins>
</build>
</project>
시작