public IEnumerable <Person> Read() { CreateConnectionAndQuery("SELECT Id, FirstName, LastName, Age FROM person"); ResultSet dataReader = query.executeQuery(); personList.Clear(); while (dataReader.next()) { personList.Add( new Person( (uint)dataReader.getInt(0), dataReader.getString(1), dataReader.getString(2), (uint)dataReader.getInt(3) ) ); } dataReader.close(); dataReader.Dispose(); DisposeConnection(); return(personList); }
static public Hashtable find(string sql) { PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); Hashtable result = resultSet.hasNext() ? resultSet.fetch() : new Hashtable(); resultSet.Dispose(); pdo.Dispose(); return(result); }
public void DisposeResultSet() { // Setup: Mock file stream factory, mock db reader var mockFileStreamFactory = new Mock <IFileStreamFactory>(); // If: I setup a single resultset and then dispose it ResultSet rs = new ResultSet(Common.Ordinal, Common.Ordinal, mockFileStreamFactory.Object); rs.Dispose(); // Then: The file that was created should have been deleted mockFileStreamFactory.Verify(fsf => fsf.DisposeFile(It.IsAny <string>()), Times.Once); }
/// <summary> /// Disposes of the underlying resources. /// </summary> public void Dispose() { if (ResultGraph != null) { ResultGraph.Dispose(); ResultGraph = null; } if (ResultSet != null) { ResultSet.Dispose(); ResultSet = null; } }
public void DisposeResultSet() { // Setup: Mock file stream factory, mock db reader var mockFileStreamFactory = new Mock <IFileStreamFactory>(); var mockDataReader = Common.CreateTestConnection(null, false).CreateCommand().ExecuteReaderAsync().Result; // If: I setup a single resultset and then dispose it ResultSet rs = new ResultSet(mockDataReader, Common.Ordinal, Common.Ordinal, mockFileStreamFactory.Object); rs.Dispose(); // Then: The file that was created should have been deleted mockFileStreamFactory.Verify(fsf => fsf.DisposeFile(It.IsAny <string>()), Times.Once); }
static public List <Hashtable> select(string sql) { List <Hashtable> list = new List <Hashtable>(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); while (resultSet.hasNext()) { list.Add(resultSet.fetch()); } resultSet.Dispose(); pdo.Dispose(); return(list); }
public List <Hashtable> select() { List <Hashtable> result = new List <Hashtable>(); string sql = builder.buildSelect(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); while (resultSet.hasNext()) { result.Add(resultSet.fetch()); } resultSet.Dispose(); pdo.Dispose(); return(result); }
public List <string> column(string field) { List <string> result = new List <string>(); string sql = builder.buildSelect(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); while (resultSet.hasNext()) { Hashtable hashtable = resultSet.fetch(); result.Add(hashtable[field].ToString()); } resultSet.Dispose(); pdo.Dispose(); return(result); }
protected void selectCollect(Collect <Hashtable> collect) { if (collect == null) { throw new NullReferenceException("collect 列不能为Null"); } string sql = builder.buildSelect(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); while (resultSet.hasNext()) { collect.Add(resultSet.fetch()); } resultSet.Dispose(); pdo.Dispose(); }
public Hashtable column(string field, string key) { Hashtable result = new Hashtable(); string sql = builder.buildSelect(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); while (resultSet.hasNext()) { Hashtable hashtable = resultSet.fetch(); var k = hashtable[key]; var v = hashtable[field]; result[k] = v; } resultSet.Dispose(); pdo.Dispose(); return(result); }
public Hashtable find() { //limit(1); string sql = builder.buildSelect(); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); Hashtable hashtable = null; if (resultSet.hasNext()) { hashtable = resultSet.fetch(); } else { hashtable = new Hashtable(); } resultSet.Dispose(); pdo.Dispose(); return(hashtable); }
virtual protected Hashtable parseData(Hashtable data, bool isInsert) { Hashtable result = new Hashtable(); // 分析数据 try { var sql = getTableFind(parseTable()); PDO pdo = new PDO(); ResultSet resultSet = pdo.query(sql); int length = resultSet.columnCount(); for (int i = 0; i < length; i++) { string col = resultSet.columnName(i); string type = resultSet.columnType(i); if (col.ToLower().Equals("id")) { continue; } if (data.ContainsKey(col)) { object content = data[col]; if (content is ArrayList) { ArrayList var = (ArrayList)content; if (var[0].Equals("inc") || var[0].Equals("dec")) { string fuhao = var[0].Equals("inc") ? "+" : "-"; result.Add(col, col + fuhao + var[1]); } } else { result.Add(col, getFieldValue(type, content.ToString())); } } else { if (isInsert) { result.Add(col, getFieldDefault(type)); } } } resultSet.Dispose(); pdo.Dispose(); /* * DataSet dataSet = Connect.getDataSet(sql); * DataColumnCollection columns = dataSet.Tables[0].Columns; * for (int i = 0; i < columns.Count; i++) * { * DataColumn column = columns[i]; * string col = column.ColumnName; * string type = column.DataType.ToString(); * if (col.ToLower().Equals("id")) * { * continue; * } * if (data.ContainsKey(col)) * { * object content = data[col]; * if (content is ArrayList) * { * ArrayList var = (ArrayList) content; * if (var[0].Equals("inc") || var[0].Equals("dec")) * { * string fuhao = var[0].Equals("inc") ? "+" : "-"; * result.Add(col, col + fuhao + var[1]); * } * } * else * { * result.Add(col, getFieldValue(type, content.ToString())); * } * } * else * { * if (isInsert) * { * result.Add(col, getFieldDefault(type)); * } * } * }*/ } catch (Exception e) { Console.WriteLine(e); } return(result); }
void ReleaseDesignerOutlets() { if (ActionBar != null) { ActionBar.Dispose(); ActionBar = null; } if (AddressOK != null) { AddressOK.Dispose(); AddressOK = null; } if (BottomConstraint != null) { BottomConstraint.Dispose(); BottomConstraint = null; } if (BottomSeparator != null) { BottomSeparator.Dispose(); BottomSeparator = null; } if (DistanceFilters != null) { DistanceFilters.Dispose(); DistanceFilters = null; } if (DistanceFiltersOpenClose != null) { DistanceFiltersOpenClose.Dispose(); DistanceFiltersOpenClose = null; } if (DistanceLimit != null) { DistanceLimit.Dispose(); DistanceLimit = null; } if (DistanceLimitInput != null) { DistanceLimitInput.Dispose(); DistanceLimitInput = null; } if (DistanceSourceAddress != null) { DistanceSourceAddress.Dispose(); DistanceSourceAddress = null; } if (DistanceSourceAddressLabel != null) { DistanceSourceAddressLabel.Dispose(); DistanceSourceAddressLabel = null; } if (DistanceSourceAddressText != null) { DistanceSourceAddressText.Dispose(); DistanceSourceAddressText = null; } if (DistanceSourceCurrent != null) { DistanceSourceCurrent.Dispose(); DistanceSourceCurrent = null; } if (DistanceSourceCurrentLabel != null) { DistanceSourceCurrentLabel.Dispose(); DistanceSourceCurrentLabel = null; } if (DistanceUnitText != null) { DistanceUnitText.Dispose(); DistanceUnitText = null; } if (FilterLayout != null) { FilterLayout.Dispose(); FilterLayout = null; } if (ListType != null) { ListType.Dispose(); ListType = null; } if (ListView != null) { ListView.Dispose(); ListView = null; } if (ListViewMap != null) { ListViewMap.Dispose(); ListViewMap = null; } if (LoaderCircle != null) { LoaderCircle.Dispose(); LoaderCircle = null; } if (LoaderCircleLeftConstraint != null) { LoaderCircleLeftConstraint.Dispose(); LoaderCircleLeftConstraint = null; } if (LoadNext != null) { LoadNext.Dispose(); LoadNext = null; } if (LoadPrevious != null) { LoadPrevious.Dispose(); LoadPrevious = null; } if (MapSatellite != null) { MapSatellite.Dispose(); MapSatellite = null; } if (MapStreet != null) { MapStreet.Dispose(); MapStreet = null; } if (MapView != null) { MapView.Dispose(); MapView = null; } if (MenuAbout != null) { MenuAbout.Dispose(); MenuAbout = null; } if (MenuChatList != null) { MenuChatList.Dispose(); MenuChatList = null; } if (MenuChatListBg != null) { MenuChatListBg.Dispose(); MenuChatListBg = null; } if (MenuChatListBgCorner != null) { MenuChatListBgCorner.Dispose(); MenuChatListBgCorner = null; } if (MenuContainer != null) { MenuContainer.Dispose(); MenuContainer = null; } if (MenuHelpCenter != null) { MenuHelpCenter.Dispose(); MenuHelpCenter = null; } if (MenuIcon != null) { MenuIcon.Dispose(); MenuIcon = null; } if (MenuLayer != null) { MenuLayer.Dispose(); MenuLayer = null; } if (MenuLocation != null) { MenuLocation.Dispose(); MenuLocation = null; } if (MenuLogIn != null) { MenuLogIn.Dispose(); MenuLogIn = null; } if (MenuLogOut != null) { MenuLogOut.Dispose(); MenuLogOut = null; } if (MenuRegister != null) { MenuRegister.Dispose(); MenuRegister = null; } if (MenuSettings != null) { MenuSettings.Dispose(); MenuSettings = null; } if (NoResult != null) { NoResult.Dispose(); NoResult = null; } if (OpenFilters != null) { OpenFilters.Dispose(); OpenFilters = null; } if (OpenSearch != null) { OpenSearch.Dispose(); OpenSearch = null; } if (OrderBy != null) { OrderBy.Dispose(); OrderBy = null; } if (RefreshDistance != null) { RefreshDistance.Dispose(); RefreshDistance = null; } if (ResultSet != null) { ResultSet.Dispose(); ResultSet = null; } if (RippleMain != null) { RippleMain.Dispose(); RippleMain = null; } if (RippleRefreshDistance != null) { RippleRefreshDistance.Dispose(); RippleRefreshDistance = null; } if (RoundBottom != null) { RoundBottom.Dispose(); RoundBottom = null; } if (SearchIn != null) { SearchIn.Dispose(); SearchIn = null; } if (SearchLayout != null) { SearchLayout.Dispose(); SearchLayout = null; } if (SearchTerm != null) { SearchTerm.Dispose(); SearchTerm = null; } if (Snackbar != null) { Snackbar.Dispose(); Snackbar = null; } if (SnackBottomConstraint != null) { SnackBottomConstraint.Dispose(); SnackBottomConstraint = null; } if (SnackTopConstraint != null) { SnackTopConstraint.Dispose(); SnackTopConstraint = null; } if (SortBy_LastActiveDate != null) { SortBy_LastActiveDate.Dispose(); SortBy_LastActiveDate = null; } if (SortBy_RegisterDate != null) { SortBy_RegisterDate.Dispose(); SortBy_RegisterDate = null; } if (SortBy_ResponseRate != null) { SortBy_ResponseRate.Dispose(); SortBy_ResponseRate = null; } if (SortByCaption != null) { SortByCaption.Dispose(); SortByCaption = null; } if (StatusBar != null) { StatusBar.Dispose(); StatusBar = null; } if (StatusImage != null) { StatusImage.Dispose(); StatusImage = null; } if (StatusText != null) { StatusText.Dispose(); StatusText = null; } if (UseGeoContainer != null) { UseGeoContainer.Dispose(); UseGeoContainer = null; } if (UseGeoNo != null) { UseGeoNo.Dispose(); UseGeoNo = null; } if (UseGeoNoLabel != null) { UseGeoNoLabel.Dispose(); UseGeoNoLabel = null; } if (UseGeoYes != null) { UseGeoYes.Dispose(); UseGeoYes = null; } if (UseGeoYesLabel != null) { UseGeoYesLabel.Dispose(); UseGeoYesLabel = null; } if (UserSearchList != null) { UserSearchList.Dispose(); UserSearchList = null; } }