20080215-STRUST中datasource的调用方法

  

1.    DATA-SOURCE的配置

 <data-source key="sqlDB">

      <set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>

      <set-property property="description" value="SqlServerDB Connection"/>

      <set-property property="url" value="jdbc:microsoft:sqlserver://IP:1433;DatabaseName=XXX"/>

<set-property property="user" value="XXX" />

      <set-property property="password" value="XXX"/>

      <set-property property="autoCommit" value="false"/>

      <set-property property="maxCount" value="5"/>

      <set-property property="minCount" value="0"/>

      <set-property property="loginTimeout" value="180"/>

    </data-source>

2.JAVA中的引用

String strSql = "";

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

// 创建对象

javax.sql.DataSource dataSource = (DataSource) servlet.findDataSource("sqlDB");

// 创建 conn

conn = dataSource_.getConnection();

// Sql

strSql = "select A ,B,C from XXTBL where D=? and E=? and F=?;";

// pstmt

pstmt=conn.prepareStatement(strSql);

// D

pstmt.setString(1,XX);

// E

pstmt.setString(2,XX);

// F

pstmt.setString(3,XX);

rs = pstmt.executeQuery();

// 处理返回的 RS

while (rs.next()){

}