请教高手们！

edsonwen 2005-01-28 08:45:15

JAVA代码：
package phoneproject;

import java.io.*;
import java.sql.*;
import java.util.*;

public class RigorSearchBean extends WeblogicContext implements Serializable {
private static String companyName;
private static String relationMan;
private static String phone;
private static String email;
private static String mailNO;
private static String type;
private static String web;
private static String address;
private static String remark;
private static String data;
private static String check=null;
static Statement stat=null;
static ResultSet result=null;

public static Vector QueryData(){
Vector v=new Vector();
try{
String sql="";
stat=getConnection().createStatement();
if(check.equals("companyName")){
sql="select RelationMan,Phone,Email,Web,Address,MailNO,Remark from CompanyInfo where companyName like '%"+data+"%'";
}
result=stat.executeQuery(sql);
while(result.next()){
RigorSearchBean temp=new RigorSearchBean();
temp.setRelationMan(result.getString("relationMan"));
temp.setPhone(result.getString("phone"));
temp.setEmail(result.getString("email"));
temp.setWeb(result.getString("web"));
temp.setAddress(result.getString("address"));
temp.setMailNO(result.getString("mailNO"));
temp.setRemark(result.getString("remark"));
v.add(temp);
}
}
catch(Exception e){
System.out.println("a"+e.getMessage());
}
return v;
}
private void readObject(ObjectInputStream ois) throws ClassNotFoundException, IOException {
ois.defaultReadObject();
}
private void writeObject(ObjectOutputStream oos) throws IOException {
oos.defaultWriteObject();
}
public String getCompanyName() {
return companyName;
}
public void setCompanyName(String companyName) {
this.companyName = companyName;
}
public String getRelationMan() {
return relationMan;
}
public void setRelationMan(String relationMan) {
this.relationMan = relationMan;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getMailNO() {
return mailNO;
}
public void setMailNO(String mailNO) {
this.mailNO = mailNO;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getWeb() {
return web;
}
public void setWeb(String web) {
this.web = web;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
public String getCheck() {
return check;
}
public void setCheck(String check) {
this.check = check;
}
public String getData() {
return data;
}
public void setData(String data) {
this.data = data;
}
}

JSP代码：
<%@ page contentType="text/html; charset=GBK" %>
<%@ page errorPage="RigorSearchResult_error.jsp" %>
<html>
<head>
<title>
RigorSearchResult
</title>
</head>
<jsp:useBean id="rigorsearch" scope="session" class="phoneproject.RigorSearchBean" />
<jsp:setProperty name="rigorsearch" property="*" />
<body bgcolor="#ffffff">
<h1>
JBuilder Generated JSP
</h1>
<table border="2">
<tr>
<th>联系姓名</th>
<th>联系电话</th>
<th>信箱</th>
<th>网址</th>
<th>地址</th>
<th>邮编</th>
<th>简介</th>
</tr>
<%
Vector v=(phoneproject.RigorSearchBean).QueryData();
for(int i=0;i<v.size();i++){
phoneproject.RigorSearchBean temp=(phoneproject.RigorSearchBean)v.elementAt(i);
%>
<tr>
<td><%=temp.getRelationMan()%></td>
<td><%=temp.getPhone()%></td>
<td><%=temp.getEmail()%></td>
<td><%=temp.getWeb()%></td>
<td><%=temp.getAddress()%></td>
<td><%=temp.getMailNO()%></td>
<td><%=temp.getRemark()%></td>
</tr>
<%}%>
</table>
</body>
</html>
问题是：我的数据库有两条companyName为"edson"和"edsonwen"的记录。上面的sql语句在数据库的查询分析器是查出两条不同的记录，而在我的JSP页面显示的两条记录都是最后那条记录的内容，即两条都是（edsonwen）的内容。

...全文