원하시는 답이 될지 모르겠네요...제가 게시판 만들때 쓴건데..쏘스중 나머지는

아실거 같애서 중요 부분만 발췌했습니다. 아래에서는 content가 text타입입니다.

#############informix DB에 넣을때########################################## StringBuffer content = new StringBuffer();

...........

.............

PreparedStatement ps= null;

if (kubun.trim().equals("add")){

sSql= " insert into board(title,content,imgurl,conurl,regi_yn,del_yn,consize)"+

" values(?,?,?,?,?,?,?)";

ps = conn.prepareStatement(sSql );

ps.setString(1,title);

ps.setAsciiStream(2, new ByteArrayInputStream(new String(content.toString().getBytes("8859_1"),"KSC5601").getBytes()), content.length());

ps.setString(3,sImageName);

ps.setString(4,conurl);

ps.setString(5,"N");

ps.setString(6,"N");

ps.setInt(7,content.length());

ps.executeUpdate();

ps.close();

###############################꺼내올때################################

StringBuffer content = new StringBuffer();

...........

.............

sSql = "select num,title,content,conurl from board where num="+num;

byte [] bytes = new byte[4096];

int len = 0;

Statement stmt = conn.createStatement();

stmt.executeQuery(sSql);

ResultSet rs = stmt.getResultSet();

//첫번째 레코드 ...

rs.next();

num = rs.getInt(1);

title = rs.getString(2);

java.io.InputStream jstream = rs.getAsciiStream(3);

while ( (len = jstream.read(bytes)) != -1) {

content.append(new String(bytes, 0, len));

}

conurl = rs.getString(4);

lastcon = content.toString().trim();

conn.close();