BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: jsp [JSP·Î ORACLE Clob ¾ò±â] Á¶È¸¼ö: 7255


<%@ page language="java" import="java.sql.*" contentType="text/html;charset=euc-
kr" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="oracle.jdbc.driver.*" %>
<%@ page import="oracle.sql.*" %>

<%
//String rs=null;

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracledb","user","passwd");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select content from FSC_table
where seq_no='1173'");
if(rs.next())
{
Reader input = rs.getCharacterStream(1);
char[] buffer = new char[512];
int byteRead;
out.println("<pre>");
while((byteRead=input.read(buffer,0,512))!=-1)
{
for(int i=0;i<byteRead; i++)
out.print(buffer[i]);
}
input.close();
out.println("</pre>");
}
else {
System.out.println("error");
}
stmt.close();
conn.close();
%>

°ü·Ã±Û : 1 °Ç ±Û¾´½Ã°£ : 2004/05/08 14:56 from 218.149.22.88

 

Á¦ ¸ñ

Á¶È¸

³¯Â¥

±Û¾´ÀÌ

 

php.ini[PHP4±âÁØ]¼³¸í

7630

2004.05.08

PHP


  [PHP¿¡¼­ Oracle ClobŸÀÔÀбâ] ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ http://www.jspschool.com/  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡