[原创]尝试配置struts数据源

参考：

终于实现Struts的数据源连接了

http://blog.csdn.net/gotoidea/archive/2004/07/29/55048.aspx

三个需要的程序包：

commons-dbcp-1.2.1.jar

http://apache.linuxforum.net/dist/jakarta/commons/dbcp/binaries/

struts-legacy.jar

http://apache.linuxforum.net/dist/jakarta/struts/struts-legacy/

commons-pool-1.2.jar

http://apache.linuxforum.net/dist/jakarta/commons/pool/binaries/

struts-config.xml:

<data-sources >

<data-source id="DS" key="myPool" type="org.apache.commons.dbcp.BasicDataSource" >

<set-property value="jdbc:mysql://localhost/mytest" property="url" />

<set-property value="bitan" property="username" />

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

<set-property value="org.gjt.mm.mysql.Driver" property="driverClassName" />

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

</data-source>

</data-sources>

DataSourceAction.java:

……

DataSourceForm myform = (DataSourceForm) form;

DataSource ds = getDataSource(request, "myPool");

Connection con = ds.getConnection();

Statement stmt = con.createStatement();

String sql = "SELECT * FROM struts";

ResultSet rs = stmt.executeQuery(sql);

……

• ·C#2.0的特性
• ·Tomcat5的数据库连接池配置
• ·把qq信息用语音读出的几个问题
• ·也谈Fedora的中文输入
• ·将控件中的数据输出保存到本地excel或wor
• ·显示大位图时滚动条应用的小技巧
• ·J2EE之类的概念
• ·获取从“资源管理器”发送到 Clipboard
• ·利用JAVACC将HQL->SQL(1)
• ·How to be a star engine