버전 6 (anonymous에 의해 수정됨, 13 년전)
-- 
<?xml version="1.0" encoding="UTF-8"?>
<web-app 
	xmlns="http://java.sun.com/xml/ns/javaee" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
						http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
	id="WebApp_ID" version="3.0">
	<display-name>TestApp</display-name>
	<servlet>
		<servlet-name>test</servlet-name>
		<servlet-class>ServletTest</servlet-class>
	</servlet>
	
	<servlet-mapping>
		<servlet-name>test</servlet-name>
		<url-pattern>/test</url-pattern>
	</servlet-mapping>
	
	<listener>
		<listener-class>
			org.springframework.web.context.ContextLoaderListener
		</listener-class>
	</listener>
	
	<servlet>
		<servlet-name>springapp</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	</servlet>
	
	<servlet-mapping>
		<servlet-name>springapp</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	<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>
</web-app>


Globals.DriverClassName=com.mysql.jdbc.Driver
Globals.Url=jdbc:mysql://localhost:1623/spring
Globals.UserName=root
Globals.Password=ever1234

<?xml version="1.0" encoding="UTF-8"?>
<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-3.0.xsd">

    <!-- 환경설정 기본정보를 globals.properties 에서 참조하도록 propertyConfigurer 설정  -->
    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>WEB-INF/db.properties</value>
            </list>
        </property>
    </bean>
    
    <!-- mysql -->
    <bean id="dataSource-mysql" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${Globals.DriverClassName}"/>
        <property name="url" value="${Globals.Url}" />
        <property name="username" value="${Globals.UserName}"/>
        <property name="password" value="${Globals.Password}"/>
    </bean>    
<!--
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${Globals.DriverClassName}"/>
        <property name="url" value="${Globals.Url}" />
        <property name="username" value="${Globals.UserName}"/>
        <property name="password" value="${Globals.Password}"/>
    </bean>
-->
</beans>


<%@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"%>
    
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
</head>
<body>
<hr>
<h1>일반 jdbc</h1>
<p>
<%
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)+"</br>");
	}
}catch(Exception err){
	err.printStackTrace();
}
%>	
<hr>
<h1>spring lookup</h1>
<p>
<%
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)+"</br>");
	}
}catch(Exception err){
	err.printStackTrace();
}	
%>
</body>
</html>

mysql-connector-java-5.1.9.jar

--MySql

create table tblSpringBoard(
	seq 		mediumInt primary key auto_increment,
	title 		varchar(200),
	content 	varchar(2000),
	writer 		varchar(100),
	regdate 	varchar(14),
	hitcount 	mediumInt,
	password 	varchar(10)
);


select * from tblSpringBoard;

/*
--오라클
create table tblSpringBoard(
	seq 		number primary key,
	title 		varchar2(200),
	content 	varchar2(2000),
	writer 		varchar2(100),
	regdate 	varchar2(14),
	hitcount 	number,
	password 	varchar2(10)
);

create sequence seq_board;
*/