박광용 ::

'Program'에 해당되는 글 7건

SWT 이미지 자르기.(SWT IMAGE CROP)

Program/Java 2011/10/19 13:58

SWT에서 이미지를 자르려고할때 다음과 같이 구성하면된다.

final Image img = new Image(null,image.getImageData());//기존이미지

final Image img1 = new Image(null, 150, 150);//새로만들 이미지 사이즈

GC gc = new GC(img1);//GC 생성

gc.drawImage(img,150,150);//X,Y좌표 img의 복사할 시작점 좌표이다.

gc.dispose();

//아래는 그냥 이미지 파일 저장하는 부분.

ImageLoader imageLoader = new ImageLoader();

imageLoader.data = new ImageData[] { img1.getImageData() };

ByteArrayOutputStream result = new ByteArrayOutputStream();

imageLoader.save(result, SWT.IMAGE_JPEG);

java.io.File file = new java.io.File("c:\\1.jpg");

if(file.exists())

file.delete();

FileOutputStream fos = new FileOutputStream(file.toString());

fos.write(result.toByteArray());

fos.flush();

fos.close();

Trackback 0 : Comment 0

JAVA에서 CVS 연동하는 소스 입니다.

실 프로젝트에 적용했던내용입니다. 외국에 자료고 많은거같지도않고 ㅎㅎ 참조하세요.

아래 소스는 해당 command 보낸 내용을 받아와서 token으로 짤라서 이용하는게 주로 해서 개발했습니다. 짧은 기간내에 개발해야되는 프로젝트여서 다른방법이 있는지는 더 자세히 알아보지는 못했습니다. 하지만 이 방법이 좀 노가다긴한데.. 그래도 작동은 되니깐요;;

그리고 jar파일은 http://netbeans.org/projects/versioncontrol/downloads 여기서 다운받으세요.

궁금한것은 이곳에서 찾으면된다는데... 흠 글쎄요 ㅋㅋhttp://versioncontrol.netbeans.org/javacvs/library/

CVSManager.java

더보기
public class CVSManager {

	private static CVSManager instance;

	public String type = ""; //접속타입
	public String userID = ""; //아이디 
	public String userPassword = ""; //패스워드
	public String host =""; // IP
	public String port = ""; // PORT
	public String repoPath = ""; //리파지토리 Path
	public String cvsFolderPath = ""; // 로컬 CVS위치
	public String cvsModuleName = ""; 

	private boolean isWrite =false;



	public HashMap logList = new HashMap();

	public String command = "";

	public boolean isCollection;

	public static CVSManager getInstance() {
		if (instance == null) {
			instance = new CVSManager();
			System.setProperty("javacvs.multiple_commands_warning", "false");
			return instance;
		}
		else {
			return instance;
		}
	}

	public String getServerLabel(String type,String user,String password,String host,String port,String repoPath){

		String s = ":";

		if(!type.equals(""))
			s = s + type;
		if(!user.equals(""))
			s = s + ":" +user;
		if(!password.equals(""))
			s = s + ":" +password;
		if(!host.equals(""))
			s = s + "@" +host;
		if(!port.equals(""))
			s = s + ":" +port;
		if(!repoPath.equals(""))
			s = s +repoPath;

		return s;
	}

	public boolean isConnection(String location){
		try {
			PServerConnection server = cvs_Open(location);
			server.open();
			server.close();
			if(server!=null)
				return true;
			else
				return false;

		} catch (Exception e){
			errorController(e);
			return false;
		}
	}

	public PServerConnection cvs_Open(String location){
		try {
			CVSRoot cvsroot = CVSRoot.parse(location);
			GlobalOptions globalOptions = new GlobalOptions();
			globalOptions.setCVSRoot(cvsroot.toString());

			PServerConnection con = new PServerConnection(cvsroot);

			type = "pserver";
			userID = cvsroot.getUserName();
			userPassword = cvsroot.getPassword();
			host = cvsroot.getHostName();
			port = String.valueOf(cvsroot.getPort());
			repoPath = cvsroot.getRepository();

			return con;
		} catch (Exception e){
			errorController(e);
			return null;
		}
	}
	public PServerConnection cvs_Open(){
		try {
			CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));
			GlobalOptions globalOptions = new GlobalOptions();
			globalOptions.setCVSRoot(cvsroot.toString());

			PServerConnection con = new PServerConnection(cvsroot);


			ProjectManager.getInstance().writeConfig();
			return con;
		} catch (Exception e){
			errorController(e);
			return null;
		}
	}

	public boolean isMatching(File f1,File f2){




		try {
			FileInputStream fis = new FileInputStream(f1);
			BufferedInputStream  bis = new BufferedInputStream(fis);
			DataInputStream dis = new DataInputStream(bis);

			FileInputStream fis2 = new FileInputStream(f2);
			BufferedInputStream  bis2 = new BufferedInputStream(fis2);
			DataInputStream dis2 = new DataInputStream(bis2);

			while(dis.available()!= 0){
				if(!dis.readLine().equals(dis2.readLine())){
					dis.close();
					bis.close();
					fis.close();
					dis2.close();
					bis2.close();
					fis2.close();
					return false;



				}
			}
			dis.close();
			bis.close();
			fis.close();
			dis2.close();
			bis2.close();
			fis2.close();

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}

		return true;
	}
	public void histroy(String file){
		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));
		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		System.out.println(cvsFolderPath+File.separator+cvsModuleName);
		client.setLocalPath(cvsFolderPath+File.separator+cvsModuleName);
		client.getEventManager().addCVSListener(new N3BasicListener());







		File f = new File(file);
		File[] afile = new File[1];
		afile[0]= f;	
		LogCommand verCommand = new LogCommand();
		verCommand.setFiles(afile);



		System.out.println(verCommand.getCVSCommand());
		try {

//			client.executeCommand(update, globalOptions);
			setCollection(true);
			client.executeCommand(verCommand, globalOptions);
			setCollection(false);

			historyToken();

			con.close();	
		} catch (Exception e) {
			errorController(e);
		}





	}
	public void download(String file,String ver,String writePath) {
		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));
		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		System.out.println(cvsFolderPath+File.separator+cvsModuleName);
		client.setLocalPath(cvsFolderPath+File.separator+cvsModuleName);
		client.getEventManager().addCVSListener(new N3BasicListener());


		UpdateCommand update = new UpdateCommand();



		File f = new File(file);
		File[] afile = new File[1];
		afile[0]= f;	


		update.setFiles(afile);
		update.setPipeToOutput(true);
		update.setUpdateByRevision(ver);
		System.out.println(update.getCVSCommand());
		try {
			setCollection(true);
			
			client.executeCommand(update, globalOptions);
			setCollection(false);
			File writeFile = new File(writePath);
			FileWriter fileWriter = new FileWriter(writeFile);
			BufferedWriter buffer = new BufferedWriter(fileWriter);



			if(command.indexOf("VERS: ")>=0){
				ver = command.substring(command.lastIndexOf("VERS: ")+"VERS: ".length(),command.lastIndexOf("***************")).replaceAll("\n", "");

			}
			if(command.indexOf("model Package (")>=0){//파일 다운받는 신호 이 다음부터 파일 표시됨
				command = command.substring(command.indexOf("model Package ("),command.lastIndexOf(";")+1);
				if(command.indexOf("property ID_CVS_FILE_VER=")>=0){
					String text = command.substring(command.indexOf("property ID_CVS_FILE_VER="));
					text = text.substring(0,text.indexOf("PROPERTY_N3EOF"));
					command= command.replaceAll(text, "property ID_CVS_FILE_VER="+ver);
				}
			}



			buffer.write(command);
			buffer.flush();
			buffer.close();
			fileWriter.close();

			con.close();	
		} catch (Exception e) {
			errorController(e);
		}





	}


	public void update(String file) {
		setCollection(true);

		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));
		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		System.out.println(cvsFolderPath+File.separator+cvsModuleName);
		client.setLocalPath(cvsFolderPath+File.separator+cvsModuleName);
		client.getEventManager().addCVSListener(new N3BasicListener());


		UpdateCommand update = new UpdateCommand();



		File f = new File(file);
		File[] afile = new File[1];
		afile[0]= f;	


		update.setFiles(afile);
		update.setPipeToOutput(true);

		System.out.println(update.getCVSCommand());
		try {

			client.executeCommand(update, globalOptions);
			setCollection(false);
			con.close();
			updateToken();
		} catch (Exception e) {
			errorController(e);
		}





	}


	public void importCommand(String module,String rTage,String vTag,String log) {

		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));

		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		client.getEventManager().addCVSListener(new BasicListener()); 


		client.setLocalPath(cvsFolderPath+File.separator+cvsModuleName);

		ImportCommand importCommand = new ImportCommand();
		importCommand.setReleaseTag(rTage);
		importCommand.setVendorTag(vTag);
		importCommand.setLogMessage(log);
		importCommand.setModule(module);
		importCommand.setImportDirectory(cvsFolderPath);

		System.out.println(importCommand.getCVSCommand());
		try {
			client.executeCommand(importCommand, globalOptions);



		} catch (Exception e) {
			errorController(e);
		}

	}
	public boolean isCVSFolder(){
		File f = new File(cvsFolderPath +File.separator + cvsModuleName +File.separator +"CVS");
		if(f.exists())
			return true;
		return false;
	}
	public void checkout() {
		setCollection(true);
		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));

		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		client.getEventManager().addCVSListener(new BasicListener()); 


		client.setLocalPath(cvsFolderPath);

		CheckoutCommand checkout = new CheckoutCommand(true, cvsModuleName);



		try {
			client.executeCommand(checkout, globalOptions);



		} catch (Exception e) {
			errorController(e);
		}
		setCollection(false);
	}
	public void commit(String file,String msg) {
		setCollection(true);

		CVSRoot cvsroot = CVSRoot.parse(getServerLabel(type,userID,userPassword,host,port,repoPath));
		GlobalOptions globalOptions = new GlobalOptions();
		globalOptions.setCVSRoot(cvsroot.toString());

		PServerConnection con = new PServerConnection(cvsroot);

		Client client = new Client(con, new StandardAdminHandler());
		System.out.println(cvsFolderPath+File.separator+cvsModuleName);
		client.setLocalPath(cvsFolderPath+File.separator+cvsModuleName);




		CommitCommand commitComand = new CommitCommand();		
		AddCommand addComand = new AddCommand();

		client.getEventManager().addCVSListener(new N3BasicListener()); 

		File f = new File(file);
		File[] afile = new File[1];
		afile[0]= f;




		addComand.setFiles(afile);
		commitComand.setFiles(afile);
		commitComand.setMessage("<MSG START>"+msg+"</MSG END>");
		commitComand.setForceCommit(true);



		try {
			con.open();


			boolean success = client.executeCommand(addComand, globalOptions);
			client.executeCommand(commitComand, globalOptions);
			commitToken();
			con.close();

		} catch (Exception e) {
			errorController(e);
		}

		setCollection(false);
	}

	public boolean isWrite() {
		return isWrite;
	}

	public void setWrite(boolean isWrite) {
		this.isWrite = isWrite;
	}



	public boolean isCollection() {
		return isCollection;
	}

	public void setCollection(boolean isCollection) {
		if(isCollection){
			command = "";
			isWrite = false;
			logList.clear();
		}
		this.isCollection = isCollection;
	}

	public void commitToken(){

		if(ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected()!=null && ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected() instanceof PackageTreeModel){
			PackageTreeModel packageTreeModel = (PackageTreeModel)ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected();
			FinalPackageModel finalPackageModel = (FinalPackageModel)packageTreeModel.getRefModel();


			String ver = "";
			if(command.indexOf("new revision: ")>=0){//파일 다운받는 신호 이 다음부터 파일 표시됨
				ver = command.substring(command.indexOf("new revision: ")+"new revision: ".length(),command.indexOf("; previous revision:"));

			}else if(command.indexOf("version number ")>=0){
				ver = command.substring(command.indexOf("version number ")+"version number ".length(),command.indexOf("\n"));

			}else if(command.indexOf("initial revision: ")>=0){
				ver = command.substring(command.indexOf("initial revision: ")+"initial revision: ".length(),command.lastIndexOf("done"));

			}
			finalPackageModel.setCvsFileVer(ver.replaceAll("\n", ""));
			ProjectManager.getInstance().getModelBrowser().refresh(packageTreeModel);
		}
	}

	public void updateToken(){
		String ver = "";
		if(command.indexOf("VERS: ")>=0){
			ver = command.substring(command.lastIndexOf("VERS: ")+"VERS: ".length(),command.lastIndexOf("***************")).replaceAll("\n", "");

		}
		if(command.indexOf("model Package (")>=0){//파일 다운받는 신호 이 다음부터 파일 표시됨
			command = command.substring(command.lastIndexOf("model Package ("));

			String text = command.substring(command.indexOf("property ID_CVS_FILE_VER="));
			text = text.substring(0,text.indexOf("PROPERTY_N3EOF"));
			command= command.replaceAll(text, "property ID_CVS_FILE_VER="+ver);

			if(ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected()!=null && ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected() instanceof PackageTreeModel){
				PackageTreeModel packageTreeModel = (PackageTreeModel)ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected();
				FinalPackageModel finalPackageModel = (FinalPackageModel)packageTreeModel.getRefModel();

				try{
					File writeFile = new File(packageTreeModel.getLinkPath()+ver);
					FileWriter fileWriter = new FileWriter(writeFile);
					BufferedWriter buffer = new BufferedWriter(fileWriter);

					buffer.write(command);
					buffer.flush();
					buffer.close();
					fileWriter.close();

					File f1 = new File(packageTreeModel.getLinkPath());					


					if(writeFile.exists()){
						if(CVSManager.getInstance().isMatching(f1,writeFile)){
							writeFile.delete();


						}
						else{
							if(Double.parseDouble(ver) > Double.parseDouble(finalPackageModel.getCvsFileVer())){

								MessageBox dialog = new MessageBox(ProjectManager.getInstance().window.getShell(),SWT.ICON_QUESTION|SWT.YES|SWT.NO);
								dialog.setText("Message");
								dialog.setMessage(N3Messages.DIALOG_CVS_DOWNLOAD_IS_DOWN_VER);
								int p=dialog.open();

								switch(p) {
								case IDialogConstants.FINISH_ID:
									System.out.println("Scrip Wizard Finish!!");
									break;
								case SWT.NO:    
									return;
								case SWT.CANCEL:
									break;
								}
								f1.delete();
								writeFile.renameTo(f1);


							}else{
								MessageBox dialog = new MessageBox(ProjectManager.getInstance().window.getShell(),SWT.ICON_QUESTION|SWT.YES|SWT.NO);
								dialog.setText("Message");
								dialog.setMessage(N3Messages.DIALOG_CVS_DOWNLOAD_IS_UP_VER);
								int p=dialog.open();

								switch(p) {
								case IDialogConstants.FINISH_ID:
									System.out.println("Scrip Wizard Finish!!");
									break;
								case SWT.NO:    
									return;
								case SWT.CANCEL:
									break;
								}
								f1.delete();
								writeFile.renameTo(f1);

							}



							UMLTreeParentModel umlTreeParentModel = (UMLTreeParentModel)packageTreeModel.getParent();

							ProjectManager.getInstance().deleteUMLModel(packageTreeModel);

							ProjectManager.getInstance().removeUMLNode(packageTreeModel.getParent(), packageTreeModel);



							ProjectManager.getInstance().getModelBrowser().select(packageTreeModel);
							TeamProjectManager.getInstance().load(umlTreeParentModel, f1.getParent(), f1.getName());
							CVSManager.getInstance().setWrite(false);


						}

					}
				}catch(Exception e){
					errorController(e);
				}
			}
		}


	}
	public void verToken(){
		if(ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected()!=null 
				&& ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected().getRefModel() !=null
				&& ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected().getRefModel()instanceof FinalPackageModel){
			FinalPackageModel packageModel = (FinalPackageModel)ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected().getRefModel();
			PackageTreeModel packageTreeModel =(PackageTreeModel)ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected();
			if(command.indexOf("head: ")>=0){

				String text = command.substring(command.indexOf("head: ")+"head: ".length(),command.indexOf("branch:")).replaceAll("\n","").trim();


//				packageModel.setCvsFileVer(String.valueOf(value));
				ProjectManager.getInstance().getModelBrowser().refresh(ProjectManager.getInstance().getModelBrowser().getUMLTreeModelSelected());

			}else if(command.indexOf("initial revision: ")>=0){
				command = command.replaceAll("initial revision: ", "");

			}else if(command.indexOf("cvs server: use `cvs add' to create an entry ")>=0){
				packageModel.setCvsFileVer("1.1");
			}
			ProjectManager.getInstance().getModelBrowser().refresh(packageTreeModel);
		}
	}
	public void historyToken(){
		command = command.replaceAll("----------------------------\n", "N3Token");

		String[] stk = command.split("N3Token");


		for(int i = 1; i < stk.length; i ++){
			java.util.Properties properties = new java.util.Properties();
			String revisin = stk[i].substring(stk[i].indexOf("revision")+"revision".length(),stk[i].indexOf("date")).replaceAll("\n", "");
			properties.put("revision", revisin);
			stk[i]=stk[i].substring(stk[i].indexOf("date"));

			properties.put("date", stk[i].substring(stk[i].indexOf("date")+"date: ".length(),stk[i].indexOf(";")));
			stk[i]=stk[i].substring(stk[i].indexOf(";")+1);

			stk[i]=stk[i].substring(stk[i].indexOf("<MSG START>")+"<MSG START>".length(),stk[i].indexOf("</MSG END>"));
			properties.put("desc",stk[i]);
			System.out.println("");

			logList.put(revisin,properties);

		}
	}
	
	public void errorController(Exception e){
		ProjectManager.getInstance().showMessage(e.getMessage());
		e.printStackTrace();
	}

 


N3BasicListener.java

더보기
public class N3BasicListener extends BasicListener {
	

	public void messageSent(MessageEvent arg0) {
		// TODO Auto-generated method stub
		super.messageSent(arg0);
		String msg = arg0.getMessage();
		if(CVSManager.getInstance().isCollection()){//파일 다운받는 신호 이 다음부터 파일 표시됨
			if(CVSManager.getInstance().command.equals("")){
				CVSManager.getInstance().command = CVSManager.getInstance().command+msg;
			}else{
				CVSManager.getInstance().command = CVSManager.getInstance().command+"\n"+msg;		
			
			}
		}
		
	}
	 
	public void messageSent(BinaryMessageEvent e) {
		// TODO Auto-generated method stub
		super.messageSent(e);
	}

}

Trackback 0 : Comment 0

JAVA와 CVS연동하기.

Program/Java 2011/10/11 10:28

CVS 연동 프로그램 구현할때 참조하기 좋은사이트인거같다 ㅎㅎ

http://pmguda.com/555

http://graham-king.blogspot.com/2007/11/java-cvs-functions-checkout-from-cvs.html

제일 위에 있는 예제중에서 CVSRoot.parse("");

이 부분이있는데. 이부분에 패스워드가 틀리다는 에러가 뜨면,,,

:pserver:[ID]:[패스워드]@[IP]:[리파지토리 네임]

:pserver:id:password@192.168.0.11:/nabee

이런식으로하면된다,.

Trackback 0 : Comment 0

mysql 로컬호스트(localhost)에서만 접속되는 문제

Program/mysql 2011/09/01 12:53

mysql을 깔았는데 로컬쪽에서만 접속되도록 설정이 되어있다 root user이던...

그래서 이것을 어느곳에서나 접속가능하도록 변경해주어야 된다. (보안상 문제가없다면..)

mysql 접속후
update user set host='%';
flush privileges;

라고 처주면된다.. 생각보다 쉽지않은가?

Trackback 0 : Comment 0

JAVA에서 파일 오픈하기 (윈도우)

Program/Java 2009/06/29 10:43

JAVA에서 exe 파일을 실행하기 위해서는 Runtime.getRuntime().exec("파일 주소"); 과 같이 실행하면 되지만

파일을 실행하기위해서는 조금 변경을 해야된다. 왜냐하면 어떤 파일과 연동이되서 실행을 시켜야되는 정보를 java에서 알지를 못하니깐 말이다...

File f = new File(item.desc);
if(f.exists()){
 try{        
  Process fileExec = 
  fileExec = Runtime.getRuntime().
  exec("rundll32.exe shell32.dll,ShellExec_RunDLL \""+f.toString()+"\"");                                             
  fileExec.waitFor();
  }catch(IOException ie){
   System.out.println("첨부파일열기 실행오류  :"+ie.toString());                                             
  }catch(InterruptedException ire){
   System.out.println("첨부파일열기 실행오류2 :"+ire.toString());
  }
}else{
}

Trackback 0 : Comment 0

syntaxhighlighter로 블로그를 꾸며요~

Program 2009/04/23 10:04

이번에 Spring, IBatis, GWT 프로젝트를 시작합니다 .

그래서 이번에 블로그로 제작과정을 올려보려고 하는데, 평소에 소스검색하다가 간간히 syntaxhighlighter로 소스를 기제해놓은 블로그들이 많더군요... 그래서 이번에 적용했습니다.

인터넷에 방법올라온 사이트 중 아래 사이트가 샨새교 블로그에 적용시키는 방법을 잘 기제해놨더군요~~~

이렇게 올릴준비도해놨구 했는데... 잘 배워서 올릴수있으려나... 에휴... 너무 어렵다 Spring~

http://mainia.tistory.com/313

Language	Aliases
C++	cpp, c, c++
C#	c#, c-sharp, csharp
CSS	css
Delphi	delphi, pascal
Java	java
Java Script	js, jscript, javascript
PHP	php
Python	py, python
Ruby	rb, ruby, rails, ror
Sql	sql
VB	vb, vb.net
XML/HTML	xml, html, xhtml, xslt

tags : syntaxhighlighter

Trackback 0 : Comment 0

오라클에서 SELECT문으로 DB구조 보기

Program/Oracle 2009/04/22 15:32

SELECT X.TABLE_NAME TABLE_ID, 


(SELECT COMMENTS FROM USER_TAB_COMMENTS WHERE TABLE_NAME = X.TABLE_NAME) TABLE_NM, 


X.COLUMN_NAME FIELD_ID, 


(SELECT COMMENTS FROM USER_COL_COMMENTS WHERE TABLE_NAME = X.TABLE_NAME AND COLUMN_NAME = X.COLUMN_NAME) FIELD_NAME, 


X.DATA_TYPE AS "TYPE", 


DECODE(X.DATA_TYPE, 'DATE', NULL, 'BLOB', NULL, 


X.DATA_LENGTH || CASE WHEN X.DATA_PRECISION IS NOT NULL THEN ',' || X.DATA_SCALE END ) DATATYPES, 


CASE WHEN SUBSTR(Y.INDEX_NAME, 1, 2) = 'PK' THEN 'PK' 


ELSE DECODE(X.NULLABLE, 'N', 'NOT NULL', '') END "NOT NULL", 


X.DATA_DEFAULT 


FROM COLS X, USER_IND_COLUMNS Y 


WHERE X.TABLE_NAME = Y.TABLE_NAME(+) 


AND X.COLUMN_NAME = Y.COLUMN_NAME(+) 


ORDER BY X.TABLE_NAME, X.COLUMN_ID

출처 : http://beehone.egloos.com/1332306

tags : Oracle, SQL

Trackback 0 : Comment 1

◀ PREV : [1] : NEXT ▶

티스토리 툴바

박광용

'Program'에 해당되는 글 7건

SWT 이미지 자르기.(SWT IMAGE CROP)

JAVA에서 CVS연동 예제 소스

JAVA와 CVS연동하기.

mysql 로컬호스트(localhost)에서만 접속되는 문제

JAVA에서 파일 오픈하기 (윈도우)

syntaxhighlighter로 블로그를 꾸며요~

오라클에서 SELECT문으로 DB구조 보기