Microsoft SQL Server JDBC 드라이버 3.0
드라이버다운로드
Tomcat>conf> context.xml
------------------------------------------------------------------------------
<Resource name="jdbc/sql2000" auth="Container" type="javax.sql.DataSource"
description="EDUCS JDBC Connections in Tomcat WAS"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://192.168.1.171:1433;DatabaseName=Pubs"
username="sa"
password="1234
maxActive="20"
/>
------------------------------------------------------------------------------
Contents Root > WEB-INF > web.xml
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/EDUCS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
----------------------------------------------------------------------------------
test page
jstl.jar , standard.jar 설정후...
<%@ page contentType = "text/html; charset=euc-kr" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
//session.setAttribute("test","1234");
%>
<sql:query var="rs" dataSource="jdbc/sql2000">
select b_id,b_subject,reg_date,b_writer from Board
</sql:query>
<html>
<head>
<title>DB Test</title>
</head>
<body>
<h2>Results${sessionScope.test}</h2>
<table width=700 border=1>
<c:forEach var="row" items="${rs.rows}">
<tr>
<td>${row.b_id}</td>
<td><a href="Board_view.jsp?id=${row.b_id}">${row.b_subject}</a></td>
<td>${row.reg_date}</td>
<td>${row.b_writer}</td>
</tr>
</c:forEach>
</table>
</body>
</html>
