{{{ 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(); } %> }}} {{{ 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; */ }}}