Click here to Skip to main content
15,887,331 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Sir i m using netbeans ide and database is mysql
I m creating registration form in jsp and servlet
my servlet name is register.java
I m using glassfish server


I m posting code :
register.java

package validate;

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import java.sql.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author ttkau
 */
public class Register extends HttpServlet {

     final String db_driver="com.mysql.jdbc.Driver";
    final  String db_url="jdbc:mysql://localhost:3306/register?zeroDateTimeBehavior=convertToNull";
    final String db_user="root";
    final  String db_pass="pitech2017";
    PreparedStatement pstmt;
    Connection connect;
    String name , email,mobile_no,password,retype_password;
    
    
    
    
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
       
    }

    
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        PrintWriter out = response.getWriter();
        response.setContentType("text/html");
        name = request.getParameter("txtName");
        email = request.getParameter("txtEmail");
        mobile_no = request.getParameter("txtMobile");
        password = request.getParameter("pwdPass");
        try {
            Class.forName(db_driver);
            connect = DriverManager.getConnection(db_url,db_user,db_pass);
            String sql = "insert into signup(name,email,mobileNo,password)values(?,?,?,?)";
            pstmt = connect.prepareStatement(sql);
            pstmt.setString(1,name);
            pstmt.setString(2, email);
            pstmt.setString(3,mobile_no);
            pstmt.setString(4,password);
            
            int i = pstmt.executeUpdate(sql);
            if(i==1)
            {
                out.println("Data has been inserted successfully ");
                response.sendRedirect("SignIn.jsp");
            }
            
            
            
        } 
        catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
         
        catch(SQLException e1)
        {
            e1.printStackTrace();
        }
    }

   
  
}


when i run the servlet it shows blank page bt when i run the jsp page afteer filling the registration form data is nt inserted

What I have tried:

I have tried the code into the jsp page by using apache tomcat it shows http error 400 requested resource is not availablee
Posted
Comments
Richard MacCutchan 28-Jul-17 5:33am    
Why are you trying to store passwords in clear text?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900