当前位置:数据库 > Oracle >>

单独的java程序连接oracle数据库

[java] 
/**
 * 单独的java程序连接oracle数据库
 * author:JavaAlpha
 * date :2012-12-3 12:02:44
 */ 
import java.sql.*; 
public class Test { 
public static void main(String[] args){ 
String driver = "oracle.jdbc.driver.OracleDriver"; 
String url = "jdbc:oracle:thin:@192.168.1.1:1521:orcl"; 
String user = "root"; 
String password = "123456"; 
try { 
Class.forName(driver);  
        Connection conn = DriverManager.getConnection(url, user, password); 
        if(!conn.isClosed()) 
            System.out.println("Succeeded connecting to the Database!");  
            Statement statement = conn.createStatement(); 
            String sql = "SELECT PASSWORD from USER WHERE id='test1'"; 
             
      ResultSet rs = statement.executeQuery(sql);        
      while(rs.next())   www.zzzyk.com
            { 
             System.out.println(rs.getString("PASSWORD")); 
            } 
            rs.close(); 
            conn.close(); 
           } catch(ClassNotFoundException e) { 
            System.out.println("Sorry,can`t find the Driver!"); 
            e.printStackTrace(); 
           } catch(SQLException e) { 
            e.printStackTrace(); 
           } catch(Exception e) { 
            e.printStackTrace(); 
           }           


补充:软件开发 , Java ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,