원하시는 답이 될지 모르겠네요...제가 게시판 만들때 쓴건데..쏘스중 나머지는
아실거 같애서 중요 부분만 발췌했습니다. 아래에서는 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();
|