UC知道javaBean连数据库向jsp传不了值
来源：百度知道 编辑：UC知道 时间：2024/06/04 14:59:25
javaBean 代码如下：
package wgg;
import java.util.Vector;
import java.sql.*;
public class Nxf{
public Nxf(){
System.out.println("gou zao hanshu");
}
private String newstitle=null; //文章标题
private String author=null; //作者
public static Vector getInfor(){
Vector articleinfor=new Vector();//文章信息
String sql=null;
Statement stmt=null;
Connection conn=null;
String user="wgg";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
System.out.println("ClassNotFound");
}
System.out.println("this is getInfor class");
try{
conn=DriverManager.getConnection("jdbc:odbc:wgg",user,"");
stmt=conn.createStatement();
sql="select * from 学会文件 ";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
Nxf art=
package wgg;
import java.util.Vector;
import java.sql.*;
public class Nxf{
public Nxf(){
System.out.println("gou zao hanshu");
}
private String newstitle=null; //文章标题
private String author=null; //作者
public static Vector getInfor(){
Vector articleinfor=new Vector();//文章信息
String sql=null;
Statement stmt=null;
Connection conn=null;
String user="wgg";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
System.out.println("ClassNotFound");
}
System.out.println("this is getInfor class");
try{
conn=DriverManager.getConnection("jdbc:odbc:wgg",user,"");
stmt=conn.createStatement();
sql="select * from 学会文件 ";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
Nxf art=
不为空不代表它的size>0
articleInfor肯定不为空的,因为你有new Vector(),这已经非空了,可能你没有数据吧.你在javabean里也打印size看看?测试看看吧
把这段放到jsp中去看看,还是没有的话就神奇了
try{
Vector infor=NXFX.getInfor();
int length=infor.size();
for(int i=0;i<length;i++)
{NXFX textInfor=(NXFX)infor.get(i);
System.out.println(textInfor.getTitle()+" "+textInfor.getAuthor());
}
}catch(Exception e){
System.out.println("excepiton");
}
先用你的SQL去数据库查一下//看到底有数据没..
while(rs.next()){
Nxf art=new Nxf();
art.setTitle(rs.getString("文章标题"));
art.setAuthor(rs.getString("作者"));
articleinfor.add(art);
}
改成
while(rs.next()){
Nxf art=new Nxf();
art.setTitle(rs.getString("文章标题"));
art.setAuthor(rs.getString("作者"));
articleinfor.add(art);
System.out.println("add succes one!");
}
查看到底加入值没有