现在的错误是java.sql.SQLException: No data found 可是我的数据库里面明明是有数据的呀 这到底是为什么 请指教 什么叫做循环取值呀?
sql="select * from TB_SHUKKADT,TB_HINMOKUMST,TB_HENPINRIREKI where TB_SHUKKADT.HINCD=\'"+HINCD+"\'and TB_SHUKKADT.SZCD=TB_HINMOKUMST.SZCD and TB_SHUKKADT.SZCD=TB_HENPINRIREKI.SZCD"; 就是这句 涉及到多表查询的问题
String sql=""; ResultSet rs; if(HINCD!=null){ if(!HINCD.equals("")){ sql="select * from TB_SHUKKADT,TB_HINMOKUMST,TB_HENPINRIREKI where TB_SHUKKADT.HINCD=\'"+HINCD+"\'and TB_SHUKKADT.SZCD=TB_HINMOKUMST.SZCD and TB_SHUKKADT.SZCD=TB_HENPINRIREKI.SZCD"; }else if(!HINCD.equals("")){ sql="select * from TB_HINMOKUMST where HINCD=\'"+HINCD+"\'"; }else if(!HINNM.equals("")){ sql="select * from TB_HINMOKUMST where HINNM=\'"+HINNM+"\'"; }else if(!SZCD.equals("")){ sql="select * from TB_HINMOKUMST where SZCD=\'"+SZCD+"\'"; }else if(!CLRCD.equals("")){ sql="select * from TB_HINMOKUMST where CLRCD=\'"+CLRCD+"\'"; }else if(!SHUKKATANKA.equals("")){ sql="select * from TB_HINMOKUMST where SIIRETANKA="+SIIRETANKA+""; }else if(!SHUKKASU.equals("")){ sql="select * from TB_SHUKKADT where SHUKKASU="+SHUKKASU+""; }else if(!SHUKKASU.equals("")){ sql="select * from TB_HENPINRIREKI where HENPINSU="+HENPINSU+""; } rs=stmt.executeQuery(sql); int alltemp1=0; int alltemp2=0; int alltemp=0; %> <form method="post" action=""> <table width="800" border="1" cellspacing="0" cellpadding="2"> <%while(rs.next()){%> <tr> <td width="52" align="center"><%=rs.getString("HINCD")%></td> <td width="52" align="center"><%=rs.getString("HINNM")%></td> <td width="52" align="center"><%=rs.getString("SZCD")%></td> <td width="52" align="center"><%=rs.getString("CLRCD")%></td> <td width="52" align="center"><%=rs.getString("SIIRETANKA")%></td> <td width="52" align="center"><%=rs.getString("SHUKKASU")%></td> <td width="52" align="center"><%=rs.getString("HENPINSU")%></td>
<% int temp1=rs.getInt("SIIRETANKA"); int temp2=rs.getInt("HENPINSU"); int temp=temp1*temp2; %> <td width="52" align="center"><%=rs.getString("TEMP")%></td>
sql="select * from TB_SHUKKADT,TB_HINMOKUMST,TB_HENPINRIREKI where TB_SHUKKADT.HINCD=\'"+HINCD+"\'and TB_SHUKKADT.SZCD=TB_HINMOKUMST.SZCD and TB_SHUKKADT.SZCD=TB_HENPINRIREKI.SZCD"; 就是这个代码的错误 您们给看看好吗? HINCD 和SZCD都是文本型的
可是我的数据库里面明明是有数据的呀
这到底是为什么 请指教
什么叫做循环取值呀?
就是这句 涉及到多表查询的问题
多贴一点代码
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=shift_jis"%>
<html lang="ja">
<head>
<title>峲恀捠彜斕攧僔僗僥儉</title>
<meta name="author" contents="KBW Corporation">
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<meta http-equiv="Content-Style-Type" content="text/css">
<meta HTTP-EQUIV="content-script-type" CONTENT="text/javascript">
<meta name="robots" content="index,follow">
<link href="../css/base.css" rel="Stylesheet" type="text/css">
<style type="text/css">
<!---->
</style> </head> <body bgcolor="#FFFFFF" text="#000000" topmargin="0" marginheight="0" leftmargin="10" marginwidth="10">
<div align="center">
<div class="contMain">
<%
//打开?#65533;据縼E
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\\kosin.mdb";
String user="sa";
String password="psa";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//获取柄靴参?#65533;
String SHUKKANO=request.getParameter("SHUKKANO");
String SHUKKAFUKUNO=request.getParameter("SHUKKAFUKUNO");
String HENPINYMD=request.getParameter("HENPINYMD");
String NOUNYUCD=request.getParameter("NOUNYUCD");
String TOKUICD=request.getParameter("TOKUICD");
String SHUKKAYMD=request.getParameter("SHUKKAYMD");
String EIGYOMANCD=request.getParameter("EIGYOMANCD");
String SAIBANNO=request.getParameter("SAIBANNO");
String HINCD=request.getParameter("HINCD");
String HINNM=request.getParameter("HINNM");
String SZCD=request.getParameter("SZCD");
String CLRCD=request.getParameter("CLRCD");
String SHUKKASU=request.getParameter("SHUKKASU");
String SHUKKATANKA=request.getParameter("SHUKKATANKA");
String HENPINSU=request.getParameter("HENPINSU");
String SIIRETANKA=request.getParameter("SIIRETANKA");
String sql="";
ResultSet rs;
if(HINCD!=null){
if(!HINCD.equals("")){
sql="select * from TB_SHUKKADT,TB_HINMOKUMST,TB_HENPINRIREKI where TB_SHUKKADT.HINCD=\'"+HINCD+"\'and TB_SHUKKADT.SZCD=TB_HINMOKUMST.SZCD and TB_SHUKKADT.SZCD=TB_HENPINRIREKI.SZCD";
}else if(!HINCD.equals("")){
sql="select * from TB_HINMOKUMST where HINCD=\'"+HINCD+"\'";
}else if(!HINNM.equals("")){
sql="select * from TB_HINMOKUMST where HINNM=\'"+HINNM+"\'";
}else if(!SZCD.equals("")){
sql="select * from TB_HINMOKUMST where SZCD=\'"+SZCD+"\'";
}else if(!CLRCD.equals("")){
sql="select * from TB_HINMOKUMST where CLRCD=\'"+CLRCD+"\'";
}else if(!SHUKKATANKA.equals("")){
sql="select * from TB_HINMOKUMST where SIIRETANKA="+SIIRETANKA+"";
}else if(!SHUKKASU.equals("")){
sql="select * from TB_SHUKKADT where SHUKKASU="+SHUKKASU+"";
}else if(!SHUKKASU.equals("")){
sql="select * from TB_HENPINRIREKI where HENPINSU="+HENPINSU+"";
}
rs=stmt.executeQuery(sql);
int alltemp1=0;
int alltemp2=0;
int alltemp=0;
%>
<form method="post" action="">
<table width="800" border="1" cellspacing="0" cellpadding="2">
<%while(rs.next()){%>
<tr>
<td width="52" align="center"><%=rs.getString("HINCD")%></td>
<td width="52" align="center"><%=rs.getString("HINNM")%></td>
<td width="52" align="center"><%=rs.getString("SZCD")%></td>
<td width="52" align="center"><%=rs.getString("CLRCD")%></td>
<td width="52" align="center"><%=rs.getString("SIIRETANKA")%></td>
<td width="52" align="center"><%=rs.getString("SHUKKASU")%></td>
<td width="52" align="center"><%=rs.getString("HENPINSU")%></td>
<%
int temp1=rs.getInt("SIIRETANKA");
int temp2=rs.getInt("HENPINSU");
int temp=temp1*temp2;
%>
<td width="52" align="center"><%=rs.getString("TEMP")%></td>
</tr>
<%}%>
<tr>
<td width="52" align="center"> 丂</td>
<td width="66" align="center"> 丂</td>
<td width="48" align="center"> 丂</td>
<td width="90" align="center"> 丂</td>
<td width="120" align="center"> 丂</td>
<td width="60" align="center"> 丂</td>
<td width="60" align="center"><%=alltemp1%>丂</td>
<td width="60" align="center"><%=alltemp2%>丂</td>
<td width="60" align="center"><%=alltemp%>丂</td>
</tr>
</table>
</form> <%
}
%>
</div>
</div>
</body>
</html>
这是所有的代码
就是这个代码的错误 您们给看看好吗?
HINCD 和SZCD都是文本型的