databasetest.java

JGraph扩展应用。自定义Renderer,自定义视图View实现自定义工作流控件

/**
 * 
 */
package flow.graph.db.bean;

import java.beans.XMLDecoder;
import java.beans.XMLEncoder;
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Vector;

import javax.swing.JOptionPane;

import flow.graph.app.FlowManager;
import flow.graph.db.SQLiteConnection;
import flow.graph.gui.graph.file.LabelBean;
import flow.graph.util.Encoder;

/**
 * @author Administrator
 *
 */
public class DataBaseTest {
	public static void main(String[] args){
		/*
		//XMLDecoder dec = new XMLDecoder(new ByteArrayInputStream());
		try {
			LabelBean lb = new LabelBean();
			lb.setType(decoder1("哈哈哈"));
			lb.setValue(decoder1("中国移动"));
			System.out.println(lb);
			Vector v = new Vector();
			v.add(lb);
			XMLEncoder enc;
			enc = new XMLEncoder(new FileOutputStream(new File("test1.xml")));
			enc.writeObject(v);
			enc.close();
			
			
			XMLDecoder dec;
			dec = new XMLDecoder(new FileInputStream(new File("test1.xml")));
			Vector vec = (Vector)dec.readObject();
			Object[] obj = vec.toArray();
			for(int i=0;i<obj.length;i++){
				LabelBean l = (LabelBean)vec.get(i);
				System.out.println(decoder(l.getType()));
				System.out.println(decoder(l.getValue()));
				//System.out.println(obj[i]);
			}
		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}*/

		Connection con = SQLiteConnection.getConnection();
		if(con == null){
			int res = JOptionPane.showConfirmDialog(FlowManager.getInstance(),
					"Connect data base \""+SQLiteConnection.SQLite_DATABASE+"\" failed!",
					"System Infomation",
					JOptionPane.CLOSED_OPTION);	
		}
		else{
			NodeBean bean = DataBaseNode.selectNodeById(con, 23);
			//System.out.println(DataBaseTest.decoder1(DataBaseTest.decoder(bean.getT_graph())));
			//System.out.println(DataBaseTest.decoder(bean.getT_graph()));
			try {
				System.out.println(decoder(new String(bean.getT_graph().getBytes("UTF-8"))));
			} catch (UnsupportedEncodingException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
					
			System.out.println("------------------------------------------");
			System.out.println(bean.getT_desc());

			System.out.println("------------------------------------------");
			
			try {
				XMLDecoder dec = new XMLDecoder(new ByteArrayInputStream(bean.getT_graph().getBytes("UTF-8")));
				Vector vec = (Vector)dec.readObject();
				System.out.println(vec);
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
	}
	public static String decoder(String s){
		try {
			return new String(s.getBytes("UTF-8"), "gb2312");
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return "";
	}
	public static String decoder1(String s){
		try {
			return new String(s.getBytes("gb2312"), "UTF-8");
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return "";
	}
}