File: chapter4.html

package info (click to toggle)
hk-classes 0.7.3-1
links: PTS
area: main
in suites: sarge
size: 6,976 kB
ctags: 8,014
sloc: cpp: 84,248; sh: 8,328; python: 3,255; makefile: 257
file content (261 lines) | stat: -rw-r--r-- 5,244 bytes
parent folder | download | duplicates (3)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>Show data of a column</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="The hk_classes programmer's tutorial"
HREF="index.html"><LINK
REL="PREVIOUS"
TITLE="Preselect the driver and user information"
HREF="chapter3.html"><LINK
REL="NEXT"
TITLE="Alter data of a column"
HREF="chapter5.html"><META
HTTP-EQUIV="Content-Style-Type"
CONTENT="text/css"><LINK
REL="stylesheet"
HREF="common/kde-common.css"
TYPE="text/css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=iso-8859-1"><META
HTTP-EQUIV="Content-Language"
CONTENT="en"><LINK
REL="stylesheet"
HREF="common/kde-localised.css"
TYPE="text/css"
TITLE="KDE-English"><LINK
REL="stylesheet"
HREF="common/kde-default.css"
TYPE="text/css"
TITLE="KDE-Default"></HEAD
><BODY
CLASS="CHAPTER"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#AA0000"
VLINK="#AA0055"
ALINK="#AA0000"
STYLE="font-family: sans-serif;"
><DIV
CLASS="logoheader"
><A
HREF="http://www.kde.org/"
></A
></DIV
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>The hk_classes programmer's tutorial</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="chapter3.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="chapter5.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="CHAPTER4"
></A
>Chapter 4. Show data of a column</H1
><P
>&#13;Now we try to show data of a specific column. For this we get a hk_column object. hk_column represents a specific column of a datasource.
 To display the data of the actual row use the command mycolumn-&#62;asstring().
 The hk_datasource::column_by_name method allows you to select a
column by it's name.</P
><P
>When you enable a datasource the row selector is in row 0 (the first row). To move the row selector use one of the
hk_datasource methods:
<UL
><LI
STYLE="list-style-type: disc"
><P
>bool  goto_row (unsigned long r)</P
></LI
><LI
STYLE="list-style-type: disc"
><P
>bool  goto_first (void)</P
></LI
><LI
STYLE="list-style-type: disc"
><P
>bool  goto_last (void)</P
></LI
><LI
STYLE="list-style-type: disc"
><P
>bool  goto_next (void)</P
></LI
><LI
STYLE="list-style-type: disc"
><P
>bool  goto_previous (void)</P
></LI
></UL
></P
><P
><DIV
CLASS="EXAMPLE"
><HR><A
NAME="AEN79"
></A
><P
><B
>Example 4-1. Show data of a column</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="PROGRAMLISTING"
>   1&nbsp;#include &#60;hk_classes.h&#62;
   2&nbsp;#include &#60;iostream&#62;
   3&nbsp;int main()
   4&nbsp;{
   5&nbsp;   hk_drivermanager* mydrivermanager = new hk_drivermanager();
   6&nbsp;   if (mydrivermanager==NULL) {cout &#60;&#60;"error creating mydrivermanager"&#60;&#60;endl;exit(1);}
   7&nbsp;   hk_connection* myconnection = mydrivermanager-&#62;new_connection("mysql");
   8&nbsp;   if (myconnection==NULL) {cout &#60;&#60;"error creating myconnection"&#60;&#60;endl;exit(1);}
   9&nbsp;   myconnection-&#62;set_host("localhost");
  10&nbsp;   myconnection-&#62;set_user("root");
  11&nbsp;   myconnection-&#62;set_password("mypasswd");
  12&nbsp;   myconnection-&#62;connect();
  13&nbsp;
  14&nbsp;   hk_database* mydatabase=myconnection-&#62;new_database("exampledb");
  15&nbsp;   if (mydatabase==NULL) {cout &#60;&#60;"error creating mydatabase"&#60;&#60;endl;exit(1);}
  16&nbsp;   hk_datasource* mydatasource= mydatabase-&#62;new_table("authors");
  17&nbsp;   if (mydatasource==NULL) {cout &#60;&#60;"error creating mydatasource"&#60;&#60;endl;exit(1);}
  18&nbsp;   mydatasource-&#62;enable();
  19&nbsp;
  20&nbsp;   <FONT
COLOR="RED"
>hk_column* mycolumn = mydatasource-&#62;column_by_name("name");</FONT
>
  21&nbsp;   <FONT
COLOR="RED"
>if (mycolumn==NULL) {cout &#60;&#60;"error getting column"&#60;&#60;endl;exit(1);}</FONT
>
  22&nbsp;   <FONT
COLOR="RED"
>cout &#60;&#60;"Value of the first row: "&#60;&#60;mycolumn-&#62;asstring()&#60;&#60;endl;</FONT
>
  23&nbsp;   <FONT
COLOR="RED"
>mydatasource-&#62;goto_next();</FONT
>
  24&nbsp;   <FONT
COLOR="RED"
>cout &#60;&#60;"Value of the second row: "&#60;&#60;mycolumn-&#62;asstring()&#60;&#60;endl;</FONT
>
  25&nbsp;
  26&nbsp;   delete mydrivermanager;
  27&nbsp;}</PRE
></TD
></TR
></TABLE
><HR></DIV
></P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="chapter3.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="chapter5.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Preselect the driver and user information</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Alter data of a column</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>