import java.sql.*;
class Exp11_4
{
public static void main (String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:EMPDSN");
PreparedStatement stm=conn.prepareStatement("select * from EmpMaster where empName='Ramesh';");
ResultSet rs=stm.executeQuery();
System .out.println("Employee Name:"+rs.getString(1)+"\t"+"Salary:"+rs.getDouble(3));
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException ce)
{
ce.printStackTrace();
}
}
}
class Exp11_4
{
public static void main (String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:EMPDSN");
PreparedStatement stm=conn.prepareStatement("select * from EmpMaster where empName='Ramesh';");
ResultSet rs=stm.executeQuery();
System .out.println("Employee Name:"+rs.getString(1)+"\t"+"Salary:"+rs.getDouble(3));
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(ClassNotFoundException ce)
{
ce.printStackTrace();
}
}
}