android怎么连接mysql

android怎么连接mysql？

第一步：连接MySQL数据库：public class DBOpenHelper { private static String driver = "com.mysql.jdbc.Driver"// MySQL驱动 private static String url = "jdbc:mysql://IP:xxxx/数据库"//MYSQL数据库连接Url private static String user = "root"//用户名 private static String password = "root"//密码 //连接数据库 public static Connection getConn(){ Connection conn = null try { Class.forName(driver)//获取MYSQL驱动 conn = (Connection) DriverManager.getConnection(url, user, password)//获取连接 } catch (ClassNotFoundException e) { e.printStackTrace() } catch (SQLException e) { e.printStackTrace() } return conn } //关闭数据库 public static void closeAll(Connection conn, PreparedStatement ps){ if (conn != null) { try { conn.close() } catch (SQLException e) { e.printStackTrace() } } if (ps != null) { try { ps.close() } catch (SQLException e) { e.printStackTrace() } } } //关闭数据库 public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs){ if (conn != null) { try { conn.close() } catch (SQLException e) { e.printStackTrace() } } if (ps != null) { try { ps.close() } catch (SQLException e) { e.printStackTrace() } } if (rs != null) { try { rs.close() } catch (SQLException e) { e.printStackTrace() } } }}第二步：MySQL数据库操作： public class DBService { private Connection conn=null //打开数据库对象 private PreparedStatement ps=null//操作整合sql语句的对象 private ResultSet rs=null//查询结果的集合 //DBService 对象 public static DBService dbService=null // 构造方法，私有化 private DBService(){ } //获取MySQL数据库单例类对象 public static DBService getDbService(){ if(dbService==null){ dbService=new DBService() } return dbService } // 获取数据 public List