📄 feedbackservlet.java
字号:
package vote;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class feedbackServlet 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><title>feedbackServlet</title></head>"); out.println("<body>"); out.println("<p>The servlet has received a GET. This is the reply.</p>"); out.println("</body></html>"); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); //将信息存储在表voter中 String candidate,voterName,voterCompany,voterCountry,ipAdress; java.util.Date voteTime; candidate=request.getParameter("candidate"); voterName=request.getParameter("voter"); voterCompany=request.getParameter("company"); voterCountry=request.getParameter("country"); ipAdress=request.getRemoteAddr(); voteTime=new java.util.Date(); String voter_sql; voter_sql="insert into voter(candidate,voter_name,voter_company,voter_country,"; voter_sql=voter_sql+"ip_address,vote_time) values('"+candidate+"','"+voterName; voter_sql=voter_sql+"','"+voterCompany+"','"+voterCountry+"','"+ipAdress; voter_sql=voter_sql+"','"+voteTime.toLocaleString()+"')"; try { executeQuery(voter_sql); } catch(Exception e1) { out.println(e1.getMessage()); } //将表result中的票数增加 int voteNum; String result_sql; result_sql="update result set vote_num=vote_num+1 where "; result_sql=result_sql+" candidate='"+candidate+"'"; try { executeQuery(result_sql); } catch(Exception e2) { out.println(e2.getMessage()); } out.println("<html>"); out.println("<head>"); out.println("<title>"); out.println("投票系统"); out.println("</title>"); out.println("<meta content=\"text/html; charset=gb_2312-80\" http-equiv=\"Content-Type\">"); out.println("<meta content=\"blueriver\" name=\"Author\">"); out.println("</head>"); out.println("<BODY>"); out.println("<P align=center><FONT "); out.println("size=5>谢谢你，"+voterName); out.println("<br>"); out.println("您的投票已经被提交.</FONT></P>"); out.println("<hr>"); out.println("<DIV align=center>"); out.println("<a href=\"vote.showServlet\" target=_blank>查看当前投票情况</a><br>"); out.println("<a href=\"vote.voteServlet\">返回</a>"); 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 + -