public int GetRemoteData() { String result = "字段1 - 字段2\n"; try { if (!LoginActivity.TestConnect()) return -1; Connection conn = DataBaseUtil.getSQLConnection(); if (conn == null) { /*Looper.prepare(); Toast.makeText(getApplicationContext(), "连接服务器数据库失败,请检查网络连接!将使用本地数据字典。" , Toast.LENGTH_LONG).show(); Looper.loop();*/ return -1; } String sql = "select * from DataDictionary order by firstitem,seconditem,thirditem"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); dbHelper.ClearTable("datadictionary"); iRowCount = 0; while (rs.next()) { strFirstVal[iRowCount] = rs.getString("FirstItem"); strSecondVal[iRowCount] = rs.getString("SecondItem"); strThirdVal[iRowCount] = rs.getString("ThirdItem"); strFouthVal[iRowCount] = rs.getString("FourthItem"); strOperateUnit[iRowCount] = rs.getString("OperateUnit"); dbHelper.InsertDictionary( strFirstVal[iRowCount], strSecondVal[iRowCount], strThirdVal[iRowCount], strFouthVal[iRowCount], strOperateUnit[iRowCount], "TRUE"); iRowCount++; } rs.close(); stmt.close(); conn.close(); return 1; } catch (SQLException e) { e.printStackTrace(); Looper.prepare(); Toast.makeText(getApplicationContext(), "连接服务器数据库异常!" + e.getMessage(), Toast.LENGTH_LONG) .show(); Looper.loop(); return -1; } }