package jdbc.eduask.banksystem;
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.SQLException; public class MyJdbcTools {
 /**用户名*/
 static String user="scott";
 /**密码*/
 static String password="tiger";
 /**驱动*/
 static String driverName="oracle.jdbc.driver.OracleDriver";
 static String url="jdbc:Oracle:thin:@localhost:1521/orcl"; /** 获取一个连接 */
 public static Connection getConnection() {
 Connection c = null;
 try {
 Class.forName(driverName);// 加载驱动
 c = DriverManager.getConnection(url, user, password);
 } catch (ClassNotFoundException e) {
 e.printStackTrace();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 return c; }
 /** 关闭数据库 */
 public static void close(Connection c) {
 if (c != null) {
 try {
 if (!c.isClosed()) {// 如果没有关闭
 c.close();
 }
 } catch (SQLException e) {
 e.printStackTrace();
 } }
 } }