WebLogic运用DB的Java控件访问数据库(1)

<JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
LoginDelaySeconds="1" MaxCapacity="20" Name="liwei"
PasswordEncrypted="{3DES}WBNJPYUOAvE=" Properties="user=liwei"
Targets="cgServer" URL="jdbc:oracle:thin:@localhost:1521:wincn"/>
<JDBCTxDataSource JNDIName="liwei" Name="liwei" PoolName="liwei" Targets="cgServer"/>

CREATE TABLE TEST(
A                         VARCHAR2(10),
B                         VARCHAR2(10),
C                         VARCHAR2(10),
D                         VARCHAR2(10)
)

package recordset; 
import com.bea.control.*; 
import java.sql.SQLException; 
/* 
* @jc:connection data-source-jndi-name="liwei" 
*/ 
public interface test extends DatabaseControl, com.bea.control.ControlExtension
{ 
/**
* @jc:sql statement::
*   INSERT INTO TEST (A,B,C,D) 
*   VALUES ({_A},{_B},{_C},{_D})
* ::
*/
public int insert( String _A, String _B,String _C,String _D );
/**
* @jc:sql statement::
* UPDATE TEST SET B = {_B} ,C = {_C} ,D = {_D} WHERE A = {_A}
* ::
*/
public int update( String _A, String _B,String _C,String _D );

/**
* @jc:sql statement::
* DELETE TEST WHERE A = {_A}
* ::
*/
public int delete( String _A );    
/**
* @jc:sql statement::
* SELECT * FROM TEST WHERE A = {_A}
* ::
*/
public tblTest select( String _A );

/**
* @jc:sql statement::
* SELECT * FROM TEST
* ::
*/
public tblTest[] selectAll();
public static class tblTest implements java.io.Serializable
{
public String A;
public String B;
public String C;
public String D;
}
}