스프링필드 에버그린테라스 742

        private Hashtable<String,String> get_log_file() {

                Hashtable<String,String> logset = new Hashtable<String,String>();

                try {

                        BufferedReader in = new BufferedReader(new FileReader("/home/webmail/myst_export_log/record/WEB.log"));

                        String s;

                        while ((s = in.readLine()) != null) {

                                if (s.equals("") || s.charAt(0) == '#') { continue; }  //라인이 공백이거나 첫글자가 #이면 패스

                                String temp[] = s.split(":");

                                logset.put(temp[0], temp[1]); // logset에 넣음

                        }

                        in.close();

                } catch (IOException e) {

                        e.printStackTrace();

                }

                //출력하기

              Enumeration en = logset.keys();

              while (en.hasMoreElements()) {

                      String key = en.nextElement().toString();

          System.out.println(key + " :::: "+logset.get(key));

              }

              return logset;

        }

import! java.io.*;

-------------------------------

try{

    BufferedReader in = new BufferedReader(new FileReader("/home/webmail/test.txt"));

    while ( (String s = in.readLine()) != null ) {

        System.out.println(s);

    }

    in.close();

} catch (IOException e) {

    e.printStackTrace();

}

import! java.io.*;

public class File_EXE {

    public static void main(String[] args) {

        String s;

        try {

            String cmd = "/home/webmail/test/time_converter.pl -dtu 2012/02/08/00/00/00";

            Runtime rt= Runtime.getRuntime();

            Process oProcess = rt.exec(cmd);

            BufferedReader stdOut = new BufferedReader(new InputStreamReader(oProcess.getInputStream()));

            BufferedReader stdErr = new BufferedReader(new InputStreamReader(oProcess.getErrorStream()));

            while( (s = stdOut.readLine()) != null) System.out.println(s);

            while( (s = stdErr.readLine()) != null) System.out.println(s);

        } catch (Exception e) {

            e.printStackTrace();

            System.exit(-1);

        }

    }

}

use Time::Local;

sub get_yesterday($$$)

{

    my ($y, $m, $d) = @_; #년도, 월, 일을 입력받는다.(날짜지정해서쓸때만 인자받음)

    my ($sec, $min, $hour, $mday, $mon, $year) = (0,0,0,$d,$m-1,$y-1900); #날짜지정해서 쓸때

    #my ($sec, $min, $hour, $mday, $mon, $year) = localtime();  #그냥 현재날짜만 쓸때

    my $yesterday_midday=timelocal(0,0,0,$mday,$mon,$year) - 60*60*24;

    ($sec, $min, $hour, $mday, $mon, $year) = localtime($yesterday_midday);

    my $YesterdaysDate = sprintf("%4d%02d%02d", $year+1900, $mon+1, $mday);

    return $YesterdaysDate; 

}

chown -h 소유자.그룹 심볼릭링크파일명

system("clear");

sub get_dbf($)

{

    my ($old_home) = @_;

    my (%h, $k, $v);

    my $euckr_to_utf8 = Text::Iconv->new("EUC-KR","UTF-8");

    my $filename = $old_home;

    tie %h, "DB_File", $filename;

    my $h_arr = {};

    while (($k, $v) = each %h ) {

       # EUCKR -> UTF8

       $k = $euckr_to_utf8->convert($k);

       $v = $euckr_to_utf8->convert($v);

       # remove (^@ -> \x00) (^M -> \x08) (^E -> \x05)

       $k =~ s/[\t\r\n\x00\x08\x05]//g;

       $v =~ s/[\t\r\n\x00\x08]//g;

       $v =~ s/\x05/\|\^\|/g;

       #my @arr = split(/\|\^\|/, $v, 14);

       $h_arr->{$k}=$v;

    }

    untie %h;

    return $h_arr;

}

<%

String id=request.getParameter("id");

String passwd = request.getParameter("password");

String name = request.getParameter("name");

Timestamp register = new Timestamp(System.currentTimeMillis());

Connection conn=null;

PreparedStatement pstmt=null;

String str="";

try{

 String jdbcURL = "jdbc:mysql://localhost:3306/test";

 String dbId="root";

 String dbPass="pass";

 Class.forName("com.mysql.jdbc.Driver");

 conn=DriverManager.getConnection(jdbcURL,dbId,dbPass);

 String sql="INSERT INTO member VALUES(?,?,?,?)";

 pstmt=conn.prepareStatement(sql);

 pstmt.setString(1,id);

 pstmt.setString(2,passwd);

 pstmt.setString(3,name);

 pstmt.setTimestamp(4,register);

 pstmt.executeUpdate();

 str = "member테이블에 새로운 레코드를 추가하였습니다!";

} catch(Exception e){

 e.printStackTrace();

 str="실패했음";

} finally {

 if(pstmt != null) try{pstmt.close();}catch(SQLException sqle){}

 if(conn !=null) try{conn.close();} catch(SQLException sqle){}

}

%>

<jsp:include page="포함되는 페이지" flush="false">

    <jsp:param name="paramName1" value="var1" />

    <jsp:param name="paramName2" value="var2" />

<jsp:include>

<% request.setCharacterEncoding("euc-kr"); %>

select DATE_FORMAT(date_header,'%a, %d %b %Y %T +0900') from table_name;

Tue, 04 Oct 2011 16:50:00 +0900

#!/usr/local/mobigen/CrediMail/perl/bin/perl -w

BEGIN {

#$ENV{{IB_PATH} = "/usr/local/mobigen/mysql/lib/mysql";

#$ENV{LD_LIBRARY_PATH} = "/usr/local/mobigen/mysql/lib/mysql";

    push @main::INC, ".";

    push @main::INC, "/usr/local/mobigen/CrediMail/modules";

};

use strict;

use mobigen;

use DBI;

MAIN:

{

    if (! @ARGV) {

        print "Usage : $0 userid \n";

        exit(0);

    }

    my $db = DBI -> connect("DBI:mysql:database=private_db:host=localhost","id","password",{'RaiseError'=> 1}); #알맞게 수정하세요

    print "DB_CONNECT SUCCESS\n";

    my $sql = "SELECT * FROM TABLE";

    my $sth = $db->prepare($sql);

    $sth->execute();

    print "DB_SELECT MAILBOX\n";

    my $mailbox ={};

    while (my @row_ref = $sth->fetchrow_array){

        $mailbox->{$row_ref[0]} = $row_ref[1]} ;

    }

    $sth->finish;

    $db->disconnect();

}

foreach my $line (@array) {
    print "$line \n";
} 

print $_. "\n" foreach(@array);

# ls -l |grep ^d| wc -l

# ls -l |grep ^- | wc -l

#!/usr/bin/perl

use POSIX;

MAIN:

{

    my $c_date = POSIX::strftime("%Y%m%d%H%M%S", localtime(time()));

    print "$c_date \n";

}