<%@ page contentType="text/html;charset=euc-kr" import="java.sql.*,java.io.*,javax.sql.*,javax.naming.*,java.util.*,util.*,java.text.*,java.net.*"%><% int B_ORDER = TUtil.strToInt(request.getParameter("B_ORDER"),0); // °¡Á®¿Ã ¸®½ºÆ® ±ÛÀÇ ½ÃÀÛ ¹øÈ£ int B_STEP = TUtil.strToInt(request.getParameter("B_STEP"),0); String fn = TUtil.n2bs(request.getParameter("fn"),""); int FILE_SIZE=0; String Query=""; String BBSCODE = ""; String FILE=""; String FILE_LOACTION=""; StringBuffer query = null; StringBuffer query1 = new StringBuffer(); query = new StringBuffer(); //query ÀúÀå¼Ò »ý¼º //query.append(" SELECT a.B_NUM, a.BBSCODE, a.B_FILENAME1, a.B_FILENAME2, a.B_FILENAME3, a.B_FILENAME4, a.B_FILENAME5 ") query.append(" SELECT a.B_NUM, a.BBSCODE, ") .append(" a.B_FILENAME1, a.B_FILENAME2, a.B_FILENAME3, a.B_FILENAME4, a.B_FILENAME5, a.B_FILENAME6, a.B_FILENAME7, a.B_FILENAME8, a.B_FILENAME9, a.B_FILENAME10, ") .append(" a.B_FILENAME11, a.B_FILENAME12, a.B_FILENAME13, a.B_FILENAME14, a.B_FILENAME15, a.B_FILENAME16, a.B_FILENAME17, a.B_FILENAME18, a.B_FILENAME19, a.B_FILENAME20, ") .append(" a.B_FILENAME21, a.B_FILENAME22, a.B_FILENAME23, a.B_FILENAME24, a.B_FILENAME25, a.B_FILENAME26, a.B_FILENAME27, a.B_FILENAME28, a.B_FILENAME29, a.B_FILENAME30, ") .append(" a.B_FILENAME31, a.B_FILENAME32, a.B_FILENAME33, a.B_FILENAME34, a.B_FILENAME35, a.B_FILENAME36, a.B_FILENAME37, a.B_FILENAME38, a.B_FILENAME39, a.B_FILENAME40, ") .append(" a.B_FILENAME41, a.B_FILENAME42, a.B_FILENAME43, a.B_FILENAME44, a.B_FILENAME45, a.B_FILENAME46, a.B_FILENAME47, a.B_FILENAME48, a.B_FILENAME49, a.B_FILENAME50, ") .append(" a.B_FILENAME51, a.B_FILENAME52, a.B_FILENAME53, a.B_FILENAME54, a.B_FILENAME55, a.B_FILENAME56, a.B_FILENAME57, a.B_FILENAME58, a.B_FILENAME59, a.B_FILENAME60 ") .append(" FROM UNI_BBS a, ") .append(" (SELECT * FROM BBS_ADMIN WHERE A_USE='Y' AND A_PORT='80') b ") .append(" WHERE a.B_DEL_CHK='N' AND a.B_LOOK='Y' and b.A_BBSCODE=a.BBSCODE AND a.B_STEP =? "); query1.append(" SELECT a.B_NUM, a.BBSCODE, ") .append(" a.B_FILENAME1, a.B_FILENAME2, a.B_FILENAME3, a.B_FILENAME4, a.B_FILENAME5, a.B_FILENAME6, a.B_FILENAME7, a.B_FILENAME8, a.B_FILENAME9, a.B_FILENAME10, ") .append(" a.B_FILENAME11, a.B_FILENAME12, a.B_FILENAME13, a.B_FILENAME14, a.B_FILENAME15, a.B_FILENAME16, a.B_FILENAME17, a.B_FILENAME18, a.B_FILENAME19, a.B_FILENAME20, ") .append(" a.B_FILENAME21, a.B_FILENAME22, a.B_FILENAME23, a.B_FILENAME24, a.B_FILENAME25, a.B_FILENAME26, a.B_FILENAME27, a.B_FILENAME28, a.B_FILENAME29, a.B_FILENAME30, ") .append(" a.B_FILENAME31, a.B_FILENAME32, a.B_FILENAME33, a.B_FILENAME34, a.B_FILENAME35, a.B_FILENAME36, a.B_FILENAME37, a.B_FILENAME38, a.B_FILENAME39, a.B_FILENAME40, ") .append(" a.B_FILENAME41, a.B_FILENAME42, a.B_FILENAME43, a.B_FILENAME44, a.B_FILENAME45, a.B_FILENAME46, a.B_FILENAME47, a.B_FILENAME48, a.B_FILENAME49, a.B_FILENAME50, ") .append(" a.B_FILENAME51, a.B_FILENAME52, a.B_FILENAME53, a.B_FILENAME54, a.B_FILENAME55, a.B_FILENAME56, a.B_FILENAME57, a.B_FILENAME58, a.B_FILENAME59, a.B_FILENAME60 ") .append(" FROM UNI_BBS a, " ) .append(" (SELECT * FROM BBS_ADMIN WHERE A_USE='Y') b " ) .append(" WHERE a.B_DEL_CHK='N' AND a.B_LOOK='Y' and b.A_BBSCODE=a.BBSCODE AND a.B_STEP = " + B_STEP ); //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:"+query1.toString());} Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = DBConnection.getGBConnection_new(); //stmt = con.createStatement(); //rs = stmt.executeQuery(Query); stmt = con.prepareStatement(query.toString()); stmt.setInt( 1, B_STEP ); rs = stmt.executeQuery(); String ffn="B_FILENAME1"; /* */ if( rs.next() ) { for ( int kk = 1 ; kk < 61 ; kk++ ) { BBSCODE = TDbUtil.getValue(rs,"BBSCODE",""); ffn="B_FILENAME"+TUtil.i2s(kk); if ( B_ORDER == kk ) FILE=TDbUtil.getValue(rs,ffn,""); } /* BBSCODE = TDbUtil.getValue(rs,"BBSCODE",""); if ( B_ORDER == 1 ) FILE=TDbUtil.getValue(rs,"B_FILENAME1",""); if ( B_ORDER == 2 ) FILE=TDbUtil.getValue(rs,"B_FILENAME2",""); if ( B_ORDER == 3 ) FILE=TDbUtil.getValue(rs,"B_FILENAME3",""); if ( B_ORDER == 4 ) FILE=TDbUtil.getValue(rs,"B_FILENAME4",""); if ( B_ORDER == 5 ) FILE=TDbUtil.getValue(rs,"B_FILENAME5",""); */ } rs.close(); stmt.close(); con.close(); } catch(SQLException e) { System.out.println("¿À·ù=" + "/Common/board/download.jsp"); } finally { if ( rs != null ) try {rs.close();}catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if ( stmt != null ) try {stmt.close();}catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if ( con != null ) try {con.close();}catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} } //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:002");} //if(BBSCODE.equals("filetest")) { // FILE = fn; //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:003");} if ( FILE.length()!=0 ) { //if ( "AIX".equals(TUtil.getOS()) ) //con=FILE.indexOf("/"); //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:004");} if (FILE.indexOf("/")>0) { String[] aa; aa = FILE.split("/"); BBSCODE = aa[0]; FILE = aa[1]; } if (FILE.indexOf("|")>0) { //86302C18430E4AF18226134A9A399F5C.hwp|Á¤ÁÖȯ°æ ÇöȲ(2019.3¿ù¸») - °Ô½Ã¿ëÃÖÁ¾.hwp String[] bb; FILE = FILE.replace("|", "@@@"); bb = FILE.split("@@@"); FILE = bb[0]; } //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:005");} FILE_LOACTION = "/tmax/webhome/data/"+BBSCODE+"/"+FILE; File fileUp = new File(FILE_LOACTION); //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:005.5");} int ifilesize1 = (int)fileUp.length(); //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:005.6");} int ifilesize = ( ifilesize1>1023 ) ? 1024:(int)fileUp.length(); //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:005.7");} //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:007.1"+",,fileUp.isFile():"+fileUp.isFile()+",,ifilesize:"+ifilesize);} if ( fileUp.isFile() && ( ifilesize > 0 ) ) { //if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:008"+",,fileUp.isFile():"+fileUp.isFile()+",,ifilesize:"+ifilesize);} // byte b[] = new byte[0x100000]; // byte b[] = new byte[ifilesize]; String strClient = request.getHeader("User-Agent"); if ( !"AIX".equals(TUtil.getOS()) ) FILE = new String(FILE.getBytes("ksc5601"),"8859_1"); if( strClient!=null && strClient.indexOf("MSIE 5.5") != -1 ) { response.setHeader("Content-Type", "doesn/matter;"); response.setHeader("Content-Disposition", "filename=" + FILE.replaceAll("\r", "").replaceAll("\n", "") + ";"); } else { response.setHeader("Content-Type", "application/octet-stream;"); response.setHeader("Content-Disposition", "attachment;filename=\""+ FILE.replaceAll("\r", "").replaceAll("\n", "") + "\";"); }; response.setHeader("Content-Transfer-Encoding", "binary;"); response.setHeader("Pragma", "no-cache;"); response.setHeader("Expires", "-1;"); response.setHeader("Content-Length", ""+ifilesize1 ); FileInputStream fileinputstream = null; BufferedInputStream bufferedinputstream = null; OutputStream outputstream = response.getOutputStream(); try { fileinputstream = new FileInputStream(fileUp); bufferedinputstream = new BufferedInputStream(fileinputstream); int i; while((i = bufferedinputstream.read()) != -1) outputstream.write(i); outputstream.flush(); } catch(Exception e) { System.out.println("¿À·ù=" + "/Common/board/download.jsp"); } finally { if(fileinputstream != null) try{fileinputstream.close(); } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if(bufferedinputstream != null) try{bufferedinputstream.close(); } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if(fileUp != null) try{fileUp=null; } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if(strClient != null) try{strClient=null; } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} if(FILE != null) try{FILE=null; } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} outputstream.flush(); if(outputstream != null) try{outputstream.flush(); } catch(Exception e){System.out.println("¿À·ù=" + "/Common/board/download.jsp");} } } // if else { out.print(TUtil.returnHistory("¼±ÅÃÇÑ ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù...")); } } else { out.print(TUtil.returnHistory("¼±ÅÃÇÑ ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù....")); } %>