📄 savedata.jsp
字号:
<html>
<title>送出信息</title>
<body>
<%@page contentType = "text/html;charset=GB2312"
import = "java.sql.*"
%>
<%
String name = (String)session.getValue("name");
String pay=new String(request.getParameter("pay").getBytes("ISO-8859-1"));
String address =new String(request.getParameter("address").getBytes("ISO-8859-1"));
String receive = new String(request.getParameter("receive").getBytes("ISO-8859-1"));
String orderlist = new String(request.getParameter("orderlist").getBytes("ISO-8859-1"));
String account = request.getParameter("account");
String month = request.getParameter("month");
String day = request.getParameter("day");
String date = month + "月" + day +"日"; //组成日期字符串
if(address.equals("")) //送货地址为空
{
out.println("<center><h1>错误信息</h1><hr>");
out.println("<font color='red' size='5'>请输入送货地点</font><hr>");
out.println("<input type='button' value='回上一页' onclick='history.back()'>");
}
else if(receive.equals("")) //收货人为空
{
out.println("<center><h1>错误信息</h1><hr>");
out.println("<font color='red' size='5'>请输入收货人!</font><hr>");
out.println("<input type='button' value='回上一页' onclick='history.back()'>");
}
else
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:flower");
Statement smt =con.createStatement();
String sql;
out.println("<center><h1>谢谢惠顾</h1><hr>");
out.println("<font color='green' size='5'>已经成功地接受您的订单!</font><hr>");
sql="insert into orderlist(订货人,付款方式,送货地点,收货人,送货日期,订购花卉,价钱) values ('"+name+"','"+pay+"','"+address+"','"+receive+"','"+date+"','"+orderlist+"','"+account+"')";
smt.execute(sql);
con.close();
}
%>
<a href="enter.jsp">离开花店</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -