Saturday, February 26, 2011

Core java programmer


import java.io.*;
import java.sql.*;
import java.awt.event.*;
import java.awt.*;
import java.util.*;
import java.lang.*;
class History
{

public static void main(String args[])
{


String dd="asbdjs";
while(dd.length()>0)
{

try{
System.out.println("welcome to personal account information");
System.out.println("\n"+"enter q to quit");
System.out.println("\n");
System.out.println("enter account number :");
BufferedReader read=new BufferedReader(new InputStreamReader(System.in));
String sx=read.readLine();
if(sx.equals("q"))
{
System.exit(0);
}
else
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException k)
{
System.out.println(k);
}
try
{
String url="jdbc:odbc:test";
int account=Integer.parseInt(sx);
String command="select * from Account where account like "+account;
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement();
ResultSet rs=s.executeQuery(command);



while(rs.next())
{

String s1=rs.getString(1);
String s2=rs.getString(2);
int d1=rs.getInt(3);
int d2=rs.getInt(4);
int s3=rs.getInt(5);

String data="account "+s1+"\n"+"date "+s2+" withdrawl "+d1+" deposit "+d2+"\n"+"balance "+s3+"\n";

System.out.println(data);
System.out.println("\n");

}

}
catch(SQLException k)
{
System.out.println(k);
}
}

}

catch(Exception w)
{
System.out.println(w);
}
}
}
}

No comments:

Post a Comment