下面介绍在Tomcat服务器下使用连接池来连接数据库的操作 一:修改web.xml文件: <div class="codetitle"><a style="CURSOR: pointer" data="77479" class="copybut" id="copybut77479" onclick="doCopy('code77479')"> 代码如下:<div class="codebody" id="code77479"> <?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> project index.html index.htm index.jsp default.html default.htm default.jsp DBConnection siniteksirm javax.sql.DataSource Container 在web-app之间插入这段代码。指定要是用的Resource名称。 二:修改tomcat下的context.xml文件: 在Context标签之间加入如下代码。 <div class="codetitle"><a style="CURSOR: pointer" data="69193" class="copybut" id="copybut69193" onclick="doCopy('code69193')"> 代码如下:<div class="codebody" id="code69193"> <Resource name="siniteksirm" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@192.168.1.196:1521:orcl" username="paxt" password="paxt" maxActive="20" maxIdle="10" maxWait="-1" testOnBorrow="true" validationQuery="select 1 from dual"/> 三:选择Oracle的数据库驱动,加入到Tomcat的lib包中。本项目中为:Ojdbc14.jar. 四:提供一个jsp页面: <div class="codetitle"><a style="CURSOR: pointer" data="47166" class="copybut" id="copybut47166" onclick="doCopy('code47166')"> 代码如下:<div class="codebody" id="code47166"> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="javax.naming.Context" %> <%@ page import="javax.naming.InitialContext" %> <%@ page import="java.sql." %> <%@ page import="javax.sql.DataSource" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> Insert title here <% DataSource ds = null; try{ Context context = new InitialContext(); ds = (DataSource)context.lookup("java:comp/env/siniteksirm"); Connection conn = ds.getConnection(); PreparedStatement pst = conn.prepareStatement("select from sdc_fundbase where rownum <= 2"); ResultSet rs = pst.executeQuery(); while(rs.next()){ out.println(rs.getString("fund4")); out.println(" "); } if(ds != null){ out.println("数据库连接"); } }catch(Exception e){ e.printStackTrace(); out.println("数据库连接失败"); } %> 启动Tomcat,这样就可以访问页面。 (编辑:岳阳站长网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|