package cn.com.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DB { public static Connection getConnection(){ String DBUrl = "jdbc:oracle:thin:@localhost:1521:leadfar"; String DBUser = "ur"; String DBPassword = "ur"; Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { conn = DriverManager.getConnection(DBUrl,DBUser,DBPassword); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void commit(Connection conn){ try { conn.commit(); } catch (SQLException e) { e.printStackTrace(); } } public static void close(Statement stmt){ try { if(stmt != null){ stmt.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void close(ResultSet rs){ try { if(rs!=null){ rs.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void close(Connection conn){ if(conn != null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void rollback(Connection conn){ try { conn.rollback(); } catch (SQLException e) { e.printStackTrace(); } } public static void main(String[] args) { System.out.println(DB.getConnection()); } }