Example : All Integrated Complete JSP & Oracle 10g Code using NetBeans 8.2 [All-in-One Code : Part 0].
/* NB : Add 'ojdbc6' or above version of JAR file first in 'Project -Libraries' folder of Netbeans IDE 8.2 */
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
String msg = "";
String urslno3 = "";
String ursname3 = "";
String uraddr3 = "";
String urgen3 = "";
String uruname3 = "";
String urpasswd3 = "";
String urcpasswd3 = "";
String urdob3 = "";
String urmobno3 = "";
String uremail3 = "";
String ursecques3 = "";
String ursecans3 = "";
String urcricket3 = "";
String urdance3 = "";
String urmusic3 = "";
String urrem3 = "";
//-------------- Connectivity Codes ---------------//
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl",
"System",
"raj"
);
//-------------- Save or Add New Records Code ---------------//
if(request.getParameter("BtnSave") != null) {
urslno3 = request.getParameter("urslno1");
ursname3 = request.getParameter("ursname1");
uraddr3 = request.getParameter("uraddr1");
urgen3 = request.getParameter("urgen1");
uruname3 = request.getParameter("uruname1");
urpasswd3 = request.getParameter("urpasswd1");
urcpasswd3 = request.getParameter("urcpasswd1");
urdob3 = request.getParameter("urdob1");
urmobno3 = request.getParameter("urmobno1");
uremail3 = request.getParameter("uremail1");
ursecques3 = request.getParameter("ursecques1");
ursecans3 = request.getParameter("ursecans1");
urcricket3 = request.getParameter("urcricket1") == null ? "" : request.getParameter("urcricket1");
urdance3 = request.getParameter("urdance1") == null ? "" : request.getParameter("urdance1");
urmusic3 = request.getParameter("urmusic1") == null ? "" : request.getParameter("urmusic1");
urrem3 = request.getParameter("urrem1");
if(!urpasswd3.equals(urcpasswd3)) {
msg = "Password and Confirm Password do not match.";
} else {
String sql = "INSERT INTO UREG "
+ "(SLNO5,SNAME5,ADDR5,GEN5,UNAME5,PASSWORD5,CPASSWORD5,DOB5,"
+ "MOBNO5,EMAIL5,SECQUES5,SECANS5,CRICKET5,DANCE5,MUSIC5,REM5) "
+ "VALUES (?,?,?,?,?,?,?,TO_DATE(?,'YYYY-MM-DD'),?,?,?,?,?,?,?,?)";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(urslno3));
pst.setString(2, ursname3);
pst.setString(3, uraddr3);
pst.setString(4, urgen3);
pst.setString(5, uruname3);
pst.setString(6, urpasswd3);
pst.setString(7, urcpasswd3);
pst.setString(8, urdob3);
pst.setString(9, urmobno3);
pst.setString(10, uremail3);
pst.setString(11, ursecques3);
pst.setString(12, ursecans3);
pst.setString(13, urcricket3);
pst.setString(14, urdance3);
pst.setString(15, urmusic3);
pst.setString(16, urrem3);
int i = pst.executeUpdate();
if(i > 0)
{
msg = "Record Saved Successfully.";
urslno3 = ursname3 = uraddr3 = urgen3 = uruname3 = urpasswd3 =
urcpasswd3 = "";
urdob3 = urmobno3 = uremail3 = ursecques3 = ursecans3 = "";
urcricket3 = urdance3 = urmusic3 = urrem3 = "";
}
}
}
//-------------- Search or Find Existing Records Code ---------------//
if(request.getParameter("BtnSearch") != null) {
urslno3 = request.getParameter("urslno1");
String sql = "SELECT * FROM UREG WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(urslno3));
rs = pst.executeQuery();
if(rs.next()) {
urslno3 = rs.getString("SLNO5");
ursname3 = rs.getString("SNAME5");
uraddr3 = rs.getString("ADDR5");
urgen3 = rs.getString("GEN5");
uruname3 = rs.getString("UNAME5");
urpasswd3 = rs.getString("PASSWORD5");
urcpasswd3 = rs.getString("CPASSWORD5");
urdob3 = rs.getString("DOB5").substring(0,10);
urmobno3 = rs.getString("MOBNO5");
uremail3 = rs.getString("EMAIL5");
ursecques3 = rs.getString("SECQUES5");
ursecans3 = rs.getString("SECANS5");
urcricket3 = rs.getString("CRICKET5");
urdance3 = rs.getString("DANCE5");
urmusic3 = rs.getString("MUSIC5");
urrem3 = rs.getString("REM5");
msg = "Record Found.";
} else {
msg = "Record Not Found.";
}
}
//-------- Update or Edit or Modify or Change Existing Records Code --------//
if(request.getParameter("BtnUpdate") != null) {
urslno3 = request.getParameter("urslno1");
ursname3 = request.getParameter("ursname1");
uraddr3 = request.getParameter("uraddr1");
urgen3 = request.getParameter("urgen1");
uruname3 = request.getParameter("uruname1");
urpasswd3 = request.getParameter("urpasswd1");
urcpasswd3 = request.getParameter("urcpasswd1");
urdob3 = request.getParameter("urdob1");
urmobno3 = request.getParameter("urmobno1");
uremail3 = request.getParameter("uremail1");
ursecques3 = request.getParameter("ursecques1");
ursecans3 = request.getParameter("ursecans1");
urcricket3 = request.getParameter("urcricket1") == null ? "" : request.getParameter("urcricket1");
urdance3 = request.getParameter("urdance1") == null ? "" : request.getParameter("urdance1");
urmusic3 = request.getParameter("urmusic1") == null ? "" : request.getParameter("urmusic1");
urrem3 = request.getParameter("urrem1");
String sql = "UPDATE UREG SET "
+ "SNAME5=?, ADDR5=?, GEN5=?, UNAME5=?, PASSWORD5=?, CPASSWORD5=?, "
+ "DOB5=TO_DATE(?,'YYYY-MM-DD'), MOBNO5=?, EMAIL5=?, SECQUES5=?, "
+ "SECANS5=?, CRICKET5=?, DANCE5=?, MUSIC5=?, REM5=? "
+ "WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setString(1, ursname3);
pst.setString(2, uraddr3);
pst.setString(3, urgen3);
pst.setString(4, uruname3);
pst.setString(5, urpasswd3);
pst.setString(6, urcpasswd3);
pst.setString(7, urdob3);
pst.setString(8, urmobno3);
pst.setString(9, uremail3);
pst.setString(10, ursecques3);
pst.setString(11, ursecans3);
pst.setString(12, urcricket3);
pst.setString(13, urdance3);
pst.setString(14, urmusic3);
pst.setString(15, urrem3);
pst.setInt(16, Integer.parseInt(urslno3));
int i = pst.executeUpdate();
if(i > 0) {
msg = "Record Updated Successfully.";
urslno3 = ursname3 = uraddr3 = urgen3 = uruname3 = urpasswd3 = urcpasswd3 = "";
urdob3 = urmobno3 = uremail3 = ursecques3 = ursecans3 = "";
urcricket3 = urdance3 = urmusic3 = urrem3 = "";
} else {
msg = "Record Not Found.";
}
}
//-------------- Delete or Remove Existing Records Code ---------------//
if(request.getParameter("BtnDelete") != null) {
urslno3 = request.getParameter("urslno1");
String sql = "DELETE FROM UREG WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(urslno3));
int i = pst.executeUpdate();
if(i > 0) {
msg = "Record Deleted Successfully.";
urslno3 = "";
} else {
msg = "Record Not Found.";
}
}
} catch(Exception e) {
msg = "Error: " + e;
}
%>
//-------------- HTML & CSS Design Code ---------------//
<!DOCTYPE html>
<html>
<head>
<title>User Registration Form</title>
//-------------- CSS Code ---------------//
<style>
body{
font-family: Arial;
background:#eef3ff;
}
.container{
width:650px;
margin:40px auto;
background:white;
padding:25px;
border-radius:12px;
box-shadow:0 0 10px gray;
}
h2{
text-align:center;
color:#003366;
}
.msg{
text-align:center;
color:green;
font-weight:bold;
margin-bottom:12px;
}
table{
width:100%;
}
td{
padding:8px;
}
input, select, textarea{
width:95%;
padding:8px;
border:1px solid #aaa;
border-radius:5px;
}
.radio, .check{
width:auto;
}
textarea{
height:70px;
}
.btn{
width:110px;
padding:9px;
border:none;
color:white;
border-radius:5px;
cursor:pointer;
}
.save{background:green;}
.reset{background:red;}
.search{background:blue;}
.update{background:orange;}
.delete{background:black;}
</style>
</head>
//-------------- HTML Code ---------------//
<body>
<div class="container">
<h2>User Registration Form</h2>
<div id="msgbox" class="msg">
<%= msg %>
</div>
<form name="form1" id="form2" action="Registration.jsp" method="post">
<table>
<tr>
<td>Serial No</td>
<td>
<input type="number" name="urslno1" id="urslno2"
value="<%= urslno3 %>" required>
</td>
</tr>
<tr>
<td>Student Name</td>
<td>
<input type="text" name="ursname1" id="ursname2"
value="<%= ursname3 %>" required>
</td>
</tr>
<tr>
<td>Address</td>
<td>
<textarea name="uraddr1" id="uraddr2" required><%= uraddr3 %></textarea>
</td>
</tr>
<tr>
<td>Gender</td>
<td>
<input class="radio" type="radio" name="urgen1" value="Male"
<%= urgen3.equals("Male") ? "checked" : "" %> required> Male
<input class="radio" type="radio" name="urgen1" value="Female"
<%= urgen3.equals("Female") ? "checked" : "" %>> Female
<input class="radio" type="radio" name="urgen1" value="Other"
<%= urgen3.equals("Other") ? "checked" : "" %>> Other
</td>
</tr>
<tr>
<td>User Name</td>
<td><input type="text" name="uruname1" value="<%= uruname3 %>" required></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="urpasswd1" value="<%= urpasswd3 %>" required></td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input type="password" name="urcpasswd1" value="<%= urcpasswd3 %>" required></td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input type="date" name="urdob1" value="<%= urdob3 %>" required></td>
</tr>
<tr>
<td>Mobile No</td>
<td><input type="text" name="urmobno1" maxlength="10" value="<%= urmobno3 %>" required></td>
</tr>
<tr>
<td>Email</td>
<td><input type="email" name="uremail1" value="<%= uremail3 %>" required></td>
</tr>
<tr>
<td>Security Question</td>
<td>
<select name="ursecques1" required>
<option value="Choose One">Choose One</option>
<option value="What is Your Favourite Book"
<%= ursecques3.equals("What is Your Favourite Book") ? "selected" : "" %>>
What is Your Favourite Book?</option>
<option value="What is Your Favourite Teacher"
<%= ursecques3.equals("What is Your Favourite Teacher") ? "selected" : "" %>>
What is Your Favourite Teacher?</option>
<option value="What is Your Favourite Place"
<%= ursecques3.equals("What is Your Favourite Place") ? "selected" : "" %>>
What is Your Favourite Place?</option>
<option value="What is Your Favourite Pet"
<%= ursecques3.equals("What is Your Favourite Pet") ? "selected" : "" %>>
What is Your Favourite Pet?</option>
</select>
</td>
</tr>
<tr>
<td>Security Answer</td>
<td><input type="text" name="ursecans1" value="<%= ursecans3 %>" required></td>
</tr>
<tr>
<td>Hobbies</td>
<td>
<input class="check" type="checkbox" name="urcricket1" value="Cricket"
<%= "Cricket".equals(urcricket3) ? "checked" : "" %>> Cricket
<input class="check" type="checkbox" name="urdance1" value="Dance"
<%= "Dance".equals(urdance3) ? "checked" : "" %>> Dance
<input class="check" type="checkbox" name="urmusic1" value="Music"
<%= "Music".equals(urmusic3) ? "checked" : "" %>> Music
</td>
</tr>
<tr>
<td>Remarks</td>
<td><textarea name="urrem1" id="urrem2"><%= urrem3 %></textarea></td>
</tr>
<tr>
<td colspan="2" align="center">
<input class="btn save" type="submit" name="BtnSave" value="Save">
<input class="btn reset" type="button" value="Reset"
onclick="window.location.href='Registration.jsp';">
<input class="btn search" type="submit" name="BtnSearch"
value="Search" formnovalidate>
<input class="btn update" type="submit" name="BtnUpdate"
value="Update"
onclick="return confirm('Do you want to update this record ?');">
<input class="btn delete" type="submit" name="BtnDelete"
value="Delete" formnovalidate
onclick="return confirm('Do you want to delete this record ?');">
</td>
</tr>
</table>
</form>
</div>
//-------------- Java Script Code ---------------//
<script>
window.onload = function()
{
var msgbox1 = document.getElementById("msgbox");
if(msgbox1.innerHTML.trim() != "")
{
setTimeout(function()
{
msgbox.style.display = "none";
},3000); // 3 seconds
}
};
</script>
</body>
</html>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