%@ 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' AND A_BBSCODE NOT IN('simpan_pds') ) b ")
.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;
boolean is_view = ((TUtil.o2s(session.getAttribute("is_view"),"false")).equals("false")) ? false:true;
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";
/*
*/
out.println("
:000");
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=TUtil.StrReplace(TDbUtil.getValue(rs,ffn,""), "|", ";");
FILE= (is_slipt(FILE))? fslipt(FILE)[0]:FILE;
}
}
}
//System.out.println("
:111000"+",,is_view:"+is_view+",,BBSCODE:"+BBSCODE);
out.println("
:FILE:: "+FILE);
//rs.close();
//stmt.close();
//con.close();
//System.out.println("
:FILE:: "+FILE);
}
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;
//}
//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(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:005");}
FILE_LOACTION = "/tmax/webhome/data/"+BBSCODE+"/"+FILE;
if(BBSCODE.equals("simpan_pds") || BBSCODE.equals("simpan_news_test")) {
FILE_LOACTION = "/gpfs01/webhome/singo_data/"+BBSCODE+"/"+FILE;
}
//if(B_STEP==2713499) {System.out.println(":/gpfs01/www_home/Common/board/download.jsp:006");}
if(BBSCODE.equals("simpan_pds") && is_view == false) {
out.print(TUtil.returnHistory("¼±ÅÃÇÑ ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù..."));
}else{
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("¼±ÅÃÇÑ ÆÄÀÏÀº Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù...."));
}
%>
<%!
public static String[] fslipt(String FILENAME){
String result[] = new String[2];
String resultss = FILENAME;
//System.out.println("
/tmax/www_home/Common/board_egov/download.jsp:fslipt:001"+FILENAME);
if (is_slipt(FILENAME)){
//System.out.println("
/tmax/www_home/Common/board_egov/download.jsp:fslipt:002");
result = FILENAME.split(";");
//resultss = TUtil.StrReplace(resultss, "|", ";");//
//System.out.println("
/tmax/www_home/Common/board_egov/download.jsp:fslipt:003:"+FILENAME);
//System.out.println("
/tmax/www_home/Common/board_egov/download.jsp:fslipt:004:"+result[0]);
//System.out.println("
/tmax/www_home/Common/board_egov/download.jsp:fslipt:005:"+result[1]);
}
return result;
}
public static boolean is_slipt(String FILENAME){
return (FILENAME.length()!=0 && FILENAME.indexOf(";")>-1);
}
public static boolean is_slipt(String FILENAME,String ss){
return (FILENAME.length()!=0 && FILENAME.indexOf(ss)>-1);
}
%>