123 Java Registration form with database Mysql, Oracle database | Adv java servlet tutorial

Publicado em: 19 Dezembro 2018
no canal de: tech fort
1,305
52

For login registration form java source code, student registration form in java with database connectivity Oracle, MYsql, servlet, sqlyog, html registration form with database connectivity Jsp with Mysql an example for Login and Registration Page JAVA - How To Design Login And Register Form In Java Netbeans servlet registration form example with database
#Example java web application using above three ways to create RequestDispatcher object:Approach 3:(Using ServletContext object with getNamedDispatcher() method)
Two ways:
1) Servlet + HTML/JSP + Oracle Database + Tomcat Server
2) Servlet + HTML/JSP + Mysql Database + Tomcat Server

Deployment Directory Structure:
-------------------------------
39PatientWA
-----------
|----------patientReg.html
|----------WEB-INF
|-----web.xml
|-----lib
|----ojdbc14.jar (Oracle)
|----mysql-connector-java-5.1.10-bin.jar
|----------classes
|-------RegistrationServlet.java
|-------SuccessServlet.java
|----------*.class

Step 1) Create table in database (Oracle Or Mysql)
--------------------------------------------------
Create table patient(pid varchar(10),pname varchar(20),email varchar(50),mobile varchar(14),bloodg varchar(10),gender varchar(7),dicease varchar(30),address varchar(100), wardno varchar(8));

+91-9876543210

Step 2) Create Deployment Directory Structure:
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps

Create the foleder in above path/location "39PatientWA"
Create "WEB-INF" foleder in "39PatientWA"
Create "lib" foleder in "39PatientWA"
Create "classes" foleder in "39PatientWA"

Step 3) registration.html and save to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA folder

Step 4) Create RegistrationServlet.java and save to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF\classes

Step 5) SuccessServlet.java and save to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF\classes

Step 6) Add ojdbc14.jar Oracle for Oracle Database to lib folder
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF\lib

Add the mysql-connector-java-5.1.10-bin.jar file for Mysql Databse to lib folder
C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF\lib

Step 7) Compile The Servlet Programs (Do confirm servlet-api.jar is present in classpth )

Go go command prompt javac *.java

Step 7.1) Create web.xml file and save to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF

Step 8) Deploy the Java web application (Context Root Folder "39PatientWA")

(Skip: already our Context Root Folder 39PatientWA is present in webapps folder of Tomcat)

Copy and paste 39PatientWA folder to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps


Step 9) Start the tomcat server:
Go to
C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin\Tomcat9.exe

Step 10) Test the 39PatientWA java web applicatoin
Open the browser
http://localhost:2020/39PatientWA
OR
http://127.0.0.1:2020/39PatientWA
OR
http://YourMachineName:2020/39PatientWA


Step 11)Check in Oracle DB table students

Select * from students;

Lets Try with HTTP Get Method based Request.

Lets Try With MySql Database (Above Applicaion).
=================================================

Create table patient(pid varchar(10),pname varchar(20),email varchar(50),mobile varchar(14),bloodg varchar(10),gender varchar(7),dicease varchar(30),address varchar(100), wardno varchar(8));

Table successfully created in mysql.

Step 12) Change Connection driver class and URL in RegistrationServlet.java

Step 13) Add the Mysql Connector jar to lib folder mysql-connector-java-5.1.10-bin.jar file to

C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\39PatientWA\WEB-INF\lib

Step 14) Compile the RegistrationServlet.java
go to command prompt javac RegistrationServlet.java

Step 15) Reload the 39PatientWA web application by moving to tomcat admin console

Step 16) Test the 39PatientWA java web applicatoin
Open the browser
http://localhost:2020/39PatientWA
OR
http://127.0.0.1:2020/39PatientWA
OR
http://YourMachineName:2020/39PatientWA

Thank you
Hospital Clinic Mini Project Patient information

#java #login #register #form #page #project #source_code #netbeans #mysql #sqlyog #source #code #step #students #beginners #login #registration #form #database


Nesta página do site você pode assistir ao vídeo on-line 123 Java Registration form with database Mysql, Oracle database | Adv java servlet tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário tech fort 19 Dezembro 2018, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,305 vezes e gostou 52 espectadores. Boa visualização!