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;
 
 }