Category(범용)

외워서 쓸수 없는 부분들을 복사해서 쓰는 글입니다.

주로 XML import 부분과 Maven dependency, DBDriver 등 도매인들이 적혀있습니다.

검색은 Crtl + F로 진행 합니다.

 

1. 소문자를 기준으로 작성되며 '언어 - 프레임워크 - API' 순으로 작성됩니다.

2.'-' 표시는 모두 제거 하고 검색합니다. (ex xml spring context)

3.DB 는 jdbc 혹은 datasource 로 검색할 수 있습니다.

4.maven 은 xml mvn 이 아닌 mvn ~ 으로 검색합니다.

 

 

 

 

---

xml spring configuration

xml spring beans

xml spring bean

---

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"
>

---

xml spring context

---

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd

---

xml mvn

---

<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
http://maven.apache.org/xsd/maven-4.0.0.xsd">

---

xml mybatis configuration

---

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

---

xml mybatis mapper

---

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

---

xml aspectj

xml aop

---

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
<aop:aspectj-autoproxy />

---

jsp jstl

jsp c

---

<%@ taglib profix="c" uri="http://java.sun.com/jsp/jstl/core"%>

---

jsp form

---

<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>

---

jsp properties

jsp tags

---

<%@ taglib prefix="tags" uri="http://www.springframework.org/tags/tags"%>

---

mvn servlet

mvn servlet jsp

mvn jstl

---

<!--dependencies 밖에 추가-->

<packaging>war</packaging><!--web 프로젝트 선언-->

 

<!--dependencies 안에 추가-->
<dependency>
<groupId>javax.servlet</groupId><!--서블릿 추가-->
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>

<dependency>
<groupId>javax.servlet.jsp</groupId><!--JSP 추가-->
<artifactId>javax.servlet.jsp-api</artifactId>
<version>2.3.2-b02</version>
<scope>provided</scope>
</dependency>

<dependency>
<groupId>javax.servlet</groupId><!--jstl 추가-->
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>

---

mvn spring

mvn spring context

mvn spring test

---

</dependency>
<dependency>
<groupId>org.springframework</groupId><!--Spring-->
<artifactId>spring-core</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>

 

<dependency>
<groupId>org.springframework</groupId><!--Spring context-->
<artifactId>spring-context</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>

 

<dependency>
<groupId>org.springframework</groupId><!--Spring test-->
<artifactId>spring-test</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>

---

mvn spring mvc

---

<dependency>
<groupId>org.springframework</groupId><!--mvc 작용 추가-->
<artifactId>spring-webmvc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>

---

mvn spring jdbc

mvn spring transcation

mvn tomcat jdbc

---

<dependency>
<groupId>org.springframework</groupId><!--Spring transaction 사용 추가-->
<artifactId>spring-jdbc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>

<dependency>
<groupId>org.apache.tomcat</groupId><!--톰켓 DB 연동 사용 추가-->
<artifactId>tomcat-jdbc</artifactId>
<version>8.5.27</version>
</dependency>

---

mvn mariadb

---

<dependency>
     <groupId>org.mariadb.jdbc</groupId>
     <artifactId>mariadb-java-client</artifactId><!--mariaDB JDBC-->
     <version>2.7.4</version>
</dependency>

---

mvn junit

---

<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId><!--test 모듈-->
<version>4.13.2</version>
</dependency>

---

mvn vaild

mvn validation

---

<dependency>
<groupId>javax.validation</groupId><!--글로벌 Valid 예외처리-->
<artifactId>validation-api</artifactId>
<version>1.1.0.Final</version>
</dependency>

---

mvn jackson

mvn json

---

<dependency>
<groupId>com.fasterxml.jackson.core</groupId><!--JSON 처리-->
<artifactId>jackson-databind</artifactId>
<version>2.9.4</version>
</dependency>

---

mvn mybatis

---

<dependency>
<groupId>org.mybatis</groupId><!-- myBatis DB연동 -->
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId><!-- myBatis spring DB연동 -->
<artifactId>mybatis-spring</artifactId>
<version>2.0.0</version>
</dependency>

---

datasource

jdbc

---

Name	driver path	URL	비고
mariadb	org.mariadb.jdbc.Driver	jdbc:mariadb://%s:%d/%s2	%s = ip 혹은 도메인
mysql	com.mysql.jdbc.driver	jdbc:mysql://%s:%d?serverTimezone=UTC/%s2	%d = 포트
oracle	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin://%s:%d:orcl	%s2 = 데이터베이스 이름
mssql	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://%s:%d;DatabaseName=%s2