jdbc mysql 解密_java通过JDBC操作mysql

packagejava_project;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;importjava.sql.Types;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;public classJdbcConnection{//MySQL 8.0 以下版本 - JDBC 驱动名及数据库 URL

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";static final String DB_URL = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC&characterEncoding=utf8";//数据库的用户名与密码，需要根据自己的设置

static final String USER = "root";static final String PASS = "";

Connection conn= null;

PreparedStatement stmt= null;

ResultSet rs= null;private voidconnectionDb() {try{

Class.forName(JDBC_DRIVER);

conn=DriverManager.getConnection(DB_URL,USER,PASS);

}catch(SQLException e1) {

e1.printStackTrace();

}catch(Exception e) {

e.printStackTrace();

}

}public List> getResult(String sql,String[] coulmns, int[] types) {

List> list = null;try{

connectionDb();

setParams(sql,coulmns,types);

rs=stmt.executeQuery();

list=handleResultSetToMapList(rs);//完成后关闭

closeDb(conn,stmt,rs);

}catch(SQLException se){//处理 JDBC 错误

se.printStackTrace();

}catch(Exception e){//处理 Class.forName 错误

e.printStackTrace();

}finally{

closeDb(conn,stmt,rs);

}returnlist;

}//格式化结果为集合

private List> handleResultSetToMapList(ResultSet resultSet) throwsSQLException{

List> values = new ArrayList<>();

List columnLabels =getColumnLabels(resultSet);

Map map = null;while(resultSet.next()) {

map= new HashMap<>();for(String columnLabel : columnLabels) {

Object value=resultSet.getObject(columnLabel);

map.put(columnLabel, value);

}

values.add(map);

}returnvalues;

}//获取表头，取表列名称

private List getColumnLabels(ResultSet rs) throwsSQLException{

List labels = new ArrayList<>();

ResultSetMetaData rsmd=rs.getMetaData();for(int i =0; i< rsmd.getColumnCount(); i++) {

labels.add(rsmd.getColumnLabel(i+1));

}returnlabels;

}private voidcloseDb(Connection connection,PreparedStatement prepareStatement, ResultSet resultSet) {//关闭结果集合

if(resultSet != null) {try{

resultSet.close();

}catch(SQLException e) {

e.printStackTrace();

}

}//关闭预见处理语句

if(prepareStatement != null) {try{

prepareStatement.close();

}catch(SQLException e) {

e.printStackTrace();

}

}//关闭连接

if(connection != null) {try{

connection.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}//格式化参数

private boolean setParams(String sql,String[] columns, int[] types) throwsNumberFormatException,SQLException{if(sql == null) {return false;

}

stmt=conn.prepareStatement(sql);if(columns != null && types != null && columns.length != 0 && types.length != 0) {for(int i = 0; i < types.length; i ++) {switch(types[i]) {caseTypes.INTEGER:

stmt.setInt(i+1, Integer.parseInt(columns[i]));break;caseTypes.BOOLEAN:

stmt.setBoolean(i+1, Boolean.parseBoolean(columns[i]));break;caseTypes.CHAR:

stmt.setString(i+1, columns[i]);break;caseTypes.DOUBLE:

stmt.setDouble(i+1, Double.parseDouble(columns[i]));break;caseTypes.FLOAT:

stmt.setFloat(i+1, Float.parseFloat(columns[i]));break;default:break;

}

}

}return true;

}

}