不能这样写,你这样只取得出来一行.
可以这样:
public ArrayList news(Connection con){
String sql="select * from b1";
String tl=new String();
ArrayList al = new ArrayList();
try{
this.con=con;
Statement lstmt1=null;
lstmt1=this.con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs1=lstmt1.executeQuery(sql);
for(int i=1;i<=5;i++){
tl=rs1.getString("title");
al.add(tl);
}
rs1.close();
lstmt1.close();
}
catch(SQLException sex1){
System.out.println(sex1.toString());
}
return al;
}
可以这样:
public ArrayList news(Connection con){
String sql="select * from b1";
String tl=new String();
ArrayList al = new ArrayList();
try{
this.con=con;
Statement lstmt1=null;
lstmt1=this.con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs1=lstmt1.executeQuery(sql);
for(int i=1;i<=5;i++){
tl=rs1.getString("title");
al.add(tl);
}
rs1.close();
lstmt1.close();
}
catch(SQLException sex1){
System.out.println(sex1.toString());
}
return al;
}
还有一个问题,在jsp端该如何接收呢??
定义一个数组吗?请大虾明示!!
===============================
public String[] news(Connection con){
String sql="select * from b1";
String[] tl=new String[5];
try{
this.con=con;
Statement lstmt1=null;
lstmt1=this.con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs1=lstmt1.executeQuery(sql);
int i = 0;
while(rs.next())
{
tl[0]=rs1.getString("title");
i++;
} rs1.close();
lstmt1.close();
}
catch(SQLException sex1){
System.out.println(sex1.toString());
}
return tl;
}======================================
在jsp页面用for循环将值取出来。
出错如下:
to:nbm0(www.西伯利亚.com.cn)
--------------------Configuration: j2sdk1.4.0 <Default>--------------------
C:\resin-2.1.4\jsp\WEB-INF\CLASSES\nboard.java:54: incompatible types
found : java.lang.String[]
required: java.lang.String
return tl;
^
1 errorto:xiaofenguser(风雨) --------------------Configuration: j2sdk1.4.0 <Default>--------------------
C:\resin-2.1.4\jsp\WEB-INF\CLASSES\nboard.java:37: cannot resolve symbol
symbol : class ArrayList
location: class dc.nboard
ArrayList al=new ArrayList();
^
C:\resin-2.1.4\jsp\WEB-INF\CLASSES\nboard.java:37: cannot resolve symbol
symbol : class ArrayList
location: class dc.nboard
ArrayList al=new ArrayList();
^
2 errors请大虾在看一下!!!
public String news(Connection con){
这样了??
第二个您要在文件前面加:
import java.util.*;