Skip to main content

Connection to Oracle Database Using JSP

<%@page import="java.sql.*"%>
<%
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","INVCTLSYS","FUSION");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM TBL_PURCHASED_INVOIE_REGISTER");
while(rs.next())
{
out.println(rs.getInt("SYS_ID")+"   ->   "+rs.getInt("VENDOR_SYS_ID")+"   ->   "+rs.getString("VENDOR_NAME")+"   ->   "+rs.getString("INVOICE_ID")+"<br>");
}
}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