正在尝试使用表格输出。 当程序运行时输出查询到到list集合的内容,但却总是无法输出。代码如下请指教。或者谁能用JSF+SQL2000做一个dataTable标签的输出发送至[email protected],只要正确立即给分。
DB类:
package biaogetest;import java.sql.*;
import java.util.*;
public class DBManage {
private Connection conn;
private Statement stmt;
private ResultSet rs;
public Connection myConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=kaka;","sa","sa"); } catch (Exception ex) {
ex.printStackTrace(); //以下省略不写
}
return conn;
} public Statement myStatement() { try {
conn=this.myConnection();
stmt = conn.createStatement();
} catch (SQLException ex) {
}
return stmt;
} public ResultSet myResultSet(String sql) {
try {
stmt=this.myStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
}
return rs;
} public void closeAll() {
try {
if (stmt != null) {
stmt.close();
}
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException ex) { }
}
}
受管BEAN
package biaogetest;import java.util.List;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;public class ubean {
public ubean() {
}
String uname;
String pwd;
public String getPwd() {
return pwd;
} public String getUname() {
return uname;
} public void setPwd(String pwd) {
this.pwd = pwd;
} public void setUname(String uname) {
this.uname = uname;
} public List getall()
{
DBManage db=new DBManage();
List list=new ArrayList();
try {
ResultSet rs = db.myResultSet("select * from uload");
while (rs.next()) {
ubean ub = new ubean();
ub.setUname(rs.getString(1));
ub.setPwd(rs.getString(2));
list.add(ub);
}
} catch (SQLException ex) {
}
return list;
}}
JSP:
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<html>
<head>
<title>
index
</title>
</head>
<body bgcolor="#ffffff">
<f:view>
<h:form>
<h:dataTable value="#{bean.getall}"> <h:column>
<h:outputText value="#{bean.uname}"/>
</h:column>
</h:dataTable>
</h:form>
</f:view>
</body>
</html>
DB类:
package biaogetest;import java.sql.*;
import java.util.*;
public class DBManage {
private Connection conn;
private Statement stmt;
private ResultSet rs;
public Connection myConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=kaka;","sa","sa"); } catch (Exception ex) {
ex.printStackTrace(); //以下省略不写
}
return conn;
} public Statement myStatement() { try {
conn=this.myConnection();
stmt = conn.createStatement();
} catch (SQLException ex) {
}
return stmt;
} public ResultSet myResultSet(String sql) {
try {
stmt=this.myStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
}
return rs;
} public void closeAll() {
try {
if (stmt != null) {
stmt.close();
}
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException ex) { }
}
}
受管BEAN
package biaogetest;import java.util.List;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;public class ubean {
public ubean() {
}
String uname;
String pwd;
public String getPwd() {
return pwd;
} public String getUname() {
return uname;
} public void setPwd(String pwd) {
this.pwd = pwd;
} public void setUname(String uname) {
this.uname = uname;
} public List getall()
{
DBManage db=new DBManage();
List list=new ArrayList();
try {
ResultSet rs = db.myResultSet("select * from uload");
while (rs.next()) {
ubean ub = new ubean();
ub.setUname(rs.getString(1));
ub.setPwd(rs.getString(2));
list.add(ub);
}
} catch (SQLException ex) {
}
return list;
}}
JSP:
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<html>
<head>
<title>
index
</title>
</head>
<body bgcolor="#ffffff">
<f:view>
<h:form>
<h:dataTable value="#{bean.getall}"> <h:column>
<h:outputText value="#{bean.uname}"/>
</h:column>
</h:dataTable>
</h:form>
</f:view>
</body>
</html>
解决方案 »
- 运行ejb报的一个错误
- hibernate 注解问题!!!怎么注解长度属性啊!在线等你啊!!!
- “齐达内温俊波教育公司教育剧场”
- struts2+hibernate3+spring出错,callbackFilter找不到
- 工作找到了,来散分的。。。
- tomcat3.2版本加载图片异常
- 关于request.getsession(true),为什么seesion要从request中取得?
- 有关java.sql包中的PreparedStatement的使用,oracle和mysql不同
- interface
- ant 编译wsdl文件生成client端 报错 Could not create task or type of type: clientgen
- axis2 如何跟 域认证 结合
- 小弟来求教希望大哥大姐来帮助
"#{bean.getall}" -> "#{bean.all}"
bean 命名要有规则。只看出了这两个问题。你试试