一个较完整的连接数据库写法!(请大家参考)

代码如下(以oralce连接为例

import  java.sql. * ; public   class  Conn  ... {    /** *//**     * @param args     */    public static void main(String[] args) ...{        // TODO 自动生成方法存根        String driver = "oracle.jdbc.driver.jdbcDriver";        Connection conn = null; // 初始化连接对象；        PreparedStatement stmt = null; // 初始化语句对象；        ResultSet rs = null; // 初始化结果集对象；        String user = "scott";        String pwd = "tiger";        String url = "jdbc:oracle:thin:@localhost:1521";        String sql = "具体sql语句";        try ...{            Class.forName(driver); // 调用数据库驱动；            conn = DriverManager.getConnection(url, user, pwd); // 引用连接对象；            stmt = conn.prepareStatement(sql); // 引用语句对象；            rs = stmt.executeQuery();            while (rs.next()) ...{                                                                //具体数据提取（略）            }        } catch (Exception e) ...{            // TODO 自动生成 catch 块            e.printStackTrace();        } finally ...{            try ...{                if (rs != null) // 判断结果集是否为空，避免空指针异常；                    rs.close(); // 关闭结果集对象；            } catch (Exception e1) ...{                // TODO 自动生成 catch 块                e1.printStackTrace();            }            try ...{                if (stmt != null) // 判断语句对象是否为空，避免空指针异常；                    stmt.close(); // 关闭语句对象；            } catch (Exception e2) ...{                // TODO 自动生成 catch 块                e2.printStackTrace();            }            try ...{                if (conn != null) // 判断连接对象是否为空，避免空指针异常；                    conn.close(); // 关闭连接对象；            } catch (SQLException e3) ...{                // TODO 自动生成 catch 块                e3.printStackTrace();            }        }    }}

)：呵呵，好了