struts-config.xml添加
在<struts-config>里面加上
<!-- ========== Data Source Configuration =============================== -->
<data-sources>
<data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.struts.util.GenericDataSource">
<set-property property="password" value="shiwtshiwt" />
<set-property property="minCount" value="" />
<set-property property="maxCount" value="" />
<set-property property="user" value="swt" />
<set-property property="driverClass" value="org.gjt.mm.mysql.Driver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:mysql://localhost:3306/smsgroup?autoReconnect=true" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source>
</data-sources>
在你的Action类的excute即可执行以下连接数据库代码
import javax.servlet.ServletContext;
import javax.sql.*;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String tel = "tel";
ServletContext context = this.servlet.getServletContext();
DataSource dataSource = (DataSource)context.getAttribute("org.apache.struts.action.DATA_SOURCE");
try {
conn = dataSource.getConnection();
stmt = conn.createStatement();
//rs = stmt.executeQuery("select * from user where age = 24");
rs = stmt.executeQuery("select * from c_13760827783 where id = 6");
if( rs.next() ){
tel = rs.getString("name");
System.out.print(tel);
}
}catch (SQLException e) {
System.err.println(e.getMessage());
}