JDBC - Servlet connectivity

SERVLET - JDBC

Stud.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body bgcolor="magenta" text="blue">
<h1>   Student mark list </h1>
<form method ="get"  action = "stud"> <br>
NAME :     <input type= "text" NAME = "nam" > <br> <br>
ROLL NO: <input type= "text" NAME = "rno"> <br> <br>
MARK1 :  <input type= "text"  NAME = "m1" > <br> <br>
MARK2 :  <input type= "text"  NAME = "m2" > <br> <br>
MARK 3 :  <input type= "text"  NAME = "m3" > <br> <br>
<input type= "submit" value = "submit" ><br > <br> <br>
</form>
</body>
</html>

Stud.java

import java.io.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

/**
 * Servlet implementation class Stud
 */
@WebServlet("/Stud")
public class Stud extends HttpServlet {
       private static final long serialVersionUID = 1L;
      
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Stud() {
        super();
        // TODO Auto-generated constructor stub
    }

       /**
        * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
        */
    int m11,m22,m33,tot,avg;
    public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
    {
    res.setContentType("text/plain");
    PrintWriter out=res.getWriter();
    String a = req.getParameter("nam");
    String b = req.getParameter("rno");
    String m1=req.getParameter("m1");
    String m2=req.getParameter("m2");
    String m3=req.getParameter("m3");
    try{
    m11=Integer.parseInt(m1);
    m22=Integer.parseInt(m1);
    m33=Integer.parseInt(m1);
    }
    catch(Exception e)
    {
    }
    tot=m11+m22+m33;
    avg=tot/3;
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(Exception e)
    {
    System.out.println(e);
    }
    try
    {
    Connection c = DriverManager.getConnection("jdbc:odbc:Marklist","","");
    Statement s=c.createStatement();
    s.executeUpdate("insert into marktable values('"+a+"',"+b+","+m1+","+m2+","+m3+","+tot+","+avg+")");
    s.close();
    c.close();
    }
    catch(Exception e)
    {
    }
    out.println("<html> <body bgcolor=aqua text=red>");
    out.println("<h1 align=center>STUDENT DETAILS </br>");
    out.println("NAME:" +a);
    out.println("<br> Roll No:" +b);
    out.println("<br> TOTAL: " +tot);
    out.println("<br> AVERAGE:" +avg);
    out.println("</h1></body></html>");
       }

       /**
        * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
        */
       protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
              // TODO Auto-generated method stub
       }
}


Comments

Post a Comment

Popular posts from this blog

Artificial Intelligence

Image
Artificial Intelligence 1.    What is AI technique? Artificial  Intelligence (AI)  is  the study  of  how  to make computers do things which, at  the moment, people do better. It is a method that exploits knowledge that should be represented in such a way that: ·    The knowledge captures generalizations. ·    It can be understood by people who must provide it. ·    It can be easily modified to correct errors and to reflect changes. ·    It can be used in situations even if it is not accurate and complete. ·    It helps to narrow the range of possibilities that is has to be considered. 2.    What are the steps to be considered to solve a problem? To solve a particular problem, the following steps are taken into account, ·    Define the problem precisely. ·    Analyze the problem. ·    Isolate and represent the task knowledge that is necessary to solve a problem. ·    Choose the best problem-solving techniques and apply it to a particular problem.
Read more

The taxonomy of CASE Tools

CASE Tool Taxonomy CASE tools can be classified by · by function, · by user type (e.g. manager, tester), or · by stage in SE process (e.g. requirements, test) The following taxonomy is classified by function. Business Information Tools model business information flow. The tools represent business data object and model their flow. Network tools could be modified to yield the same functionality. Process Management Tools model processes. You have to understand the process in order to model it. The tools help you capture process. This is a key component of TQI. Project Planning Tools help plan and schedule projects. Examples are PERT and CPM. Finding parallelismand eliminating bottlenecks assist in streamlining projects. Risk Analysis Tools helps build a risk table from the schedule outlining the risk each component of the production process and categorizing the risks as catastrophic, critical, marginal, or negligible. A cost is associated with eac
Read more

Zoho Second round - adding a digit to all the digits of a number

Adding a digit to all the digits of a number eg digit=4, number = 2875, o/p= 612119 C Program: #include<stdio.h> #include<conio.h> #include<string.h> int main() {     int t,n,i=0;     char num[100];     printf("Enter the digit: ");     scanf("%d",&n);     printf("Enter the number: ");     scanf("%s",num);     printf("o/p ");     for(i=0;i<strlen(num);i++)     {     printf("%d",num[i]-'0'+n);     }  getch();  return 0; }  
Read more