List of usage examples for org.apache.commons.fileupload FileUploadException getClass
@HotSpotIntrinsicCandidate public final native Class<?> getClass();
From source file:com.krawler.esp.portalmsg.Mail.java
public static String insertMailMsg(Connection conn, javax.servlet.http.HttpServletRequest request, String companyid) throws ServiceException, ParseException, JSONException { org.apache.commons.fileupload.DiskFileUpload fu = new org.apache.commons.fileupload.DiskFileUpload(); java.util.List fileItems = null; org.apache.commons.fileupload.FileItem fi = null; int sizeinmb = forummsgcomm.getmaxfilesize(conn, companyid); long maxsize = sizeinmb * 1024 * 1024; fu.setSizeMax(maxsize);/* w w w. ja v a2 s . co m*/ boolean fileupload = false; java.util.HashMap arrParam = new java.util.HashMap(); JSONObject jobj = new JSONObject(); try { fileItems = fu.parseRequest(request); } catch (org.apache.commons.fileupload.FileUploadException e) { com.krawler.utils.json.base.JSONObject jerrtemp = new com.krawler.utils.json.base.JSONObject(); if (e.getClass().getSimpleName().equalsIgnoreCase("SizeLimitExceededException")) { jerrtemp.put("msg", "For attachments, maximum file size allowed is " + sizeinmb + "MB"); } else { jerrtemp.put("msg", "Problem while uploading file."); } jerrtemp.put("Success", "Fail"); jobj.append("data", jerrtemp); return jobj.toString(); } for (java.util.Iterator k = fileItems.iterator(); k.hasNext();) { fi = (org.apache.commons.fileupload.FileItem) k.next(); arrParam.put(fi.getFieldName(), fi.getString()); if (!fi.isFormField()) { if (fi.getSize() > maxsize) { com.krawler.utils.json.base.JSONObject jerrtemp = new com.krawler.utils.json.base.JSONObject(); jerrtemp.put("Success", "Fail"); jerrtemp.put("msg", "Attachment size should be upto " + sizeinmb + "MB"); jobj.append("data", jerrtemp); return jobj.toString(); } fileupload = true; } } String poster_id = request.getParameter("userId"); String post_subject = StringUtil .serverHTMLStripper(java.net.URLDecoder.decode(arrParam.get("title").toString())); String post_text = java.net.URLDecoder.decode(arrParam.get("ptxt").toString()); String folder = "1"; Boolean readflag = false; String last_folder_id = "1"; String reply_to = ""; String sendflag = StringUtil.serverHTMLStripper(request.getParameter("sendflag")); String post_id1 = ""; String to_id = ""; String msgFor = ""; String fid = ""; String sendefolderpostid = ""; Boolean done = false; String[] tos = {}; if (sendflag.compareTo("reply") == 0) { post_id1 = StringUtil.serverHTMLStripper(request.getParameter("repto")); msgFor = getUserFromPost(conn, post_id1); fid = StringUtil.serverHTMLStripper(request.getParameter("fid")); if (fid.compareTo("3") != 0) { to_id = msgFor; } } else if (sendflag.compareTo("newmsg") == 0) { tos = request.getParameter("repto").split(";"); fid = StringUtil.serverHTMLStripper(request.getParameter("fid")); msgFor = to_id; } int draft = Integer.parseInt(request.getParameter("draft")); String query; String post_id = ""; String temp = ""; // JSONObject jobj = new JSONObject(); String usr = to_id; DbResults rs1 = null; DbResults rs2 = null; int numRows = 0; boolean uploaded = false; java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); java.util.Date d = new java.util.Date(); java.sql.Timestamp sqlPostDate = new java.sql.Timestamp(d.getTime()); UserDAO userDao = new UserDAOImpl(); if (sendflag.compareTo("reply") == 0) { if (draft == 1) { post_id = UUID.randomUUID().toString(); folder = getDraftId(poster_id);//"3"; last_folder_id = "0"; readflag = false; reply_to = ""; if (fid.compareTo("3") != 0) { if (StringUtil.isNullOrEmpty(to_id) || StringUtil.isNullOrEmpty(poster_id)) { return KWLErrorMsgs.exSuccessFail; } query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?,?,false, ?, ?, ?, ?)"; post_id = UUID.randomUUID().toString(); numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); } else { if (StringUtil.isNullOrEmpty(post_id1)) { return KWLErrorMsgs.exSuccessFail; } query = "Update mailmessages set post_subject=?, post_text=? where post_id=?"; numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_subject, post_text, post_id1 }); } } else if (draft == 2) { if (StringUtil.isNullOrEmpty(post_id1) || /*StringUtil.isNullOrEmpty(subdomain) || StringUtil.isNullOrEmpty(post_id) ||*/ StringUtil .isNullOrEmpty(to_id) || StringUtil.isNullOrEmpty(poster_id) /*|| StringUtil.isNullOrEmpty(reply_to)*/) { return KWLErrorMsgs.exSuccessFail; } // query = "SELECT users.userid FROM users inner join userlogin on users.userid=userlogin.userid where username=? and users.companyid = ?;"; // rs2 = DbUtil.executeQuery(conn, query, new Object[]{post_id1, companyid}); // // if (rs2.next()) { to_id = msgFor; // } query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?, ?,false, ?, ?, ?, ?)"; post_id = UUID.randomUUID().toString(); numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); if (fileupload) { forummsgcomm.doPost(conn, fileItems, post_id, sqlPostDate, poster_id, post_id); uploaded = true; } post_id = UUID.randomUUID().toString(); folder = "0"; last_folder_id = "0"; readflag = false; reply_to = ""; query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?, ?,false, ?, ?, ?, ?)"; numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); if (fileupload) { forummsgcomm.doPost(conn, fileItems, post_id, sqlPostDate, poster_id, post_id); } } else { query = "SELECT poster_id FROM mailmessages where post_id=?"; DbResults rs = DbUtil.executeQuery(conn, query, post_id1); while (rs.next()) { to_id = rs.getString(1); } } } else { if (draft != 1) { if (draft == 3) { for (int t = 0; t < tos.length; t++) { to_id = StringUtil.serverHTMLStripper(tos[t]); if (to_id.contains("@")) { query = "SELECT userid FROM users where emailid=?;"; rs2 = DbUtil.executeQuery(conn, query, to_id); if (rs2.next()) { to_id = (rs2.getString(1)); } else { usr = to_id; to_id = "-1"; //for invalid username } } else { query = "SELECT users.userid FROM users inner join userlogin on users.userid = userlogin.userid where userlogin.username=? and users.companyid = ?;"; rs2 = DbUtil.executeQuery(conn, query, new Object[] { to_id, companyid }); if (rs2.next()) { to_id = (rs2.getString(1)); } else { usr = AuthHandler.getUserName(conn, to_id); if (StringUtil.isNullOrEmpty(usr)) { usr = to_id; to_id = "-1"; //for invalid username } } } if (to_id.compareTo("-1") != 0) { if (StringUtil.isNullOrEmpty(to_id) || StringUtil.isNullOrEmpty(poster_id)) { return KWLErrorMsgs.exSuccessFail; } if (fid.compareTo("3") != 0 && t == tos.length - 1) { folder = "1"; query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?, ?,false, ?, ?, ?, ?)"; post_id = UUID.randomUUID().toString(); numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); } folder = "0"; query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?, ?,false, ?, ?, ?, ?)"; post_id = UUID.randomUUID().toString(); sendefolderpostid = post_id; numRows = DbUtil.executeUpdate(conn, query, new Object[] { post_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); //post_id = UUID.randomUUID().toString(); if (fileupload) { forummsgcomm.doPost(conn, fileItems, post_id, sqlPostDate, poster_id, post_id); uploaded = true; } last_folder_id = "0"; readflag = false; reply_to = ""; done = true; } if (fid.compareTo("3") == 0 && done == true) {//move to this users sent mails post_id = request.getParameter("postid"); String tempfolder = "1"; DbResults rstemp = null; query = "select poster_id from mailmessages where post_id=?"; rstemp = DbUtil.executeQuery(conn, query, new Object[] { post_id }); if (rstemp.next()) { query = "update mailmessages set to_id=?, poster_id=?, post_subject=?, post_text=?, post_time=?, flag=false, folder=?, reply_to=?, last_folder_id=?, readflag=? where post_id=?"; int tempnumrows = DbUtil.executeUpdate(conn, query, new Object[] { to_id, poster_id, post_subject, post_text, sqlPostDate, tempfolder, reply_to, last_folder_id, readflag, post_id }); if (tempnumrows == 0) { if (to_id.compareTo("-1") == 0) { com.krawler.utils.json.base.JSONObject jtemp = new com.krawler.utils.json.base.JSONObject(); jtemp.put("Success", "userfail"); jtemp.put("Subject", usr); jobj.append("data", jtemp); return jobj.toString(); } else { return KWLErrorMsgs.exSuccessFail; } } } } } } } else { for (int t = 0; t < tos.length; t++) { to_id = StringUtil.serverHTMLStripper(tos[t]); post_id = request.getParameter("postid"); folder = getDraftId(poster_id);//"3"; last_folder_id = getDraftId(poster_id); readflag = false; reply_to = ""; query = "SELECT users.userid FROM users inner join userlogin on users.userid = userlogin.userid where userlogin.username=? and users.companyid = ?;"; rs2 = DbUtil.executeQuery(conn, query, new Object[] { to_id, companyid }); if (rs2.next()) { to_id = (rs2.getString(1)); } else { to_id = poster_id; } if (done == false) { if (to_id.compareTo("-1") != 0) { if (StringUtil.isNullOrEmpty(to_id) || StringUtil.isNullOrEmpty(poster_id)) { return KWLErrorMsgs.exSuccessFail; } DbResults rstemp = null; query = "select poster_id from mailmessages where post_id=?"; rstemp = DbUtil.executeQuery(conn, query, new Object[] { post_id }); if (rstemp.next()) { query = "update mailmessages set to_id=?, poster_id=?, post_subject=?, post_text=?, post_time=?, flag=false, folder=?, reply_to=?, last_folder_id=?, readflag=? where post_id=?"; numRows = DbUtil.executeUpdate(conn, query, new Object[] { to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag, post_id }); } else { String tpost_id = UUID.randomUUID().toString(); folder = getDraftId(poster_id);//"3"; last_folder_id = "0"; readflag = false; reply_to = ""; if (fid.compareTo("3") != 0) { if (StringUtil.isNullOrEmpty(to_id) || StringUtil.isNullOrEmpty(poster_id)) { return KWLErrorMsgs.exSuccessFail; } query = "Insert into mailmessages (post_id, to_id, poster_id, post_subject, post_text, post_time, flag, folder, reply_to, last_folder_id, readflag) values ( ?, ?, ?, ?, ?,?,false, ?, ?, ?, ?)"; numRows = DbUtil.executeUpdate(conn, query, new Object[] { tpost_id, to_id, poster_id, post_subject, post_text, sqlPostDate, folder, reply_to, last_folder_id, readflag }); } } } } } } } if (fileupload && !uploaded) { forummsgcomm.doPost(conn, fileItems, post_id, sqlPostDate, poster_id, sendefolderpostid); } if (numRows == 0) { if (to_id.compareTo("-1") == 0) { com.krawler.utils.json.base.JSONObject jtemp = new com.krawler.utils.json.base.JSONObject(); jtemp.put("Success", "userfail"); jtemp.put("Subject", usr); jobj.append("data", jtemp); return jobj.toString(); } else { return KWLErrorMsgs.exSuccessFail; } } else { String dateTime = ""; String UserName = ""; String Image = ""; query = "SELECT userlogin.username,image FROM users inner join userlogin on users.userid=userlogin.userid where users.userid=?;"; rs2 = DbUtil.executeQuery(conn, query, poster_id); if (rs2.next()) { UserName = (rs2.getString(1)); Image = (rs2.getString(2)); } if (draft == 1 && sendflag.compareTo("reply") == 0) { query = "SELECT post_time FROM mailmessages where post_id=?;"; rs1 = DbUtil.executeQuery(conn, query, post_id1); if (rs1.next()) { dateTime = (rs1.getObject(1).toString()); } } else { query = "SELECT post_time FROM mailmessages where post_id=?;"; rs1 = DbUtil.executeQuery(conn, query, post_id); if (rs1.next()) { dateTime = (rs1.getObject(1).toString()); } } String userTime = Timezone.toCompanyTimezone(conn, sqlPostDate.toString(), companyid); java.util.Date tempdate = sdf.parse(userTime); java.text.SimpleDateFormat sdf1 = new java.text.SimpleDateFormat("yyyy-MM-dd h:mm a"); JSONStringer j = new JSONStringer(); com.krawler.utils.json.base.JSONObject jtemp = new com.krawler.utils.json.base.JSONObject(); String success = "Success"; if (folder.compareTo("3") == 0) { success = "Draft"; } jtemp.put("Success", success); jtemp.put("post_time", sdf1.format(tempdate).toString()); jtemp.put("flag", "false"); jtemp.put("post_id", post_id); jtemp.put("post_subject", post_subject); jtemp.put("post_text", ""); jtemp.put("poster_id", UserName); jtemp.put("readflag", "0"); jtemp.put("imgsrc", Image); jtemp.put("senderid", poster_id); jobj.append("data", jtemp); /*temp = j.object().key("Success").value("Success").key("post_time") .value(sdf1.format(tempdate).toString()).key("flag").value( "false").key("post_id").value(post_id).key( "post_subject").value(post_subject) .key("post_text").value("").key("poster_id") .value(UserName).key("readflag").value("0").key("imgsrc") .value(Image).key("senderid").value(poster_id).endObject() .toString();*/ } return jobj.toString(); }