连接oracle换成mysql_怎样将连接oracle转换成连接mysql的？

packagecom.dw.util;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.util.Properties;publicclassDbCo...

package com.dw.util;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;

public class DbConn {

/**

* 数据库连接类

* @author DY1101shaoyuxian

*/

private static String username=null;

private static String password=null;

private static String driver=null;

private static String url=null;

static{

Properties ps=new Properties();

try {

ps.load(DbConn.class.getResourceAsStream("/db.properties"));

driver=ps.getProperty("driver");

url=ps.getProperty("url");

username=ps.getProperty("username");

password=ps.getProperty("password");

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static Connection getConn() {

Connection con = null;

try {

Class.forName(driver);

con = DriverManager.getConnection(url, username, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return con;

}

public void closeCon(Connection con) {

// TODO Auto-generated method stub

if(con!=null){

try {

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public static void main(String[] args) {

try {

DbConn.getConn();

System.out.println("数据库连接成功");

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

展开