This is the html page:
Add Client
-->
First name
Last name
User name
Father name
Email
Password
Street
Building
Date of birth
Gender Male Female
Adresse Beirut Mont Liban South Bekaa North
Phone number
Last connexion
And this is the servlet:
package AdminClient;
import java.io.IOException; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Locale;
import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
/** * Servlet implementation class AddClientServlet */ @WebServlet("/AddClientServlet") public class AddClientServlet extends HttpServlet { private static final long serialVersionUID = 1L;
/** * @see HttpServlet#HttpServlet() */ public AddClientServlet() { super(); // TODO Auto-generated constructor stub } @Override public void service(ServletRequest request, ServletResponse response)throws ServletException, IOException { String first = request.getParameter( "first_name" ); String last = request.getParameter( "last_name" ); String father = request.getParameter( "father_name" ); String phone = request.getParameter( "phone_number" ); String email = request.getParameter( "email" ); String username = request.getParameter( "username" ); String password = request.getParameter( "password" ); String dateBirth = request.getParameter( "date_of_birth" ); DateFormat formatter,formatter1; java.util.Date date = null; java.util.Date date1 = null; formatter = new SimpleDateFormat("yyyy-mm-dd",Locale.ENGLISH); try { date =formatter.parse(dateBirth); } catch (ParseException e2) { // TODO Auto-generated catch block e2.printStackTrace(); } String gender = request.getParameter( "gender" ); String street = request.getParameter( "street" ); String city = request.getParameter( "city" ); String lastConnection = request.getParameter( "last_connexion" ); formatter1 = new SimpleDateFormat("yyyy-mm-dd",Locale.ENGLISH); try { date1 = formatter.parse(lastConnection); } catch (ParseException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } String building = request.getParameter( "building" ); Client c = new Client (first,last,father,phone,email,username,password,date,gender,street,city,date1,building); try { Class.forName("org.postgresql.Driver"); String url="jdbc
ostgresql://localhost:5432/HouraniBank"; Connection connection = DriverManager.getConnection(url, "rayan", "rayan"); Statement st = connection.createStatement(); String query = "insert into client (first_name,last_name,father_name,phone_number,email,username, password, date_of_birth,gender, street,city,last_connexion,building) values ('"+c.getFirst()+"','"+c.getLast()+"','"+c.getFather()+"','"+c.getPhone()+"','"+c.getEmail()+"','"+c.getUsername()+"','"+c.getPassword()+"','"+c.getDateBirth()+"','"+c.getGender()+"','"+c.getStreet()+"','"+c.getCity()+"','"+c.getLastConnection()+"','"+c.getBuilding()+"');"; st.executeUpdate(query); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } ((HttpServletResponse) response).sendRedirect("addClient.html"); } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { service(request,response); System.out.println("Check request input in console"); System.out.println("first "+request.getParameter( "first_name" )); System.out.println("last "+request.getParameter( "last_name") ); System.out.println("father"+request.getParameter( "father_name") ); System.out.println("phone"+request.getParameter( "phone_number") ); System.out.println("email "+request.getParameter( "email") ); System.out.println("username "+request.getParameter( "username") ); System.out.println("password "+request.getParameter( "password" )); System.out.println("dateBirth "+request.getParameter( "date_of_birth") ); System.out.println("gender "+request.getParameter( "gender" ) ); System.out.println("street "+ request.getParameter( "street" )); System.out.println("city "+request.getParameter( "city" )); System.out.println("lastConnxion "+request.getParameter( "last_connexion" )); System.out.println("building "+ request.getParameter( "building" )); } }
And this is the java class:
package AdminClient;
import java.util.Date;
public class Client {
private int id; private String first, last, father, phone, email, username, password,gender, street, city, building; private Date dateBirth,lastConnection; public Client(String first, String last, String father, String phone, String email, String username, String password, Date dateBirth, String gender, String street, String city, Date lastConnection, String building) { super(); this.id = id; this.first = first; this.last = last; this.father = father; this.phone = phone; this.email = email; this.username = username; this.password = password; this.dateBirth = dateBirth; this.gender = gender; this.street = street; this.city = city; this.lastConnection = lastConnection; this.building = building; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getFirst() { return first; } public void setFirst(String first) { this.first = first; } public String getLast() { return last; } public void setLast(String last) { this.last = last; } public String getFather() { return father; } public void setFather(String father) { this.father = father; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Date getDateBirth() { return dateBirth; } public void setDateBirth(Date dateBirth) { this.dateBirth = dateBirth; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public String getStreet() { return street; } public void setStreet(String street) { this.street = street; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public Date getLastConnection() { return lastConnection; } public void setLastConnection(Date lastConnection) { this.lastConnection = lastConnection; } public String getBuilding() { return building; } public void setBuilding(String building) { this.building = building; } }
ERROR:
type Exception report
message
description The server encountered an internal error that prevented it from fulfilling this request.
exception java.lang.NullPointerException java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1439) java.text.DateFormat.parse(DateFormat.java:364) AdminClient.AddClientServlet.service(AddClientServlet.java:58) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
URGENT!!!
أكثر...
Add Client
-->
First name
Last name
User name
Father name
Password
Street
Building
Date of birth
Gender Male Female
Adresse Beirut Mont Liban South Bekaa North
Phone number
Last connexion
And this is the servlet:
package AdminClient;
import java.io.IOException; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Locale;
import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
/** * Servlet implementation class AddClientServlet */ @WebServlet("/AddClientServlet") public class AddClientServlet extends HttpServlet { private static final long serialVersionUID = 1L;
/** * @see HttpServlet#HttpServlet() */ public AddClientServlet() { super(); // TODO Auto-generated constructor stub } @Override public void service(ServletRequest request, ServletResponse response)throws ServletException, IOException { String first = request.getParameter( "first_name" ); String last = request.getParameter( "last_name" ); String father = request.getParameter( "father_name" ); String phone = request.getParameter( "phone_number" ); String email = request.getParameter( "email" ); String username = request.getParameter( "username" ); String password = request.getParameter( "password" ); String dateBirth = request.getParameter( "date_of_birth" ); DateFormat formatter,formatter1; java.util.Date date = null; java.util.Date date1 = null; formatter = new SimpleDateFormat("yyyy-mm-dd",Locale.ENGLISH); try { date =formatter.parse(dateBirth); } catch (ParseException e2) { // TODO Auto-generated catch block e2.printStackTrace(); } String gender = request.getParameter( "gender" ); String street = request.getParameter( "street" ); String city = request.getParameter( "city" ); String lastConnection = request.getParameter( "last_connexion" ); formatter1 = new SimpleDateFormat("yyyy-mm-dd",Locale.ENGLISH); try { date1 = formatter.parse(lastConnection); } catch (ParseException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } String building = request.getParameter( "building" ); Client c = new Client (first,last,father,phone,email,username,password,date,gender,street,city,date1,building); try { Class.forName("org.postgresql.Driver"); String url="jdbc
ostgresql://localhost:5432/HouraniBank"; Connection connection = DriverManager.getConnection(url, "rayan", "rayan"); Statement st = connection.createStatement(); String query = "insert into client (first_name,last_name,father_name,phone_number,email,username, password, date_of_birth,gender, street,city,last_connexion,building) values ('"+c.getFirst()+"','"+c.getLast()+"','"+c.getFather()+"','"+c.getPhone()+"','"+c.getEmail()+"','"+c.getUsername()+"','"+c.getPassword()+"','"+c.getDateBirth()+"','"+c.getGender()+"','"+c.getStreet()+"','"+c.getCity()+"','"+c.getLastConnection()+"','"+c.getBuilding()+"');"; st.executeUpdate(query); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } ((HttpServletResponse) response).sendRedirect("addClient.html"); } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { service(request,response); System.out.println("Check request input in console"); System.out.println("first "+request.getParameter( "first_name" )); System.out.println("last "+request.getParameter( "last_name") ); System.out.println("father"+request.getParameter( "father_name") ); System.out.println("phone"+request.getParameter( "phone_number") ); System.out.println("email "+request.getParameter( "email") ); System.out.println("username "+request.getParameter( "username") ); System.out.println("password "+request.getParameter( "password" )); System.out.println("dateBirth "+request.getParameter( "date_of_birth") ); System.out.println("gender "+request.getParameter( "gender" ) ); System.out.println("street "+ request.getParameter( "street" )); System.out.println("city "+request.getParameter( "city" )); System.out.println("lastConnxion "+request.getParameter( "last_connexion" )); System.out.println("building "+ request.getParameter( "building" )); } }And this is the java class:
package AdminClient;
import java.util.Date;
public class Client {
private int id; private String first, last, father, phone, email, username, password,gender, street, city, building; private Date dateBirth,lastConnection; public Client(String first, String last, String father, String phone, String email, String username, String password, Date dateBirth, String gender, String street, String city, Date lastConnection, String building) { super(); this.id = id; this.first = first; this.last = last; this.father = father; this.phone = phone; this.email = email; this.username = username; this.password = password; this.dateBirth = dateBirth; this.gender = gender; this.street = street; this.city = city; this.lastConnection = lastConnection; this.building = building; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getFirst() { return first; } public void setFirst(String first) { this.first = first; } public String getLast() { return last; } public void setLast(String last) { this.last = last; } public String getFather() { return father; } public void setFather(String father) { this.father = father; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Date getDateBirth() { return dateBirth; } public void setDateBirth(Date dateBirth) { this.dateBirth = dateBirth; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public String getStreet() { return street; } public void setStreet(String street) { this.street = street; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public Date getLastConnection() { return lastConnection; } public void setLastConnection(Date lastConnection) { this.lastConnection = lastConnection; } public String getBuilding() { return building; } public void setBuilding(String building) { this.building = building; } }
ERROR:
type Exception report
message
description The server encountered an internal error that prevented it from fulfilling this request.
exception java.lang.NullPointerException java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1439) java.text.DateFormat.parse(DateFormat.java:364) AdminClient.AddClientServlet.service(AddClientServlet.java:58) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
URGENT!!!
أكثر...