import java.sql.*;
import java.lang.*;
public class pst
{public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String query="select *from employee where salary>20000";
Connection con=DriverManager.getConnection("jdbc:odbc:name","","");
PreparedStatement pst = con.prepareStatement(query);
ResultSet rs1 = pst.executeQuery();
while(rs1.next())
{
System.out.println(rs1.getString(1)+ "\t" +rs1.getString(2)+ "\t" +rs1.getString(3)+ "\t" +rs1.getString(4)+
"\t" +rs1.getString(5));
}
}
catch(Exception e)
{System.out.println("error " +e);
}
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment