struts 中连接数据库连接池

最新推荐文章于 2014-04-24 22:37:00 发布

hzxmsn

最新推荐文章于 2014-04-24 22:37:00 发布

阅读量1.5k

点赞数

分类专栏： Java-j2ee 文章标签：数据库连接池 struts path action import null

本文链接：https://blog.csdn.net/hzxmsn/article/details/1328448

版权

Java-j2ee 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

struts-config.xml添加

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
"http://struts.apache.org/dtds/struts-config_1_2.dtd">

<struts-config>

<form-beans>

<form-bean name="MovieForm" type="com.coraise.web.stb.MovieForm"/>

</form-beans>

<action-mappings>

</struts-config>

在你的Action类的excute方法中即可执行以下连接数据库代码

import javax.servlet.ServletContext;
import javax.sql.*;

Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   String tmpName = "currentName";
   ServletContext context = this.servlet.getServletContext();
   DataSource dataSource = (DataSource)context.getAttribute("DATA_SOURCE");

   try {
    conn = dataSource.getConnection();
    stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from user where id = 6");
    if( rs.next() ){
     tmpName = rs.getString("name");
     System.out.print(tmpName);
    }
   }catch (SQLException e) {
    System.err.println(e.getMessage());
   }