Java-->Android 直连 Ms Sql Server 2008数据库

首先下载jar包: http://download.csdn.net/detail/angcyo/9111585

连接方法

public void dbConnect(String db_connect_string, String db_userid, String db_password) {    try {        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");        Connection conn = DriverManager.getConnection(db_connect_string, db_userid, db_password);        System.out.println("connected");//如果执行到此,说明连接成功        conn.close();    }catch (Exception e) {        e.printStackTrace();}

调用方式:

dbConnect("jdbc:sqlserver://223.244.227.14:21006;databaseName=OnDemand", "xzsoft1", "xzsoft2");

解释一下:
223.244.227.14 – 数据库ip
21006 – 数据库端口
OnDemand – 数据库名称
xzsoft1 – 用户名
xzsoft2 –密码

增删改查

Statement statement = conn.createStatement();//用于执行查询语句String queryString = "select * from sysobjects where type='u'";// 枚举所有表ResultSet rs = statement.executeQuery(queryString);//唯有查询 用这个方法   while (rs.next()) {    System.out.println(rs.getString(1));   }ResultSet rs2 = statement.executeQuery("select * from ds_member_locations");//查询ds_member_locations表中的所有字段while (rs2.next()) {    System.out.println(rs2.getString(1) + " " + rs2.getString(2) + " " + rs2.getString(3) + " "      + rs2.getString(4) + " " + rs2.getString(5) + " " + rs2.getString(6));//输出所有字段,注意索引从1开始,而不是0开始   }   int n = statement.executeUpdate("INSERT INTO test_name VALUES ('测试1234124')");//插入数据库,返回值为 影响的行数   int n2 = statement     .executeUpdate("UPDATE test_name SET name2 = 'new 测试1234124' WHERE name2 = '测试1234124123123123' ");//更新数据   String sql2 = String.format("DELETE FROM test_name WHERE name2 = '%s'", "123124");//删除数据   int n3 = statement.executeUpdate(sql2);

存储过程的调用

CallableStatement cstmt = conn.prepareCall("{ call dbo.Notify_Online(?,?,?,?,?)}");   // 设置对应的参数,需要指定参数的类型   cstmt.setInt(1, 2);   cstmt.setFloat(2, 88.26313500000f);   cstmt.setFloat(3,88.26313500000f);   cstmt.setInt(4, 1);   // 注册OUT参数   cstmt.registerOutParameter(5, java.sql.Types.SMALLINT);//输出参数的类型和位置   // 执行存储过程   cstmt.execute();   // 获取参数值   System.out.println(cstmt.getInt(5));//得到返回值

扩展阅读:
http://ryxxlong.iteye.com/blog/1033762
http://www.searchsoa.com.cn/showcontent_61502.htm

至此: 文章就结束了,如有疑问: QQ群:274306954 欢迎您的加入.

更多相关文章

随机推荐