Servlet操作Oracle
package test;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
public class Conndb extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
response.setContentType("text/html");
response.setCharacterEncoding("gb2312");
PrintWriter out = response.getWriter();
out.println("<table border=1>");
out.println("<tr><td>Content:</td></tr>");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.250:1521:test", "scott", "tiger");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from emp");
while(rs.next()){
out.println("<tr>");
out.println("<td>" + rs.getString("ename") + "</td>");
out.println("<td>" + rs.getString("MGR") + "</td>");
out.println("</tr>");
}
out.println("</table>");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt= null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22990797/viewspace-2638121/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- servlet 當中操作檔案Servlet
- servlet,filter,sessionListener,cookie,session操作ServletFilterSessionCookie
- Servlet連線OracleServletOracle
- 使用“純”Servlet做一個單表的CRUD操作Servlet
- Oracle EBS - Forms Servlet與Socket模式比較OracleORMServlet模式
- Servlet技術---Servlet深化Servlet
- Servlet系列:(一)servlet原理剖析Servlet
- Servlet技術----Servlet入門Servlet
- JAVA類中透過Servlet操作JSP中Session變數方法JavaServletJSSession變數
- 求救:jdbc與mysql透過Servlet操作後連線關閉不了JDBCMySqlServlet
- Oracle 集合操作Oracle
- oracle基本操作Oracle
- oracle索引操作Oracle索引
- Oracle列操作Oracle
- ORACLE批量操作Oracle
- oracle 表操作Oracle
- Servlet.service() for Servlet jsp threw exception javax.servlet.ServletException:File "/pageFooServletJSExceptionJava
- JSP實現servlet對資料庫的增刪查改操作JSServlet資料庫
- Jsp/Servlet:小結圖片操作的一些程式碼薦JSServlet
- JavaWeb——ServletJavaWebServlet
- JavaWEB - ServletJavaWebServlet
- Oracle的move操作Oracle
- Oracle 共享池操作Oracle
- Oracle並行操作——並行DML操作Oracle並行
- Java+MyEclipse+Tomcat (四)Servlet提交表單和資料庫操作JavaEclipseTomcatServlet資料庫
- Servlet 如何工作Servlet
- Java之ServletJavaServlet
- Servlet筆記Servlet筆記
- Servlet 新手教程Servlet
- Web核心-ServletWebServlet
- Servlet面試題Servlet面試題
- servlet詳解Servlet
- 非同步Servlet非同步Servlet
- Servlet基礎Servlet
- Servlet第二篇【Servlet呼叫圖、Servlet細節、ServletConfig、ServletContext】ServletContext
- Servlet3.0新特性-非同步處理Servlet、FilterServlet非同步Filter
- Servlet第一篇【介紹Servlet、HTTP協議、WEB目錄結構、編寫入門Servlet程式、Servlet生命週期】ServletHTTP協議Web
- DBA ORACLE連線操作Oracle