Advertisement
Guest User

Untitled

a guest
Sep 28th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.53 KB | None | 0 0
  1. WebServlet cannot be resolved to a type
  2. The attribute value is undefined for the annotation type
  3.  
  4. package Jeans;
  5. import java.io.IOException;
  6. import java.io.InputStream;
  7. import java.sql.Connection;
  8. import java.sql.PreparedStatement;
  9. import java.sql.SQLException;
  10.  
  11. import javax.servlet.ServletException;
  12. import javax.servlet.http.HttpServlet;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15. import javax.servlet.annotation.WebServlet;
  16.  
  17. import com.sun.java.swing.plaf.windows.TMSchema.Part;
  18.  
  19.  
  20. import javax.servlet.http.Part;
  21.  
  22.  
  23.  
  24. @WebServlet("/FileUploadDBServlet ")
  25.  
  26. //// i got an error here////////////////////////////
  27. @MultipartConfig(maxFileSize = 16177215)
  28.  
  29. public class FileUploadDBServlet extends HttpServlet {
  30.  
  31.  
  32. private String dbURL = "db";
  33. private String dbUser = "dbuser";
  34. private String dbPass = "dbpassword";
  35. String messageMio = "da contorllare";
  36. GestioneDB gestioneDB;
  37. boolean connessione;
  38. Connection conn;
  39.  
  40. protected void doPost(HttpServletRequest request,
  41. HttpServletResponse response) throws ServletException, IOException {
  42.  
  43.  
  44.  
  45.  
  46. String giorno= request.getParameter("giorno");
  47. String mese= request.getParameter("mese");
  48. String anno= request.getParameter("anno");
  49. String dataFormatoItaliano = giorno + "-" + mese + "-" + anno;
  50.  
  51. String titolo = request.getParameter("titolo");
  52. String titoletto = request.getParameter("titoletto");
  53. String testoMouse = request.getParameter("testoMouse");
  54. String link = request.getParameter("link");
  55. String data = dataFormatoItaliano;
  56. String testo = request.getParameter("testo");
  57.  
  58.  
  59.  
  60.  
  61. //// i got an error here////////////////////////////
  62. Part filePart = request.getPart("immaginePrincipale");
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69. String didascaliaImmaginePrincipale = request.getParameter("didascaliaImmaginePrincipale");
  70.  
  71.  
  72. InputStream immaginePrincipale = null;
  73. if (filePart != null) {
  74. // obtains input stream of the upload file
  75. immaginePrincipale = filePart.getInputStream();
  76. }
  77.  
  78.  
  79.  
  80.  
  81.  
  82. String message = null;
  83.  
  84. try {
  85.  
  86. gestioneDB = new GestioneDB();
  87. conn = gestioneDB.cn();
  88.  
  89.  
  90.  
  91. gestioneDB.inserimentoNews(titolo, titoletto, testoMouse, link, testo, data, immaginePrincipale, didascaliaImmaginePrincipale);
  92.  
  93.  
  94.  
  95. String sql = "INSERT INTO allegati_news (allegato,didascalia,tipo,id_news,immagine) values (?,?,?,?,?)";
  96.  
  97.  
  98.  
  99.  
  100. PreparedStatement statement = conn.prepareStatement(sql);
  101. statement.setString(1, "firstName");
  102. statement.setString(2, "lastName");
  103. statement.setInt(3, 1);
  104. statement.setInt(4,1);
  105. if (immaginePrincipale != null) {
  106. statement.setBlob(5, immaginePrincipale);
  107. }
  108.  
  109.  
  110.  
  111.  
  112. int row = statement.executeUpdate();
  113. if (row > 0) {
  114. message = "File salvato nel db";
  115. }
  116. } catch (SQLException ex) {
  117. message = "ERROR: " + ex.getMessage();
  118. ex.printStackTrace();
  119. } finally {
  120. if (conn != null) {
  121.  
  122. try {
  123. conn.close();
  124. } catch (SQLException ex) {
  125. ex.printStackTrace();
  126. }
  127. }
  128.  
  129. request.setAttribute("Message", gestioneDB.getInserimentoNewMessaggio());
  130.  
  131.  
  132.  
  133. getServletContext().getRequestDispatcher("/Message.jsp").forward(request, response);
  134. }
  135. }
  136. }
  137.  
  138. <?xml version="1.0" encoding="UTF-8"?>
  139. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  140. <display-name>Jeans2</display-name>
  141. <welcome-file-list>
  142. <welcome-file>index.html</welcome-file>
  143. <welcome-file>index.htm</welcome-file>
  144. <welcome-file>index.jsp</welcome-file>
  145. <welcome-file>default.html</welcome-file>
  146. <welcome-file>default.htm</welcome-file>
  147. <welcome-file>default.jsp</welcome-file>
  148. </welcome-file-list>
  149. <servlet>
  150. <description></description>
  151. <display-name>prova</display-name>
  152. <servlet-name>prova</servlet-name>
  153. <servlet-class>Jeans.prova</servlet-class>
  154. </servlet>
  155. <servlet-mapping>
  156. <servlet-name>prova</servlet-name>
  157. <url-pattern>/prova</url-pattern>
  158. </servlet-mapping>
  159. <servlet>
  160.  
  161. <description></description>
  162. <display-name>FileUploadDBServlet</display-name>
  163. <servlet-name>FileUploadDBServlet</servlet-name>
  164. <servlet-class>Jeans.FileUploadDBServlet</servlet-class>
  165. </servlet>
  166. <servlet-mapping>
  167. <servlet-name>FileUploadDBServlet</servlet-name>
  168. <url-pattern>/FileUploadDBServlet</url-pattern>
  169. </servlet-mapping>
  170.  
  171. <servlet>
  172. <description></description>
  173. <display-name>BlobDisplay</display-name>
  174. <servlet-name>BlobDisplay</servlet-name>
  175. <servlet-class>Jeans.BlobDisplay</servlet-class>
  176. </servlet>
  177. <servlet-mapping>
  178. <servlet-name>BlobDisplay</servlet-name>
  179. <url-pattern>/BlobDisplay</url-pattern>
  180. </servlet-mapping>
  181.  
  182.  
  183. </web-app>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement