使用JAVA连接Oracle

最新推荐文章于 2025-11-26 15:59:01 发布

原创最新推荐文章于 2025-11-26 15:59:01 发布 · 845 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #string #templates #null #sql #oracle

此博客展示了用Java连接Oracle数据库并执行SQL查询的代码。定义了连接字符串、用户和密码，通过`dBConn`方法建立连接，`query`方法执行查询，`dBEnds`方法关闭连接，最后在`main`方法中查询`emp`表中`job`为`MANAGER`的数据。

package edu.gzu.kyle;
import java.sql.*;

/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class OracleTest {
   protected Connection conn = null;
   protected Statement stmt = null;
   private String url = "jdbc:oracle:thin:@JH1:1521:ORA92";   //连接字符串
   private String usr = "scott";     //连接使用的用户和密码
   private String pwd = "tiger";

   public OracleTest(){
       super();
   }
   public void dBConn(){
       try{
       Class.forName("oracle.jdbc.driver.OracleDriver");
       conn = DriverManager.getConnection(url, usr, pwd);
       stmt = conn.createStatement();
       }catch(ClassNotFoundException e){
       System.out.println("Class not foune");
       e.printStackTrace();
       }catch(SQLException e){
       e.printStackTrace();
       }
       }
   public ResultSet query(String sql) throws SQLException{
       return stmt.executeQuery(sql);
       }
   public void dBEnds(){
       try{
       if(stmt != null){
       stmt.close();
       stmt = null;
       }
       }catch(SQLException e){
       e.printStackTrace();
       }
   }

   public static void main(String[] args) {

       String sql = "select * from emp where job='MANAGER'";
       OracleTest ot = new OracleTest() ;
       try{
       ot.dBConn();
       ResultSet rs = ot.query(sql);
       while (rs.next()) {
       System.out.println(rs.getString(1));
       }
       rs.close();
         }catch(SQLException e){
       e.printStackTrace();
       }finally{
          ot.dBEnds();
       }
   }
}