<Resource name="jdbc/news"

              auth="Container"  type="javax.sql.DataSource"  maxActive="100"

              maxIdle="30" maxWait="10000" username="root"  password="123456"

              driverClassName="com.mysql.jdbc.Driver"

              url="jdbc:mysql://127.0.0.1:3306/news?useUnicode=true&amp;characterEncoding=GBK"/>
    

// 获取数据库连接

        public Connection getConnection2() {

            try {

                //初始化上下文

                Context cxt=new InitialContext();

                //获取与逻辑名相关联的数据源对象

                DataSource ds=(DataSource)cxt.lookup("java:comp/env/jdbc/news");

                conn=ds.getConnection();

            } catch (NamingException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            } catch (SQLException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

            return conn;

        }