Skip to main content

Connect to Oracle : A java servlet program

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class connToHr extends HttpServlet
{
    public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
    {
           
            PrintWriter out=res.getWriter();
        try
        {
            String conURL="jdbc:oracle:thin:@localhost:1521:orcl";
            String conUSER="HR";
            String conPASSWORD="HR";   
            String uniDriver="sun.jdbc.odbc.JdbcOdbcDriver";
            Driver d=(Driver)Class.forName(uniDriver).newInstance();   
            Connection con=DriverManager.getConnection(conURL,conUSER,conPASSWORD);
            Statement stmt=con.createStatement();
            ResultSet rs;    
             rs= stmt.executeQuery("SELECT * FROM EMPLOYEES");
   

            while(rs.next())
            {
                out.println("<HTML><BODY><H1>THE EMPLOYEE DETAILS ARE</H1><TABLE>");
                out.println("<TR><TD>"+rs.getString("EMPLOYEE_ID")+"</TD><TD>"+
                    rs.getString("FIRST_NAME")+"</TD><TD>"+rs.getString("SALARY")+"</TD></TR>");
                out.println("</TABLE>");
            }
        }catch(Exception e){out.println(e.getMessage());}
    }
}
       
Labels:

Comments

Post a Comment

Popular posts from this blog

Sample : String Reverse In Java

import java.io.*; class test {     public static void main(String args[])     {         DataInputStream in=new DataInputStream(System.in);         try         {             String text;             System.out.println("\nEnter The Text");             text=in.readLine();             System.out.println("\nIn Reverse Order::\n");             for(int i=text.length()-1;i>=0;i--)             {                 System.out.print(text.charAt(i));             }          ...
Post a Comment
Read more

Getting Browser Information in javaScript

<html> <head> <script> function getBrowserName() { tag_link.innerHTML="You are surfing internet through  "+'<b>'+navigator.appName+'</b>'+" browser family." } </script> </head> <body onLoad="getBrowserName()"> <center> <p id="tag_link" style="font-size:30"></p> </center> </body> </html>
Post a Comment
Read more