boujours,
mon probleme c'est que je n'arrive pas a recuperer les données depuis ma base de donnée :
voici le code
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String login = request.getParameter("login");
String passe = request.getParameter("passe");
PrintWriter out = response.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
String URL="jdbc:mysql://127.0.0.1/test";
Connection con=null;
try {
con = DriverManager.getConnection(URL,"root","");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String query="select * from user";
try{
Statement stmt = con.createStatement();
ResultSet rs = (ResultSet) stmt.executeQuery(query);
while(rs.next())
{
out.println("EmpName" + " " + "EmpSalary" + "
");
out.println(rs.getString(1) + " " + rs.getString(2) + "
");
}
}
catch(Exception e){
System.out.println("erreur");
}
out.println("yassine");
}
}
--------------------------------------------------------------------------------
voici l'erreur que j'ai eu :
--------------------------------------------------------------------------------
23:55:56,203 INFO [STDOUT] erreur
23:55:56,203 ERROR [[MyServlet]] "Servlet.service()" pour la servlet MyServlet a généré une exception
java.lang.NullPointerException
at MyServlet.doPost(MyServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
23:57:50,968 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51331servlet_1-exp.war/
23:57:51,109 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51332servlet_1-exp.war/
23:58:07,468 INFO [STDOUT] erreur
23:58:07,484 ERROR [[MyServlet]] "Servlet.service()" pour la servlet MyServlet a généré une exception
java.lang.NullPointerException
at MyServlet.doPost(MyServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
23:59:01,390 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51332servlet_1-exp.war/
23:59:01,453 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51333servlet_1-exp.war/
23:59:15,171 ERROR [[MyServlet]] "Servlet.service()" pour la servlet MyServlet a généré une exception
java.lang.Error: Unresolved compilation problems:
Unhandled exception type SQLException
Unhandled exception type SQLException
at MyServlet.doPost(MyServlet.java:66)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
00:00:06,734 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51333servlet_1-exp.war/
00:00:06,781 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51334servlet_1-exp.war/
00:00:43,140 INFO [STDOUT] erreur
00:00:43,140 ERROR [[MyServlet]] "Servlet.service()" pour la servlet MyServlet a généré une exception
java.lang.NullPointerException
at MyServlet.doPost(MyServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
00:03:12,328 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51334servlet_1-exp.war/
00:03:12,406 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51335servlet_1-exp.war/
00:03:46,984 INFO [STDOUT] erreur
00:03:46,984 ERROR [[MyServlet]] "Servlet.service()" pour la servlet MyServlet a généré une exception
java.lang.NullPointerException
at MyServlet.doPost(MyServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Unknown Source)
00:07:23,140 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51335servlet_1-exp.war/
00:07:23,171 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51336servlet_1-exp.war/
00:08:13,343 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51336servlet_1-exp.war/
00:08:13,390 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51337servlet_1-exp.war/
00:13:34,265 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51337servlet_1-exp.war/
00:13:34,328 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51338servlet_1-exp.war/
00:14:09,578 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51338servlet_1-exp.war/
00:14:09,640 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51339servlet_1-exp.war/
00:14:49,937 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51339servlet_1-exp.war/
00:14:50,046 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51340servlet_1-exp.war/
00:15:40,343 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51340servlet_1-exp.war/
00:15:40,421 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51341servlet_1-exp.war/
00:16:02,656 INFO [STDOUT] erreur
00:21:36,312 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51341servlet_1-exp.war/
00:21:36,375 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51342servlet_1-exp.war/
00:21:58,781 INFO [STDOUT] erreur
00:23:21,781 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51342servlet_1-exp.war/
00:23:21,843 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51343servlet_1-exp.war/
00:23:41,187 INFO [STDOUT] erreur
00:29:17,781 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51343servlet_1-exp.war/
00:29:17,843 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51344servlet_1-exp.war/
00:29:34,906 INFO [STDOUT] erreur
00:31:08,281 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51344servlet_1-exp.war/
00:31:08,375 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51345servlet_1-exp.war/
00:31:18,953 INFO [STDOUT] erreur
00:33:43,906 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51345servlet_1-exp.war/
00:33:43,937 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51346servlet_1-exp.war/
00:33:58,812 INFO [STDOUT] erreur
00:50:11,109 INFO [TomcatDeployer] undeploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51346servlet_1-exp.war/
00:50:11,171 INFO [TomcatDeployer] deploy, ctxPath=/servlet_1, warUrl=.../tmp/deploy/tmp51347servlet_1-exp.war/
00:50:28,359 INFO [STDOUT] erreur
Afficher la suite