Struts开发数据方面,可参考这里:
http://www.javawebstudio.com/html/  9、如何实现Struts 数据库应用程序    10、如何在Struts 数据库应用程序中实现分页显示    11、如何在Struts 数据库应用程序中实现记录的删除、更新及链接    12、如何在Struts 数据库应用程序中实现记录的添加    13、如何建立一个带登陆页面的Struts数据库应用程序    14、如何建立一个带登陆页面及角色的Struts数据库应用程序

解决方案 »

  1.   

    在struts-config.xml中配置:
      <data-sources>
        <data-source>
          <set-property property="autoCommit" value="false" />
          <set-property property="description" value="Database for Personal of System" />
          <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
          <set-property property="maxCount" value="5" />
          <set-property property="minCount" value="1" />
          <set-property property="url" value="jdbc:oracle:thin:@ytb:1521:ORCL" />
          <set-property property="user" value="crm" />
          <set-property property="password" value="crm" />
        </data-source>
      </data-sources>
      

  2.   

    mysql的配置:
    data-sources>
    <data-source>
    <set-property property="autoCommit" value="true"/><set-property property="description" value="MySql Data Source"/>
    <set-property property="driverClass" value="com.caucho.jdbc.mysql.Driver"/>
    <set-property property="maxCount" value="10"/>
    <set-property property="minCount" value="2"/>
    <set-property property="user" value="admin"/>
    <set-property property="password" value="admin"/>
    <set-property property="url"
    value="jdbc:mysql-caucho://localhost:3306/storefront"/>
    </data-source>
    </data-sources>
      

  3.   

    我也有错误!但是错误信息不一致! 大家帮忙看看! 谢谢!
    _______________________________________________________2004-12-31 12:17:30 org.apache.struts.action.ActionServlet initModuleDataSources
    严重: Initializing application data source QuerySystem
    java.lang.NullPointerException
            at java.net.URLClassLoader$1.run(URLClassLoader.java:190)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:282)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1255)
            at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
            at org.apache.struts.util.RequestUtils.applicationClass(RequestUtils.java:119)
            at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:145)
            at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:775)
            at org.apache.struts.action.ActionServlet.init(ActionServlet.java:331)
            at javax.servlet.GenericServlet.init(GenericServlet.java:211)
            at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029)
            at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
            at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4017)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
            at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
            at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
            at org.apache.commons.digester.Rule.end(Rule.java:276)
            at org.apache.commons.digester.Digester.endElement(Digester.java:1058)
            at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
            at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(
    Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
            at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
            at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
            at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
            at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
            at org.apache.commons.digester.Digester.parse(Digester.java:1567)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
            at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
            at org.apache.catalina.core.StandardService.start(StandardService.java:480)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
            at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
            at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)