서식스토리

1. jdk 1.5 SE 설치

2. eclipse 설치
http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/ganymede/SR1/eclipse-jee-ganymede-SR1-win32.zip

3. eclipse 실행시 에러가 나면..
도스창에서 eclipse.exe -vm "C:\Program Files\Java\jdk1.5.0_16\bin\javaw.exe"

- eclipse를 지우려면 workspace까지 지워야 문제의 소지가 없다.

function getMonthEnd($month)
{
 if(strlen($month) == 6){
  $tmp = substr($month,0,4) .'-'. substr($month,4,2) .'-01';
 }else{
  $tmp = $month .'-01';
 }

 $tmp = strtotime("+1 month",strtotime($tmp));
 return date("d",strtotime("-1 day",$tmp));
}

WHERE SUBSTRING(휴대폰필드명,1,3) NOT IN('010','011','016','017','018','019');

<!--StartFragment-->CREATE TABLE member(
id varchar(30) not null,
name varchar(30),
cnt integer ,
primary key(id)
);

insert into member values ('aaaa','강만수',10);
insert into member values ('bbbb','강천수',11);
insert into member values ('cccc','강백수',12);
insert into member values ('dddd','강조수',13);
insert into member values ('eeee','강억수',14);

CREATE TABLE member_new(
id varchar(30) not null,
cnt integer,
primary key(id)
);


insert into member_new values('bbbb',129);
insert into member_new values('cccc',130);
insert into member_new values('dddd',131);


UPDATE member A, member_new B SET A.cnt=B.cnt WHERE A.id=B.id;

       RunFrame r = new RunFrame();
       r.setSize(300, 100); 
       r.show(); ===>   r.setVisible(true);