注册 登录
编程论坛 J2EE论坛

如何用userBean以数组的形式输出查询的结果?

yfzsj 发布于 2007-01-01 02:22, 553 次点击

jsp部分:
<%
String text=request.getParameter("textfield");
String radio=request.getParameter("radiobutton");
String backdata[];
backdata=queryedId.getRs(radio,text);

out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"索引");
out.print("<TH width=100>"+"书名");
out.print("<TH width=100>"+"作者");
out.print("<TH width=100>"+"年份");
out.print("<TH width=100>"+"价格");
out.print("</TR>");

out.print("<TR>");
out.print("<TD >"+backdata[0]+"</TD>");
out.print("<TD >"+backdata[1]+"</TD>");
out.print("<TD >"+backdata[2]+"</TD>");
out.print("<TD >"+backdata[3]+"</TD>");
out.print("<TD >"+backdata[4]+"</TD>");
out.print("</TR>") ;

out.print("</Table>");

%>
javaBean
package book;
import java.sql.*;
public class queryed {
String choose="",textent="" ;
String[] result=new String[5];
public queryed(){

}

public void setChoose(String radiobutton){
choose=radiobutton;
}
public String getChoose(){
return choose;
}

public void setTextent(String textfield){
textent=textfield;
}
public String getTextent(){
return textent;
}
public String[] getRs(String radio2,String text2){


try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try{
Connection con;
Statement sql;
ResultSet rs;
con=DriverManager.getConnection("jdbc:odbc:yfzyzr","sa","");
sql=con.createStatement();
String condition="";
condition="SELECT * FROM book WHERE "+radio2+" LIKE '%"+text2+"%' ORDER BY bookid";
rs=sql.executeQuery(condition);

result[0]=rs.getString("bookId");
result[1]=rs.getString("bookname");
result[2]=rs.getString("author");
result[3]=rs.getString("year");
result[4]=rs.getString("price");

con.close();

}catch(SQLException e){}
return result;
}
}

但结果好象并没有取得,查询结果!
也就是查询结果的数组元素并不能被输出.

[此贴子已经被作者于2007-1-1 14:06:46编辑过]

1 回复
#2
禹_二2007-01-01 17:50

把这些信息放到一个数组中不太好,放到一个Vector中更好!!

1