import java.sql.*;

public class statemetn2 {

    public static void main(String[] args) throws Exception{
        // TODO Auto-generated method stub
        String JDBCDrivers = "oracle.jdbc.driver.OracleDriver";
        String useThisDriver_url = "jdbc:oracle:thin:@localhost:1521:xe";

        Class.forName(JDBCDrivers);
        Connection con = DriverManager.getConnection(useThisDriver_url,"user08","1111");
        PreparedStatement pstmt = con.prepareStatement("SELECT * from EMP2 where EMPNO=?");
        pstmt.setString(1,"7001");
        ResultSet rs = pstmt.executeQuery();
        while(rs.next()){
            String col1 = rs.getString(1);
            String col2 = rs.getString(2);
            System.out.print("EMPNO: " + col1 );
            System.out.print("\tEMPNAME:  " + col2);
        }
        rs.close(); stmt.close(); con.close();
    }

}