<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/css/bootstrap.min.css" integrity="sha384-zCbKRCUGaJDkqS1kPbPd7TveP5iyJE0EjAuZQTgFLD2ylzuqKfdKlfG/eSrtxUkn" crossorigin="anonymous">
<style>
*{
margin:0px;
padding:0px;
}
</style>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark text-primary">
<a class="navbar-brand text-info font-weight-bold" href="http://localhost:8080/CreateASimpleWebApplication/#">NISUM TECHNOLOGY</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="nav-link" href="https://www.nisum.com/">Home <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item active">
<a class="nav-link" href="#">About Us <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item active">
<a class="nav-link" href="#">Contact Us <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-expanded="false">
Carears
</a>
<div class="dropdown-menu" aria-labelledby="navbarDropdown">
<a class="dropdown-item" href="#">Action</a>
<a class="dropdown-item" href="#">Another action</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="#">Something else here</a>
</div>
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
</form>
</div>
</nav>
<div class="card ">
<div class="card-header text-center">
<br>
<h5 class="card-title text-info">WELCOME TO NISUM TECHNOLOGY</h5>
<h4 class="card-text text-success">Nisum has developed proprietary tools that can be instantly integrated into your company's infrastructure to rapidly solve problems in business agility.</h4>
<a href="http://localhost:8080/WebApplicationUsingServletJsp/student_record.jsp" class="btn btn-primary">Crud Operation</a>
</div>
<br><br><br>
<div class="card-body">
<div class="container">
<div class="row">
<div class="col-md-6 offset-md-3">
<div class="card rounded-lg border border-danger">
<div class="card-header">
<h3 align="center">(--UPDATE RECORD--)</h3>
</div>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet" %>
<%
String u = request.getParameter("u");
Integer studentId = Integer.parseInt(u);
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/firstDBPractice", "root", "nisum123");
Statement stat = con.createStatement();
ResultSet result = stat.executeQuery("select * from student where student_id='"+studentId+"'");
%>
<div class="card-body rounded-lg ">
<form action="UpdateRecord" method="post">
<%
while(result.next()){
%>
<div class="form-group"> <input type="hidden" class="form-control" name="SID" value=" <% out.print(result.getString("student_id")); %>" > </div>
<div class="form-group"> <input type="hidden" class="form-control" name="SRNO" value=" <% out.print(result.getString("student_RNo")); %>" > </div>
<input type="text" class="form-control" name="SNAME" value=" <% out.print(result.getString("student_name")); %>" >
</div>
<%
}
%>
<div class="card-footer text-center">
<input type="submit" name="submit" value="Update" id="update" class="form-control btn-primary" > </form>
</div>
</div>
</div>
</div>
</div>
<br><br><br>
</div>
<div class="card-footer bg-info text-center">
<br><br>
<h5 class="card-title text-warning">BUILDING SUCCESS TOGETHER</h5>
<h4 class="card-text text-danger">Nisum Technology Is Hiring For Java Developer & Java Script Developer </h4>
<a href="https://www.nisum.com/" class="btn btn-dark">For More Updates Visit THis Site</a>
<br><br>
</div>
</div>
</body>
</html>