首先在你的context里面配置数据库
1这是一个访问Hypersonic的例子
factory
org.apache.commons.dbcp.BasicDataSourceFactory
maxActive
10
maxIdle
10
maxWait
50000
username
sa
password
driverClassName
org.hsqldb.jdbcDriver
url
jdbc:hsqldb:file:../resource/sfgl
factory
org.apache.commons.dbcp.BasicDataSourceFactory
maxActive 100
maxIdle 30
maxWait 10000
username SYSTEM
password MANAGER
driverClassName oracle.jdbc.driver.OracleDriver
url jdbc:oracle:thin:@ibmserver:1521:ORCL
public void execute(ExoActionEvent event) throws Exception {
String yhh = event.getParameter(OBJECTID);
UIListYhda uiList = (UIListYhda) event.getComponent();
UIJqfk uiJqfk = (UIJqfk) uiList.getSibling(UIJqfk.class);
List list = new ArrayList();
Jqfk j;
Connection conn =
uiList.service_.getDataSource("WaterDS").getConnection();
try {
conn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql =
"select * from ZLS.JQFK where YHH = '" + yhh + "' ";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
j = new Jqfk();
j.setYhh(rs.getString("YHH"));
j.setYsl(rs.getString("YSL"));
j.setZje(rs.getString("ZJE"));
j.setCbqk(rs.getString("CBQK"));
j.setJqrq(rs.getDate("JQRQ"));
j.setHs(rs.getString("HS"));
j.setHsrq(rs.getDate("HSRQ"));
}
//rs.close();
//stmt.close();
//conn.close();
uiJqfk.setData(list);
uiList.setRenderedSibling(UIJqfk.class);
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn.close();
}
}
}
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=367849