Struts DataSource

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;

}