Android能不能直接访问MySQL数据库? Android能直接访问MySQL数据库,还是应该通过中介来访问,比如做个PHP页面? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;//import com.mysql.jdbc.Driver;public class MysqlConn { /*cpcp 驱动程序名*/ public static final String DRIVER = "com.mysql.jdbc.Driver"; /*sinaweibo 数据库名*/ public static final String DATABASE = "scenic_management"; public static final String URL = "jdbc:mysql://10.21.14.38:3306/"+DATABASE; //public static final String URL = "jdbc:mysql://localhost:3306/"+DATABASE; public static final String USERNAME = "root"; public static final String PASSWORD = "724241"; Connection connection = null; PreparedStatement preparedStatement = null; ResultSet resultSet = null; public Connection getConnection(){ if (null!=connection){ return connection; } try { Class.forName(DRIVER).newInstance(); connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); } catch (InstantiationException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IllegalAccessException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; }}本地连接可以连上,但是在虚拟机中运行就不行。是这样写吗? Android 使用 SQLite 的很多,使用 mysql 的还真是少见 CFS文件是什么。要怎么才能打开 为什么服务器上面Innodb_buffer_pool_read_ahead_evicted这个会比Innodb_buffer_pool_read_ahead大 mysql如何查询叶子节点 MySQL5.5 数据库名.表名的问题 mysql存储过程参数处理问题 sql 语句如何同时删除多列 一个sql语句怎么写 求将字符类型转化为int类型的mysql语句 sos,mysql不支持in子查询吗? mysql 中执行sql命令 EF6+MySQL字段类型对应问题 !有无试过的呢 mysql中输入不了中文,求解
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
//import com.mysql.jdbc.Driver;public class MysqlConn {
/*cpcp 驱动程序名*/
public static final String DRIVER = "com.mysql.jdbc.Driver";
/*sinaweibo 数据库名*/
public static final String DATABASE = "scenic_management";
public static final String URL = "jdbc:mysql://10.21.14.38:3306/"+DATABASE;
//public static final String URL = "jdbc:mysql://localhost:3306/"+DATABASE;
public static final String USERNAME = "root";
public static final String PASSWORD = "724241"; Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
public Connection getConnection(){
if (null!=connection){
return connection;
}
try {
Class.forName(DRIVER).newInstance();
connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
}
本地连接可以连上,但是在虚拟机中运行就不行。是这样写吗?