java dbhelper类_DBHelper--Java JDBC SSH 连接数据库工具类

概述

JDBC 指 Java 数据库连接，是一种标准Java应用编程接口( JAVA API)，用来连接 Java 编程语言和广泛的数据库。

简单使用

使用JDBC需要以下几个步骤

1. 加载JDBC驱动程序

2. 提供JDBC连接的URL

3. 创建数据库连接

4. 创建一个Statement对象

5. 执行SQL语句

6. 处理返回结果

7. 关闭数据库连接

废话少说上代码

package com.aicai.qa.tools.statics;

import com.aicai.qa.tools.statics.config.SysConfigUtil;

import java.sql.*;

/**

* @author tengfei

* @version 1.0

* @date 2018/7/15 下午8:32

*/

public class DBHelper {

private static DBHelper dbHelper=null;

private String host;

private Integer port;

private String dataBaseName;

private String jdbcDriver;

private String userName;

private String password;

private String jdbcConnectionStr;

private Connection connection;

private PreparedStatement preparedStatement;

private ResultSet resultSet;

private DBHelper() {

this.host = SysConfigUtil.getSysConfigUtil("jdbc.properties").getString("jdbc.host");

this.port = SysConfigUtil.getSysConfigUtil("jdbc.properties").getInt("jdbc.port");

this.dataBaseName = SysConfigUtil.getSysConfigUtil("jdbc.properties").getString("jdbc.dataBaseName");

this.userName = SysConfigUtil.getSysConfigUtil("jdbc.properties").getString("jdbc.userName");

this.password = SysConfigUtil.getSysConfigUtil("jdbc.properties").getString("jdbc.password");

this.jdbcDriver = SysConfigUtil.getSysConfigUtil("jdbc.properties").getString("jdbc.driver");

jdbcConnectionStr = String.format("jdbc:mysql://%s:%s/%s", host, port, dataBaseName);

}

public static DBHelper createDBHelper() {

dbHelper = new DBHelper