Monday, October 17, 2016

Home » » Creating a mailing Module in Project using JSP and SERVLET by santosh sir

Creating a mailing Module in Project using JSP and SERVLET by santosh sir

By 3 comments
    Mailing Module in  Project  using  JSP and SERVLET

 create table in oracle 


CREATE TABLE  "SUBSCRIBE" 
   ( "EMAILID" VARCHAR2(40)
   )
/



1. ConnectionProvider Class to give Connection to our application







1. Create index.jsp

























<!DOCTYPE html>

<html lang="en">

<head>

  <title>Bootstrap Theme Company</title>

  <meta charset="utf-8">

  <meta name="viewport" content="width=device-width, initial-scale=1">

  <link rel="stylesheet"href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>

  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>





  <style>
.jumbotron {
    background-color: #f4511e; /* Orange */
    color: #ffffff;}





 .navbar {
    margin-bottom: 0;
    
 background-color: #f4511e;
    z-index: 9999;
    
 border: 0;
    font-size: 12px !important;
    
 line-height: 1.42857143 !important;
    letter-spacing: 
 4px;
    border-radius: 0;}

.navbar li a, .navbar 
 .navbar-brand {
    
 color: #fff !important;}

.navbar-nav li a:hover, .navbar-nav 
 li.active a {
    color: #f4511e !important;
    
 background-color: #fff !important;}

.navbar-default .navbar-toggle 
 {
    border-color: transparent;
    
 color: #fff !important;}











</style>



</head>



<body>



<!-- navigation bar code  -->



<nav class="navbar navbar-default 
 navbar-fixed-top">

  <div class="container">

   
 <div class="navbar-header">

      <button type="button" class="navbar-toggle" 
 data-toggle="collapse" data-target="#myNavbar">

        <span 
 class="icon-bar"></span>

        <span class="icon-bar"></span>

        <span 
 class="icon-bar"></span> 

      </button>

      <a class="navbar-brand" href="#">Logo</a>

   
 </div>

    <div class="collapse navbar-collapse" id="myNavbar">

      <ul 
 class="nav navbar-nav navbar-right">

        
 <li><a href="#about">ABOUT</a></li>

        
 <li><a href="#services">SERVICES</a></li>

        
 <li><a href="#portfolio">PORTFOLIO</a></li>

        
 <li><a href="#pricing">PRICING</a></li>

        
 <li><a href="#contact">CONTACT</a></li>

        <li><a href="#contact">LOGIN</a></li>

      </ul>

   
 </div>

  </div>

</nav>



<div class="jumbotron text-center">



  <h1>Company</h1> 



  <p>We specialize in blablabla</p> 



  <form class="form-inline"  action="storemailid">
    <input type="email" class="form-control" size="50" placeholder="Email Address">
    <button type="button" class="btn btn-danger">Subscribe</button>
  </form>





<!-- this is the logic to show message to end user that he has subscribed..!! -->

 <%if((String)request.getAttribute("subMsg")!=null){%>

  <div><span><%=(String)request.getAttribute("subMsg") %></span></div> 



   <%} %>  







</div>







</body>



</html>





2. storemailid.java (this is a servlet )

































Share:  Facebook Twitter Google+
















































3 comments:








  1. UnknownOctober 21, 2016 at 4:41 AM
    java.sql.SQLException: Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    The Connection descriptor used by the client was:
    localhost:1521:project

     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
     at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
     at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at in.project.connect.ConnectionProvider.getConnection(ConnectionProvider.java:21)
     at in.project.connect.ConnectionProvider.main(ConnectionProvider.java:31)
    null
    ReplyDelete
  2. UnknownOctober 21, 2016 at 4:47 AM
     Mamta just change this localhost:1521:project to localhost:1521:xe
    ReplyDelete











Thank you , i will be send you a solution for each query yor post over here.