import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ShowDeptServlet extends HttpServlet {
public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String URL = "jdbc:oracle:thin:system/nacira@nacira:1521:razek";
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
Connection con = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL, "system", "nacira");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(
"select"
+ " d.deptdesc as DEPTNAME,"
+ " e.fname as FNAME,"
+ " e.lname as LNAME, "
+ " e.title as TITLE,"
+ " e.email as EMAIL"
+ " from departements d, employes e"
+ " where d.deptMgrNo = e.empno"
+ " order by DEPTNAME"
);
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Responsable des departements</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<H2>Responsable des departements</H2>");
out.println("<DL>");
while (rs.next()){
String deptName = rs.getString(1);
String firstName = rs.getString(2);
String lastName = rs.getString(3);
String title = rs.getString(4);
String email = rs.getString(5);
out.println("<DT><B>"+ deptName +"</B></DT>");
out.println("<DD>"+ firstName + " " + lastName + ", " + title + "<BR>");
out.println(" " + email + "<BR>");
out.println("</DD>");
}
out.println("</DL>");
out.println("</BODY>");
out.println("</HTML>");
}
catch (Exception e) {
e.printStackTrace(new PrintWriter(out));
}
finally {
if (con != null){
try {
con.close();
}
catch (SQLException ignore){}
}
}
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
Mar 7 Mar à 18:24
