TA的每日心情 | 开心
2021-3-12 23:18 |
|---|
签到天数: 2 天 [LV.1]初来乍到
|
|
JSP页面初始化时，也会初始化对应的JSF中的bean,在bean里加一个构造函数，在构造函数里取数据库的资料,这样在JSP页面上就可以显示数据库中的数据。
给你贴一段代码看看：
package com.jack;
import java.sql.*;
import java.sql.DriverManager;
/**
*
* @author jack
*/
public class DBConnect {
private static Connection conn=null;
/** Creates a new instance of Conn */
public DBConnect()
{
OpenConnection();
}
public void Close()
{
try
{
conn.close();
}
catch(SQLException e)
{
System.out.println(e);
}
}
public static Connection getConnection()
{
if (conn==null)
OpenConnection();
return conn;
}
public static void OpenConnection()
{
if (conn==null)
{
try
{
java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:localServer","sa","");
System.out.println("get connection success!");
}
catch(SQLException e)
{
System.out.println(e);
}
catch(ClassNotFoundException e)
{
System.out.println("class not found!");
}
}
}
}
package com.jack;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import javax.Servlet.jsp.jstl.sql.Result;
import javax.servlet.jsp.jstl.sql.ResultSupport;
/**
* @author jack
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class CustomerBean
{
public Result getAll() throws SQLException
{
System.out.println("begin get Connection;");
Connection conn=DBConnect.getConnection();
System.out.println("end get Connection");
Statement stmt=conn.createStatement();
System.out.println("create Statement");
ResultSet result=stmt.executeQuery("select JobNo,name,DepartmentNo,HomeAddress,Telphone,ClassName from EmployEmpTable");
System.out.println("get Resultset");
return ResultSupport.toResult(result);
}
}
index.jsp:
<HTML>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<f:view>
<head>
<link href="styles.css" rel="stylesheet" type="text/css"/>
<f:loadBundle basename="com.corejsf.messages" var="msgs"/>
<title>
<h:outputText value="#{msgs.pageTitle}"/>
</title>
</head>
<body>
<h:form>
<h:dataTable value="#{customer.all}" var="customer"
styleClass="customers"
headerClass="customersHeader" columnClasses="custid,name">
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.customerIdHeader}"/>
</f:facet>
<h:outputText value="#{customer.JobNo}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.nameHeader}"/>
</f:facet>
<h:outputText value="#{customer.Name}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.phoneHeader}"/>
</f:facet>
<h:outputText value="#{customer.DepartmentNo}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.addreSSHeader}"/>
</f:facet>
<h:outputText value="#{customer.HomeAddress}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.cityHeader}"/>
</f:facet>
<h:outputText value="#{customer.Telphone}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="#{msgs.stateHeader}"/>
</f:facet>
<h:outputText value="#{customer.ClassName}"/>
</h:column>
</h:dataTable>
</h:form>
</body>
</f:view>
</html>
文件faces-config.xml:
<?xml version="1.0"?>
<!DOCTYPE faces-config PUBLIC
"-//Sun Microsystems, Inc.//DTD JavaSErver Faces Config 1.0//EN"
"http://java.sun.com/dtd/web-facesconfig_1_0.dtd">
<faces-config>
<managed-bean>
<managed-bean-name>customer</managed-bean-name>
<managed-bean-class>com.jack.CustomerBean</managed-bean-class>
<managed-bean-scope>session</managed-bean-scope>
</managed-bean>
</faces-config>
function TempSave(ElementID)
{
CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(ElementID).value);
CommentsPersistDiv.save("CommentXMLStore");
}
function Restore(ElementID)
{
CommentsPersistDiv.load("CommentXMLStore");
document.getElementById(ElementID).value=CommentsPersistDiv.getAttribute("CommentContent");
} |
|
|手机版|Java学习者论坛
( 声明：本站资料整理自互联网，用于Java学习者交流学习使用，对资料版权不负任何法律责任，若有侵权请及时联系客服屏蔽删除 )
发表于 2014-10-10 02:52:07