Database provide set of tables to store record and JDBC will work similar to bridge between database table and application form.
Step for JDBC operation:-
1) First Install Database server in your machine using MYSQL,ORACLE,SYBASE etc.
2) Create Database Under MYSQL Server using PHPMYADMIN OF XAMPP or MYSQL YOG
create database databasename;
http://localhost/phpmyadmin/
3) Create Table using PHP MYADMIN or XAMPP
create table tablename(columnname datatype,columnname datatype)
4) Create JSP page and design JSP Web form according to table
5) Create Servlet and write data insertion code
6) Add Jar file of MYSQL Driver using Netbeans
JSP Code:-
<%--
Document : StudentInfo
Created on : Mar 6, 2020, 6:03:18 PM
Author : Hp
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form action="StudentSer" method="post">
<input type="text" name="txtrno" placeholder="Enter rno" /> <br><br>
<input type="text" name="txtname" placeholder="Enter name" /> <br><br>
<input type="text" name="txtbranch" placeholder="Enter branch" /> <br><br>
<input type="text" name="txtfees" placeholder="Enter fees" /> <br><br>
<input type="submit" name="btnsubmit" value="Insert" /> <br><br>
</form>
<a href="viewstudent.jsp">VIEW STUDENT RECORD HERE</a>
</body>
</html>
Servlet Code:-
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
/**
*
* @author Hp
*/
public class StudentSer extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
PrintWriter out = response.getWriter();
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stuinfo","root","");
Statement st = con.createStatement();
int x = st.executeUpdate("insert into student(rno,name,branch,fees) values('"+request.getParameter("txtrno")+"','"+request.getParameter("txtname")+"','"+request.getParameter("txtbranch")+"','"+request.getParameter("txtfees")+"')");
if(x!=0)
{
out.print("Data Inserted Successfully");
}
} catch (Exception ex) {
}
}
}
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
ViewStudent.jsp:-
<%--
Document : viewstudent
Created on : Mar 7, 2020, 6:12:09 PM
Author : Hp
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<a href="StudentInfo.jsp">BACK</a>
<br>
<hr>
<h6>VIEW STUDENT RECORD HERE</h6>
<hr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stuinfo","root","");
Statement st = con.createStatement();
ResultSet res = st.executeQuery("select * from student");
while(res.next())
{
out.println(res.getInt(1) +" "+res.getString(2) +" "+res.getString(3) +" "+res.getString(4)+"<br>");
}
%>
</body>
</html>
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
ViewStudent.jsp:-
<%--
Document : viewstudent
Created on : Mar 7, 2020, 6:12:09 PM
Author : Hp
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<a href="StudentInfo.jsp">BACK</a>
<br>
<hr>
<h6>VIEW STUDENT RECORD HERE</h6>
<hr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stuinfo","root","");
Statement st = con.createStatement();
ResultSet res = st.executeQuery("select * from student");
while(res.next())
{
out.println(res.getInt(1) +" "+res.getString(2) +" "+res.getString(3) +" "+res.getString(4)+"<br>");
}
%>
</body>
</html>
Post a Comment
If you have any doubt in programming or join online classes then you can contact us by comment .