I change it to
DataSource ds=(DataSource)pageContext.getAttribute(Action.DATA_SOURCE_KEYK);
conn=ds.getConnection();
stm=conn.createStatement();
rs=stm.executeQuery(insertsql);
But the error remain
My struts-config.xml is:
/////////////////////////////////////////////////////
<data-sources>
<data-source type="org.apache.struts.util.GenericDataSource" key="mydatasource">
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="MyWebSite Data Source Configuration"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxCount"
value="4"/>
<set-property property="minCount"
value="2"/>
<set-property property="password"
value="qijiashe"/>
<set-property property="url"
value="jdbc:mysql://localhost:3306/myweb"/>
<set-property property="user"
value="lyo"/>
</data-source>
</data-sources>
I can query the database in
servlet but not in jsp.I use struts1.1. Why? :roll: