📄 showservlet.java

📁 jsp 应用开发详解源代码电子工业出版社包含书中个源代码
💻 JAVA
字号:
package vote;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class showServlet extends HttpServlet {  private static final String CONTENT_TYPE = "text/html; charset=GBK";  /**Initialize global variables*/  public void init() throws ServletException {    String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";    try {      Class.forName(sDBDriver);    }    catch(java.lang.ClassNotFoundException e) {      System.err.println( e.getMessage());    }  }  public ResultSet executeQuery(String sql) {    String sConnStr = "jdbc:odbc:vote";    Connection connect = null;    ResultSet rs = null;    rs = null;    try {      connect = DriverManager.getConnection(sConnStr);      Statement stmt = connect.createStatement();      rs = stmt.executeQuery(sql);    }    catch(SQLException ex) {      System.err.println(ex.getMessage());    }    return rs;  }  public String getStr(String str)  {	try	{		String temp_p=str;		byte[] temp_t=temp_p.getBytes("ISO8859-1");		String temp=new String(temp_t);		return temp;	}	catch(Exception e)	{	}	return "null";  }  /**Process the HTTP Get request*/  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {    response.setContentType(CONTENT_TYPE);    PrintWriter out = response.getWriter();    out.println("<html>");    out.println("<head>");    out.println("<title>当前票数统计</title>");    out.println("<meta content=\"text/html; charset=gb_2312-80\" http-equiv=\"Content-Type\">");    out.println("<meta content=\"blueriver\" name=\"Author\">");    out.println("<meta http-equiv=\"refresh\" content=\"10\"></head>");    out.println("");    out.println("<body bgcolor=\"#FFFFFF\">");    out.println("<div align=\"center\">");    out.println("  <h1><b>当前票数统计</b> </h1>");    out.println("  <table width=\"60%\" border=\"1\">");    out.println("    <tr bgcolor=\"#CCCCFF\"> ");    out.println("      <td width=\"51%\"> ");    out.println("        <div align=\"center\"><font color=\"#FF0033\"><b>候选公司名</b></font></div>");    out.println("      </td>");    out.println("      <td width=\"49%\"> ");    out.println("        <div align=\"center\"><font color=\"#FF0033\"><b>当前票数</b></font></div>");    out.println("      </td>");    out.println("    </tr>");    ResultSet RS_result;    RS_result=executeQuery("select * from result order by vote_num desc");    String companyName;    int voteNum;    try{    while(RS_result.next())    {      companyName=RS_result.getString("candidate");      voteNum=RS_result.getInt("vote_num");      out.println("    <tr>");      out.println("      <td width=\"51%\" bgcolor=\"#FFFFFF\">");      out.println("        <div align=\"center\">");      out.println(companyName);      out.println("</div>");      out.println("      </td>");      out.println("      <td width=\"49%\">");      out.println("        <div align=\"center\">");      out.println(voteNum);      out.println("</div>");      out.println("      </td>");      out.println("    </tr>");  }  RS_result.close();  }catch(Exception exc)  {    System.err.println(exc.getMessage());  }  out.println("  </table>");  out.println("  <hr align=\"center\">");  out.println("  <h2><b>投票人的详细资料</b> </h2>");  out.println("  <table width=\"100%\" border=\"1\">");  out.println("    <tr bgcolor=\"#FFCCCC\">");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票的公司</b></font></div>");  out.println("      </td>");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票人姓名</b></font></div>");  out.println("      </td>");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票人所在公司</b></font></div>");  out.println("      </td>");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票人所在国家</b></font></div>");  out.println("      </td>");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票人的IP地址</b></font></div>");  out.println("      </td>");  out.println("      <td>");  out.println("        <div align=\"center\"><font color=\"#0000FF\"><b>投票时间</b></font></div>");  out.println("      </td>");  out.println("    </tr>");  ResultSet RS_voter;  RS_voter=executeQuery("select * from voter order by vote_time desc");  String candidate,voterName,voterCompany,voterCountry,ipAdress;  java.util.Date voteTime;  try{  while(RS_voter.next())  {    candidate=RS_voter.getString("candidate");    voterName=RS_voter.getString("voter_name");    voterCompany=RS_voter.getString("voter_company");    voterCountry=RS_voter.getString("voter_country");    ipAdress=RS_voter.getString("ip_address");    voteTime=RS_voter.getDate("vote_time");    out.println("<tr>");    out.println("      <td>&nbsp;"+candidate+"</td>");    out.println("      <td>&nbsp;"+voterName+"</td>");    out.println("      <td>&nbsp;"+voterCompany+"</td>");    out.println("      <td>&nbsp;"+voterCountry+"</td>");    out.println("      <td>&nbsp;"+ipAdress+"</td>");    out.println("      <td>&nbsp;"+voteTime+"</td>");    out.println("    </tr>");  }  RS_voter.close();  }catch(Exception exc2)  {    System.err.println(exc2.getMessage());  }  out.println("  </table>");  out.println("  <p>&nbsp;</p>");  out.println("</div>");  out.println("</body>");  out.println("</html>");  }  /**Clean up resources*/  public void destroy() {  }}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -