Results 1 to 3 of 3
- 01-23-2009, 03:41 AM #1
Member
- Join Date
- Jan 2009
- Posts
- 15
- Rep Power
- 0
How To Use This Statement In My Program
STATEMENT IS (----------ResultSetMetaData counter=rs.getData();-----------)
this is my program
import java.io.*;
import java.sql.*;
class status
{
public static void main(String args[])throws IOException
{
String customerid=null;
String str=null;
Connection con =null;
ResultSet rs =null;
Statement st =null;
String city="salem";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:tiens") ;
st=con.createStatement();
str = "select customerid,count(customername) \"counter\" from customer ";
rs =st.executeQuery(str);
while(rs.next())
{
customerid=rs.getString("customerid");
System.out.println(customerid);
}
rs.close();
st.close();
}catch(Exception e){}
}
}
- 01-23-2009, 04:54 AM #2
Senior Member
- Join Date
- Dec 2008
- Location
- Hong Kong
- Posts
- 473
- Rep Power
- 5
rs.getData()... i cant find this method in java5 and java6...
you may try getMetaData() method and read
ResultSetMetaData (Java Platform SE 6)
or
ResultSetMetaData (Java 2 Platform SE 5.0)
- 01-23-2009, 08:12 AM #3
Member
- Join Date
- Jan 2009
- Posts
- 4
- Rep Power
- 0
Similar Threads
-
unreachable statement - Java calculator program
By V2001Gordon in forum New To JavaReplies: 3Last Post: 12-13-2008, 12:57 AM -
If statement, please help??
By soc86 in forum New To JavaReplies: 5Last Post: 11-23-2008, 02:58 PM -
Help with if statement
By carl in forum New To JavaReplies: 1Last Post: 08-06-2007, 07:53 AM -
Statement or Prepared Statement ?
By paty in forum JDBCReplies: 3Last Post: 08-01-2007, 04:45 PM -
If Statement
By aDrizzle in forum New To JavaReplies: 4Last Post: 07-08-2007, 08:55 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks