jdbc工具类链接oracle,java连接Oracle的工具类jdbc编程

public class JdbcUtils {

private static String url&＃61;"jdbc:oracle:thin:&＃64;localhost:1521:orcl";

private static String user&＃61;"scott";

private static String pwd&＃61;"tiger";

private JdbcUtils(){

}

// 1、注册驱动oracle.jdbc.driver.OracleDriver

static{

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("数据库驱动加载失败&＃xff01;");

}

}

// 2、建立一个连接

public static Connection getConnection() throws SQLException{

return DriverManager.getConnection(url, user, pwd);

}

// 5、关闭资源

public static void free(ResultSet rs,Statement stmt,Connection conn){

try {

if(rs!&＃61;null)

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(stmt!&＃61;null)

stmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(conn!&＃61;null)

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}