jiesuan.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.*"%>
<%! float sum; %>
<%!    
        String Name;
        String Address;
		String Zip;
	String Phone;
	String Email;
	String fangshi;
	
		String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String ConnStr="jdbc:odbc:zhuce";
%>
<%
    Name=request.getParameter("Name");
	Address=request.getParameter("Address");
	Zip=request.getParameter("Zip");
	Phone=request.getParameter("Phone");
	Email=request.getParameter("Email");
	fangshi=request.getParameter("fangshi");
	
	if(Name.equals("")||Address.equals("")||fangshi.equals(""))
		{
		out.println("带*为必填项,请您重新填写,谢谢!<p>您将在3秒钟后返回注册页");
		response.setHeader("Refresh","3;URL=jiesuan.htm");
		return;
	}
	
   
String sql="insert into xinxi(Name,Address,Zip,Phone,Email,fangshi) values ('"+Name+"','"+Address+"','"+Zip+"','"+Phone+"','"+Email+"','"+fangshi+"')";

	try	
		{
			Class.forName(DBDriver);//加载JDBC驱动程序
		}
	catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("database:"+e.getMessage());
			out.println("驱动没有加载");
		}

	try
		{
			Connection conn=DriverManager.getConnection(ConnStr," "," ");
			
			Statement stmt=conn.createStatement();

			stmt.executeUpdate(sql);
			
			
			stmt.close();
			conn.close();
		}
	catch(SQLException e)
		{
			System.err.println("executeUpdate:"+e.getMessage());
			out.println("数据没有写入");
		}

    %>
<div align="center"><font color="#FF9900" size="4" face="隶书">购买成功，以下是您的商品信息，我们将把您购买的产品送到以下地址:</font></p> 
</div>
<div align="center"> <font color="#FF9900">
  <%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:zhuce";
Connection con=DriverManager.getConnection(url,"","");
Statement st= con.createStatement();
String strSql="select * from xinxi where Name='"+Name+"'";
st.executeQuery(strSql);
ResultSet rs=st.executeQuery(strSql);
if(rs.next())

%>
  <img src="im/image018.gif" width="26" height="17"> </font></div>
<table width="59%" height="102" border="1" align="center" bordercolor="#b8d8f8">
  <tr> 
    <td height="33" align="left" valign="middle" bordercolor="#B8D8F8"><div align="left"><font color="#FF9900">收货人姓名： 
        <%out.print(rs.getString("Name"));%>
        </font></div></td>
  </tr>
  <tr> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#FF9900">收货人地址： 
        <%out.print(rs.getString("Address"));%>
        &nbsp;</font></div></td>
  </tr>
  <tr> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#FF9900">邮政编码： 
        <%out.print(rs.getString("Zip"));%>
        &nbsp;</font></div></td>
  </tr>
  <tr> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#FF9900">联系电话: 
        <%out.print(rs.getString("Phone"));%>
        &nbsp;</font></div></td>
  </tr>
  <tr> 
    <td height="34" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#FF9900">电子邮箱： 
        <%out.print(rs.getString("Email"));%>
        &nbsp;</font></div></td>
  </tr>
  <tr> 
    <td height="35" align="center" valign="middle" bordercolor="#B8D8F8"> <div align="left"><font color="#FF9900">付款方式： 
        <%out.print(rs.getString("fangshi"));%>
        &nbsp;&lt;收&gt;</font></div></td>
  </tr>
</table>

  <p align="center">&nbsp; </p>
<div align="center">
  <%Statement aa= con.createStatement();
String str1="select * from cart";
st.executeQuery(str1);
ResultSet rs1=aa.executeQuery(str1);
sum=0;
while(rs1.next())
{
  %>
  <table width="75%" border="1" align="center" bordercolor="b8d8f8">
    <tr> 
      <td width="50%"><font color="#FF9900">物品：</font></td>
      <td width="50%"><font color="#FF9900">价格：</font></td>
    </tr>
    <tr> 
      <td><font color="#FF9900"> 
        <%out.print(rs1.getString("product_name"));%>
        </font></td>
      <td><font color="#FF9900">&nbsp; 
        <%//out.print(rs1.getString("jiage"));
		 String sf=rs1.getString("p_newprice");
		 out.print(sf);
		 float s=Float.parseFloat(sf);
		  sum=sum+s;
		%>
        </font></td>
    </tr>
  </table>
</div>
<%}
rs1.close();
aa.close();
out.println("<center><font color=#ff9900>总价格为："+sum+"</font></center><br>");
%>
<p align="center"><font color="#FF9900"> 
  <%
Statement ss= con.createStatement();
String Sql="delete from cart";
ss.executeUpdate(Sql);
//rs.close();
//st.close();
%>
  <font size="7" face="隶书">欢迎下次光临本网站！</font></font></p>
<p align="center"><a href="../index.jsp"><font color="#FF9900" size="3" face="Kai">返回主页</font></a></p>
<p>&nbsp;</p>
<p>&nbsp; </p>
</BODY>
</HTML>