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

JAVA连接oracle数据库

[html] <SPAN style="COLOR: #ff6666; FONT-SIZE: 14px">package util; 
 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
 
import javax.naming.Context; 
import javax.naming.InitialContext; 
import javax.naming.NamingException; 
import javax.sql.DataSource; 
 
public class DBCon { 
    //数据库驱动对象 
    public static final String DRIVER="oracle.jdbc.driver.OracleDriver"; 
    //数据库连接地址(数据库名) 
    public static final String URL="jdbc:oracle:thin:@localhost:1521:orcl"; 
    //登陆名 
    public static final String USER="FM"; 
    //登陆密码 
    public static final String PWD="FM"; 
    //创建数据库连接对象 
    private Connection con=null; 
    //创建数据库预编译对象 
    private PreparedStatement ps=null; 
    //创建结果集 
    private ResultSet rs=null; 
    //创建数据源对象 
    public static DataSource source=null; 
 
//  //静态代码块 
//  static{ 
// 
//      //初始化配置文件context 
//      try { 
//          Context context=new InitialContext(); 
//          source=(DataSource)context.lookup("java:comp/env/jdbc/webmessage"); 
//      } catch (Exception e) { 
//          // TODO Auto-generated catch block 
//          e.printStackTrace(); 
//      } 
// 
// 
//  } 
 
        /** 
         * 获取数据库连接 
         */ 
        public Connection getCon(){ 
            try { 
                Class.forName(DRIVER); 
            } catch (ClassNotFoundException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
            try { 
                con=DriverManager.getConnection(URL,USER,PWD); 
            } catch (SQLException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
             
            return con; 
        } 
//  /** 
//   * 获取数据库连接 
//   */ 
//  public Connection getCon(){ 
// 
//      try { 
//          con=source.getConnection(); 
//      } catch (SQLException e) { 
//          // TODO Auto-generated catch block 
//          e.printStackTrace(); 
//      } 
// 
//      return con; 
//  } 
 
 
    /** 
     * 关闭所有资源 
     */ 
    public void closeAll(){ 
        if(rs!=null) 
            try { 
                rs.close(); 
            } catch (SQLException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
            if(ps!=null) 
                try { 
                    ps.close(); 
                } catch (SQLException e) { 
                    // TODO Auto-generated catch block 
                    e.printStackTrace(); 
                } 
                if(con!=null) 
                    try { 
                        con.close(); 
                    } catch (SQLException e) { 
                        // TODO Auto-generated catch block 
                        e.printStackTrace(); 
                    } 
 
 
    } 
    /** 
     * @

补充:软件开发 , Java ,
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,