IT猫扑网文章教程

分类分类

连接Oracle的驱动与mysql

2015-06-28 00:00作者:网管联盟

  Mysql的驱动:

  public PersonOperation() {

  try {

  Class.forName(&com.mysql.jdbc.Driver&);

  try {

  connection = DriverManager.getConnection(

  &jdbc:mysql://localhost:3306/linger&, &root&, &123456&);

  //&jdbc:mysql://localhost:3306/checkcode?useUnicode=true&characterEncoding=utf-8&;

  } catch (SQLException e) {

  // TODO Auto-generated catch block

  e.printStackTrace();

  }

  } catch (ClassNotFoundException e) {

  // TODO Auto-generated catch block

  e.printStackTrace();

  }

  // connection = DBPool.getConnection();

  }

  Oracle的驱动:

  public class Driver {

  public static void main(String[] args) throws IOException,

  InstantiationException, IllegalAccessException,

  ClassNotFoundException {

  Connection con = null;

  try {

  Class.forName(&oracle.jdbc.driver.OracleDriver&);

  con = DriverManager.getConnection(

  &jdbc:oracle:thin:@localhost:1521:orcl&, &system&, &sys&);

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

  Statement statement = con.createStatement();

  ResultSet resultSet = statement

  .executeQuery(&select * from scott.emp&);

  while (resultSet.next()) {

  System.out.print(resultSet.getString(1));

  System.out.print(resultSet.getString(2));

  System.out.print(resultSet.getString(3));

  System.out.println(resultSet.getString(4));

  }

  } catch (SQLException e) {

  }

  }

  }

展开全部

相关文章

说两句网友评论
    我要跟贴
    取消