Skip to content

Latest commit

 

History

History
238 lines (180 loc) · 5.12 KB

2019-01-26-Project-part1-signuppage.md

File metadata and controls

238 lines (180 loc) · 5.12 KB
Raw
layout title author categories image tags
post
Netbeans Project Signup Page code with Jsp
Jai
tutorial
assets/img/Discount.jpg
summer

NETBEANS OJDBC CONNECTION | ORACLE |

Video []

Source code []

HTML FILE


<!DOCTYPE html>
<html>
<style>
body {font-family: Arial, Helvetica, sans-serif;}
* {box-sizing: border-box;}

/* Full-width input fields */
input[type=text], input[type=password] {
  width: 100%;
  padding: 15px;
  margin: 5px 0 22px 0;
  display: inline-block;
  border: none;
  background: #f1f1f1;
}

/* Add a background color when the inputs get focus */
input[type=text]:focus, input[type=password]:focus {
  background-color: #ddd;
  outline: none;
}

/* Set a style for all buttons */
button {
  background-color: #4CAF50;
  color: white;
  padding: 14px 20px;
  margin: 8px 0;
  border: none;
  cursor: pointer;
  width: 100%;
  opacity: 0.9;
}


.h2{
   text-align: center;
} 

button:hover {
  opacity:1;
}

/* Extra styles for the cancel button */
.cancelbtn {
  padding: 14px 20px;
  background-color: #f44336;
}

/* Float cancel and signup buttons and add an equal width */
.cancelbtn, .signupbtn {
  float: left;
  width: 50%;
}

/* Add padding to container elements */
.container {
  padding: 16px;
}

/* The Modal (background) */
.modal {
  display: none; /* Hidden by default */
  position: fixed; /* Stay in place */
  z-index: 1; /* Sit on top */
  left: 0;
  top: 0;
  width: 100%; /* Full width */
  height: 100%; /* Full height */
  overflow: auto; /* Enable scroll if needed */
  background-color: #474e5d;
  padding-top: 50px;
}

/* Modal Content/Box */
.modal-content {
  background-color: #fefefe;
  margin: 5% auto 15% auto; /* 5% from the top, 15% from the bottom and centered */
  border: 1px solid #888;
  width: 80%; /* Could be more or less, depending on screen size */
}

/* Style the horizontal ruler */
hr {
  border: 1px solid #f1f1f1;
  margin-bottom: 25px;
}
 
/* The Close Button (x) */
.close {
  position: absolute;
  right: 35px;
  top: 15px;
  font-size: 40px;
  font-weight: bold;
  color: #f1f1f1;
}

.close:hover,
.close:focus {
  color: #f44336;
  cursor: pointer;
}

/* Clear floats */
.clearfix::after {
  content: "";
  clear: both;
  display: table;
}

/* Change styles for cancel button and signup button on extra small screens */
@media screen and (max-width: 300px) {
  .cancelbtn, .signupbtn {
     width: 100%;
  }
}
</style>
<body>

<h2>Signup Form</h2>

<div>
  
  <form class="modal-content" action="signup.jsp">
    <div class="container">
      <h1>Sign Up</h1>
      <p>Please fill in this form to create an account.</p>
      <hr>
      <label for="fname"><b>First Name</b></label>
      <input type="text" placeholder="First Name" name="fname" required>

      <label for="lname"><b>Last Name</b></label>
      <input type="text" placeholder="Last Name" name="lname" required>


      <label for="pswd"><b>Enter password</b></label>
      <input type="Password" placeholder="Enter password" name="pswd" required>
      
       <label for="addr"><b>Enter address</b></label>
      <input type="text" placeholder="Enter Address" name="addr" required>
      

      <label for="email"><b>Enter Email</b></label>
      <input type="text" placeholder="Enter Email" name="email" required>


      <label for="mobno"><b>mobile no</b></label>
      <input type="text" placeholder="mobile no" name="mobno" required>

    
      
      <label>
        <input type="checkbox" checked="checked" name="remember" style="margin-bottom:15px"> Remember me
      </label>
      <div class="clearfix">
        <button type="button" onclick="document.getElementById('id01').style.display='none'" class="cancelbtn">Cancel</button>
        <button type="submit" class="signupbtn">Sign Up</button>
      </div>

      <p>By creating an account you agree to our <a href="#" style="color:dodgerblue">Terms & Privacy</a>.</p>

      
    </div>
  </form>
</div>



</body>
</html>

JSP FILE

NOTE : CHANGE CRYPTO PC TO YOUR BELOVED HOSTNAME (MINE WAS CRYPTO-PC ) CHANGE TO YOURS THIS LINE ["jdbc:oracle:thin:@HOSTNAME:1521:XE","USERNAME","PASSWORD" ]

<%@page language="java" import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
try
{
ResultSet rs =null;
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=    DriverManager.getConnection("jdbc:oracle:thin:@Crypto-pc:1521:XE","panda","piggy");
Statement stmt=con.createStatement();
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String pswd=request.getParameter("pswd");
String addr=request.getParameter("addr");
String email=request.getParameter("email");
String mobno=request.getParameter("mobno");
stmt.executeUpdate("insert into register values('"+fname+"','"+lname+"','"+pswd+"','"+addr+"','"+email+"','"+mobno+"')");
response.sendRedirect("login.html");
con.close();
stmt.close();
}
catch(ClassNotFoundException e)
{
out.println(e.getMessage());
} %>

It's best viewed on desktop rather than mobile, and can be accessed [here]

<iframe width="560" height="315" src="https://www.youtube.com/embed/lCAqQizuFZg" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>