invalid descriptor index???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sama sam
    New Member
    • Feb 2012
    • 1

    invalid descriptor index???

    import java.sql.*;
    import java.util.Date;
    import java.text.Parse Exception;
    import java.util.Calen dar;
    import java.text.DateF ormat;
    import java.util.Date;


    class DataBase{
    public static void main(String a[]) throws Exception{
    Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;

    int temp1=0;
    // String s;
    // Format formatter;



    Date date = new Date();


    Connection con=DriverManag er.getConnectio n("jdbc:odbc:Di scharge");
    System.out.prin tln("Sucessfull y Connected ");
    Statement st= con.createState ment();
    ResultSet rs= st.executeQuery ("select Discharge_Value from Taunsa_Normal") ;

    //ResultSet rs= st.executeQuery ("select Flood_Date, Time, Discharge_Value from Taunsa_Normal") ;



    while(rs.next() ){


    /*
    temp1=Integer.p arseInt(rs.getS tring(1));
    System.out.prin tln(temp1);



    System.out.prin tln(rs.getDate( 2));

    */

    temp1=Integer.p arseInt(rs.getS tring(1));
    java.sql.Time dbSqlDate = rs.getTime(3);
    java.sql.Date dbSqlTime = rs.getDate(2);



    System.out.prin tln(temp1);
    System.out.prin tln("dbSqlTime= " + dbSqlTime);
    System.out.prin tln("dbSqlDate= " + dbSqlDate);



    }
    System.out.prin tln(temp1);







    st.close();
    con.close();

    }
    }
Working...