JDBCUtil连接数据库的写法

JDBCUtil连接mySQL数据库的写法：

代码：

import com.harzone.dongguan.service.JDBCutil;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;

import java.sql.*;

@Component
public class JDBCUtilImpl implements JDBCutil {
    @Value("${jdbc.username}")
    private  String username;
    @Value("${jdbc.password}")
    private  String password;
    @Value("${jdbc.path}")
    private  String Path;
    @Value("${jdbc.port}")
    private String port;
    @Value("${jdbc.DatabaseName}")
    private String DatabaseName;

    @Override
    public Connection getConnection() {
        try {
            try {
                Class.forName("com.mysql.cj.jdbc.Driver");
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
            String url = "jdbc:mysql://" + Path + ":" + port + "/" + DatabaseName + "?characterEncoding=utf8&useSSL=true&serverTimezone=GMT";
            Connection connection = DriverManager.getConnection(url, username,password);
            return connection;
        } catch (SQLException e) {
            System.out.println("数据库连接失败。。。。。");
            e.printStackTrace();
        }
        return null;
    }

    @Override
    public void colseAll(ResultSet rs, Statement statement, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (statement != null) {
            try {
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

配置相关写法：

#数据库连接
jdbc:
  username: root
  password: root
  path: localhost
  port: 3306
  DatabaseName: demo01

调用相关的写法：

 　　　　　　PreparedStatement preparedStatement = null;
            Connection connection = jdbcUtil.getConnection();
            //查询字典表获取性别code
            String sql = "SELECT * FROM dictionary d WHERE d.type='XBDM'";
            try {
                preparedStatement = connection.prepareStatement(sql);
                ResultSet rs = preparedStatement.executeQuery();
                while (rs.next()) {
                    String code_name = rs.getString("code_name");
                    //判断得到的性别和字典表的性别，匹配返回对应的code值
                    if (genderCode.equals(code_name)) {
                        String code = rs.getString("code");
                        //将code封装到请求体，实现转换字段
                        bodyMap.put("genderCode", code);
                    }
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }