<%@ page contentType="text/html;charset=euc-kr" language="java" import! = "java.util.*, java.net.*, java.io.*, java.sql.*, common.*"%>
<%
Connection conn = null;
Statement st = null;
ResultSet rs = null;
StringBuffer sql="";
Common_Data cd = null;
int rsCount=0;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
cd = new Common_Data();
}catch(ClassNotFoundException ce){
out.println(ce);
}
try{
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=DB_NM;user=sa;password=pwd");
st = conn.createStatement();
sql.append(" SELECT * FROM TBL_NM ");
rs= st.executeQuery(sql.toString());
while(rs.next()){
out.println(rs.getString(1));
}
rs.close();
}catch(SQLException se){
out.println(se);
}finally{
try{
if(rs!=null)rs.close();
if(st!=null)st.close();
if(conn!=null)conn.close();
}catch(SQLException se){}
}
%>
'IT' 카테고리의 다른 글
[스크랩] JSP ResultSet 다루기 (0) | 2010.03.15 |
---|---|
[스크랩] List, Map, Set (0) | 2010.03.15 |
[스크랩] 성적처리 Vector, ArrayList, Hashtable, Random (0) | 2010.03.15 |
[스크랩] [JSP] 형변환 String <-> Integer (0) | 2010.03.15 |
[스크랩] JSP: 내장객체 request (0) | 2010.03.15 |