TanSanC

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.restlet.Application;
import org.restlet.Request;
import org.restlet.Response;
import org.restlet.Restlet;
import org.restlet.Server;
import org.restlet.data.MediaType;
import org.restlet.data.Protocol;
import org.restlet.routing.Router;

public class test extends Application{
	public static Connection makeConnection() {
		String url = "jdbc:mysql://localhost/book_db";
		String id = "root";
		String password = "green";
		Connection con = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("드라이버 적재 성공");
			con = DriverManager.getConnection(url, id, password);
			System.out.println("데이터베이스 연결 성공");
		} catch (ClassNotFoundException e) {
			System.out.println("드라이버를 찾을 수 없습니다.");
		} catch (SQLException e) {
			System.out.println("연결에 실패하였습니다.");
		}
		return con;
	}
	public static Statement stmt;
	public static void main(String[] args) throws Exception {
		Connection con = makeConnection();
		stmt = con.createStatement();
		Server server = new Server(Protocol.HTTP, 8182);
		server.setNext(new test());
		server.start();
	}
	public static String selectBooks(Statement stmt) throws SQLException {
		ResultSet rs = stmt.executeQuery("SELECT * FROM books");
		String result = "";
		while (rs.next()) {
			int id = rs.getInt("book_id");
			String title = rs.getString("title");
			if( title != null)
			{
				result += id + " " + title + "\n";
			}
		}
		return result;
	}
	@Override
	public Restlet createInboundRoot() {
		Router router = new Router();
		router.attach("http://localhost:8182/books", restlet1);
		return router;
	}

	public Restlet restlet1 = new Restlet() {
		public void handle(Request request, Response response) {
			String message = "";
			try {
				message += selectBooks(stmt);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			response.setEntity(message, MediaType.TEXT_PLAIN);
		}
	};
}

1. 데이터 삽입 INSERT

INSERT INTO books (title, publisher, year, price)

  VALUES('Operating System Concepts', 'Wiley', '2003', 30700);

INSERT INTO books (title, publisher, year, price)

  VALUES('Head First PHP and MYSQL', 'OReilly', '2009', 58000);

INSERT INTO books (title, publisher, year, price)

  VALUES('C Programming Language', 'Prentice-Hall', '1989', 35000);

INSERT INTO books (title, publisher, year, price)

  VALUES('Head First SQL', 'OReilly', '2007', 43700);

2. 데이터 확인 

(지난 코드 재실행)

JAVA MYSQL Test

1. MYSQL 설치

http://www.mysql.com/downloads/installer/

1.2 MYSQL JAVA 드라이버 설치

http://www.mysql.com/downloads/connector/j/

ZIP 파일 압축 해제 후

jar 파일 을 복사하여

내 컴퓨터의 

Java\jre7\lib\ext

폴더에 붙여넣기 합니다.

2. MYSQL Table 생성

DROP DATABASE book_db;

CREATE DATABASE book_db;

USE book_db;

CREATE TABLE books(

book_id INT NOT NULL auto_increment,

title VARCHAR(50),

publisher VARCHAR(30),

year VARCHAR(10),

price INT,

PRIMARY KEY(book_id)

);

3. TEST CODE

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class test {
	public static Connection makeConnection() {
		String url = "jdbc:mysql://localhost/book_db";
		String id = "root";
		String password = "green";
		Connection con = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("드라이버 적재 성공");
			con = DriverManager.getConnection(url, id, password);
			System.out.println("데이터베이스 연결 성공");
		} catch (ClassNotFoundException e) {
			System.out.println("드라이버를 찾을 수 없습니다.");
		} catch (SQLException e) {
			System.out.println("연결에 실패하였습니다.");
		}
		return con;
	}

	public static void main(String[] args) throws SQLException {
		Connection con = makeConnection();
		Statement stmt = con.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT * FROM books");
		while (rs.next()) {
			int id = rs.getInt("book_id");
			String title = rs.getString("title");
			System.out.println(id + " " + title);
		}
	}
}

3. 데이터베이스 연결 확인

출처 : http://ggons.tistory.com/35

1. js 및 css 다운로드

 - http://alexgorbatchev.com/SyntaxHighlighter/download/ 에서 zip 파일 내려받기

syntaxhighlighter_3.0.83.zip

 - 임의의 폴더에 압축 해제시켜 놓습니다.


2. js 및 css 등록

 - Admin → 꾸미기 → HTML/CSS 편집
 - "파입업로드" 탭에서 위에서 압축해제한 파일 중 scripts, styles 폴더의 모든 js 및 css를 업로드 합니다.

몇년을 귀차니즘으로 버티다가 기어이 "소스코드 문법 강조 스타일"을 적용해본다. 짜잉나는 네이버 블로그를 떠난 이유도 이런 자유도 때문이 아닐까 한다.

3. skin.html 수정

 - HTML/CSS 탭 내의 skin.html 내용중 Head 태그내에 아래를 붙여넣음
 - Required 주석이 붙은 것은 반드시 붙여넣어야 하고..
 - Optional 붙은 주석은 이름을 잘 보고 쓰고 싶은 것만 넣으면 됩니다.

<!-- Required including -->
<script type="text/javascript" src="./images/shCore.js"></script>
<link rel="stylesheet" type="text/css" href="./images/shCore.css" />
<link rel="stylesheet" type="text/css" href="./images/shThemeDefault.css" />

<!-- Optional including -->
<script type="text/javascript" src="./images/shBrushAppleScript.js"></script>
<script type="text/javascript" src="./images/shBrushAS3.js"></script>
<script type="text/javascript" src="./images/shBrushBash.js"></script>
<script type="text/javascript" src="./images/shBrushColdFusion.js"></script>
<script type="text/javascript" src="./images/shBrushCpp.js"></script>
<script type="text/javascript" src="./images/shBrushCSharp.js"></script>
<script type="text/javascript" src="./images/shBrushCss.js"></script>
<script type="text/javascript" src="./images/shBrushDelphi.js"></script>
<script type="text/javascript" src="./images/shBrushDiff.js"></script>
<script type="text/javascript" src="./images/shBrushErlang.js"></script>
<script type="text/javascript" src="./images/shBrushGroovy.js"></script>
<script type="text/javascript" src="./images/shBrushJava.js"></script>
<script type="text/javascript" src="./images/shBrushJavaFX.js"></script>
<script type="text/javascript" src="./images/shBrushJScript.js"></script>
<script type="text/javascript" src="./images/shBrushPerl.js"></script>
<script type="text/javascript" src="./images/shBrushPhp.js"></script>
<script type="text/javascript" src="./images/shBrushPlain.js"></script>
<script type="text/javascript" src="./images/shBrushPowerShell.js"></script>
<script type="text/javascript" src="./images/shBrushPython.js"></script>
<script type="text/javascript" src="./images/shBrushRuby.js"></script>
<script type="text/javascript" src="./images/shBrushSass.js"></script>
<script type="text/javascript" src="./images/shBrushScala.js"></script>
<script type="text/javascript" src="./images/shBrushSql.js"></script>
<script type="text/javascript" src="./images/shBrushVb.js"></script>
<script type="text/javascript" src="./images/shBrushXml.js"></script>

<!-- Required including -->
<script type="text/javascript">
    SyntaxHighlighter.all();
</script>


4. 소스코드 작성

 - 에디터 우측상단 html 체크박스 체크 후 HTML 수정모드로 진입하여
 - 아래처럼 pre 태그 내에 소스코드를 써주면 됩니다.

6. 사용 가능한 brush 목록

 - http://alexgorbatchev.com/SyntaxHighlighter/manual/brushes 참조

restlet-jse-2.1.2

restlet.org 다운로드 사이트가 일부 익스플로러에서 접속되지 않아서 분할 압축으로 올립니다.

restlet-jse-2.1.2.vol1.egg

restlet-jse-2.1.2.vol2.egg

restlet-jse-2.1.2.vol3.egg

restlet-jse-2.1.2.vol4.egg

restlet-jse-2.1.2.vol5.egg

import java.io.IOException;
import java.net.URLDecoder;
 
import org.restlet.Application;
import org.restlet.Request;
import org.restlet.Response;
import org.restlet.Restlet;
import org.restlet.Server;
import org.restlet.data.MediaType;
import org.restlet.data.Protocol;
import org.restlet.ext.xml.DomRepresentation;
import org.restlet.representation.Representation;
import org.restlet.resource.ServerResource;
import org.restlet.routing.Router;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
 
public class RESTRouteService extends Application {
    public static void main(String[] args) throws Exception {
        // Create the HTTP server and listen on port 8182
        Server server = new Server(Protocol.HTTP, 8182);
        server.setNext(new RESTRouteService());
        server.start();
    }
 
    public Restlet restlet1 = new Restlet() {
        public void handle(Request request, Response response) {
           String message = "This is a information for students";
           response.setEntity(message, MediaType.TEXT_PLAIN);
        }
    };
 
    public Restlet restlet2 = new Restlet() {
        public void handle(Request request, Response response) {
           String message = "_ 1/students/1_ 2/students/2";
           response.setEntity(message, MediaType.TEXT_XML);
        }
    };
    public Restlet restlet3 = new Restlet() {
        public void handle(Request request, Response response) {
           String message = "_  1Jun-Ha Jung
Seoul
_  ";
           response.setEntity(message, MediaType.TEXT_XML);
        }
    };
    Restlet order = new Restlet(getContext()) {
        @Override
        public void handle(Request request, Response response) {
           // Print the user name of the requested orders
           String p1 = (String)request.getAttributes().get("p1");
           String p2 = (String)request.getAttributes().get("p2");
          
           String sum = "" + (new Integer(p1) + new Integer(p2));
          
           String message = "p1 \"" + p1
                   + "\" p2 \"" + p2 + "\" sum \"" + sum + "\"" ;
           response.setEntity(message, MediaType.TEXT_PLAIN);
        }
    };
    @Override
    public Restlet createInboundRoot() {
        Router router = new Router();
        router.attach("http://localhost:8182/info", restlet1);
        router.attach("http://localhost:8182/students", restlet2);
        router.attach("http://localhost:8182/students/1", restlet3);
    router.attach("http://localhost:8182/Point/{p1}/{p2}", order);
 
        return router;
    }
 
}
 

1. RESTLET 설치

http://restlet.org/download/current#release=stable&edition=jse&distribution=zip

restlet-jse-2.1.2.vol1.egg

restlet-jse-2.1.2.vol2.egg

restlet-jse-2.1.2.vol3.egg

restlet-jse-2.1.2.vol4.egg

restlet-jse-2.1.2.vol5.egg

2. RESTLET 라이브러리 설정

해당 프로젝트 - [우클릭] - [Properties] - [JAVA Build Path]

[Libraries] - [Add External JARs] - restlet 압출 파일해제한 폴더로 이동

org.restlet.jar 파일 선택

3. 예제 코드

import org.restlet.Server;
import org.restlet.data.Protocol;
import org.restlet.resource.Get;
import org.restlet.resource.ServerResource;
 
public class RESTletHelloWorld extends ServerResource {
   public static void main(String[] args) throws Exception {  
      new Server(Protocol.HTTP, 8182,
          RESTletHelloWorld.class).start();  
   }  
   @Get 
   public String toString() {
      return "Hello, RESTlet World!123";  
   }  
}
 
 

4. 브라우저를 이용하여

http://localhost:8182 접속