<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%!
DataSource ds = null;
public void jspInit(){
try{
Context context = new InitialContext();
ds = (DataSource)context.lookup("OracleJNDI");
}catch(Exception e){
}
}
%>
<%@page import="javax.naming.Context"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
Insert title here
DataSource(DB Connection) 의 사용
| 아이디 |
암호 |
이름 |
이메일 |
<%
Connection con = ds.getConnection();
Statement stmt = con.createStatement();
String sql = " Select * From userinfo";
ResultSet rs = stmt.executeQuery(sql);
if(rs!=null){
while(rs.next()){
%>
| <%=rs.getString(1) %> |
<%=rs.getString(2) %> |
<%=rs.getString(3) %> |
<%=rs.getString(4) %> |
<%
}
}
%>