Changes between Version 2 and Version 3 of db/MySql

차이점 주위로
다음 차이점은 무시하기:
작성자:
anonymous (IP: 221.150.127.103)
날짜/시간:
2012-10-17 AM 11:42:03 (13 년 전)
설명:

--

Legend:

변경되지 않음
추가됨
제거됨
변경됨

  • db/MySql

    v2 v3  
    7979 
    8080}}} 
     81 
     82{{{ 
     83<%@page import="javax.sql.DataSource"%> 
     84<%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%> 
     85<%@page import="org.springframework.context.ApplicationContext"%> 
     86<%@page import="java.sql.DriverManager"%> 
     87<%@page import="java.sql.ResultSet"%> 
     88<%@page import="java.sql.Statement"%> 
     89<%@page import="java.sql.Connection"%> 
     90<%@ page language="java" contentType="text/html; charset=EUC-KR" 
     91    pageEncoding="EUC-KR"%> 
     92     
     93<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
     94<html> 
     95<head> 
     96<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR"> 
     97<title>Insert title here</title> 
     98</head> 
     99<body> 
     100<hr> 
     101<h1>일반 jdbc</h1> 
     102<p> 
     103<% 
     104Connection conn; 
     105Statement stmt; 
     106ResultSet rset; 
     107try{ 
     108        Class.forName("com.mysql.jdbc.Driver"); 
     109        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","ever1234"); 
     110        stmt = conn.createStatement(); 
     111        rset = stmt.executeQuery("select * from TEAM "); 
     112        while(rset.next()){ 
     113                out.println(rset.getInt(1)+" : "+rset.getString(2)+"</br>"); 
     114        } 
     115}catch(Exception err){ 
     116        err.printStackTrace(); 
     117} 
     118%>       
     119<hr> 
     120<h1>spring lookup</h1> 
     121<p> 
     122<% 
     123try{ 
     124        ApplicationContext  context = WebApplicationContextUtils.getWebApplicationContext( 
     125                                                                        request.getSession().getServletContext()); 
     126        DataSource ds = (DataSource)context.getBean("dataSource-mysql"); 
     127        conn = ds.getConnection(); 
     128        stmt = conn.createStatement(); 
     129        rset = stmt.executeQuery("select * from TEAM "); 
     130        while(rset.next()){ 
     131                out.println(rset.getInt(1)+" : "+rset.getString(2)+"</br>"); 
     132        } 
     133}catch(Exception err){ 
     134        err.printStackTrace(); 
     135}        
     136%> 
     137</body> 
     138</html> 
     139}}}