JDBC连接数据库帮助类
import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;/** * 连接数据包装类 * * @author yanxiaojia * @qq 1576735050 * */public class BaseDao {public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";public static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";public static final String USERNAME = "scott";public static final String PASSWORD = "tiger";/** * 连接数据 * * @return conn */public Connection getConnection() {Connection conn = null;try {Class.forName(DRIVER);conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);} catch (Exception e) {e.printStackTrace();}return conn;}/** * 关闭连接对象 * * @param conn * 连接对象 * @param pstmt * 预编译对象 * @param rs * 结果集 */public void closeAll(Connection conn, PreparedStatement pstmt, ResultSet rs) {try {if (rs != null) {rs.close();}if (pstmt != null) {pstmt.close();}if (conn != null) {pstmt.close();}} catch (Exception e) {e.printStackTrace();}}/** * 增删改操作 * * @param sql * SQL命令 * @param param * 参数 * @return */public int executsQuery(String sql, String[] param) {int result = 0;Connection conn = null;PreparedStatement pstmt = null;try {conn = this.getConnection();pstmt = conn.prepareStatement(sql);if (param != null) {for (int i = 0; i < param.length; i++) {pstmt.setString(i + 1, param[i]);}}result = pstmt.executeUpdate();} catch (Exception e) {e.printStackTrace();} finally {this.closeAll(conn, pstmt, null);}return result;}}