CPaintDC dc(this);
CFont font;
font.CreatePointFont(600, "Courier New" ); //폰트크기와 폰트
CFont *pFont = dc.SelectObject(&font);
dc.SetTextColor(RGB(0, 125, 250)); //글씨 파란색
dc.SetBkColor( RGB(190, 190, 190) ); //바탕
dc.TextOut(20, 18, _T("TEST") );
dc.SelectObject(pFont);
font.DeleteObject();
Trackback 0 And
Comment 0
#include <atldbcli.h>
#include <iostream>
using namespace std;
// define a class to hold the data from the table
class state
{
public:
// data elements
TCHAR m_ip[20];
TCHAR m_curdate[20];
TCHAR m_curtime[20];
TCHAR m_floor[20];
TCHAR m_direction[20];
TCHAR m_door_state[20];
TCHAR m_operate_mode[20];
TCHAR m_run_state[20];
// column binding -- I only want these 4 fields
BEGIN_COLUMN_MAP(state)
COLUMN_ENTRY(1, m_ip)
COLUMN_ENTRY(2, m_curdate)
COLUMN_ENTRY(3, m_curtime)
COLUMN_ENTRY(4, m_floor)
COLUMN_ENTRY(5, m_direction)
COLUMN_ENTRY(6, m_door_state)
COLUMN_ENTRY(7, m_operate_mode)
COLUMN_ENTRY(8, m_run_state)
END_COLUMN_MAP()
};
// declare the OLEDB objects
CDataSource ds;
CSession session;
CCommand <CAccessor<state> > cust;
int main()
{
try{
// fire up COM
HRESULT hr = CoInitialize(0);
if(FAILED(hr))
{
cout << "Can't start COM!? " << endl;
return -1;
}
// connect to the database
CDBPropSet dbinit(DBPROPSET_DBINIT);
dbinit.AddProperty(DBPROP_INIT_PROMPT,(SHORT)4);
dbinit.AddProperty(DBPROP_INIT_PROVIDERSTRING, OLESTR("PROVIDER=SQLOLEDB.1;SERVER= ;UID= ;PWD= ;DATABASE= "));
dbinit.AddProperty(DBPROP_INIT_LCID, (LONG)1043); //->Locale identifier
hr = ds.Open(_T("SQLOLEDB"), &dbinit);
if(FAILED(hr))
{
cout << "Can't open db" << endl;
return -1;
}
// start the session
hr = session.Open(ds);
if(FAILED(hr))
{
cout << "Can't open SESSION" << endl;
ds.Close();
return -1;
}
// construct the query string
TCHAR mySQL[] = "SELECT ip,curdate,curtime,floor,direction,door_state,operate_mode,run_state FROM state";
// open the dataset
hr = cust.Open(session, mySQL);
if(FAILED(hr))
{
cout << "Can't open TABLE" << endl;
session.Close();
ds.Close();
return -1;
}
// read all the data
while(cust.MoveNext() == S_OK)
{
cout << cust.m_curdate << ", " << cust.m_curtime << ", ";
cout << cust.m_ip << ", " << cust.m_direction << endl;
}
cust.Close();
session.Close();
ds.Close();
cout << "That's All Folks" << endl;
return 1;
}
catch(...)
{
cout << "Unknown failure" << endl;
return -1;
}
}
Trackback 0 And
Comment 0
GrabMyBooks라는 파이어폭스용 애드온을 사용하면 쉽게 만들 수 있다.
More에서 METADATA에 language에 있는 en을 ko-KR로 바꾸어주어야 한글이 깨지지 않고 잘 보인다.
More에서 METADATA에 language에 있는 en을 ko-KR로 바꾸어주어야 한글이 깨지지 않고 잘 보인다.
Trackback 0 And
Comment 0
