[Spring] DB setting

Dependencies:

• Spring context
• Spring core
• Spring jdbc
• commons-dbcp
• mysql-connector

Add these on POM.xml

<project>
    ...
    </build>
    <dependencies>
        // You write Dependencies here.
    </dependencies>
</project>

Spring context

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Spring core

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Spring jdbc

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.2.5.RELEASE</version>
</dependency>

Commons-dbcp

<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>

MySQL connector

Download MySQL Connector
Project Folder Right Click > Build Path > Configure Build Path > Add External JARs > (Add this jar file)

Insert

1. BookDaoSpring.java
2. Test.java
3. applicationContext.xml

BookDaoSpring.java

public class BookDaoSpring {
    // dao relies on this Object
    private JdbcTemplate jdbcTemplate;
    // Constructor, Setter for DI
    public BookDaoSpring() {}
    public BookDaoSpring(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
////////////////////////////////////////////////////////
    public int insert(BookVO book) {
        String sql = 
            "INSERT INTO BOOK(TITLE,PUBLISHER,PRICE,WRITER)"
            +"VALUES(?,?,?,?)"; 
        return jdbcTemplate.update(sql,
                book.getTitle(),
                book.getPublisher(),
                book.getPrice(),
                book.getWriter());
    }
}

Test.java

public class Test {
    public static void main(String[] args) {
        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("test02_spring/applicationContext.xml");
        BookDaoSpring dao = context.getBean("dao", BookDaoSpring.class);
  
        BookVO book = new BookVO("Spring textbook", "meme", 30000, "Samsung");
 System.out.println("insert Result"+dao.insert(book));
    }
}

applicationContext.xml

Right Click its package > New > Spring Bean Configuration File > name it 'applicationContext'

<bean id="ddd" class="org.apache.commons.dbcp.BasicDataSource">
 <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
 <property name="url" value="jdbc:mysql://127.0.0.1./spring"/>
 <property name="username" value="root"/>
 <property name="password" value="sds1501"/>
</bean>

<bean id="jjjj" class="org.springframework.jdbc.core.JdbcTemplate">
 <property name="dataSource" ref="ddd"/>
</bean>

<bean id="dao" class="test02_spring.BookDaoSpring">
 <property name="jdbcTemplate" ref="jjjj"/>
</bean>
  
  
  
 

 

            
 

        
            
        

[Spring] Two ways to implements.

Sample.java

package test01_scope;

import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;

@Component("sss")
@Scope("prototype")
public class Sample {
 //
 }

Test.java

Sample sample1 = context.getBean("sss", Sample.class);

application.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">
<bean class="test01_scope.Sample" id="sample1" scope="prototype"/>
<bean class="test01_scope.Sample" id="sample2" scope="singleton"/>

<context:annotation-config/>
<context:component-scan base-package="test01_scope"/>
</beans>

[Spring]Beginning of Spring

There are many ways to implements Spring Project.

How to Make a Maven Project(for Beginner):

1. Create 'Java Project'
2. Right-Click the Project folder > Configure > Convert to Maven Project > Finish
3. src > Spring Bean Configuration File(.xml) > name it 'applicationContext'

Then, it creates a POM.xml file. This is not the way you do in the company but to make it look clear without many files and complex file tree, you can start it in this way.

In the company, you create a Maven Project directly.

ref)

maven: accumulator of knowledge

POM: Project Object Model

Then, you have two choices to import Spring Library.

1. Download: mvnrepository(spring-core, spring-context)
2. Edit POM.xml: 

<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">

  <modelVersion>4.0.0</modelVersion>

  <groupId>Day02_DI</groupId>

  <artifactId>Day02_DI</artifactId>

  <version>0.0.1-SNAPSHOT</version>

  <build>

    <sourceDirectory>src</sourceDirectory>

    <plugins>

      <plugin>

        <artifactId>maven-compiler-plugin</artifactId>

        <version>3.6.1</version>

        <configuration>

          <source>1.8</source>

          <target>1.8</target>

        </configuration>

      </plugin>

    </plugins>

  </build>

<dependencies>

<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->

<dependency>

    <groupId>org.springframework</groupId>

    <artifactId>spring-core</artifactId>

    <version>4.2.5.RELEASE</version>

</dependency>

  <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->

<dependency>

    <groupId>org.springframework</groupId>

    <artifactId>spring-context</artifactId>

    <version>4.2.5.RELEASE</version>

</dependency>

</dependencies>

</project>

Then, create 'spring Bean Configuration File' into 'src' folder with a name -  'applicationContext.xml'.


@autoWired

[jQuery] How to add and remove 'disabled' attribute.

$('#btn').attr('disabled', '');

$('#btn').attr('disabled', 'true');

$('#btn').attr('disabled', 'false');

$('#btn').attr('disabled', 'disabled');

Those are the same.

$('#btn').removeAttr('disabled');

This is how you remove the attribute.

[jsp]How to include 'header.jsp' and 'footer.jsp' in all the jsp files in easy way using web.xml

It might be wrong... But It is like this way.
Go to WebContent > WEB-INF and source like this.

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>NeverIn</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>

  <jsp-config>
  <jsp-property-group>
  <url-pattern>/board/*</url-pattern>
  <include-prelude>/board/header.jsp</include-prelude>
  <include-coda></include-coda>
  </jsp-property-group>
  </jsp-config>
</web-app>

[Servlet] How servlet looks like, what it contains its inside.

Servlet has Context Path(ex. @WebServlet("/file.do")) above class name and it consists of two parts - doGet(), doPost()

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    if( ){
    } else if( ){
    } else if( ){
    } else ...
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    if( ){
    } else if( ){
    } else if( ){
    } else ...
}

Servlet - > Ajax 한글 깨짐 해결 방법

Servlet에
response.setContentType("text/text;charset=euc-kr");

Ajax에

dataType: 'Text'

추가