1 、在struts-config.xml下
<data-sources >
<data-source key="DataSource">
<set-property property="minCount" value="2" />
<set-property property="password" value="spring" />
<set-property property="maxCount" value="10" />
<set-property property="user" value="spring" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="datasource" />
<set-property property="url" value="jdbc:oracle:thin:@it10:1521:SP" />
<set-property property="autoCommit" value="false" />
<set-property property="readOnly" value="false" />
<set-property property="loginTimeout" value="" />
</data-source>
2、在Action下
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) throws Exception {
DataSource dataSource=this.getDataSource(request,Constants.DATASOURCE_KEY);
Connection connection=dataSource.getConnection(); //取得Connection
HelpBean helpBean=new HelpBean();
Vector infovv=helpBean.getItemInfos(connection);
}
3、Constants.java
package com.tek.david.dataBase.pool;
/**
* @author qianzh
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class Constants {
public static String DATASOURCE_KEY="DataSource";
}
4、建立HelpBean
加入方法
public Vector getItemInfos(Connection conn) throws Exception{
Vector ret=new Vector();
Statement stmt=conn.createStatement();
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
ItemBean itemBean=new ItemBean();
InfoBean infoBean=new InfoBean();
infoBean.setUser_id(rs.getString(1));
infoBean.setUsername(rs.getString(2));
infoBean.setPassword(rs.getString(3));
infoBean.setNeedqty(rs.getString(4));
itemBean.setInfoBean(infoBean);
itemBean.setIsqty("");
ret.add(itemBean);
}
rs.close();
stmt.close();
conn.close();
return ret;
}
