118 lines
4.0 KiB
Plaintext
118 lines
4.0 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@ page import="java.util.*"%>
|
|
<%@ page import="java.io.*"%>
|
|
<%@ page import="com.oreilly.servlet.MultipartRequest" %>
|
|
<%@ page import="com.oreilly.servlet.multipart.DefaultFileRenamePolicy" %>
|
|
<%@include file="/include/db/db_connect.jsp"%>
|
|
<%@include file="/include/function/function.jsp"%>
|
|
<%request.setCharacterEncoding("utf-8");%>
|
|
<%
|
|
|
|
|
|
String fileName = "";
|
|
String realFolder = "";
|
|
String saveFolder = "/upload/board";
|
|
String encType = "utf-8";
|
|
int maxSize = 10 * 1024 * 1024;
|
|
|
|
ServletContext scontext = getServletContext();
|
|
ArrayList saveFiles = new ArrayList();
|
|
ArrayList orgFiles = new ArrayList();
|
|
realFolder = scontext.getRealPath(saveFolder);
|
|
MultipartRequest multi = new MultipartRequest( request
|
|
, realFolder
|
|
, maxSize
|
|
, encType
|
|
, new DefaultFileRenamePolicy() );
|
|
Enumeration files = multi.getFileNames();
|
|
int t1 = 0;
|
|
String[] a_file = new String[11];
|
|
int olp = 11;
|
|
while( files.hasMoreElements() ){
|
|
olp = olp - 1;
|
|
|
|
String name = (String)files.nextElement();
|
|
String fName = multi.getFilesystemName( name );
|
|
String oName = multi.getOriginalFileName( name );
|
|
String type = multi.getContentType( name );
|
|
File f = multi.getFile( name );
|
|
if(fName != null && !fName.equals("")){
|
|
t1 = t1 + 1;
|
|
if(t1 > 1){
|
|
fileName = fileName + "|";
|
|
}
|
|
fileName = fileName + fName;
|
|
a_file[olp] = fName;
|
|
|
|
}else{
|
|
a_file[olp] = "";
|
|
}
|
|
}
|
|
if(fileName == null){
|
|
fileName = "";
|
|
}
|
|
|
|
String c_no = r_call(multi.getParameter("c_no"));
|
|
String show_no = r_call(multi.getParameter("show_no"));
|
|
String check_no = r_call(multi.getParameter("check_no"));
|
|
String c_relation = r_call(multi.getParameter("c_relation"));
|
|
String c_relation2 = r_call(multi.getParameter("c_relation2"));
|
|
String c_title = r_call(multi.getParameter("c_title"));
|
|
String c_name = r_call(multi.getParameter("c_name"));
|
|
String c_content = r_call(multi.getParameter("c_content"));
|
|
String o_file = r_call(multi.getParameter("o_file"));
|
|
String o_file_name = r_call(multi.getParameter("o_file_name"));
|
|
String last_file = "";
|
|
if(!fileName.equals("")){
|
|
last_file = fileName;
|
|
}else{
|
|
if(o_file.equals("y")){
|
|
last_file = "";
|
|
}else{
|
|
last_file = o_file_name;
|
|
}
|
|
}
|
|
|
|
String sql_ok = "";
|
|
sql_ok = "update tbl_board set c_title = '"+ c_title +"',c_content='"+ c_content +"',c_file ='"+ last_file +"' where c_no = " + c_no;
|
|
|
|
stmt2.execute(sql_ok);
|
|
|
|
String max_c_no = c_no;
|
|
|
|
sql_ok = "delete from tbl_board_to where c_board_no = " + c_no;
|
|
stmt2.execute(sql_ok);
|
|
|
|
|
|
String c_type[] = new String[4];
|
|
c_type[0] = r_call(multi.getParameter("c_type_0"));
|
|
c_type[1] = r_call(multi.getParameter("c_type_1"));
|
|
c_type[2] = r_call(multi.getParameter("c_type_2"));
|
|
c_type[3] = r_call(multi.getParameter("c_type_3"));
|
|
for(int i = 0 ; i < 4; i++){
|
|
if(c_type[i].equals("y")){
|
|
String sql_csr = "insert into tbl_board_to (c_board_no, c_group_type,c_group_no, c_user_type) values(";
|
|
sql_csr = sql_csr + max_c_no + "," + 0 + "," + i + ",0)";
|
|
stmt.execute(sql_csr);
|
|
}
|
|
}
|
|
//if(!c_type[0].equals("y")){
|
|
String[] a_team =multi.getParameterValues("c_team");
|
|
if(a_team != null && !a_team.equals("")){
|
|
for(int i=0;i<a_team.length;i++)
|
|
{
|
|
String sql_csr = "insert into tbl_board_to (c_board_no, c_group_type,c_group_no, c_user_type) values(";
|
|
sql_csr = sql_csr + max_c_no + "," + 1 + "," + a_team[i] + ",0)";
|
|
stmt.execute(sql_csr);
|
|
}
|
|
}
|
|
|
|
//}
|
|
|
|
%>
|
|
<script>
|
|
alert("Edit OK");
|
|
parent.location.href="view.jsp?show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>&c_no=<%=c_no%>";
|
|
</script>
|
|
<%@include file="/include/db/db_close.jsp"%>
|