servlet连接mysql数据库和oracle数据库

时间:2021-10-12 13:06:39

连接mysql数据库

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class BaseDao
{
//连接mysql数据库
  Connection conn = null;
  Statement st = null;
  PreparedStatement pst = null;
  ResultSet rs = null;
  

  
  public Connection getConn()
  {
    try
    {
          String databaseName = "easynews";//数据库名
          String host = "localhost";
          String port = "3306";
          String username = "root"; //用户AK
          String password = "root"; //用户SK
          String driverName = "com.mysql.jdbc.Driver";
          String dbUrl = "jdbc:mysql://";
          String serverName = host + ":" + port + "/";
          String connName = dbUrl + serverName + databaseName;//数据库地址jdbc:mysql://localhost:3306/easynews
      Class.forName(driverName);
      this.conn = DriverManager.getConnection(connName, username, password);
      if (this.conn != null) {
        System.out.println("数据库连接成功");
      } else {
        System.out.println("数据库连接失败");
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return this.conn;
  }
  
  public void closeAll(Statement st, ResultSet rs, Connection conn)
  {
    try
    {
      if (st != null) {
        st.close();
      }
      if (rs != null) {
        rs.close();
      }
      if (conn != null) {
        conn.close();
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
  }
}

连接oracle数据库

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
 
public class BaseDao
{
  String username = "scott";
  String password = "tiger";
  String url = "jdbc:oracle:thin:localhost:1521:orcl";
  String driver = "oracle.jdbc.driver.OracleDriver";
  Connection conn = null;
  Statement st = null;
  PreparedStatement pst = null;
  ResultSet rs = null;
  
  public Connection getConn()
  {
    try
    {
      Class.forName(this.driver);
      this.conn = DriverManager.getConnection(this.url, this.username, this.password);
      if (this.conn != null) {
      System.out.println("数据库连接成功");
      } else {
        System.out.println("数据库连接失败");
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
    return this.conn;
  }   
  public void closeAll(Statement st, ResultSet rs, Connection conn)
  {
    try
    {
      if (st != null) {
        st.close();
      }
      if (rs != null) {
        rs.close();
      }
      if (conn != null) {
        conn.close();
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
  }
}