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

连接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();

}

}

}