testoracle .java

数据库连接包括连接池。很有用的资料

import  java.sql.*;  
 
   public  class  testOracle  
   {  
   public  static  void  main(String[]  args)  
     {  
     //定义变量初始化：  
     Connection  conn  =  null;  
     Statement  stmt  =  null;  
     ResultSet  rset  =  null;  
       
     System.out.println("开始测试Oracle的数据库驱动程序!");  
       
     try{  
             Class.forName("oracle.jdbc.driver.OracleDriver");  
           }  
     catch(ClassNotFoundException  e)  
           {  
             System.out.println("数据库驱动类没找到");    
           }    
       
       
     try{  
             conn  =  DriverManager.getConnection("jdbc:oracle:thin@192.168.0.8:1521:lzg","lzg","19721021");  
             System.out.println("数据库连接成功！");    
         }catch(SQLException  e)  
         {  
           System.out.println("执行SQL语句异常！");              
           e.printStackTrace();    
         }  
             
       }  
   }