在页面里面我想获取数据库一列的数据
在页面里面我想获取数据库一列的数据
List manhualist= manhuabean.mysort();
for(int i=0;i
{
System.out.println("you");
}
%>
其中Manhua是一个类,bean类,里面有name,id,author,等等属性getter和setter
然后Manhuabean是一个处理它的类,里面定义了方法mysort(),具体如下:
public List mysort()
{conn=DataBaseConnection.getConnection();
List templist= new ArrayList();
String sql="select * from cartoon order by dianji";
try {
PreparedStatement pst=conn.prepareStatement(sql);
ResultSet rst=pst.executeQuery();
if(rst.wasNull())
System.out.println("the rst is null");
while (rst.next()) {
String name = rst.getString("name");
int dianji = rst.getInt("dianji");
int id = rst.getInt("id");
Manhua temp2 = new Manhua();
temp2.setId(id);
temp2.setName(name);
temp2.setDianji(dianji);
System.out.println("the cartoon has the result" + name);
templist.add(temp2);
}
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("the templist is " + templist.size());
return templist;
}
然后一开服务器,发生错误,错误如下:
57: