|
|
10.4.3 Servlet getcat.java
Acest servlet are ca rol de baza prezentarea catre client a unei liste de selectie cu categoriile de produse disponibile. Aceste categorii pot fi selectate deasemenea si dintr-o banda orizontala, situata deasupra listei de selectie, in care se deruleaza denumirile categoriilor, in plan orizontal. Aceasta derulare este realizata de applet-ul Newsticker, realizat de Gokhan Dagli. Dupa selectatea unei categorii, prin ajutorul unui JavaScript, se apeleaza servlet-ul alimb.java, care va fi afisat in cadranul din dreapta.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
public class getcat extends HttpServlet{
private Connection con;
private PrintWriter out;
public void init(ServletConfig conf)throws ServletException {
super.init(conf);
String Driver = getServletConfig().getInitParameter("driver");
String DataBase = getServletConfig().getInitParameter("database");
String User = getServletConfig().getInitParameter("username");
String Pass = getServletConfig().getInitParameter("password");
try{
Class.forName(Driver).newInstance();
con = DriverManager.getConnection(DataBase,User,Pass);
}catch(Exception e) {
System.err.println(e);
}
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
doGet(req,res);
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
HttpSession ses = req.getSession();
ses.setAttribute("connexion",con);
PrintWriter out = res.getWriter ();
String url = res.encodeURL("/adi/servlet/alimb");
out.println("<html>");
out.println("<head>");
out.println("<title>Pagina realizata de servlet-ul getcat</title>");
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">");
out.println("<META content=\"text/html; charset=windows-1252\" http-equiv=Content-Type>");
out.println("<LINK href=\"/adi/tli.css\" rel=STYLESHEET type=text/css>");
out.println("<META content=\"MSHTML 5.00.2614.3500\" name=GENERATOR>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
out.println("</head>");
out.println("<body bgcolor=\"#fff0f0\" link=\"675000\" vlink=\"340034\" alink=\"343546\">");
try{
Statement stmt = con.createStatement();
ResultSet rs;
out.println("<table width=\"260\" height=210 align=center>");
out.println("<tr><td align=left>");
out.println("<applet code=\"newsticker.class\" codebase=\"/adi/applets\" width=260 height=28>");
out.println("<param name=\"applet_width\" value=\"260\">");
out.println("<param name=\"applet_height\" value=\"28\">");
out.println("<param name=\"regcode\" value=\"\">");
out.println("<param name=\"info\" value=\"Applet by Gokhan Dagli\">");
out.println("<param name=\"bgcolor\" value=\"fff0f0\">");
out.println("<param name=\"fontcolor\" value=\"450000\">");
out.println("<param name=\"highlight_color\" value=\"f06020\">");
out.println("<param name=\"delay_time\" value=\"2000\">");
out.println("<param name=\"scroll_delay\" value=\"8\">");
out.println("<param name=\"scroll_jump\" value=\"3\">");
out.println("<param name=\"font_type\" value=\"Arial\">");
out.println("<param name=\"font_size\" value=\"16\">");
out.println("<param name=\"font_style\" value=\"1\">");
out.println("<param name=\"text_alignment\" value=\"center\">");
out.println("<param name=\"left_margin\" value=\"10\">");
rs = stmt.executeQuery("select * from categ order by cod");
int j=0;
while(rs.next()){
j++;
out.println("<param name=\"text" + j + "\" value=\"" + rs.getString(2) + "\" >");
out.println("<param name=\"link" + j + "\" value=\"http://localhost:8080"
+ url + "?cat=" + rs.getString(1) + "\">");
}
out.println("<param name=target_frame value=\"prod\">");
out.println("</applet>");
out.println("</td></tr>");
out.println("<tr><td align=left>");
out.println("<table width=\"100%\">");
out.println("<td align=left><form action=\"" + url + "\" target=\"prod\" method=\"post\"
name=view>");
out.println("<font color=450000 size=3>");
out.println("<b>Alege categoria:</b><br>");
out.println("</font>");
out.println("<SELECT name=\"cat\" onchange=do_reply();>");
out.println("<option value=0 selected >");
for(int i=0;i<9;i++)
out.println(" ");
out.println("</option>");
rs = stmt.executeQuery("select * from categ order by cod");
while(rs.next())
out.println("<option value=" + rs.getString(1) + ">" + rs.getString(2) + "</option>");
out.println("</select></form></td></table>");
rs.close();
out.println("</td></tr>");
out.println("<tr><td align=left valign=middle>");
out.println("<hr align=left color=301010 width=260>");
out.println("</td></tr>");
out.println("<tr><td width=260 align=left valign=middle>");
rs = stmt.executeQuery("select count(codc) from comenzi");
out.println("<font face=\"Arial\" size=1 color=919200>");
out.println(" Am primit <b>" + rs.getString(1) + "</b>
comenzii;");
out.println("</font>");
out.println("<font face=\"Arial\" size=2 color=f992200>");
out.println("<br> Noi suntem satisfacuti <b>!!!</b>");
out.println("</font>");
out.println("<font face=\"Arial\" size=3 color=519211>");
out.println("<br> Clientii nostri sunt satisfacuti");
out.println("</font>");
out.println("</td></tr>");
rs.close();stmt.close();
}
catch(SQLException e) {out.println("An SQL Exception was thrown.");}
out.println("<tr><td align=left valign=middle>");
out.println("<hr align=left color=301010 width=260>");
out.println("</td></tr>");
out.println("<tr><td align=left width=240 valign=top>");
out.println("<font face=\"Arial\" size=1 color=992299>Spatiu Publicitar</font>");
out.println("</td></tr>");
out.println("</table>");
// out.println("<table width=\"260\" height=350>");
// out.println("<tr><td width=\"260\" align=center valign=middle>");
out.println("<table width=\"240\" height=330 bgcolor=#fff0f0 align=center>");
out.println("<td width=\"240\" align=center valign=middle>");
//out.println("<table width=\"225\" height=310 bgcolor=#fff0f0>");
//out.println("<td class=box1 width=\"235\" align=center valign=middle>");
//out.println("<table width=\"220\" height=190 bgcolor=670000 bbb832>");
//out.println("<td class=box0 width=\"230\" align=center valign=middle>");
out.println("<table width=\"175\" height=170 bgcolor=760033>");
out.println("<td class=box3 width=\"175\" align=left >");
out.println("<img src=\"/adi/imagini/sy.gif\" width=175>");
out.println("</td></table>");
// out.println("</td></table>");
// out.println("</td></table>");
out.println("</td></table>");
// out.println("</td></tr><tr><td>");
out.println("<table width=\"260\" align=center>");
out.println("<td width=\"260\" align=center valign=middle><font face=Arial size=1>");
out.println("www.sahajayoga.org;");
out.println("</td></table>");
// out.println("</td></tr></table>");
out.println("</body></html>");
out.close();
}
public void destroy(){
try{
con.close();
}
catch(SQLException e) {;}
}
}
|
|
