打印本文 打印本文 关闭窗口 关闭窗口
JDBC连接Oracle和Mysql数据库示例
作者:武汉SEO闵涛  文章来源:敏韬网  点击数959  更新时间:2009/4/22 20:49:10  文章录入:mintao  责任编辑:mintao

 import java.sq.*;
 
 Connection conn = null;
 Statement stmt;
 ResultSet rs;  
  
 String sql = "select * from tab " ;

 //con = DriverManager.getConnection("jdbc:poolman://tgpms-help");

 //连接Oracle数据库
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
 conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.15.248:1521:ycdb","webcfcquery","kill859");
 
//连接Mysql数据库
 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
 conn = DriverManager.getConnection("jdbc:mysql://localhost/meeting","root","21century");
 
  
 stmt = con.createStatement();
 rs = stmt.executeQuery(sql);  
 
 rs.close();
 stmt.close();
 con.close();

打印本文 打印本文 关闭窗口 关闭窗口