?? adaptoramin.java.svn-base
字號:
package hdaty.prtds.rdgadaptor.gui;
import hdaty.prtds.rdgadaptor.protocol.DataSour;
import hdaty.prtds.rdgadaptor.protocol.Message;
import hdaty.prtds.rdgadaptor.protocol.Source;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
import java.awt.Toolkit;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.eclipse.swt.SWT;
import org.eclipse.swt.custom.CCombo;
import org.eclipse.swt.custom.TableEditor;
import org.eclipse.swt.events.ModifyEvent;
import org.eclipse.swt.events.ModifyListener;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.events.ShellListener;
import org.eclipse.swt.graphics.Image;
import org.eclipse.swt.graphics.Point;
import org.eclipse.swt.graphics.Rectangle;
import org.eclipse.swt.layout.FormAttachment;
import org.eclipse.swt.layout.FormData;
import org.eclipse.swt.layout.FormLayout;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Combo;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.FileDialog;
import org.eclipse.swt.widgets.Group;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Menu;
import org.eclipse.swt.widgets.MenuItem;
import org.eclipse.swt.widgets.MessageBox;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.TableItem;
import org.eclipse.swt.widgets.Text;
import org.eclipse.swt.widgets.Tray;
import org.eclipse.swt.widgets.TrayItem;
import org.eclipse.swt.widgets.Event;
import org.eclipse.swt.widgets.Listener;
import org.eclipse.swt.events.ShellEvent;
public class Adaptoramin {
private Table table;
protected Shell shell;
protected Shell dialogshell;
static DataSour S;
static Vector Message=new Vector();
Vector Mes=new Vector();
//MessageInfro Infro=new MessageInfro();
Vector dataSources;
Vector comb1,comb2;//comb1是數據源的下拉框，comb2是目的數據庫的下拉框
Vector comb3,comb4,comb5,Text1;//comb3是數據源表的下拉框，comb4是目的數據庫表的下拉框
//public CCombo comb[][];
/**
* Launch the application
* @param args
*/
public static void main(String[] args) {
try {
Adaptoramin Adaptor= new Adaptoramin();
Adaptor.open();
try {
File f = new File("./src/config/DATASOURCE.txt");
if(f.exists()){
System.out.print("文件存在");
f.delete();
if(S.getS().size()!=0){f.createNewFile();//不存在則創(chuàng)建
ObjectOutputStream out =new ObjectOutputStream(new FileOutputStream(f));
out.writeObject(S);
}
}else{
System.out.print("文件不存在");
if(S.getS().size()!=0){f.createNewFile();//不存在則創(chuàng)建
ObjectOutputStream out =new ObjectOutputStream(new FileOutputStream(f));
out.writeObject(S);
}
}
File fr = new File("./src/config/task.txt");
if(fr.exists()){
System.out.print("文件存在");
fr.delete();
fr.createNewFile();//不存在則創(chuàng)建
ObjectOutputStream outr =new ObjectOutputStream(new FileOutputStream(fr));
outr.writeObject(Message);
}else{
System.out.print("文件不存在");
if(Message.size()!=0){
fr.createNewFile();//不存在則創(chuàng)建
ObjectOutputStream outr =new ObjectOutputStream(new FileOutputStream(fr));
outr.writeObject(Message);
}
}
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* Open the window
* @throws IOException
* @throws FileNotFoundException
* @throws ClassNotFoundException
*/
public void open() throws FileNotFoundException, IOException, ClassNotFoundException {
File f = new File("./src/config/DATASOURCE.txt");
if(f.exists()){
System.out.print("文件存在");
ObjectInputStream in=new ObjectInputStream(new FileInputStream(f));
S=(DataSour)in.readObject();
}else{
System.out.print("文件不存在");
dataSources=new Vector();
S=new DataSour(dataSources);
}
File F = new File("./src/config/task.txt");
if(F.exists()){
System.out.print("文件存在");
ObjectInputStream Inr=new ObjectInputStream(new FileInputStream(F));
Message=(Vector)Inr.readObject();
}else{
System.out.print("文件不存在");
}
createContents();
}
int count=0;
/**
* Create contents of the window
*/
protected void createContents() {
Display display = Display.getDefault();
comb1=new Vector();
comb2=new Vector();
comb3=new Vector();
comb4=new Vector();
comb5=new Vector();
Text1=new Vector();
shell = new Shell(SWT.TITLE);
final Toolkit kit = Toolkit.getDefaultToolkit();
shell.setLayout(new FormLayout());
shell.setSize(800, 500);
final int point_x=(kit.getScreenSize().width - 800) / 2;
final int point_y=(kit.getScreenSize().height - 500) / 2;
shell.setLocation(point_x,point_y);
shell.setText("關系型數據庫通用數據采集適配器V1.0");
final Tray tray=display.getSystemTray();
if(tray==null){
System.out.println("該系統(tǒng)不支持系統(tǒng)托盤");
return;
}
final TrayItem item=new TrayItem(tray,SWT.None);
Image image=new Image(display,"./src/config/icon.gif");
item.setImage(image);
item.setToolTipText("數據轉移軟件");
item.addListener(SWT.Show, new Listener() {
public void handleEvent(Event event) {
System.out.println("show");
}
});
item.addListener(SWT.Hide, new Listener() {
public void handleEvent(Event event) {
System.out.println("hide");
}
});
item.addListener(SWT.Selection, new Listener() {
public void handleEvent(Event event) {
System.out.println("selection");
}
});
item.addListener(SWT.DefaultSelection, new Listener() {
public void handleEvent(Event event) {
System.out.println("default selection");
shell.setVisible(!shell.isVisible());
tray.getItem(0).setVisible(!shell.isVisible());
}
});
shell.addShellListener(new ShellListener() {
public void shellActivated(ShellEvent e) {
// TODO Auto-generated method stub
}
public void shellClosed(ShellEvent e) {
// TODO Auto-generated method stub
}
public void shellDeactivated(ShellEvent e) {
// TODO Auto-generated method stub
}
public void shellDeiconified(ShellEvent e) {
// TODO Auto-generated method stub
}
public void shellIconified(ShellEvent e) {
shell.setVisible(!shell.isVisible());
tray.getItem(0).setVisible(!shell.isVisible());
}
});
Menu menu = new Menu(shell, SWT.BAR);
shell.setMenuBar(menu);
final MenuItem newSubmenuMenuItem_2 = new MenuItem(menu, SWT.CASCADE);
newSubmenuMenuItem_2.setText("文件");
final Menu menu_4 = new Menu(newSubmenuMenuItem_2);
newSubmenuMenuItem_2.setMenu(menu_4);
final MenuItem newSubmenuMenuItem_3 = new MenuItem(menu_4, SWT.CASCADE);
newSubmenuMenuItem_3.setText("打開");
final Menu menu_5 = new Menu(newSubmenuMenuItem_3);
newSubmenuMenuItem_3.setMenu(menu_5);
final MenuItem newItemMenuItem_14 = new MenuItem(menu_5, SWT.NONE);
newItemMenuItem_14.setText("日志文件");
newItemMenuItem_14.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(final SelectionEvent e) {
//"日志文件"
Shell logshell = new Shell();
logshell.setSize(586, 422);
final int point_x=(kit.getScreenSize().width - 586) / 2;
final int point_y=(kit.getScreenSize().height - 422) / 2;
logshell.setLocation(point_x, point_y);
logshell.setText("日志文件");
Text logText = new Text(logshell, SWT.BORDER|SWT.V_SCROLL|SWT.READ_ONLY|SWT.WRAP);
logText.setBounds(0, 0, 578, 388);
String FileName="./src/config/log.txt";
File myFile=new File(FileName);
if(!myFile.exists())
{
System.err.println("Can't Find " + FileName);
}
String result = null;
try
{
BufferedReader in = new BufferedReader(new FileReader(myFile));
String str;
while ((str = in.readLine()) != null)
{
System.out.println(str);
result=result+str+"\n";
}
in.close();
}
catch (IOException e1)
{
e1.getStackTrace();
}
logText.setText(result);
logshell.open();
}
});
new MenuItem(menu_4, SWT.SEPARATOR);
final MenuItem newItemMenuItem_4 = new MenuItem(menu_4, SWT.NONE);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -