%@ 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("¼±ÅÃÇÑ ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù...."));
}
%>