你搞砸了一切。无需导入aws-java-sdk-1.8.5.jar。这是aws-sdk Java jar。用于连接到具有MysqL数据库的RDS实例。您所需要做的就是导入mysql-connector- java-5.1.18-bin.jar并具有在RDS中启动的数据库的访问权限和凭据。从您的IP(将在其中运行代码的机器)获得连接到数据库的权限,并且此代码将连接到数据库,并且您可以基于您的凭据访问权限执行查询。
public static void main(String[] args)
{
try{
String host = "jdbc:MysqL://rds-ip:3306/rds-database-name";
String uName = "rds-database-username";
String uPass = "rds-database-pasword";
Connection con = DriverManager.getConnection( host, uName, uPass );
Statement stmt = con.createStatement();
String sql = "SELECT * FROM tablename";
ResultSet rs = stmt.executeQuery(sql);
rs.next();
int id_col = rs.getInt("id");
String column1 = rs.getString("column1");
String column2 = rs.getString("column2");
}
catch(sqlException err){
System.out.println(err.getMessage());
}
}