银行交易系统 MyJdbcTools

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(); }

} }

}