QuestionAsk Questions?
Abhishek
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?
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?
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
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 Pages:
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
- Most Effective SEO Tools
- Assigning value to anchor <a></a> tag using custom tag
- java code using while loop
