leavewords.java
来自「JAVA数据库编程实例随书源码」· Java 代码 · 共 74 行
JAVA
74 行
import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.sql.*;public class LeaveWords extends HttpServlet {public void init() throws ServletException {} protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException { java.io.PrintWriter out=new java.io.PrintWriter(response.getOutputStream()); out.print("<html>"); out.print("<head><title>保存留言</title></head>"); out.print("<body>"); out.print("<center><h3>谢谢留言</h3></center>"); out.print("<hr>"); out.print("<h4>留言信息</h4>"); String getDate=new java.util.Date().toString(); String getName=request.getParameter("cName"); String getEmail=request.getParameter("cEmail"); String getWords=request.getParameter("cWords"); String getTopic=request.getParameter("cTopic"); if(getName.length()<1){ //检查客户的留言信息是否完整 out.print("请输入姓名"); }else{ if(getEmail.length()<3){ out.print("请输入正确的Email地址"); } else{ if(getTopic.length()<1){ out.print("请输入主题"); } else{ if(getWords.length()<1){ out.print("没有留言"); } else{ //客户输入完整的信息则响应 在HTML中让客户看到自己的留言 out.print("<table>"); out.print("<tr><td align=\"right\">姓名：</td><td>"); out.print(getName); out.print("</td></tr>"); out.print("<tr><td align=\"right\">Email地址：</td><td>"); out.print(getEmail); out.print("</td></tr>"); out.print("<tr><td align=\"right\">主题：</td><td>"); out.print(getTopic); out.print("</td></tr>"); out.print("<tr><td valign=\"top\" align=\"right\">留言：</td><td>"); out.print(getWords); out.print("</td></tr>"); out.print("<tr><td align=\"right\">日期：</td><td>"); out.print(getDate); out.print("</td></tr></table>"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn=DriverManager.getConnection("jdbc:odbc:words"); String str="INSERT INTO words VALUES('"; String data=getName+"','"+getDate+"','"+getEmail+"','"+getTopic+"','"+getWords+"')"; Statement st=cn.createStatement(); st.executeUpdate(str+data); st.close(); cn.close(); out.print("<center><h3>成功保存留言<h3></center>"); } catch(Exception e){ out.print(e.getMessage()); } }}}} out.print("<hr>"); //输出响应HTML文件的尾部信息 out.print("<form name=\"displayform\" action=\"/test/servlet/DisplayWords\" method=\"POST\">"); out.print("<input type=\"submit\" name=\"action\" value=\"查看留言\">"); out.print("</form>"); out.print("</body></html>"); out.flush(); }}⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?