亚洲丁香日韩,亚洲人av在线,中文在线三区

Weblogic database Servlet

import ?java.sql.Connection;

import ?java.sql.ResultSet;

import ?java.sql.ResultSetMetaData;

import ?java.sql.SQLException;

import ?java.sql.Statement;

import ?java.util.Hashtable;

import ?javax.naming.Context;

import ?javax.naming.InitialContext;

import ?javax.naming.NamingException;

import ?javax.servlet.ServletException;

import ?javax.servlet.http.HttpServlet;

import ?javax.servlet.http.HttpServletRequest;

import ?javax.servlet.http.HttpServletResponse;

import ?javax.sql.DataSource;

public ? class ?WeblogicDbServlet? extends ?HttpServlet? {

??DataSource?pool;

?? public ? void ?init()? throws ?ServletException? {

????Context?env? = ? null ;

????Hashtable?ht? = ? new ?Hashtable();

????ht.put(Context.INITIAL_CONTEXT_FACTORY,

???????? " weblogic.jndi.WLInitialContextFactory " );

???? // ht.put(Context.PROVIDER_URL,"t3: // localhost:7001");

???? try ? {

??????env? = ? new ?InitialContext(ht);

??????pool? = ?(javax.sql.DataSource)?env.lookup( " oracle-8i-athletes " );

?????? if ?(pool? == ? null )

???????? throw ? new ?ServletException(

???????????? " 'oracle-8i-athletes'?is?an?unknown?DataSource " );

????} ? catch ?(NamingException?ne)? {

?????? throw ? new ?ServletException(ne);

????}

??}

?? public ? void ?doGet(HttpServletRequest?request,?HttpServletResponse?response)

?????? throws ?ServletException,?java.io.IOException? {

????String?sql? = ? " select?*?from?athlete " ;

????Connection?conn? = ? null ;

????Statement?stmt? = ? null ;

????ResultSet?rs? = ? null ;

????ResultSetMetaData?rsm? = ? null ;

????response.setContentType( " text/html " );

????java.io.PrintWriter?out? = ?response.getWriter();

????out

????????.println( " <html><head><title>Weblogic?Database?Access</title></head><body> " );

????out.println( " <h2>Database?info</h2> " );

????out.println( " <table?border='1'><tr> " );

???? try ? {

??????conn? = ?pool.getConnection();

??????stmt? = ?conn.createStatement();

??????rs? = ?stmt.executeQuery(sql);??rsm? = ?rs.getMetaData();

?????? int ?colCount? = ?rsm.getColumnCount();

?????? // print?column?names

?????? for ?( int ?i? = ? 1 ;?i? <= ?colCount;? ++ i)? {

????????out.println( " <th> " ? + ?rsm.getColumnName(i)? + ? " </th> " );

??????}

??????out.println( " </tr> " );

?????? while ?(rs.next())? {

????????out.println( " <tr> " );

???????? for ?( int ?i? = ? 1 ;?i? <= ?colCount;? ++ i)

??????????out.println( " <td> " ? + ?rs.getString(i)? + ? " </td> " );

????????out.println( " </tr> " );

??????}

????} ? catch ?(Exception?e)? {

?????? throw ? new ?ServletException(e.getMessage());

????} ? finally ? {

?????? try ? {

????????stmt.close();

????????conn.close();

??????} ? catch ?(SQLException?sqle)? {

??????}

????}

????out.println( " </table></body></html> " );

????out.close();

??} ? // doGet

} ?

posted on 2006-05-14 00:43 record java and net 閱讀(401) 評(píng)論(0) 編輯收藏所屬分類: Jsp&&Web

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問(wèn) 管理
相關(guān)文章: jsp url重寫(xiě) 偷窺struts+hibernate分頁(yè)(第二種方法) javascript常用到的一些方法 java發(fā)送email Jstl 操作數(shù)據(jù)庫(kù)相關(guān) Weblogic database Servlet tomcat配置jndi數(shù)據(jù)源小記初學(xué)者有用.整理一些初級(jí)代碼文件上傳分頁(yè)

blogjava's web log

Weblogic database Servlet

導(dǎo)航

常用鏈接

留言簿(44)

新聞檔案

2.動(dòng)態(tài)語(yǔ)言

3.工具箱

9.文檔教程

友情鏈接

搜索

最新評(píng)論