注册 登录
编程论坛 Oracle论坛

[求助] 在MyEclipse中直联oracle方法!

j2ee126 发布于 2008-07-18 14:52, 1813 次点击
我想在在MyEclipse中写一个直联oracle方法,怎么写啊!
1 回复
#2
luyihuaa52012008-07-30 17:03
public class DBAccess {
    private String driver="oracle.jdbc.driver.OracleDriver";
    
    private String url="jdbc:oracle:thin:@localhost:1521:SID";
    
    private String user="userName";
    
    private String pwd="passWord";
    
    private Connection conn;
    private Statement stmt;
    private ResultSet rst;
    
    public DBAccess(){
        try {
            Class.forName(driver);
            conn=DriverManager.getConnection(url,user,pwd);
            stmt=conn.createStatement();
            System.out.println("连接成功");
        } catch (ClassNotFoundException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        
    }
    
    
    public ResultSet query(String sql){
        try {
            rst=stmt.executeQuery(sql);
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return rst;
    }
    
    
    public int update(String sql){
        int flag=-1;//如果返回-1说明执行失败,如果返回0成功
        try {
            flag=stmt.executeUpdate(sql);
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return flag;
    }
    
    public void close(){
        try{
        
        if(rst!=null){
            rst.close();
            rst=null;
            
        }
        
        if(stmt!=null){
            stmt.close();
            stmt=null;
            
        }
        
        if(conn!=null){
            conn.close();
            conn=null;
            
        }
        }catch(SQLException e){
//             TODO 自动生成 catch 块
            e.printStackTrace();
        }
        
    }


    public Connection getConn() {
        return conn;
    }
    public static void main(String[] args) {
        DBAccess access = new DBAccess();
    }
}
1