| 浠ュ??椤圭???芥??浣跨??ebSphere??WebLogic涓??翠欢???″????版??婧?涓????藉?绠???锛?灏辨??榧????圭?圭?癸????????颁?Tomcat???″?????宸卞?存???瑰????浜?锛?Baidu浜???澶╋????扮????妗ｄ???涔??芥??杞?杞斤????????朵??筹?涓?杩?杩????????ㄧ????搴?璇?涓?澶?璇翠?锛?璇ユ??浠???宸卞?烘??浜?锛? ??澶?宸ヤ?锛? ??姝ｇ‘??jdbc椹卞?ㄦ?疯???omcat??褰?涓?common/lib??褰?涓? 渚?濡???渚?灏辨????ojdbc14.jar??浠舵?疯??拌?ョ??褰?涓??? ???拌?存??锛? ?版??搴?锛?Oracle 9i JNDI??绉帮?jdbc/test ?版??搴??炬?ュ?板??锛?127.0.0.1 ?版??搴????″??锛?orcl Tomcat瀹?瑁???褰?锛?d:/tomcat 5.5 涓???瀹?瑁???tomcat5.5(杩?涓?姝ラ?ゅ氨涓???澶?浜?)锛? 浜?????寮?D:/Tomcat 5.5/conf/server.xml??浠? ??lt;Host appBase="webapps" autoDeploy="true" name="localhost" ?????? unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false"> ???瑰??娣诲??濡?涓?淇℃??锛? <!--??????褰?????--> <Context path="/web_test" docBase="E:/dev_space/web_test" ??????? debug="0" reloadable="true" crossContext="true"> <!--杩??ユ?????-> ??????? <Resource name="jdbc/test" auth="Container" ???????? type="javax.sql.DataSource" ???????? driverClassName="oracle.jdbc.driver.OracleDriver" ???????? url="jdbc:oracle:thin:@127.0.0.1:1521:orcl" username="test" ???????? password="test" maxActive="20" maxIdle="10" maxWait="-1" /> ?拌???锛?绗?涓?姝ラ??缃?灏卞????浜? ???拌?存??锛? /web_test锛?涓?涓?????渚?濡?锛?http://127.0.0.1:8080/web_test????杩?杩?涓???褰?灏卞??浠ョ?存?ヨ?块??浣?搴??ㄤ腑??index.jsp??浠朵? E:/dev_space/web_test??搴??ㄦ???ㄧ??褰? oracle.jdbc.driver.OracleDriver 椹卞?ㄥ??绉? jdbc:oracle:thin:@127.0.0.1:1521:ora9i??URL?板?? user_name??password灏变??ㄤ?缁?浜??? 涓???搴???eb.xml???伴??缃?锛? ??寮?搴??ㄦ???ㄧ??褰?涓?WEB-INF/web.xml??浠讹???lt;/web-app>涔???娣诲??濡?涓???瀹癸? <description>Test App</description> <resource-ref> ???? <description>DB Connection</description> ???? <res-ref-name>jdbc/test</res-ref-name> ???? <res-type>javax.sql.DataSource</res-type> ???? <res-auth>Container</res-auth> </resource-ref> 淇?瀛???瀹癸?OK锛?????璧峰??omcat???★???瀹??跺伐锛? ??涓?娴?璇?娴?璇?椤甸?㈡?璇?涓?涓?锛? <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" pageEncoding="gb2312"%> <%@ page import="javax.*"%> <%@ page import="javax.naming.*"%> <% request.setCharacterEncoding("gb2312"); String sql = "select to_char(sysdate,'YYYYMMDD') today from dual "; out.print("Start<br/>"); try { ???? InitialContext ctx = new InitialContext(); ???? javax.sql.DataSource connectionPool = (javax.sql.DataSource) ctx ???? .lookup("java:comp/env/jdbc/test"); ???? Connection conn = connectionPool.getConnection(); ???? ResultSet rs = null; ???? Statement st = null; ???? st =conn.createStatement(); ???? rs = st.executeQuery(sql); ???? while (rs.next()){ ????? out.println(rs.getString("today")); ???? } ???? rs.close(); ???? st.close(); ???? conn.close(); ?? ?? } catch (Exception ex) { ???? out.print(ex.getMessage()); ???? ex.printStackTrace(); } %> <html> <body> </body> </html> 娴?璇?涓?涓?锛?濡???姝ｅ父??璇?灏变??ㄩ〉??????版??濡?:20070926锛??拌?涓?姝ワ?涓?涓?绠?????杩??ユ???缃?灏卞????浜?锛?涓??村???扮??浣??ㄨ?搴??ㄥ?蜂?淇??广?? |
![Apache配置SSLApache配置SSL[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)