GET TO KNOW WHO GOT PROMOTED

The management actively supports employee growth and to encourage individual abilities the management time to time reviews employee performance and those whose performance is found to be good are rewarded. The management is glad to announce the appraisals done in this month. <%@ page language="java" %> <%@ page import="java.sql.*, connection.DatabaseConnection" %> <% Connection con = null; try{ DatabaseConnection dbcon = new DatabaseConnection(); con = dbcon.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from promotion order by empname"); out.println("
    "); while(rs.next()){ String empname = rs.getString("empname"); String designation = rs.getString("designation"); out.println("
  • "+empname+" , "+designation+" "); } out.println("
"); }catch(Exception e){ out.println(e.getMessage()); } finally { con.close(); } %>