In tutorials will teach banking registration form in jsp servlet using use bean class for the right way to do the java web development.
First step design the Registration form
Form Registration
<html> <head> <title>Online Banking with Earnest </title> </head> <body bgcolor=pink> <br> <br> <center> <u> <h1> NDB Bank New User Registration </h1> <h3> ( Servlet application ) </h3> </u> <form method=post action="Bank.jsp"> <table border=2 bordercolor=black width=40%> <tr> <td>First Name:</td> <td> <input type=text name="fname" size=25></td> </tr> <tr> <td>Last Name:</td> <td><input type=text name="lname" size=25></td> </tr> <tr> <td>Address:</td> <td><input type=text name="address" size=25></td> </tr> <tr> <td>Account Type:</td> <td><input type=text name="account" size=25></td> </tr> <tr> <td>Annual Income:</td> <td><input type=text name="income" size=25></td> </tr> <tr> <td>Phone Number:</td> <td><input type=text name="phone" size=25></td> </tr> <tr><td> <center><input type=SUBMIT value="Register"></center><td> </tr> </table> </form> </center> </body> </html>
Create the package account inside the package create the class BankAcc.java
BankAcc.java
package account;
import java.io.*;
import java.sql.*;
public class BankAcc {
private String fname="";
private String lname="";
private String address="";
private String account="";
private String income="";
private String phone="";
private String regno="";
Connection con=null;
PreparedStatement stat=null;
public void setFname(String fname) {this.fname=fname;}
public String getFname() {return fname;}
public void setLname(String lname) {this.lname=lname;}
public String getLname() {return lname;}
public void setAddress(String address) {this.address=address;}
public String getAddress() {return address;}
public BankAcc() throws ClassNotFoundException
{
Class.forName("com.mysql.jdbc.Driver");
}
public boolean save()
{
boolean sucess=false;
try
{
con = DriverManager.getConnection("jdbc:mysql://localhost/nbank","root","");
stat = con.prepareStatement("insert into registation(firstname,lastname,phone)values(?,?,?)");
stat.setString(1,getFname());
stat.setString(2,getLname());
stat.setString(3,getAddress());
int status=stat.executeUpdate();
if(!(status==0))
{
stat=con.prepareStatement("select max(id) from registation");
ResultSet rs1=stat.executeQuery();
rs1.next();
regno=rs1.getString(1);
sucess=true;
}
}
catch(Exception e1)
{
System.out.println(e1.toString());
}
finally
{
try
{
con.close();
}
catch(Exception e2){}
return sucess;
}
}
public String getRegno()
{
return regno;
}
}
Create the bank.jsp page
bank.jsp
At the above you have add the usebean
<jsp:useBean id=”bank1″ scope=”page” class=”account.BankAcc”/>
<jsp:setProperty name=”bank1″ property=”*”/>
<jsp:useBean id="bank1" scope="page" class="account.BankAcc"/>
<jsp:setProperty name="bank1" property="*"/>
<%!
boolean succ=false;
%>
<html>
<center>
<body bgcolor=black>
<form method=post action="Bank.jsp">
<tabel style="background:darkgreen;color:yellow;font-size:13pt;font-weight:bold;">
<tr>
<th colspan=2><h1>EARNEST BANK REGISTRATION </h1></th>
<tr>
<%
succ=bank1.save();
if(succ==true)
{%>
<tr>
<td colspan2>
<jsp:getProperty name="bank1" property="fname"/>
Registration Success </td> <tr>
<tr>
<td>Your Registration Number:</td>
<jsp:getProperty name="bank1" property="regno"/></td>
</tr>
<%
} else
{
%>
<tr>
<td colspan2>
<jsp:getProperty name="bank1" property="fname"/></td>
Sorry Registration Faild </td>
</tr>
<%
}
%>
i have attached the video link below. which will do this tutorials step by step