你好, 各位.请教一个关于Struts DataSource manger的怪问题, 用Select能查询到数据返回到ResultSet, 用调用execueUpdate方法是也能够返回insert的记录数(表示成功更新), 但直接DBMS查询时, 确没有看到插入的新记录, 请有经验的大侠打救. 部分代码如下:struts-config file:<data-sources>
<data-source type="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="com.mysql.jdbc.Driver" />
<set-property
property="url"
value="jdbc:mysql://localhost/jj_sports?autoReconnect=true" />
<set-property
property="username"
value="root" />
<set-property
property="password"
value="huang1982" />
<set-property
property="maxActive"
value="10" />
<set-property
property="maxWait"
value="5000" />
<set-property
property="defaultAutoCommit"
value="false" />
<set-property
property="defaultReadOnly"
value="false" />
<set-property
property="validationQuery"
value="SELECT COUNT(*) FROM tbluser" />
</data-source>
</data-sources>//DB Access Code DataSource dataSource;
Connection myConnection = null;
String strSQL = "INSERT INTO tblGood" +
" VALUES(1, '" + goodName + "', '" + goodDesp + "', '" + owner + "', '" +
goodPrice + "', '" + status + "');";
try {
dataSource = getDataSource(request);
myConnection = dataSource.getConnection();
Statement stmt=myConnection.createStatement();
stmt.executeUpdate( strSQL );
if (rowCount==1)
return mapping.findForward( "GlobalSuccess");
else
return mapping.findForward( "GlobalFailed");
}
catch( SQLException se ){
return mapping.findForward( "GlobalFailed");
}
<data-source type="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="com.mysql.jdbc.Driver" />
<set-property
property="url"
value="jdbc:mysql://localhost/jj_sports?autoReconnect=true" />
<set-property
property="username"
value="root" />
<set-property
property="password"
value="huang1982" />
<set-property
property="maxActive"
value="10" />
<set-property
property="maxWait"
value="5000" />
<set-property
property="defaultAutoCommit"
value="false" />
<set-property
property="defaultReadOnly"
value="false" />
<set-property
property="validationQuery"
value="SELECT COUNT(*) FROM tbluser" />
</data-source>
</data-sources>//DB Access Code DataSource dataSource;
Connection myConnection = null;
String strSQL = "INSERT INTO tblGood" +
" VALUES(1, '" + goodName + "', '" + goodDesp + "', '" + owner + "', '" +
goodPrice + "', '" + status + "');";
try {
dataSource = getDataSource(request);
myConnection = dataSource.getConnection();
Statement stmt=myConnection.createStatement();
stmt.executeUpdate( strSQL );
if (rowCount==1)
return mapping.findForward( "GlobalSuccess");
else
return mapping.findForward( "GlobalFailed");
}
catch( SQLException se ){
return mapping.findForward( "GlobalFailed");
}
<data-sources >
<data-source key="eshopOracle" type="org.apache.struts.legacy.GenericDataSource">
<set-property property="password" value=" 密码" />
<set-property property="minCount" value="5" />
<set-property property="maxCount" value="10" />
<set-property property="user" value="用户名" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="eshop" />
<set-property property="url" value="jdbc:oracle:thin:@localhost:1521:服务名" />
</data-source>
</data-sources>