Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC Oracle Database error
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Abhishek
Oracle Database error
1 Answer(s)      4 years and 7 months ago
Posted in : JDBC


String query11 = "SELECT product_code, product_quantity, price FROM o"+orderid;
ResultSet rs11 = stmt.executeQuery(query11);
while(rs11.next()){
product_code[j] = rs11.getString("product_code");
product_quantity[j] = rs11.getInt("product_quantity");
product_price[j] = rs11.getLong("price");
j++;
out.println(product_code[j]);
out.println(product_quantity[j]);
out.println(product_price[j]);
out.println(j);
}
rs11.close();

This is my code.
I want to save Result set values in array.
The query is correct.
But the values i'm printing is 0 or null.
I don't know exactly where is the problem?

Advertisement
View Answers

June 16, 2010 at 3:34 PM


Hi Friend,

Try the following code:

import java.sql.*;
class Select {
public static void main(String[] args){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/register";, "root", "root");
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery("select * from item");
rs.last();
int count = rs.getRow();
rs.beforeFirst();
int id[]=new int[count];
String name[]=new String[count];
int price[]=new int[count];
int k=0;
while(rs.next()){
id[k]=rs.getInt("itemid");
name[k]=rs.getString("Item_Name");
price[k]=rs.getInt("price");
k++;
}
for(int i=0;i<id.length;i++){
System.out.println(id[i]+" "+name[i]+" "+price[i]);
}
}
catch(Exception e){
}
}
}

Hope that it will be helpful for you.
Thanks


Related Tutorials/Questions & Answers:
error oracle database connection?
error oracle database connection?  hi now i am trying to connect oracle database and also insert my data into table, but it's not working.. I created... in oracle table. my table name is logininfoclient_sla. this is my coding
Oracle Database error - JDBC
Oracle Database error   String query11 = "SELECT product_code, product_quantity, price FROM o"+orderid; ResultSet rs11 = stmt.executeQuery(query11); while(rs11.next()){ product_code[j
Advertisements
error in uploading image from jsp to oracle 10g database
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
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... also set the environment variable like that .;E:\oracle\ora81\jdbc\lib
File insertion into oracle database
File insertion into oracle database  How to Read and Insert a file (any format) into a Oracle database
storing csv into oracle database
storing csv into oracle database  i want jsp code for storing csv file into oracle database
Spring and Oracle Database
Spring and Oracle Database  I need example for Batch update process using oracle database and spring framework with full explanation
error occured in oracle - JDBC
error occured in oracle  hi... this is the error i got in oracle 11g when i am trying to insert image ORA-00984:column not allowedd here for the insert statement like this insert into imgapp('1','xxx','G:\image folder\ultrasound
Oracle 9i database problem
Oracle 9i database problem  Hi Somebody has given the solution but i... Oracle 9i in my laptop.and i got sql+ page ok.i have gone to control panel->odbc->in that i correctley configured DNS and TNS and tested the Oracle
About connection database oracle to java
About connection database oracle to java  Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... .but it has shown error in TNS .what exactly i did is that i have gone
About connection database oracle to java
About connection database oracle to java  Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... .but it has shown error in TNS .what exactly i did is that i have gone
About connection database oracle to java
About connection database oracle to java   I culdn't connect oracle... .but it has shown error in TNS .what exactly i did is that i have gone to control Panel>>Administrative Tools>>Data Sources in that i selected Oracle
About connection database oracle to java
About connection database oracle to java   I culdn't connect oracle... .but it has shown error in TNS .what exactly i did is that i have gone to control Panel>>Administrative Tools>>Data Sources in that i selected Oracle
About connection database oracle to java
About connection database oracle to java  **Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... as tiger .but it has shown error in TNS .what exactly i did is that i have gone
oracle insert statement error - JDBC
oracle insert statement error  hi.. please help me to insert a image into oracle 11g database and please say me how can i insert image from directory like G:\imagefolder\ultrasoundimage\02us02.jpeg please help me
android connection to database oracle 10g
android connection to database oracle 10g  Hello, How i can connect my android application to my oracle 10g database
Connecting Oracle database with struts - Struts
Connecting Oracle database with struts  Can anyone please provide me some solutions on Connection between Oracle database and struts
Java Connection to Oracle database
Java Connection to Oracle database  HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
jsp with database oracle
jsp with database oracle  hai i am doing one program in jsp i want to check the jsp life cycle methods so wrote one program, in which i write jspInit() method and jspDestroy() methods. but i am getting error i crate a table
Oracle Database - Insert System Time
Oracle Database - Insert System Time  Hi I want to insert only system time dynamically using a statement but not a prepared statement into Oracle Database please suggest me any code
write excel file into the oracle database
write excel file into the oracle database  dear sir, i need the jsp code that reads the excel file and stores it into the oracle database table..and also i need the code to connect oracle database? thank u in advance
Database Connectivity Withe Oracle
Database Connectivity Withe Oracle  Develop a program to perform the database driven operation like insert, Delete, Update and select. To perform the above operations create one table named Employee. Field Name Field Type EmpId
oracle database backup using jsp
oracle database backup using jsp   I want to take the backup of oracle database.I want to write the code in jsp ,so that when the page is loaded a backup of the database is stored in one of my local drives.Is it possible to do
error at the oracle programm with jsp - JSP-Servlet
error at the oracle programm with jsp  an error occured at myodbc:jdbc:missig comma
Java Barcode Program with Oracle database
no and serial no of the item being scanned to Oracle 10g database. I dont have any...Java Barcode Program with Oracle database  Hi Everyone, I need help to develop my new project, am going to do with barcode s/w, am very new
store & retrive the image from oracle database
store & retrive the image from oracle database  how can i store the image path in tha database & fetch that image from oracle database
related retrieving value from oracle database
related retrieving value from oracle database  how we get the value from database in the given textbox
related retrieving value from oracle database
related retrieving value from oracle database  how we get the value from database in the given textbox
OCI Connectivity For Oracle Plz Solve This Error
OCI Connectivity For Oracle Plz Solve This Error  import java.io...."); con=DriverManager.getConnection("jdbc:oracle:thin...) { e.printStackTrace(); } } } ---> I found Error below how i can solve this error plz
OCI Connectivity For Oracle Plz Solve This Error
OCI Connectivity For Oracle Plz Solve This Error  import java.io...."); con=DriverManager.getConnection("jdbc:oracle:thin...) { e.printStackTrace(); } } } ---> I found Error below how i can solve this error plz
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
Advertisements
 

 

 

DMCA.com