=============
sellinfo.jsp中的代码=============
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.io.*"import="java.sql.*" %>
<jsp:useBean id="cinfo" scope="page" class="web.DBConnect" /><html>
<head>
<title> 销售信息一览 </title>
</head>
<body>
<br>
<font size=5><center><b>销售情况一览表(价格单位:元)</b></center></font><br>
<table width="100%" border="1" cellspacing="5" cellpadding="0" align=center>
<%
String temp=null,name=null,name1,name2,color,date,sql1,sql2,money;
int cbuy,count=0;
float price;
ResultSet rs;
sql1 = "select * from client ";
sql2 = "select * from creturn ";
%>
<tr>
<td width="10%"><div align="center">销售日期</div></td>
<td width="10%"><div align="center">客户名称</div></td>
<td width="10%"><div align="center">商品名称</div></td>
<td width="10%"><div align="center">商品颜色</div></td>
<td width="10%"><div align="center">商品数量</div></td>
<td width="10%"><div align="center">商品价格</div></td>
<td width="10%"><div align="center">销售金额</div></td>
</tr>
<tr><td><div align="center">销售详单</div></td></tr>
<%
rs = cinfo.executeQuery(sql1);
while(rs.next())
{
date = rs.getString(7);
name1 = rs.getString(2);
name2 = rs.getString(3);
color = rs.getString(4);
cbuy = rs.getInt(5);
price = rs.getFloat(6);
money = rs.getString(8);
if(count==0)
{
temp=date;name=name1;count++;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%
}else if(date.equals(temp)==true&&name1.equals(name)==true)
{temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else if(date.equals(temp)==true&&name1.equals(name)==false)
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}
}
cinfo.close();
%>
<tr><td><div align="center">返货详单</div></td></tr>
<%
rs = cinfo.executeQuery(sql2);
while(rs.next())
{
date = rs.getString(7);
name1 = rs.getString(2);
name2 = rs.getString(3);
color = rs.getString(4);
cbuy = rs.getInt(5);
price = rs.getFloat(6);
money = rs.getString(8);
if(count==0)
{
temp=date;name=name1;count++;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%
}else if(date.equals(temp)==true&&name1.equals(name)==true)
{temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else if(date.equals(temp)==true&&name1.equals(name)==false)
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}
}
cinfo.close();
%>
</table>
</body>
</html>
sellinfo.jsp中的代码=============
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.io.*"import="java.sql.*" %>
<jsp:useBean id="cinfo" scope="page" class="web.DBConnect" /><html>
<head>
<title> 销售信息一览 </title>
</head>
<body>
<br>
<font size=5><center><b>销售情况一览表(价格单位:元)</b></center></font><br>
<table width="100%" border="1" cellspacing="5" cellpadding="0" align=center>
<%
String temp=null,name=null,name1,name2,color,date,sql1,sql2,money;
int cbuy,count=0;
float price;
ResultSet rs;
sql1 = "select * from client ";
sql2 = "select * from creturn ";
%>
<tr>
<td width="10%"><div align="center">销售日期</div></td>
<td width="10%"><div align="center">客户名称</div></td>
<td width="10%"><div align="center">商品名称</div></td>
<td width="10%"><div align="center">商品颜色</div></td>
<td width="10%"><div align="center">商品数量</div></td>
<td width="10%"><div align="center">商品价格</div></td>
<td width="10%"><div align="center">销售金额</div></td>
</tr>
<tr><td><div align="center">销售详单</div></td></tr>
<%
rs = cinfo.executeQuery(sql1);
while(rs.next())
{
date = rs.getString(7);
name1 = rs.getString(2);
name2 = rs.getString(3);
color = rs.getString(4);
cbuy = rs.getInt(5);
price = rs.getFloat(6);
money = rs.getString(8);
if(count==0)
{
temp=date;name=name1;count++;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%
}else if(date.equals(temp)==true&&name1.equals(name)==true)
{temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else if(date.equals(temp)==true&&name1.equals(name)==false)
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}
}
cinfo.close();
%>
<tr><td><div align="center">返货详单</div></td></tr>
<%
rs = cinfo.executeQuery(sql2);
while(rs.next())
{
date = rs.getString(7);
name1 = rs.getString(2);
name2 = rs.getString(3);
color = rs.getString(4);
cbuy = rs.getInt(5);
price = rs.getFloat(6);
money = rs.getString(8);
if(count==0)
{
temp=date;name=name1;count++;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%
}else if(date.equals(temp)==true&&name1.equals(name)==true)
{temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else if(date.equals(temp)==true&&name1.equals(name)==false)
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}else
{
temp=date;name=name1;
%>
<tr>
<td><div align="center"><%=date%></div></td>
<td><div align="center"><a href="cliqu.jsp?id=<%=name1%>"><font color="blue"><%=name1%></font></a></div></td>
<td><div align="center"><%=name2%></div></td>
<td><div align="center"><%=color%></div></td>
<td><div align="center"><%=cbuy%></div></td>
<td><div align="center"><%=price%></div></td>
<td><div align="center"><%=money%></div></td>
</tr>
<%}
}
cinfo.close();
%>
</table>
</body>
</html>
解决方案 »
- mysql join和inner join的区别
- struts2中 super,super.execute();是什么意思,怎么理解?
- 解析XML的工具类只能获取英文节点,不能获取中文节点
- 最近在学HTML5,想用HTML5做前台java后台,想求明白人给讲解下~
- tomcat6.0 域名设置问题
- Struts1.2页面提交信息,Action没有反应???
- jsp用什么开发工具写代码好
- 请各位网友解释javascript语句的作用(标号为1.2.3.4)
- 请教JAVA.WEB怎样才能融会贯通
- 急求linux 下Apa+tomcat+jdk的配置安装文件
- 项目中有两个jar文件里有相同名称的类怎么区分?
- 在线HTML编辑器图片上传回显的问题
cliqu.jsp中(String)request.getParameter("id");取得的英文可以正常得到,但是中文都是乱码啊?
个位帮帮忙!Thank you!!!
URLEncoder.encode (request.getParameter ("content").toString (),"UTF-8")
都不能解决
<%
request.setCharacterEncoding("GBK");
response.setContentType("text/html;charset=GBK");
% > 这个要是不好使的话加上这个
String 接收变量 = new String(((String)request.getParameter("参数")).getBytes("ISO8859-1"),"GBK");GBK是最高的 你也可以换成GB2312