android 直接连数据库吗,Android直连数据库

这篇文章记录Android直连mysql数据库,直连SqlServer数据库

直连mysql数据库

采用JDBC的方式

第一步:导入mysql架包,下载地址: mysql架包 提取码: iybw

第二步:配置信息

public class Constant {

/**

* 联网数据库驱动

*/

public static final String SQL_DEVICES = "com.mysql.jdbc.Driver";

/**

* 连接数据库条件

*/

public static final String SQL_CONNECTION = "jdbc:mysql://服务器地址:端口号/数据库名称";

/**

* 数据库用户名

*/

public static final String SQL_USERNAME = "用户名";

/**

* 数据库密码

*/

public static final String SQL_PASSWORD = "密码";

}

第三步:可新建类用于增删改查操作:

//查询操作

public static ResultSet result(String sql) throws Exception {

Class.forName(SQL_DEVICES).newInstance(); //加载MYSQL JDBC驱动程序

Connection connection = (Connection) DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME,SQL_PASSWORD);

Statement statement = (Statement) connection.createStatement();

return statement.executeQuery(sql);

}

//插入操作

public static boolean executeInsert(final String insertSql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.execute(insertSql);

} catch (Exception e) {

e.printStackTrace();

}

return true;

}

//值为1成功 更新操作

public static int executeUpdate(final String updateSql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.executeUpdate(updateSql);

} catch (Exception e) {

e.printStackTrace();

}

return 0;

}

至此,mysql的配置以及操作就完成了.

直连SqlServer数据库

采用jtds的方式

导入架包至libs文件夹,下载地址:jtds架包下载 提取码: gbvm

配置信息

public class Constant {

/**

* 联网数据库驱动

*/

public static final String SQL_DEVICES = "net.sourceforge.jtds.jdbc.Driver";

/**

* 连接数据库条件

*/

public static final String SQL_CONNECTION = "jdbc:jtds:sqlserver://服务器地址:端口/数据库名称;charset=utf8";

/**

* 数据库用户名

*/

public static final String SQL_USERNAME = "用户名";

/**

* 数据库密码

*/

public static final String SQL_PASSWORD = "密码";

}

具体的数据操作

public class JtdsHttp {

private static JtdsHttp instance = new JtdsHttp();

public static JtdsHttp getInstance() {

return instance;

}

//查询

public ResultSet executeQuery(final String querySql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.executeQuery(querySql);

} catch (Exception e) {

e.printStackTrace();

}

return null;

}

//插入

public boolean executeInsert(final String insertSql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.execute(insertSql);

} catch (Exception e) {

e.printStackTrace();

}

return true;

}

//值为1成功 更新

public int executeUpdate(final String updateSql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.executeUpdate(updateSql);

} catch (Exception e) {

e.printStackTrace();

}

return 0;

}

//删除

public boolean executeDelete(final String deleteSql) {

try {

Class.forName(SQL_DEVICES).newInstance();

Connection connection = DriverManager.getConnection(

SQL_CONNECTION, SQL_USERNAME, SQL_PASSWORD);

Statement statement = connection.createStatement();

return statement.execute(deleteSql);

} catch (Exception e) {

e.printStackTrace();

}

return false;

}

}

直连SqlServer的方式就这些了,跟mysql的差不多