在连接数据库时我们先需要在Android里下载一个jar包
mysql-connector-java
这个包可以去官网下载
然后在Android创建类JDBCUTILS
import android.util.Log;
import java.sql.Connection;
import java.sql.DriverManager;
public class JBBCUtils {
private static final String TAG = "MYSQL";
private static Connection conn = null;
private static final String ip ="这里填写你的ip地址";
private static final int port ="这里填写你的端口号";
private static final String user = "root";
private static final String password = "这里填写你连接数据库使用的密码";
public static Connection getConn(String dbname) {
String url = "jdbc:mysql://" + ip + ":" + port + "/" + dbname;
try {
Class.forName("com.mysql.jdbc.Driver");
conn =DriverManager.getConnection(url,user,password);
Log.d(TAG, "数据库连接成功");
} catch (Exception e) {
Log.d(TAG, "数据库连接失败");
}
return conn;
}
}