在java中使用jdbc连接mysql数据库
public static Connection getConnection(String ip, String port, String user, String pwd) {
Connection conn = null;
try { //port一般是 3306
String url = "jdbc:mysql://"+ ip + ":"+ port +"/test?characterEncoding=utf8&useSSL=true&createDatabaseIfNotExist=true";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, pwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}