前几天被一个项目对接要搞死了,搞了好几天,各种方法去试、各种百度去搜、各个门道去问,最终终于解决了心头一缕缕思愁!!!😭 😭 😭
先说一下我本地开发环境:Windows + MySQL(5.7.31)
原理:运用原生JDBC
/**
* 查询数据
* @return
*/
public List<AttThirdIMessagetem> getSelectData( String ip, String port, String user,String password,-String databaseName,){
String connectionUrl = "";
if(checkParam(ip,port,user,password,databaseName)){
connectionUrl = "jdbc:mysql://"+ip+":"+port+"/"+databaseName+"";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(connectionUrl,user,password);
// 获取最新
String attLeaveSql = " ";//sql语句
stmt = con.createStatement();
rs = stmt.executeQuery(attLeaveSql);
while (rs.next()) {
//处理获取数据
continue;
}
} catch (Exception e) {
logger.error("获取接口连接失败",e);
} finally {
if (rs != null) try {
rs.close();