配置了数据源后，就可以在Action中访问数据源了。

代码如下所示：

//获取Servlet上下文对象

ServletContext ctx = servlet.getServletContext();

//获得数据源

DataSource ds = (DataSource) ctx.getAttribute("DataSource");

//获取数据库的连接

Connection conn = ds.getConnection();

B、修改Action

Action将取得数据源，得到一个数据库的连接，把页面传近来的用户名和密码，通过jdbc与数据库进行对比，如果存在转到“success.jsp”并显示其名称，否则到错误页面。

具体实现代码如下所示：

public class LoginAction extends Action {

public ActionForward execute(ActionMapping actionMapping,

ActionForm actionForm, HttpServletRequest request,

HttpServletResponse response) {

LoginActionForm loginform = (LoginActionForm) actionForm;

String username = loginform.getUsername();

String userpass = loginform.getUserpass();

ServletContext ctx = servlet.getServletContext();

DataSource ds = (DataSource) ctx.getAttribute("DataSource");

boolean flag = false;

String sql = "select * from user where username='" + username

+ "' and password='" + userpass + "'";

try {

Connection conn = ds.getConnection();

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(sql);

while (rs.next()) {

flag = true;

}

} catch (Exception e) {

e.printStackTrace();

}

(编辑:aniston)