{{{

TestApp

test

ServletTest

test

/test

org.springframework.web.context.ContextLoaderListener

springapp

org.springframework.web.servlet.DispatcherServlet

springapp

*.do

index.html

index.htm

index.jsp

default.html

default.htm

default.jsp

}}} {{{ Globals.DriverClassName=com.mysql.jdbc.Driver Globals.Url=jdbc:mysql://localhost:1623/spring Globals.UserName=root Globals.Password=ever1234 }}} {{{ WEB-INF/db.properties }}} {{{ <%@page import="javax.sql.DataSource"%> <%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%> <%@page import="org.springframework.context.ApplicationContext"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> Insert title here

일반 jdbc

<% Connection conn; Statement stmt; ResultSet rset; try{ Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","ever1234"); stmt = conn.createStatement(); rset = stmt.executeQuery("select * from TEAM "); while(rset.next()){ out.println(rset.getInt(1)+" : "+rset.getString(2)+"
"); } }catch(Exception err){ err.printStackTrace(); } %>

spring lookup

<% try{ ApplicationContext context = WebApplicationContextUtils.getWebApplicationContext( request.getSession().getServletContext()); DataSource ds = (DataSource)context.getBean("dataSource-mysql"); conn = ds.getConnection(); stmt = conn.createStatement(); rset = stmt.executeQuery("select * from TEAM "); while(rset.next()){ out.println(rset.getInt(1)+" : "+rset.getString(2)+"
"); } }catch(Exception err){ err.printStackTrace(); } %> }}}