Home Answers Viewqa JSP-Servlet How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end

 
 


Venkatasitaramayya
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end
1 Answer(s)      a year and 7 months ago
Posted in : JSP-Servlet

hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have created one jsp program like this <% PreparedStatement ps; Connectin con; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DrivergetConnection("jdbc:odbc:DNSName","scott","tiger"); ResultSet rs=ps.executeQuery("select from Table1"); if(rs.next()) { out.println(rs.getInt(1)); out.println(rs.getString(2)); out.println(rs.getString(3)); out.println(rs.getInt(4)); } rs.close(); ps.close(); con.close(); %> Dont worry abut the Implementing of JSP Directives ,ihave given correctly But now when i the save this program in JSP it is alright then when i opened the Tomcat and getting the necessary path ,iam clicking on the JSP file i am not getting any thin in the internet Browser.i have given the data (Table1) in the database.so that data should come on the Browser. but not getting.So kindly the RoseIndia netizens help to solve the problem.

View Answers

October 8, 2011 at 1:25 PM


hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have created one jsp program like this

<@ page session="false"%> <@ page import="java.io.*" import="java.sql."%> <%try { PreparedStatement ps; Connectin con; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DrivergetConnection("jdbc:odbc:DNSName","scott","tiger"; ps=con.prepareStatement(); ResultSet rs=ps.executeQuery("select from Table1"); if(rs.next()) { out.println(rs.getInt(1)); out.println(rs.getString(2)); out.println(rs.getString(3)); out.println(rs.getInt(4)); } } catch(Exception e) {} rs.close(); ps.close(); con.close(); %>

But now when i iam saving this program in JSP it is alright , when i opened the Tomcat and getting the necessary path then i clicked on the JSP file i,but i am not getting any thing in the internet Browser.i have given the data (Table1) in the database.so that data should come on the Browser. but not getting.So kindly the RoseIndia netizens help to solve the problem









Related Pages:
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end  hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have created one jsp
How we delete a data of database from front end jsp page
How we delete a data of database from front end jsp page   I make a website and featch a data from data base and now i want that a delete button put in front of a featched data and when i clicked on this button then the data
How to get data from Oracle database using JSP
How to get data from Oracle database using JSP  hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have... the answer to retrieve data from the database by using servlet or jsp program
How to get the data from the database using Servlet or JSP program
How to get the data from the database using Servlet or JSP program  ... the problem   Get data from database using servlet Retrieve data from database using JSP Get data from database using JSP
fetch record from oracle database using jsp-servlet?
fetch record from oracle database using jsp-servlet?  how can i fetch data from oracle database by using jsp-servlet. i'm using eclipse, tomcat server and oracle database and creating jsp pages and also using servlet
MySQL Front
Database. These MySQL Front tools actually helps you in working fast and easily with the MySQL database. Here is the list of MySQL Front end tools: What...      How To Set Up A Debian Linux Database Server Using
not picking request parameters from the front end - JSP-Servlet
not picking request parameters from the front end  hi.... As per the code i should get output as Hello welcome to unice:venkat(which name you have enter in front end). but i am getting response as welcome to unicel
extract data fom table when a button is clicked in front end page using mysql5.0 and tomcat6.0
extract data fom table when a button is clicked in front end page using... is stored in mysql5.0 databse, when a button is clicked in front end page using... this will be helpful for you http://roseindia.net/jsp/servlet-jsp-data-list.shtml http
jdbc front end - JDBC
jdbc front end  a code written using JDBC,ODBC,SQL and swing only that allows the user to select the required driver related to a specific database that can execute the SQL queries related to that database.  Hi Friend
HIBERNATE IN CONSOLE & SERVLET
for using Hibernate in a console application & a servlet. ... HIBERNATE IN CONSOLE & SERVLET ( part-3... -- mysql\bin>mysql We will get the mysql prompt. >create database
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle???  sir.. i have number of excel sheets which... be inserted into oracle database.. please help me sir...   hi friend
how to load a table of data from oracle, to a jsp page using hashmap.
how to load a table of data from oracle, to a jsp page using hashmap.  I have a jsp page which ask for project ID,team name,member name according to this data i have to retrieve their details from the database(oracle). I have
how to get data from checkboxes - JSP-Servlet
how to get data from checkboxes  hi, i got list of tables on screen by invoking webservices.when the user selects the tables by using checkboxes, i need to get only those tables to the next page where i can get list of columns
JSP Get Data From Database
JSP Get Data From Database In this section we will discuss about how to get data from database using JSP. To get data from database to a JSP page we... example which lets you understand to fetch data from database in JSP
to get picture from ms access database by jsp-servlet....
to get picture from ms access database by jsp-servlet....  I have inserted a picture in ms access data base,,,how we can retrieve that picture by using jsp
How to get data from Excel sheet - Struts
How to get data from Excel sheet  Hi, I have an excel sheet with some data(including characters and numbers). Now i want read the data from excel sheet and display in console first then later insert this data into database
How to delete the row from the Database by using servlet
How to delete the row from the Database by using servlet  Dear Sir/Madam I am trying to delete the one user data in the Oracle SQL server database...: Delete row from database using servlet   In that link solution
How retreive data from database without using post method in jsp - JSP-Servlet
How retreive data from database without using post method in jsp  Tell me how?  Hi Friend, If you don't want to use post method then use... the selected value from the combo box and get textbox value from another page
how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp  //Customer Name: <select name="name"> <% try{ Class.forName...="select * from staff"; ResultSet rs=st.executeQuery(sql); while(rs.next
how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp  Can anybody tell me what is the problem in this code as i am not able to fetch the data from... tutorial go through the link JSP Get Data Into Dropdown list From Database   
unable to get datas from oracle database
unable to get datas from oracle database  Dear Sir, I am again struck in my project.. i want to display data from oracle database but i get this error when i run the jsp file in tomcat, I post my code below.. kindly let me
how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp  Customer Name:<select name="name"> <% try{ Class.forName...=con.createStatement(); String sql="select * from staff"; ResultSet rs
how to insert data in database using html+jsp
how to insert data in database using html+jsp  anyone know what... = null; // declare a resultset that uses as a table for output data from... and database name. Here machine name id localhost and database name
How to get data from DB in to Text box by using Jsp & Ajax
How to get data from DB in to Text box by using Jsp & Ajax   I want to get the data from database in to text box in a jsp page by using Ajax. If I... with a and from that i need to select the required value and i should store
retrive data from oracle to jsp
retrive data from oracle to jsp  i am a beginer in jsp so please help...; } } in SearchProjDAO i have to call servlet also how can i do this i have... cost and manager name and storing it in the data base. in search proj fiel
How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp?  Hello friend i want use only one jsp page.. but u give 2 pages... I want...="+emp_value xmlHttp.onreadystatechange=stateChanged xmlHttp.open("GET",url
get info from mysql using jsp and servlet
get info from mysql using jsp and servlet  HELLO! I wanna create a jsp page which able to let me get its name, phone and other info by asking the user to key in their email address from mysql database by using servlet and jsp too
how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp  Answer pl
Select tag to fetch data from oracle database
Select tag to fetch data from oracle database  I created a select box... oracle database.Similarly when address will be selected by the user from... of a student and when regnno is selected from the drop down list by a user
how to display a table from database using servlet
how to display a table from database using servlet  how to display... the following link: http://roseindia.net/jsp/servlet-jsp-data-list.shtml Thanks...://roseindia.net/jsp/servlet-jsp-data-list.shtml Thanks
How to Upload a file directly to Oracle database using JSP or Servlets?
How to Upload a file directly to Oracle database using JSP or Servlets?  Hi I want to upload a file(csv or excel) to Oracle 10g Database using JSP...;Upload File to Oracle Database</h2> <form id="form1" enctype
front controller - JSP-Servlet
front controller  How to implement front controller in a web application
How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp?  I am using a single jsp form.. i did not get from another form.. i do not use 2 jsp form.. all.... Note: I am using only this jsp form.. i do not use
Acees data from database using combo box - JSP-Servlet
Acees data from database using combo box  please let me how i access the data from database when i select combo box combo2 having values Arts... value 11 or 12, otherwise combo box combo2 remain hide. Here is JSP's files
how to get the values to dropdownlist from oracle database
how to get the values to dropdownlist from oracle database   <...("jdbc:oracle:thin:@192.168.149.95:1521:MOBIRAC1","SCOTT","SCOTT"); Statement... * from countryname"); while(rs.next()){ %> <option value="<
how to store the data in a array retrived from the database - JSP-Servlet
how to store the data in a array retrived from the database  hi... in database,and i need to disply all the employees record in a single jsp. pls can any one tell me how to do it this using jsp. thankyou,  Hi nagaraj
How to show data from database in textbox in jsp
How to show data from database in textbox in jsp   How to show data from database in textbox in jsp   Here is an example that retrieve the particular record from the database and display it in textbox using JSP. <
how to get only checked data
how to get only checked data  my problem is that i have a jsp page on which i retrieve data from the database through servlet , on the jsp page... to other servlet page having the query with select * from the database.   
JSP output in Console - JSP-Servlet
JSP output in Console  Q:An input text should be read and the same should be printed in the CONSOLE. Actually i was able to do it in the browser, but unable to get in the CONSOLE. Can anyone tell me how could i do
How to delete the row from the Database by using while loop in servlet
How to delete the row from the Database by using while loop in servlet .... It is Urgent...  When you retrieve the data from the Database by using... server database by using Servlet program (Tomcat server). In Database table
java and oracle - JSP-Servlet
data (think as 50 records) in database. Now i want to retrive the data from the database(20 records at each time but should be different for each time... Mysql for this purpose. Try the following code: Pagination of JSP
How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp?  Hi Friends... related value.... I am using only this page.. not get value from another page... in combo box from database.. by using select*from studentinformation; But when i
JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss... data from the database and set it into the dropdown list in JSP using MySQL.... This tutorial explains you that how to fetch data from database and set
CONNECT TO FRONT END - Hibernate
CONNECT TO FRONT END  HI HOW TO COONECT HIBERNET WITH STRUCT FRONT eND. PLEASE PROVIDE CODE AS SOON AS POSSIBLE. REGARDS DILEEP  Hi Friend, Please visit the following link: http://www.roseindia.net/struts
How to retreive data by using combo box value - JSP-Servlet
. Note: I am using only this jsp form.. i do not use to get values from...How to retreive data by using combo box value  I am using a single jsp form.. i did not get from another form.. i do not use 2 jsp form.. all
Oracle Books
Edge: "I enjoyed this book from the beginning 'til the end. The Oracle Edge... and shove data inside of it, or you can learn how Oracle works and exploit..., functionality, and reliability of the Oracle database. The nearly 800 pages
Oracle Database connectivity probem
Oracle Database connectivity probem  hi Below is the code of oracle database connectivity, when i compile it, it will show the error... Foundation\Tomcat 6.0\lib\servlet-api.jar;E:\oracle\ora81\jdbc\lib\classes111.zip I
error in uploading image from jsp to oracle 10g database
try to insert into the image into the database i got the above error please advice how to get rid of error   JSP upload image in Mysql database...error in uploading image from jsp to oracle 10g database  
i have developed the application in jsp(front-end -jsp,business logic-jsp).it is very slow when accessing the page - JSP-Servlet
i have developed the application in jsp(front-end -jsp,business logic-jsp... in jsp only.i did not use any classes.application is very slow when access the pages.how to improve the performance.i am using the microsoft access file
connection with database - JSP-Servlet
and the connection with the database using jsp code, I get exceptions that I have... with java code. Is there any other way to establish a connection with database in jsp... Friend, Try the following code: Send your JSP code, if you get

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.