본문 바로가기

반응형

프로그래밍

java - Servlet, JSP 한글 파일 다운로드 import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class Download extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String file_path="c:\\down"; String file_name = request.getParameter("f"); String file = file_path + file_name; PrintWriter out = response.getWriter(); File f = new Fil.. 더보기
java - oracle - Clob 쓰고 읽기 예제 I. 테이블 CREATE TABLE clob_test ( code CHAR(1) PRIMARY KEY, text CLOB ); II. 쓰기 ... connection.setAutoCommit(false); preparedstatement = connection.prepareStatement("INSERT INTO clob_test ('1', empty_clob())"); preparedstatement.executeUpdate(); preparedstatement.close(); content = "저장할 clob 데이터"; preparedstatement = connection.prepareStatement("SELECT text FROM clob_test WHERE code = '1' FRO UPDA.. 더보기
java - oracle - clob update 사용 방법 LOB Update 예제 /* * LobUpdate.sql * Chapter 16, Oracle10g PL/SQL Programming * by Ron Hardman, Mike McLaughlin, Scott Urman * * This script demonstrates LOB updates */ CREATE TABLE book_samples ( book_sample_id NUMBER (10) PRIMARY KEY, isbn CHAR(10 CHAR), description CLOB, nls_description NCLOB, book_cover BLOB, chapter_title VARCHAR2(30 CHAR), chapter BFILE ) LOB (book_cover) STORE AS blob_seg (.. 더보기
java - oracle - clob insert 사용 방법 public int getTableData(String ID, String FULL_TITLE, String TECH_AREA, String STATUS, String DEPUTY_EXECUTIVE, String SENIOR_PROJECT_MANAGER, String PROJECT_OFFICER, String PROJECT_MANAGER, String LEADING_INSTITUTE, String SUPPORTING_INSTITUTE, String COLLABORATORS, String SUPPORTERS, String PROJECT_SUMMARY, String tableName) { // Filter는 무조건 DBOracleFilter를 얻는다. IStorage storage = sm.getFilter.. 더보기
java - mysql 한글 물음표 출력 해결법 운영체제: XP 데이타 베이스 : mysql 5.0 1. jsp 파일상의 한글이 보이지 않는다면 show variables like 'c%'; - 결과 character_set_client : euckr character_set_connection : euckr character_set_database : euckr character_set_results : euckr character_set_server : euckr character_set_system : euckr collation_connection : euckr_general_ci collation_database : euckr_general_ci collation_server : euckr_general_ci 위와 같지 않다면 .... mys.. 더보기

반응형