在struts-config.xml配置数据源
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/ecar?useUnicode=true&characterEncoding=gb2312" />
<set-property property="username" value="ecar" />
<set-property property="password" value="" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
</data-source>
</data-sources>在程序中调用如下:
public Connection getConnectionFromStruts(HttpServletRequest request) {
try {
DataSource ds = this.getDataSource(request);
if (ds != null) {
System.out.println("The system has get connection from struts!");
return ds.getConnection();
}
return null;
}
catch (Exception e) {
e.printStackTrace();
return null;
}
}
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/ecar?useUnicode=true&characterEncoding=gb2312" />
<set-property property="username" value="ecar" />
<set-property property="password" value="" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
</data-source>
</data-sources>在程序中调用如下:
public Connection getConnectionFromStruts(HttpServletRequest request) {
try {
DataSource ds = this.getDataSource(request);
if (ds != null) {
System.out.println("The system has get connection from struts!");
return ds.getConnection();
}
return null;
}
catch (Exception e) {
e.printStackTrace();
return null;
}
}
当然连接池也可以。
^_^
ftp://202.38.86.188/incoming/上除了可下载JSPStudio外,还有一个完整的由JSPstudio自动生成的数据库应Hello实例可下载,不如下载一个来分析一下,可作为参考,也可以直接使用。