Example : All Integrated JSP & Oracle 10g Code using NetBeans 8.2 [All-in-One Code : Part 1].
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
String option1 = request.getParameter("option");
if(option1 != null)
{
String uname1 = request.getParameter("uname1");
String uname2 = request.getParameter("uname2");
String uname3 = request.getParameter("uname3");
String dob = request.getParameter("dob");
String sex = request.getParameter("sex");
String usid = request.getParameter("usid");
String pswd = request.getParameter("pswd");
String cpswd = request.getParameter("cpswd");
String mobile = request.getParameter("mobile");
String fth = request.getParameter("fth");
String mom = request.getParameter("mom");
String edc = request.getParameter("edc");
String bg = request.getParameter("bg");
String nat = request.getParameter("nat");
String occ = request.getParameter("occ");
String hob = request.getParameter("hob");
String pad = request.getParameter("pad");
String cad = request.getParameter("cad");
Connection con = null;
PreparedStatement ps = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl",
"system",
"raj"
);
if(option1.equals("Save"))
{
String sql = "INSERT INTO USER_REGISTRATION "
+ "(EMAIL_ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME, DOB, SEX, PASSWORD, CONFIRM_PASSWORD, "
+ "MOBILE, FATHER_NAME, MOTHER_NAME, EDUCATION, BLOOD_GROUP, NATIONALITY, OCCUPATION, "
+ "HOBBIES, PERMANENT_ADDRESS, CORRESPONDENCE_ADDRESS) "
+ "VALUES (?, ?, ?, ?, TO_DATE(?,'YYYY-MM-DD'), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
ps = con.prepareStatement(sql);
ps.setString(1, usid);
ps.setString(2, uname1);
ps.setString(3, uname2);
ps.setString(4, uname3);
ps.setString(5, dob);
ps.setString(6, sex);
ps.setString(7, pswd);
ps.setString(8, cpswd);
ps.setString(9, mobile);
ps.setString(10, fth);
ps.setString(11, mom);
ps.setString(12, edc);
ps.setString(13, bg);
ps.setString(14, nat);
ps.setString(15, occ);
ps.setString(16, hob);
ps.setString(17, pad);
ps.setString(18, cad);
int i = ps.executeUpdate();
if(i > 0)
{
out.println("<script>alert('Record saved successfully'); window.location='owyfRegistration.jsp';</script>");
}
}
else if(option1.equals("Update"))
{
String sql = "UPDATE USER_REGISTRATION SET "
+ "FIRST_NAME=?, MIDDLE_NAME=?, LAST_NAME=?, DOB=TO_DATE(?,'YYYY-MM-DD'), SEX=?, "
+ "PASSWORD=?, CONFIRM_PASSWORD=?, MOBILE=?, FATHER_NAME=?, MOTHER_NAME=?, EDUCATION=?, "
+ "BLOOD_GROUP=?, NATIONALITY=?, OCCUPATION=?, HOBBIES=?, PERMANENT_ADDRESS=?, "
+ "CORRESPONDENCE_ADDRESS=? WHERE EMAIL_ID=?";
ps = con.prepareStatement(sql);
ps.setString(1, uname1);
ps.setString(2, uname2);
ps.setString(3, uname3);
ps.setString(4, dob);
ps.setString(5, sex);
ps.setString(6, pswd);
ps.setString(7, cpswd);
ps.setString(8, mobile);
ps.setString(9, fth);
ps.setString(10, mom);
ps.setString(11, edc);
ps.setString(12, bg);
ps.setString(13, nat);
ps.setString(14, occ);
ps.setString(15, hob);
ps.setString(16, pad);
ps.setString(17, cad);
ps.setString(18, usid);
int i = ps.executeUpdate();
if(i > 0)
{
out.println("<script>alert('Record updated successfully'); window.location='owyfRegistration.jsp';</script>");
}
else
{
out.println("<script>alert('Email ID not found'); window.location='owyfRegistration.jsp';</script>");
}
}
else if(option1.equals("Delete"))
{
String sql = "DELETE FROM USER_REGISTRATION WHERE EMAIL_ID=?";
ps = con.prepareStatement(sql);
ps.setString(1, usid);
int i = ps.executeUpdate();
if(i > 0)
{
out.println("<script>alert('Record deleted successfully'); window.location='owyfRegistration.jsp';</script>");
}
else
{
out.println("<script>alert('Email ID not found'); window.location='owyfRegistration.jsp';</script>");
}
}
}
catch(Exception e)
{
out.println("<h3>Error: " + e.getMessage() + "</h3>");
}
finally
{
try
{
if(ps != null) ps.close();
if(con != null) con.close();
}
catch(Exception e)
{
out.println(e);
}
}
}
%>
<!DOCTYPE html>
<html>
<head>
<title>Registration Page</title>
</head>
<body style="background-color:#CCCCCC">
<form name="reg" action="owyfRegistration.jsp" method="post">
<center>
<div style="left:200px;top:0px;width:900px;height:900px;background-color:aliceblue;border-radius:15px">
<div style="width:900px;height:150px;background-color:antiquewhite;">
<span><img src="image/ICON/new.png" width="100" height="100"></span>
<font size="+4">New User Registration</font>
</div>
<div style="width:900px;height:500px;background-color:aliceblue;padding-top:2em">
<table>
<tr>
<td>User Name</td>
<td>:</td>
<td>
<input type="text" name="uname1" size="15" placeholder="first_name">
<input type="text" name="uname2" size="10" placeholder="middle_name">
<input type="text" name="uname3" size="10" placeholder="last_name">
</td>
</tr>
<tr>
<td>Date of Birth</td>
<td>:</td>
<td><input type="date" name="dob"></td>
</tr>
<tr>
<td>Sex</td>
<td>:</td>
<td>
<input type="radio" name="sex" value="Male">Male
<input type="radio" name="sex" value="Female">Female
<input type="radio" name="sex" value="Other">Other
</td>
</tr>
<tr>
<td>Email ID</td>
<td>:</td>
<td><input type="text" name="usid" size="40" placeholder="@gmail.com"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="pswd" size="40"></td>
</tr>
<tr>
<td>Confirm Password</td>
<td>:</td>
<td><input type="password" name="cpswd" size="40"></td>
</tr>
<tr>
<td>Mobile No.</td>
<td>:</td>
<td><input type="text" name="mobile" size="40"></td>
</tr>
<tr>
<td>Father's Name</td>
<td>:</td>
<td><input type="text" name="fth" size="30"></td>
</tr>
<tr>
<td>Mother's Name</td>
<td>:</td>
<td><input type="text" name="mom" size="30"></td>
</tr>
<tr>
<td>Educational Qualification</td>
<td>:</td>
<td>
<input type="radio" name="edc" value="matric">Matric
<input type="radio" name="edc" value="intermediate">Intermediate<br>
<input type="radio" name="edc" value="graduation">Graduation
<input type="radio" name="edc" value="pg">PG
<input type="radio" name="edc" value="Phd">Phd
<input type="radio" name="edc" value="Other">Other
</td>
</tr>
<tr>
<td>Blood Group</td>
<td>:</td>
<td>
<select name="bg">
<option>Choose One</option>
<option value="A+">A+</option>
<option value="A-">A-</option>
<option value="B+">B+</option>
<option value="B-">B-</option>
<option value="AB+">AB+</option>
<option value="AB-">AB-</option>
<option value="O+">O+</option>
<option value="O-">O-</option>
</select>
</td>
</tr>
<tr>
<td>Nationality</td>
<td>:</td>
<td>
<select name="nat">
<option value="Indian">Indian</option>
<option value="Others">Others</option>
</select>
</td>
</tr>
<tr>
<td>Occupation</td>
<td>:</td>
<td><input type="text" name="occ" size="30"></td>
</tr>
<tr>
<td>Hobbies</td>
<td>:</td>
<td><input type="text" name="hob" size="30"></td>
</tr>
<tr>
<td>Permanent Address</td>
<td>:</td>
<td><textarea rows="4" cols="30" name="pad" style="resize:none;width:200px"></textarea></td>
</tr>
<tr>
<td>Correspondence Address</td>
<td>:</td>
<td><textarea rows="4" cols="30" name="cad" style="resize:none;width:200px"></textarea></td>
</tr>
<tr>
<td colspan="3" align="center">
<input type="submit" name="option" value="Save">
<input type="submit" name="option" value="Update">
<input type="submit" name="option" value="Delete">
<input type="reset" value="Reset">
</td>
</tr>
</table>
</div>
</div>
</center>
</form>
</body>
</html>Example : All Integrated JSP & Oracle 10g Code using NetBeans 8.2 [All-in-One Code : Part 2].
<%--
Document : All Integrated Codes in JSP
Created on : 14 May, 2019, 2:15:53 PM
Author : Codershelpline
--%>
<%@include file="connect.jsp" %> // Linking of Connectivity Code file 'OR
// JSP & Oracle 10g Connectivity Code
<%@page contentType="text/html; charset=utf-8" language="java" import="java.sql.*"import=
"java.util.*" errorPage=""%>
<%
Connection conn=null;
PreparedStatement pst=null;
ResultSet rs;
Statement st=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","putusernamehere",
"putpasswordhere");
out.println("Database connected");
// Code for Transfer Html data into JSP variables
String UrTxtUname3=request.getParameter("UrTxtUname1");
String UrPassPsd3=request.getParameter("UrPassPsd1");
String UrDateDob3=request.getParameter("UrDateDob1");
String UrNumMob3=request.getParameter("UrNumMob1");
String UrTxtEmail3=request.getParameter("UrTxtEmail1");
String UrRdGender3=request.getParameter("UrRdbGender1");
String UrChkMatric3=request.getParameter("UrChkMatric1");
String UrChkInter3=request.getParameter("UrChkInter1");
String UrChkGrad3=request.getParameter("UrChkGrad1");
String UrTxrAddr3=request.getParameter("UrTxrAddr1");
String UrCmbState3=request.getParameter("UrCmbState1");
String UrCmbEmailSearch3=request.getParameter("UrCmbEmailSearch1");
String sub2=request.getParameter("sub");
// JSP Variable declaration Code
String UrTxtUname4="";
String UrPassPsd4="";
String UrDateDob4="";
String UrNumMob4="";
String UrTxtEmail4="";
String UrRdbGender4="";
String UrChkMatric4="";
String UrChkInter4="";
String UrChkGrad4="";
String UrTxrAddr4="";
String UrCmbState4="";
String Gender1="";
String Gender2="";
String Check1="";
String Check2="";
String Check3="";
try
{
if(sub2!=null)
{
// Code to Save Data from JSP to Oracle 10g
if(sub2.equals("Submit"))
{
st=conn.createStatement();
st.executeQuery("insert into TABLENAME(UrTxtUname5,UrPassPsd5,UrDateDob5,UrRdGender5,
UrNumMob5,UrTxtEmail5,UrChkMatric5,UrChkInter5,UrChkGrad5,UrTxrAdd5,UrCmbState5)
values('"+UrTxtUname3+"','"+UrPassPsd3+"','"+UrDateDob3+"','"+UrRdGender3+"',
'"+UrNumMob3+"','"+UrTxtEmail3+"','"+UrChkMatric3+"','"+UrChkInter3+"',
'"+UrChkGrad3+"','"+UrTxrAddr3+"','"+UrCmbState3+"')");
out.println("Data Saved Successfully");
}
// Code to Edit/Modify/Update Database Data via JSP
if(sub2.equals("Update"))
{
pst=conn.prepareStatement("update TABLENAME set UrTxtUname5='"+UrTxtUname3+"',
UrPassPsd5='"+UrPassPsd3+"',UrDateDob5='"+UrDateDob3+"',UrRdGender5='"+UrRdGender3+"'
,UrNumMob5='"+UrNumMob3+"',UrChkMatric5='"+UrChkMatric3+"',UrChkInter5=
'"+UrChkInter3+"',UrChkGrad5='"+UrChkGrad3+"',UrTxrAdd5='"+UrTxrAddr3+"',
UrCmbState5='"+UrCmbState3+"' where UrTxtEmail5='"+UrTxtEmail3+"'");
pst.executeUpdate();
out.println("Data Updated Successfully");
}
// Code to Delete Data from Oracle 10g Database
if(sub2.equals("Delete"))
{
pst=conn.prepareStatement("delete from TABLENAME where UrTxtEmail5=
'"+UrTxtEmail3+"' ");
pst.executeUpdate();
out.println("Record Deleted successfully");
}
// Code to Search Unique Record from Oracle 10g Database and Fill into HTML box
if (sub2.equals("Search"))
{
pst=conn.prepareStatement("select * from TABLENAME where
UrTxtEmail5='"+UrCmbEmailSearch3+"'");
rs=pst.executeQuery();
while(rs.next())
{
UrTxtUname4=rs.getString("UrTxtUname5");
UrPassPsd4=rs.getString("UrPassPsd5");
UrDateDob4=rs.getString("UrDateDob5");
UrNumMob4=rs.getString("UrNumMob5");
UrTxtEmail4=rs.getString("UrTxtEmail5");
UrRdbGender4=rs.getString("UrRdbGender5").trim();
if(UrRdbGender4.equals("Male"))
{
Gender1="checked";
}
if(UrRdbGender4.equals("Female"))
{
Gender2="checked";
}
UrChkMatric4=rs.getString("UrChkMatric5").trim();
if(UrChkMatric4.equals("Matric"))
{
Check1="checked";
}
UrChkInter4=rs.getString("UrChkInter5").trim();
if(UrChkInter4.equals("Intermediate"))
{
Check2="checked";
}
UrChkGrad4=rs.getString("UrChkInter5").trim();
if(UrChkGrad4.equals("Graduation"))
{
Check3="checked";
}
UrTxrAddr4=rs.getString("UrTxrAdd5");
UrCmbState4=rs.getString("UrCmbState5");
}
}
}
}
catch(Exception e)
{
out.println(e);
}
%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>All Integrated Code</title>
<script>
// Code for Auto Combo Selection on Matching Oracle 10g Database Data
function comboautoselect()
{
var x="<%=UrCmbState4%>" // Code to Transfer JSP Data into Java Script
document.getElementById("UrCmbState2").value=x; //Code to Assign Java Script Value
into HTML Box
}
</script>
</head>
<body onload="comboautoselect()"> // Calling of Java Script Function on Page Load
<form><center>
<fieldset style="width: 60%; background-color: aliceblue; border-radius: 8px; border-
width: 4px; border-color: cadetblue">
<table>
<h1>User Registration Page</h1>
<hr style="width: 90%">
<tr>
<td>User Name</td>
<td>:</td>
<td>
<input type="text" name="UrTxtUname1" id="UrTxtUname2" placeholder="Enter
User ID" value="<%=UrTxtUname4%>">
</td>
<td></td>
<td>
<select name="UrCmbEmailSearch1">
// Code to Hang Oracle 10g Database Data into Combo Box
<option>Select One</option>
<%
pst=conn.prepareStatement("select UrTxtEmail5 from TABLENAME order
by UrTxtEmail5");
rs=pst.executeQuery();
while(rs.next())
{
String email6=rs.getString("UrTxtEmail5");
%>
<option value="<%=email6%>"><%=email6%></option>
<%
}
%>
</select>
<input type="submit" name="sub" id="subSearch2" value="Search">
</td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td>
<input type="password" name="UrPassPsd1" id="UrPassPsd2"
placeholder="Enter Password" value="<%=UrPassPsd4%>">
</td>
</tr>
<tr>
<td>Date of Birth</td>
<td>:</td>
<td>
<input type="date" name="UrDateDob1" id="UrDateDob2" value="
<%=UrDateDob4%>">
</td>
</tr>
<tr>
<td>Gender</td>
<td>: </td>
<td>
<input type="radio" name="UrRdbGender1" id="UrRdbGenderM2" value="Male"
<%=Gender1%>>Male
<input type="radio" name="UrRdbGender1" id="UrRdbGenderF2" value="Female"
<%=Gender2%> >Female
</td>
</tr>
<tr>
<td>Mobile No.</td>
<td>:</td>
<td>
<input type="number" name="UrNumMob1" id="UrNumMob2" placeholder="Enter
10 digit No." value="<%=UrNumMob4%>">
</td>
</tr>
<tr>
<td>E-mail</td>
<td>:</td>
<td>
<input type="Email" name="UrTxtEmail1" id="UrTxtEmail2"
placeholder="[email protected]" value="<%=UrTxtEmail4%>">
</td>
</tr>
<tr>
<td>Qualification Details</td>
<td>:</td>
<td>
<input type="checkbox" name="UrChkMatric1" id="UrChkMatric2"
value="Matric" <%=Check1%> >Matric
<input type="checkbox" name="UrChkInter1" id="UrChkInter2"
value="Intermediate" <%=Check2%>>Intermediate
<input type="checkbox" name="UrChkGrad1" id="UrChkGrad2"
value="Graduation" <%=Check3%>>Graduation
</td>
</tr>
<tr>
<td>Address</td>
<td>:</td>
<td>
<textarea rows=10 cols=15 name="UrTxrAddr1" id="UrTxrAdd2">
<%=UrTxrAddr4%></textarea>
</td>
</tr>
<tr>
<td>State</td>
<td>:</td>
<td>
<select name="UrCmbState1" id="UrCmbState2">
<option value="Select One">Select One</option>
<option value="Bihar">Bihar</option>
<option value="Uttar Pradesh">Uttar Pradesh</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td>
<input type="submit" name="sub" id="subSubmit2" value="Submit">
<input type="reset" name="sub" id="subReset2" value="Reset">
<input type="submit" name="sub" id="subUpdate2" value="Update">
<input type="submit" name="sub" id="subDelete2" value="Delete">
</td>
</tr>
</table>
</fieldset>
</center>
</form>
</body>
</html> 
0 Comments