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;
}
}
