DB 연동하기

1. pom.xml 필요한 정보 모두 입력

                4.3.4.RELEASE
		7.0.78
		3.2.2
                1.2.0
                5.1.27


		
		
		    net.minidev
		    json-smart
		    2.0-RC3
		
		
		    org.json
		    json
		    20140107
		
		
		
		
    		com.fasterxml.jackson.core
    		jackson-databind
    		2.8.3
		
		
		
		
			com.googlecode.json-simple
			json-simple
			1.1.1
	  	
		

		
        
            org.springframework
            spring-jdbc
            ${org.springframework.jdbc-version}
        
        
		    org.apache.tomcat
		    tomcat-jdbc
		    ${org.apache.tomcat.jdbc-version}
		

        
        
            org.mybatis
            mybatis
            ${org.mybatis-version}
        
        
            org.mybatis
            mybatis-spring
            ${org.mybatis.spring-version}
        
        
        
            mysql
            mysql-connector-java
            ${org.mysql.connector-version}
        
        
        
            org.lazyluke
            log4jdbc-remix
            0.2.7
        
        
            log4j
            log4j
            1.2.15
            
                
                    javax.mail
                    mail
                
                
                    javax.jms
                    jms
                
                
                    com.sun.jdmk
                    jmxtools
                
                
                    com.sun.jmx
                    jmxri
                
            
            runtime
        
        
		
		
		
			org.apache.tiles
			tiles-servlet
			3.0.7
		
		
			org.apache.tiles
			tiles-core
			3.0.7
		
		
			org.apache.tiles
			tiles-jsp
			3.0.7
		

2. servlet-context.xml 필요한 정보 모두 입력

xmlns:tx="http://www.springframework.org/schema/tx" 
xsi:schemaLocation="http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd" 


	
	
	
	
	
		
			
				/WEB-INF/views/tiles/tiles.xml
			
		
	
	
	
	
	
 	
		
	
	
		
	
	
	

	//만약 tiles를 타지않는다면 이 코드를 JSON 앞으로 이동
	
		
		
	

3. jdbc.properite

jdbc.driverClass=net.sf.log4jdbc.DriverSpy

#svr
jdbc.url=jdbc:log4jdbc:mysql://주소/
jdbc.username=DB 이름
jdbc.password=DB 비밀번호

4. mybatis-config.xml

5. jdbc-config.xml

?xml version="1.0" encoding="UTF-8"?>


    
    
        
        
    

    
        
    

    
	   
        
        
        
	

 

6.root-context.xml

xmlns:util="http://www.springframework.org/schema/util" 
xsi:schemaLocation="
		http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans.xsd  
	    http://www.springframework.org/schema/util 
        http://www.springframework.org/schema/util/spring-util-3.2.xsd"