dingdan.jsp

jsp时间的一些小例子

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@page import="java.sql.*"%>
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*" import="java.text.SimpleDateFormat" import="java.util.Date"%>
<title>用户结算</title>
<%! float sum; %>
<%   
    String name=request.getParameter("name");
	String dizhi=request.getParameter("dizhi");
	String youbian=request.getParameter("youbian");
	String dianhua=request.getParameter("dianhua");
	String email=request.getParameter("email");
	String fukuan=request.getParameter("fukuan");
	if(name.equals("")||dizhi.equals("")||youbian.equals("")||dianhua.equals("")||email.equals(""))
	{
	out.println("带*为必填项,请您重新填写,谢谢!<p>您将在3秒钟后返回");
	response.setHeader("Refresh","3;URL=dingdan.htm");
	return;
	}
	else if(dianhua.length()>16||dianhua.length()<8)//password.length()>10||password.length()<6
	{
	out.print("请重新输入,电话号码位数不对<font color=#FF0000>8~16</font>");
	 response.setHeader("Refresh","3;URl=dingdan.htm");
	return;
	}
	else if(email.indexOf('@')<0&&email.indexOf('.')<0)
	{
	out.print("邮件格式不对，请重新输入邮件地址！");
	 response.setHeader("Refresh","3;URl=dingdan.htm");
	return;
	}
                   request.getSession(true);
		           session.putValue("name",name);//把用户填写的信息写入Session
				   session.putValue("dizhi",dizhi);
				   session.putValue("youbian",youbian);
				   session.putValue("dianhua",dianhua);
				   session.putValue("email",email);
				   session.putValue("fukuan",fukuan);
 %>
<style type="text/css">
<!--
.style1 {font-size: 16px}
.style12 {font-size: 24px}
.style14 {font-size: 16px; color: #333333; }
-->
</style>

<div align="center">
  <p>&nbsp;</p>
  <p><font color="#FF0000" size="4" face="隶书">购买成功，以下是您的商品信息，我们将把您购买的产品送到以下地址
    
:</font><font color="#FF0000">
  </p>
</div>
<div align="center"> <font color="#0080FF">
</font></div>
<table width="48%" height="260" border="1" align="center" bordercolor="#b8d8f8">
  <tr>
    <td width="52%" align="left" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">收货人姓名： 

</font></div></td> 
    <td width="48%" height="33" align="left" valign="middle" bordercolor="#B8D8F8"><div align="left"><font color="#0080FF">
      <%=session.getValue("name")%>
        </font></div></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">收货人地址： 

</font></div></td> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#0080FF">
      <%=session.getValue("dizhi")%>
        &nbsp;</font></div></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">邮政编码： 

</font></div></td> 
    <td height="23" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#0080FF">
      <%=session.getValue("youbian")%>
    &nbsp;</font></div></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">联系电话: 

</font></div></td> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#0080FF">
     <%=session.getValue("dianhua")%>
        &nbsp;</font></div></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">电子邮箱： 

</font></div></td> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#0080FF">
      <%=session.getValue("email")%>
        &nbsp;</font></div></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bordercolor="#B8D8F8"><div align="right"><font color="#FF33CC">付款方式：

</font></div></td> 
    <td height="35" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#0080FF">
      <%=session.getValue("fukuan")%>
&nbsp;&lt;收&gt; </font></div></td>
  </tr>
</table> 
<p>
  <%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String url="jdbc:odbc:c";
  Connection con=DriverManager.getConnection(url,"sa","123"); 
  Statement aa=con.createStatement();
  String str1="select * from buy";
  ResultSet rs1=aa.executeQuery(str1);
  sum=0;
  while(rs1.next())
  {String xinghao=rs1.getString("xinghao");
   String maijia=rs1.getString("maijia");
   String didian=rs1.getString("didian");
   String jiage=rs1.getString("jiage");
   String nu=rs1.getString("nu");
   String slk="";
   slk+="产品型号:"+xinghao+"|买家："+maijia+"|地点:"+didian+"|价格:"+jiage+"|数量:"+nu+"";//把信息集中到一个字段中
    float s=Float.parseFloat(jiage);//字符型转成浮点型数据
	float z=Float.parseFloat(nu);
	s=s*z;
	sum=sum+s;//核算产品总和
	String jj=String.valueOf(sum);
	request.getSession(true);
	session.putValue("jj",jj);
    session.putValue("slk",slk);
  %> 
</p>
<table width="523" height="59" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#66CCCC">
  <tr>
    <td width="98"><div align="center">产品型号</div></td>
    <td width="232"><div align="center">买家</div></td>
	<td width="232"><div align="center">地点</div></td>
    <td width="106"><div align="center">价格</div></td>
    <td width="77"><div align="center">数量</div></td>
  </tr>
  <tr>
    <td><div align="center"><%=xinghao%></div></td>
    <td><div align="left"><%=maijia%></div></td>
	<td><div align="center"><%=didian%></div></td>
    <td><div align="center"><%=jiage%></div></td>
    <td><div align="center"><%=nu%></div></td>
  </tr>
</table>
<%}
rs1.close();
aa.close();
%>
<%out.println("<center>总和是:"+sum+"元</center><br>");%>
<%	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");//创建日期对象，日期格式是yyyy-MM-dd
	String riqi=sdf.format(new Date());//日期型转为字符型
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String str="jdbc:odbc:c";
  Connection conn=DriverManager.getConnection(str,"sa","123");
  Statement stt=conn.createStatement();
  String ssql="insert into dingdan(name,dizhi,youbian,dianhua,email,fukuan,xinxi,riqi,zonghe) values ('"+session.getValue("name")+"','"+session.getValue("dizhi")+"','"+session.getValue("youbian")+"','"+session.getValue("dianhua")+"','"+session.getValue("email")+"','"+session.getValue("fukuan")+"','"+session.getValue("slk")+"','"+riqi+"','"+session.getValue("jj")+"')"; 
  stt.executeUpdate(ssql);
  stt.close();
  conn.close();
  %>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String stra="jdbc:odbc:c";

  Connection cons=DriverManager.getConnection(stra,"sa","123");
  Statement sts=cons.createStatement();
  String Sql="delete from buy";//生成订单后就会删除购物车表里的信息
  sts.executeUpdate(Sql);
  sts.close();
  cons.close();
%>
<hr size="1" class="style12">
<p align="center" class="style12">&nbsp;</p>
<p class="style14">&nbsp;</p>
</BODY>
</HTML>