我遇到一个这样的问题,就是:我数据库中建两个表,两个表通过NO链接,第一个表中有ID,NO,NAME.......第二个表中有ID,NO,INTRODUCE,PICTRUE.....
我现在想通过NO,把这两个表链接起来,在网页面中显示NO,NAME,INTRODUCE,PICTRUE...
现在我用JAVA编写程序,使它们联起来,代码如下:
public
class
BridgeIntroduceDao
...
{
public static List<Introduce> findIntroduce()...{
List<Introduce> list=new ArrayList();
try...{
PreparedStatement pstmt=DBManager.getConnection()
.prepareStatement("select b.id,name,introduce,pictruce from fleet_bridge_tab a,fleet_bridge_attribute_tab b where a.no=b.no order by b.id desc");
ResultSet rs=pstmt.executeQuery();
while(rs.next())...{
Introduce introduce=new Introduce();
introduce.setId(rs.getInt("id"));
// introduce.setNo(rs.getString("name"));
introduce.setIntroduce(rs.getString("introduce"));
introduce.setPicture(rs.getString("pictruce"));
// Bridge introduce=new Bridge();
//introduce.setName(rs.getString("name"));
list.add(introduce);
//list.add(bridge);
}
}catch(SQLException e)...{
e.printStackTrace();
}
return list;
}
}
public static List<Introduce> findIntroduce()...{
List<Introduce> list=new ArrayList();
try...{
PreparedStatement pstmt=DBManager.getConnection()
.prepareStatement("select b.id,name,introduce,pictruce from fleet_bridge_tab a,fleet_bridge_attribute_tab b where a.no=b.no order by b.id desc");
ResultSet rs=pstmt.executeQuery();
while(rs.next())...{
Introduce introduce=new Introduce();
introduce.setId(rs.getInt("id"));
// introduce.setNo(rs.getString("name"));
introduce.setIntroduce(rs.getString("introduce"));
introduce.setPicture(rs.getString("pictruce"));
// Bridge introduce=new Bridge();
//introduce.setName(rs.getString("name"));
list.add(introduce);
//list.add(bridge);
}
}catch(SQLException e)...{
e.printStackTrace();
}
return list;
}
}
上述建立了一个Itroduce.java的类,定义了ID,NO,INTRODUCE,PICTRUCE 为Private型,为他们定义SET,GET。。。
对于上述代码,我不知道该如何让里面的(Name)显示在一个页面中,或是在JSP页面中如何写代码,请教大家,帮我个忙。。。谢谢。。。。。。。