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();
}
}
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();
}
}