connectdatabase.java

来自「scwcd的考试,测试代码,如果希望参加此类考试将非常的有帮助」· Java 代码 · 共 64 行

JAVA

64 行

package scwcd.ch02;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class ConnectDatabase extends HttpServlet {
  Connection conn = null;
  String targetDB;
  int cannotConnect = 0;

  public void init() throws ServletException {
    String driver_type = "oracle.jdbc.driver.OracleDriver";
    String url         = "jdbc:oracle:thin:@localhost:1521:ora9201";
    String username    = "scott";
    String passwd      = "tiger";
 
    try{
      Class.forName(driver_type);
      conn = DriverManager.getConnection(url, username, passwd);
      DatabaseMetaData md = conn.getMetaData();
      targetDB = md.getDatabaseProductName();
    }
    catch (ClassNotFoundException e) {
      cannotConnect = 1;
    }
    catch (SQLException e){
      cannotConnect = 2;
    }
  }

  public void doGet(HttpServletRequest request, 
                    HttpServletResponse response) 
              throws ServletException, IOException {
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();

    if (cannotConnect ==1) {
      out.println("<html><body>");
      out.println("Cannot load the specified JDBC driver... ");
      out.println("</html></body>");
    } else {
      if (cannotConnect ==2) {
        out.println("<html><body>");
        out.println("Cannot create database connection...");
        out.println("</html></body>");
      }
      else {
        out.println("<html><body>");
        out.println("<p>Database connection successfully created!</p>");
        out.println("<p>The target database is: "+ targetDB +"</p>");
        out.println("</body></html>");
      }
    }
    out.close();
  }   
  public void destroy() {
    try {
      conn.close();
    } catch(SQLException e){} 		
  }  
}

connectdatabase.java - 源码说明

本页面展示了「scwcd的考试,测试代码,如果希望参加此类考试将非常的有帮助」中的 connectdatabase.java 源码文件，采用 Java 编程语言编写，共 64 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与SCWCD相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?