im trying to finish an application on eclipse using mysql .. this is the problem showen on browser ..
I dont know what does it mean (but i guess the problem is coming from the jar file)
Etat HTTP 500 -
type Rapport d''exception
message
description Le serveur a rencontré une erreur interne qui l''a empêché de satisfaire la requête.
exception
java.lang.NullPointerException
ma.fsts.miagem2.ebank.model.dao.DAOClient.create(DAOClient.java:12)
ma.fsts.miagem2.ebank.controler.ServAbonnement.doGet(ServAbonnement.java:48)
javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note La trace complète de la cause mère de cette erreur est disponible dans les fichiers journaux de Apache Tomcat/7.0.61.
Apache Tomcat/7.0.61
ServAbonnement.java (servlet)
package ma.fsts.miagem2.ebank.controler;
import java.io.IOException;
import java.util.Date;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import ma.fsts.miagem2.ebank.model.bo.Client;
import ma.fsts.miagem2.ebank.model.dao.DAOClient;
/**
* Servlet implementation class ServAbonnement
*/
@WebServlet("/ServAbonnement")
public class ServAbonnement extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public ServAbonnement() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
boolean resultat=false;
String cin=request.getParameter("cinh");
String nom=request.getParameter("nomh");
String prenom=request.getParameter("prenomh");
String tele=request.getParameter("teleh");
String adresse=request.getParameter("adrh");
String email=request.getParameter("emah");
String[] d=request.getParameter("datenh").split("-");
Date datenaiss=new Date(Integer.valueOf(d[0])-1900,Integer.valueOf(d[1])-1,Integer.valueOf(d[2]));
Client C=new Client(cin,nom,prenom,tele,adresse,email,datenaiss);
new DAOClient();
resultat=DAOClient.create(C);
System.out.println(resultat);
request.setAttribute("res", resultat);
RequestDispatcher req=request.getRequestDispatcher("./webpages/Finale.jsp");
req.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
}
DAOClient.java
package ma.fsts.miagem2.ebank.model.dao;
import java.sql.Date;
import java.sql.SQLException;
import java.util.Collection;
import ma.fsts.miagem2.ebank.model.bo.*;
import java.sql.*;
public class DAOClient {
public static boolean create(Client C){
try{
PreparedStatement pst=Connexion.getCon().prepareStatement("insert into client values(?,?,?,?,?,?,?)");
pst.clearParameters();
pst.setString(1,C.cin);
pst.setString(2,C.nom);
pst.setString(3,C.prenom);
pst.setString(4,C.tele);
pst.setString(5,C.adresse);
pst.setString(6,C.email);
String m=String.valueOf(C.datenaissance.getMonth()+1);
String j=String.valueOf(C.datenaissance.getDate());
String a=String.valueOf(C.datenaissance.getYear()+1900);
String dd=a+'-'+m+'-'+j;
pst.setString(7, dd);
pst.executeUpdate();
return true;
}
catch(SQLException e){
e.printStackTrace();
return false;
}
}
public static boolean update(Client C){return true;}
public static boolean delete(Client C){return true;}
public static Collection<Client> retreive(){return null;}
}
Aucun commentaire:
Enregistrer un commentaire