Advertisement
Guest User

Untitled

a guest
Jul 6th, 2015
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.08 KB | None | 0 0
  1. <%@ page import="java.io.*,java.sql.*,java.util.*,java.text.*,java.text.SimpleDateFormat" %>
  2. <html>
  3.  
  4.  
  5. <%
  6. int val =0;
  7. String contentType = request.getContentType();
  8.  
  9. if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
  10. DataInputStream in = new DataInputStream(request.getInputStream());
  11.  
  12. int formDataLength = request.getContentLength();
  13. byte dataBytes[] = new byte[formDataLength];
  14. int byteRead = 0;
  15. int totalBytesRead = 0;
  16.  
  17. while (totalBytesRead < formDataLength) {
  18. byteRead = in.read(dataBytes, totalBytesRead, formDataLength);
  19. totalBytesRead += byteRead;
  20. }
  21.  
  22. String file = new String(dataBytes);
  23. String saveFile = file.substring(file.indexOf("filename="") + 10);
  24. System.out.println("saveFile=" + saveFile);
  25.  
  26. saveFile = saveFile.substring(saveFile.lastIndexOf("\")+ 1,saveFile.indexOf("""));
  27. System.out.println("saveFile" + saveFile);
  28.  
  29. saveFile = file.substring(file.indexOf("filename="") + 10);
  30. saveFile = saveFile.substring(0, saveFile.indexOf("n"));
  31. saveFile = saveFile.substring(saveFile.lastIndexOf("\")+ 1,saveFile.indexOf("""));
  32.  
  33. int lastIndex = contentType.lastIndexOf("=");
  34. String boundary = contentType.substring(lastIndex + 1,contentType.length());
  35. int pos;
  36.  
  37. pos = file.indexOf("filename="");
  38. pos = file.indexOf("n", pos) + 1;
  39. pos = file.indexOf("n", pos) + 1;
  40. pos = file.indexOf("n", pos) + 1;
  41.  
  42. int boundaryLocation = file.indexOf(boundary, pos) - 4;
  43. int startPos = ((file.substring(0, pos)).getBytes()).length;
  44. int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
  45.  
  46. FileOutputStream fileOut = new FileOutputStream(saveFile);
  47. fileOut.write(dataBytes, startPos, (endPos - startPos));
  48. %>
  49.  
  50.  
  51. <%
  52. Connection con=null;
  53. PreparedStatement pstatement = null;
  54. String line = null;
  55. String value=null;
  56.  
  57.  
  58.  
  59.  
  60.  
  61.  
  62. try
  63. {
  64. StringBuilder contents = new StringBuilder();
  65. BufferedReader input = new BufferedReader(new FileReader(saveFile));
  66.  
  67. while (( line = input.readLine()) != null){
  68. contents.append(line);
  69.  
  70. }
  71.  
  72.  
  73. value = contents.toString();
  74. System.out.println("Value:"+value);
  75.  
  76. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  77. con=DriverManager.getConnection("jdbc:jtds:sqlserver://W2K8SERVER:1433/career","sa","Alpha#123" );
  78.  
  79. java.util.Date now = new java.util.Date();
  80. String DATE_FORMAT = "yyyy-MM-dd hh:mm:ss";
  81. SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
  82. String strDateNew = sdf.format(now) ;
  83.  
  84.  
  85.  
  86. String queryString = "INSERT INTO file_tbl set file_data='"+value+"',file_date='"+strDateNew+"'";
  87.  
  88. //out.println(queryString);
  89.  
  90. pstatement=con.prepareStatement(queryString);
  91.  
  92. val = pstatement.executeUpdate();
  93.  
  94. if(val>0)
  95. {
  96. %>
  97. <br><br>
  98. <b>File <% out.println(saveFile); %> has been uploaded and inserted into Database at <%=strDateNew%>.</b>
  99. <%
  100. }
  101.  
  102.  
  103. }
  104. catch(Exception e)
  105. {}
  106. }
  107. %>
  108. </html>
  109.  
  110. org.apache.jasper.JasperException: An exception occurred processing JSP page /sendfile.jsp at line 26
  111. ->root cause
  112. java.lang.StringIndexOutOfBoundsException: String index out of range: -53652
  113.  
  114. saveFile = file.substring(file.indexOf("filename="") + 10);
  115. saveFile = saveFile.substring(0, saveFile.indexOf("n"));
  116. saveFile = saveFile.substring(saveFile.lastIndexOf("\")+ 1,saveFile.indexOf("""));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement