我的JAVABEAN代码:package Photon.tr; import java.util.*; import java.sql.*; public class TdBean { private String strClientName=null; private String strSerialNumber=null; private String C_WHERE = " WHERE "; private String C_AND = " AND "; private String strSql;
public void setClientName(String ClientName ){ this.strClientName=ClientName; } public void setSerialNumber(String SerialNumber){
this.strSerialNumber=SerialNumber; } private Connection conn; public TdBean(){
this.conn=DataBase.getConnection();
} //查询数据信息。 public Collection getTd_CNRByTd_Transmission(String SerialNumber) throws Exception {
Statement stmt=conn.createStatement(); ResultSet rst=stmt.executeQuery("SELECT TestDataCNR.SerialNumber as a ,TestDataCNR.OSA_Number,TestDataCNR.ComputerName,TestDataCNR.DateTime,TestDataCNR.Tester,TestDataCNR.Channel_No,TestDataCNR.Temperature_C,TestDataCNR.Temperature_C,TestDataCNR.Voltage_V,TestDataCNR.OpticalPower_dBm,TestDataCNR.SeekCode,TestDataCNR.Level_dBmV," + "TestDataCNR.CSO_dBc,TestDataCNR.CTB_dBc,TestDataCNR.CNR_dBc,TestDataCNR.Re,TestDataTransmission.SerialNumber as b from TestDataCNR ,TestDataTransmission WHERE a=b and TestDataCNR.SerialNumber='"+key+"'");
import java.util.*;
import java.sql.*;
public class TdBean {
private String strClientName=null;
private String strSerialNumber=null;
private String C_WHERE = " WHERE ";
private String C_AND = " AND ";
private String strSql;
public void setClientName(String ClientName ){
this.strClientName=ClientName;
}
public void setSerialNumber(String SerialNumber){
this.strSerialNumber=SerialNumber;
}
private Connection conn;
public TdBean(){
this.conn=DataBase.getConnection();
}
//查询数据信息。
public Collection getTd_CNRByTd_Transmission(String SerialNumber) throws Exception
{
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery("SELECT TestDataCNR.SerialNumber as a ,TestDataCNR.OSA_Number,TestDataCNR.ComputerName,TestDataCNR.DateTime,TestDataCNR.Tester,TestDataCNR.Channel_No,TestDataCNR.Temperature_C,TestDataCNR.Temperature_C,TestDataCNR.Voltage_V,TestDataCNR.OpticalPower_dBm,TestDataCNR.SeekCode,TestDataCNR.Level_dBmV," +
"TestDataCNR.CSO_dBc,TestDataCNR.CTB_dBc,TestDataCNR.CNR_dBc,TestDataCNR.Re,TestDataTransmission.SerialNumber as b from TestDataCNR ,TestDataTransmission WHERE a=b and TestDataCNR.SerialNumber='"+key+"'");
Collection ret=new ArrayList();
while(rst.next())
{
TdBean pro=new TdBean();
Td_CNR product=new Td_CNR();
product.setSerialNumber(rst.getString("SerialNumber"));
product.setOSA_Number(rst.getString("OSA_Number"));
product.setComputerName(rst.getString("ComputerName"));
product.setDateTime(rst.getString("DateTime"));
product.setTester(rst.getString("Tester"));
product.setChannel_No(rst.getInt("Channel_No"));
product.setTemperature_C(rst.getInt("Temperature_C"));
product.setVoltage_V(rst.getFloat("Voltage_V"));
product.setOpticalPower_dBm(rst.getFloat("OpticalPower_dBm"));
product.setCSO_dBc(rst.getFloat("CSO_dBc"));
product.setCTB_dBc(rst.getFloat("CTB_dBc"));
product.setCNR_dBc(rst.getFloat("CNR_dBc"));
product.setDateTime(rst.getString("DateTime"));
//product.setExt1(rst.getString("Ext1"));
product.setLevel_dBmV(rst.getFloat("Level_dBmV"));
product.setOSA_Number(rst.getString("OSA_Number"));
product.setRe(rst.getString("Re"));
product.setSeekCode(rst.getString("SeekCode"));
ret.add(product);
}
conn.close();
return ret;
}
public static void main(String[] args){
System.out.println("jfdfjd");
}
}
我的HTML代码:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../hellking.css" type=text/css rel=stylesheet>
</head>
<body>
<center>
：：：：：：：：：产品查询：：：：：：：：：
<form action="Td_jsp.jsp" method="get">
<p>选择查询的类别
<select name="type">
<option value="0">按产品序号</option>
</select>
</p>
<p> 查询关键字：
<input type="text" name="key" onFocus="if (value =='请输入查询关键字'){value =''}" onBlur="if (value ==''){value='请输入查询关键字'}">
<br>
<br>
<input type="submit" name="submit" value="查询">
</p>
</form>
</center>
</body>
</html>
我的JSP代码:
<%@ page language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="Photon.tr.*"%><%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%><html>
<head>
<base href="<%=basePath%>">
<title>Query result</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>
<jsp:useBean id="pro" class="Photon.tr.TdBean" scope="page">
<body>
<center>
<% String SerialNumber=request.getParameter("key");%>
<H1> query result</H1>
<table width=80% border="1" bgcolor="#0888CC">
<tr bgcolor="#009966" bordercolor="#990066">
<td>SerialNumber</td><td>OSA_Number</td><td>ComputerName</td><td>DataTime</td><td>Tester</td><td>Channe_No</td><td>Temperature_C</td><td>Voltage_V</td><td>OpticalPower_dBm</td><td>SeekCode</td><td>Level_dBmV</td><td>CSO_dBc</td><td>CTB_dBc</td><td>CNR_dBc</td><td>Ext1</td>
</tr>
<%
Collection products=pro.getTd_CNRByTd_Transmission(SerialNumber);
Iterator it=products.iterator();
while(it.hasNext())
{
Td_CNR temp=(Td_CNR)it.next();
out.println("<tr bordercolor=#990066>");
out.println("<td>"+temp.getSerialNumber()+"</td>");
out.println("<td>"+temp.getOSA_Number()+"</td>");
out.println("<td>"+temp.getComputerName()+"</td>");
out.println("<td>"+temp.getDateTime()+"</td>");
out.println("<td>"+temp.getTester()+"</td>");
out.println("<td>"+temp.getChannel_No()+"</td>");
out.println("<td>"+temp.getTemperature_C()+"</td>");
out.println("<td>"+temp.getVoltage_V()+"</td>");
out.println("<td>"+temp.getOpticalPower_dBm()+"</td>");
out.println("<td>"+temp.getSeekCode()+"</td>");
out.println("<td>"+temp.getLevel_dBmV()+"</td>");
out.println("<td>"+temp.getCSO_dBc()+"</td>");
out.println("<td>"+temp.getCTB_dBc()+"</td>");
out.println("<td>"+temp.getCNR_dBc()+"</td>");
out.println("<td>"+temp.getOpticalPower_dBm()+"</td>");
}
%>
</table>
<a href="T_h.html">back</a>
</center>
</body>
</jsp:useBean>
为什么提示我的BEAN中的SQL语句中的关键字KEY无法解吸