JNDI 없는 mysql 연결 가능한 예제 안내드리니 참고 부탁드립니다.
[jdbctest.jsp]
<html>
<head>
<%@ page errorPage="errorpg.jsp"
import="java.sql.*,
javax.sql.*,
java.io.*" %>
</head>
<body>
<h1>JDBC Test</h1>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/dbname", "dbuser" , "dbpasswd");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("query");
while (rset.next()) {
결과물 처리
}
rset.close();
stmt.close();
conn.close();
%>
</body>
</html>