javabean 连接oracle数据库

package  oracle;
import java.io.*;
import java.sql.*;

public class OracleBean{
  public  String serverName="localhost";
  public  String driver="oracle.jdbc.driver.OracleDriver";
  public  String url="jdbc:oracle:thin:@59.53.182.95:1521:orcl";
  public  String user="healthy";
  public  String password="jxismp2014";
  public  String Message;
  public  Connection conn;
  
     public boolean connection(){
  try{
  Class.forName(driver);
  }
        catch(ClassNotFoundException ex){
  Message=ex.getMessage(); 
         System.exit(-1);
  }
 
   try{
   conn=DriverManager.getConnection(url,user,password);
   return true;
   }
   catch(SQLException ex){
  Message=ex.getMessage(); 
   return false;
   } 

}


 public boolean close(){

    try{
   conn.close();
   return true;
   }
  catch(Exception ex){
   
  Message=ex.getMessage(); 
   return false;
 } 

}
}

posted @ 2015-03-05 10:33  webnote  阅读(145)  评论(0编辑  收藏  举报