108 lines
4.0 KiB
Plaintext
108 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 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 sql_ok = "";
|
|
sql_ok = " insert into tbl_board (c_relation,c_relation2, c_project_no, c_member_no, c_name ,c_title,c_content,c_file,c_click,c_use, c_date) values(";
|
|
sql_ok = sql_ok + c_relation + "," + c_relation2 + "," + session.getAttribute("member_project_no") +"," + session.getAttribute("member_no") + ",'" + c_name + "','"+ c_title + "','" + c_content + "','" +fileName + "',0,0,now())";
|
|
|
|
stmt2.execute(sql_ok);
|
|
|
|
int max_c_no = 1;
|
|
String sql_hypo = " select max(c_no) as max_c_no from tbl_board ";
|
|
ResultSet rs_hypo = stmt2.executeQuery(sql_hypo);
|
|
if(rs_hypo.next()){
|
|
max_c_no = rs_hypo.getInt("max_c_no");
|
|
}
|
|
rs_hypo.close();
|
|
|
|
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("Insert OK");
|
|
parent.location.href="list.jsp?show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>";
|
|
</script>
|
|
<%@include file="/include/db/db_close.jsp"%>
|