Untitled

Experiment No. 10

Write a JSP program for Demonstration of connecting to database using JDBC data Source.

index.jsp
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Experiment 10</title>
    </head>
    <body>
        <h1>Enter Student Record</h1>
        </br>
        <form name="f1" action="AddRecord.jsp" method="get">
        Name <input type="text" name="name"id="name">
        </br>
        Roll No <input type="text" name="roll"id="roll">
        </br>
        Percentage <input type="text" name="per"id="per">
        </br>
        <input type="submit" value="Add">
        </form>
    </body>
</html>


AddRecord.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <%
        String name = request.getParameter("name");
        String rollno = request.getParameter("roll");
        String per = request.getParameter("per");
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student_record",
"root","");
            Statement st = con.createStatement();
            int  i = st.executeUpdate("insert into stud values                       ('"+rollno+"','"+name+"','"+per+"')");

          if(i!=0){

                    out.print("Record Inserted Successfully");
                  }
                   else {

                     out.print("Error while Entering Record");
                 }
                %>
    </body>
</html>