.png)
java token
Last Updated on : 26th Mar 2024 16:19:47 PM
view data in jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.DriverManager" %>
<%@page import="java.sql.SQLException" %>
<%@page import="java.util.logging.Level" %>
<%@page import="java.util.logging.Logger" %>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet" %>
<%@page import="java.util.ArrayList" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Manage Student</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css"
integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
</head>
<body>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4">
<h2 style="text-align: center">Student Details</h2>
</div>
</div>
<div class="col-sm-2">
<a href="index.jsp"><Button class="btn btn-success" style="width: 80px;">Home</Button></a>
</div>
<table class="table table-hover">
<thead>
<tr>
<th scope="col">Reg No</th>
<th scope="col">Name</th>
<th scope="col">Address</th>
<th scope="col">Course</th>
<th scope="col">Phone</th>
</tr>
</thead>
<tbody>
<%
Connection con;
PreparedStatement pst;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/bhaskar","root","sandip@123");
String query = "Select * from jspdata";
pst = con.prepareStatement(query);
rs = pst.executeQuery();
while(rs.next()){
%>
<tr>
<th scope="row"><%= rs.getString("regno") %></th>
<td><%=rs.getString("studentname")%></td>
<td><%=rs.getString("address")%></td>
<td><%=rs.getString("subject")%></td>
<td><%=rs.getString("phone")%></td>
<td><a class="btn btn-success" href="editStudent.jsp?id=<%=rs.getString("regno") %>" role="button">Edit</a>
<a class="btn btn-danger" href="removeStudent.jsp?id=<%=rs.getString("regno") %>"
role="button">Remove</a></td>
</tr>
<% }%>
</tbody>
</table>
</body>
</html>
Update data in jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.DriverManager" %>
<%@page import="java.sql.SQLException" %>
<%@page import="java.util.logging.Level" %>
<%@page import="java.util.logging.Logger" %>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet" %>
<%@page import="java.util.ArrayList" %>
<html>
<head>
<title>Student Registration Form</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/
bootstrap.min.css"
integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2"
crossorigin="anonymous">
</head>
<body>
<%
Connection con;
String msg = "";
String color = "";
if(request.getMethod().compareToIgnoreCase("post")==0)
{
try
{
String regno = request.getParameter("regno");
String name = request.getParameter("name");
String course = request.getParameter("course");
String address = request.getParameter("address");
String phone = request.getParameter("phone");
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.
getConnection("jdbc:mysql://localhost/bhaskar","root","sandip@123");
String query =
"update jspdata set studentname = ?, address= ?, subject =? ,phone= ? where regno = ?";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1, name);
pst.setString(2, address);
pst.setString(3, course);
pst.setString(4, phone);
pst.setString(5, regno);
pst.executeUpdate();
color = "green";
msg = "Student Updateddddd Succesfully";
}catch(Exception ex){
ex.printStackTrace();
color = "red";
msg = "Error Occured";
}
}
%>
<div class="form-group col-12 p-0">
<h4 style="color:<%= color %>"><%= msg %></h4>
</div>
<form id="form" method="post" action="editStudent.jsp" class="form-horizontal">
<%
PreparedStatement pst;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.
getConnection("jdbc:mysql://localhost/bhaskar","root","sandip@123");
String id = request.getParameter("id");
pst = con.prepareStatement("select * from jspdata where regno = ?");
pst.setString(1, id);
rs = pst.executeQuery();
while(rs.next())
{
%>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4">
<h2 style="text-align: center">Student Details</h2>
</div>
</div>
<hr/>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4 mx-auto">
<label>Registation No</label>
<input type="text" name="regno" class="form-control" id="regno"
value="<%= rs.getString("regno") %>">
</div>
</div>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4 mx-auto">
<label >Student Name</label>
<input type="text" name="name" class="form-control" id="name"
value="<%= rs.getString("studentname") %>">
</div>
</div>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4 mx-auto">
<label>Course:</label>
<input type="text" name="course" class="form-control" id="course"
value="<%= rs.getString("subject") %>">
</div>
</div>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4 mx-auto">
<label>Address:</label>
<input type="text" name="address" class="form-control" id="address"
value="<%= rs.getString("address") %>">
</div>
</div>
<div class="form-group">
<div class="col-sm-4"></div>
<div class="col-sm-4 mx-auto">
<label>Phone</label>
<input type="text" name="phone" class="form-control" id="phone"
value="<%= rs.getString("phone") %>">
</div>
</div>
<br/>
<div class="form-group" align="right">
<div class="col-sm-6">
<div class="col-sm-2">
<Button class="btn btn-success" style="width: 80px;">Submit</Button>
</div>
<div class="col-sm-4">
</div>
</div>
</div>
<% } %>
</form>
<div class="col-sm-12" align="right">
<a href="index.jsp"><Button class="btn btn-success" style="width: 80px;">Home</Button></a>
</div>
</body>
</html>
delete data in jsp
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%
Connection con;
String regno = request.getParameter("id");
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/bhaskar","root","sandip@123");
String query = "delete from jspdata where regno = ?";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1, regno);
pst.executeUpdate();
%>
<script>
window.location.replace("viewStudent.jsp");
</script>
Example of Encapsulation
#include <iostream>
using namespace std;
class Student
{ // encapsulation
private:
string name;
int account_number;
public:
Student(string nm, int ac)
{
name=nm;
account_number=ac;
}
string getName()
{
return name;
}
int getAccount()
{
return account_number;
}
};
int main()
{
Student s("aarti",5675) ;
cout<<"My Name is "<<s.getName()<<"Account Number is "<<s.getAccount();
return 0;
}
Become a first user to comment