Monday, March 21, 2016

New User Signup: create folder when signup and a row in a DB:

//HTML Page for Signup form


<%-- 
    Document   : signup
    Created on : Feb 11, 2016, 11:33:09 AM
    Author     : Ak-47
--%>
<!DOCTYPE html>
<html>
    <head>
        <title>signup</title>
  <meta charset="utf-8">
    <script>
    function myFunction()  // function to check passsword and confirm password
    {
    var a,b;
    a=document.form1.pass.value;
    b=document.form1.passw.value;
    
    if(a!=b || a=="")
        {
         alert("Password doesnt match");  
         form1.action = 'http://www.google.com/';
         
        }
        else
            {
             form1.action='insertuser.jsp';   
            }
    }
</script>
    </head>
    <body>
       
            <form name="form1" onsubmit="myFunction()" action="insertuser.jsp" method="post">
  
    <label>First Name: </label>
           <input type="text" name="fname" placeholder="Enter First Name" required>
   
    <label>Last Name: </label>
         <input type="text" name="lname" placeholder="Enter Last Name" required>
   
    <label>Email:</label>
      <input type="email" name="email" placeholder="Enter email" required>
 
 <label>Mobile:</label>
      <input type="text" name="mobile" placeholder="Enter Cellular Number" required>
   
            <label>Password:</label>
      <input type="password" name="pass" placeholder="Enter password" required>
            
    <label>Confirm Password:</label>
      <input type="password" name="passw" placeholder="Enter password again" required>
   
         <label>Date of Birth:</label>
      <input type="date" name="dob">
            
   <label>Gender:</label>
        <select name="gender">
          <option value="Male">Male</option>
    <option value="Female">Female</option>
    <option value="Transgender">Transgender</option>
      </select>
      
                  <label>Address:</label>
        <textarea rows="5" name="address" required></textarea>
    
      <button type="submit" class="btn btn-default">Submit</button>
    </form>
    
    </body>
</html>

//JSp page (Insertuser.jsp)

<%-- 
    Document   : insertuser
    Created on : Feb 11, 2016, 1:53:30 PM
    Author     : Ak-47
--%>
<%@ page import="java.io.*,java.util.*, javax.servlet.*, java.sql.*, databasecon.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
        <%

//declaring all the variables

        String fname=request.getParameter("fname");
        String lname=request.getParameter("lname");
        String userid=request.getParameter("email");
        String pass=request.getParameter("pass");
        String mobile=request.getParameter("mobile");
        String dob=request.getParameter("dob");
        String gender=request.getParameter("gender");
        String address=request.getParameter("address");
            
        String filePath="C:/proj/zot/web/user"; 
// declaring the file path where we want to create user folder and upload data later.
        
       try
       { 
File root = new File(filePath);
        File newfolder = new File(root, "/"+userid); //creating the new folder
            newfolder.mkdir();
                    filePath=filePath+"/"+userid+"/";
                    File newfldr = new File(filePath, "gallery");
            newfldr.mkdir();
            File newfoldr = new File(filePath, "products");
            newfoldr.mkdir();   

                Connection con=null;
Statement st=null;
      String sql="insert into users values ('"+userid+"','"+pass+"','"+fname+"','"+lname+"','"+dob+"','"+gender+"','"+mobile+"','"+address+"')";         
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getconnection("jdbc:odbc:DB_Name");  //these drivers are only for ms-access.
  st=con.createStatement();
   int x=st.executeUpdate(sql);
   if(x!=0)
    {
out.println("created successfully : <h2>"+userid+" : "+mobile+"</h2><br>");
             out.println("for more details Contact us. <br>");
   }
                       else
                       {
 out.println( userid + " already exists");
                   
                       }
            st.close();
            con.close();
        
                                           
       }
       catch(SQLException e)
                             {
      out.println(userid +" Already exists "+e);
       }
    %>
    </body>
</html>

Contact Us At: softdevelopr007@gmail.com

No comments:

Post a Comment