📄 adaptoramin.java
字号:
((CCombo)comb2.elementAt(i)).add(s.getDateName());
((CCombo)comb2.elementAt(i)).setText(Sour2);
}
}
}catch(NullPointerException e1)
{
System.out.println("未打开Excel");
}
}
});
final MenuItem newItemMenuItem_2 = new MenuItem(menu_2, SWT.NONE);
newItemMenuItem_2.setText("设置数据库");
newItemMenuItem_2.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(final SelectionEvent e) {
final Shell dialog=new Shell();
dialog.setLocation(200, 200);
dialog.setText("修改数据库");
dialog.setSize(600,400);
FormLayout formLayout= new FormLayout();
dialog.setLayout(formLayout);
formLayout.marginHeight = 10; //设置shell的上下边距为10像素
formLayout.marginWidth = 20;
Label dialogLabel=new Label(dialog,SWT.NONE);
dialogLabel.setText("选择数据库：");
dialogLabel.setAlignment(SWT.LEFT);
FormData formData=new FormData(); //创建布局数据对象formData1
formData.width=60;
formData.height=15;
formData.top = new FormAttachment(0, 6); //Label与shell上边框相距5象素
formData.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
dialogLabel.setLayoutData(formData);
final CCombo comb=new CCombo(dialog,SWT.DROP_DOWN|SWT.BORDER);
if(S.getS().size()!=0)
for(int j=0;j<S.getS().size();j++){
comb.add(((Source)S.getS().elementAt(j)).getDateName());
}
FormAttachment formAttachmentc=new FormAttachment(dialogLabel); //指定dialogLabel1为参照物
FormData formDatac=new FormData(100,15); //创建FormData对象，宽度300，高度50
formDatac.left=formAttachmentc; //b2的左边紧贴与b1的右边
comb.setLayoutData(formDatac);
Label dialogLabel1=new Label(dialog,SWT.NONE);
dialogLabel1.setText("数据库名：");
dialogLabel1.setAlignment(SWT.LEFT);
FormData formData1=new FormData(); //创建布局数据对象formData1
formData1.width=60;
formData1.height=15;
formData1.top = new FormAttachment(dialogLabel, 11); //Label与shell上边框相距5象素
formData1.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
dialogLabel1.setLayoutData(formData1);
final Text dialogtext1=new Text(dialog,SWT.BORDER);
FormAttachment formAttachment1=new FormAttachment(dialogLabel1); //指定dialogLabel1为参照物
FormData formData11=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData11.top = new FormAttachment(comb, 5); //Label与shell上边框相距5象素
formData11.left=formAttachment1; //b2的左边紧贴与b1的右边
dialogtext1.setLayoutData(formData11);
Label dialogLabel2=new Label(dialog,SWT.NONE );
dialogLabel2.setText("连接的URL：");
dialogLabel2.setAlignment(SWT.LEFT);
FormData formData2=new FormData(); //创建布局数据对象formData2
formData2.top = new FormAttachment(dialogLabel1, 11); //Label与shell上边框相距5象素
formData2.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
formData2.width=60;
formData2.height=15;
dialogLabel2.setLayoutData(formData2);
final Text dialogtext2=new Text(dialog,SWT.BORDER);
FormData formData21=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData21.top = new FormAttachment(dialogtext1, 5); //Label与shell上边框相距5象素
FormAttachment formAttachment2=new FormAttachment(dialogLabel2); //指定dialogLabel1为参照物
formData21.left=formAttachment2; //b2的左边紧贴与b1的右边
dialogtext2.setLayoutData(formData21);
Label dialogLabel3=new Label(dialog,SWT.None);
dialogLabel3.setText("用户名：");
FormData formData3=new FormData(); //创建布局数据对象formData2
formData3.top = new FormAttachment(dialogLabel2, 11); //Label与shell上边框相距5象素
formData3.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
formData3.width=60;
formData3.height=15;
dialogLabel3.setLayoutData(formData3);
final Text dialogtext3=new Text(dialog,SWT.BORDER);
// 创建FormAttachment对象formAttachment,以b1为参照物
FormAttachment formAttachment3=new FormAttachment(dialogLabel3); //指定dialogLabel1为参照物
FormData formData31=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData31.top = new FormAttachment(dialogtext2, 5); //Label与shell上边框相距5象素
formData31.left=formAttachment3; //b2的左边紧贴与b1的右边
dialogtext3.setLayoutData(formData31);
Label dialogLabel4=new Label(dialog,SWT.None);
dialogLabel4.setText("密码：");
FormData formData4=new FormData(); //创建布局数据对象formData2
formData4.top = new FormAttachment(dialogLabel3, 11); //Label与shell上边框相距5象素
formData4.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
formData4.width=60;
formData4.height=15;
dialogLabel4.setLayoutData(formData4);
final Text dialogtext4=new Text(dialog,SWT.PASSWORD|SWT.BORDER);
// 创建FormAttachment对象formAttachment,以b1为参照物
FormAttachment formAttachment4=new FormAttachment(dialogLabel4); //指定dialogLabel1为参照物
FormData formData41=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData41.top = new FormAttachment(dialogtext3, 5); //Label与shell上边框相距5象素
formData41.left=formAttachment4; //b2的左边紧贴与b1的右边
dialogtext4.setLayoutData(formData41);
Label dialogLabel5=new Label(dialog,SWT.None);
dialogLabel5.setText("schema：");
FormData formData5=new FormData(); //创建布局数据对象formData2
formData5.top = new FormAttachment(dialogLabel4, 11); //Label与shell上边框相距5象素
formData5.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
formData5.width=60;
formData5.height=15;
dialogLabel5.setLayoutData(formData5);
final Text dialogtext5=new Text(dialog,SWT.BORDER);
// 创建FormAttachment对象formAttachment,以b1为参照物
FormAttachment formAttachment5=new FormAttachment(dialogLabel5); //指定dialogLabel1为参照物
FormData formData51=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData51.top = new FormAttachment(dialogtext4, 5); //Label与shell上边框相距5象素
formData51.left=formAttachment5; //b2的左边紧贴与b1的右边
dialogtext5.setLayoutData(formData51);
Label dialogLabel6=new Label(dialog,SWT.None);
dialogLabel6.setText("Driver:");
FormData formData6=new FormData(); //创建布局数据对象formData2
formData6.top = new FormAttachment(dialogLabel5, 11); //Label与shell上边框相距5象素
formData6.left = new FormAttachment(0, 2); // Label与shell左边框相距5象素
formData6.width=60;
formData6.height=15;
dialogLabel6.setLayoutData(formData6);
final Text dialogtext6=new Text(dialog,SWT.BORDER);
// 创建FormAttachment对象formAttachment,以b1为参照物
FormAttachment formAttachment6=new FormAttachment(dialogLabel6); //指定dialogLabel1为参照物
FormData formData61=new FormData(500,15); //创建FormData对象，宽度300，高度50
formData61.top = new FormAttachment(dialogtext5, 5); //Label与shell上边框相距5象素
formData61.left=formAttachment6; //b2的左边紧贴与b1的右边
dialogtext6.setLayoutData(formData61);
Button sb=new Button(dialog,SWT.MouseDown);
sb.setText("添加数据库");
FormData formDatab=new FormData(); //创建布局数据对象formData1
formDatab.top = new FormAttachment(dialogLabel6, 80); //Label与shell上边框相距5象素
formDatab.left=new FormAttachment(0,240);
formDatab.width=80; //按钮b1的宽度为100像素
formDatab.height=40; //按钮b1的高度为50像素
sb.setLayoutData(formDatab); //设置b1的布局数据为formData1
comb.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(final SelectionEvent e) {
if(!comb.getText().equals("")){
if(S.getS().size()!=0)
for(int j=0;j<S.getS().size();j++){
if(comb.getText().equals(((Source)S.getS().elementAt(j)).getDateName()))
{
dialogtext1.setText(((Source)S.getS().elementAt(j)).getDateName());
dialogtext2.setText(((Source)S.getS().elementAt(j)).getConnURL());
dialogtext3.setText(((Source)S.getS().elementAt(j)).getUseName());
dialogtext4.setText(((Source)S.getS().elementAt(j)).getPassword());
dialogtext5.setText(((Source)S.getS().elementAt(j)).getSchema());
dialogtext6.setText(((Source)S.getS().elementAt(j)).getDriver());
}
}
}
}
});
sb.addSelectionListener(new SelectionAdapter(){
public void widgetSelected(SelectionEvent e){
//将所有的数据库信息导入数据库对象中
if((!dialogtext1.getText().equals(""))&&(!dialogtext2.getText().equals(""))&&(!dialogtext6.getText().equals(""))
&&(!dialogtext5.getText().equals(""))&&(!dialogtext3.getText().equals(""))&&(!dialogtext4.getText().equals("")))
{
if(S.getS().size()!=0)
for(int j=0;j<S.getS().size();j++){
if(comb.getText().equals(((Source)S.getS().elementAt(j)).getDateName()))
{
S.getS().removeElementAt(j);
TableItem[] items=table.getItems();
if(items.length!=0){
for(int i=0;i<items.length;i++)
{
//数据源选择
if(((CCombo)comb1.elementAt(i)).getText().equals(dialogtext1.getText()))
{
//((CCombo)comb3.elementAt(i)).removeAll();
//System.out.println("((CCombo)comb3.elementAt(i)).removeAll();");
}
((CCombo)comb1.elementAt(i)).remove(j);
//System.out.println(((CCombo)comb1.elementAt(i)).getItem(0));
// 目的数据库选择
if(((CCombo)comb2.elementAt(i)).getText().equals(dialogtext1.getText()))
{
//((CCombo)comb4.elementAt(i)).removeAll();
// System.out.println("((CCombo)comb4.elementAt(i)).removeAll();");
}
((CCombo)comb2.elementAt(i)).remove(j);
//System.out.println(((CCombo)comb1.elementAt(i)).getItem(0));
}
}
}
}
Source s=new Source(dialogtext1.getText(),dialogtext2.getText(),
dialogtext3.getText(),dialogtext4.getText(),dialogtext6.getText(),dialogtext5.getText());
s.setDateName(dialogtext1.getText());
s.setConnURL(dialogtext2.getText());
s.setUseName(dialogtext3.getText());
s.setPassword(dialogtext4.getText());
s.setSchema(dialogtext5.getText());
s.setDriver(dialogtext6.getText());
for(int j=0;j<S.getS().size();j++){
if(comb.getText().equals(((Source)S.getS().elementAt(j)).getDateName()))
{
s.setType(((Source)S.getS().elementAt(j)).getType());
}
}
S.getS().add(s);
dialogtext1.setText("");
dialogtext2.setText("");
dialogtext3.setText("");
dialogtext4.setText("");
dialogtext5.setText("");
dialogtext6.setText("");
TableItem[] items=table.getItems();
System.out.println("comb1.size"+comb1.size());
System.out.println("items.length"+items.length);
if(items.length!=0){
for(int i=0;i<items.length;i++)
{
//数据源选择
//String Sour1=((CCombo)comb1.elementAt(i)).getText();
((CCombo)comb1.elementAt(i)).add(s.getDateName());
//((CCombo)comb1.elementAt(i)).setEnabled(false);
//((CCombo)comb1.elementAt(i)).setVisible(true);
//目的数据库选择
//String Sour2=((CCombo)comb2.elementAt(i)).getText();
((CCombo)comb2.elementAt(i)).add(s.getDateName());
//((CCombo)comb2.elementAt(i)).setText("");
}
}
}else
{
}
}
});
dialog.open();
}
});
final MenuItem newSubmenuMenuItem = new MenuItem(menu, SWT.CASCADE);
newSubmenuMenuItem.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(final SelectionEvent e) {
}
});
newSubmenuMenuItem.setText("帮助");
final Menu menu_1 = new Menu(newSubmenuMenuItem);
newSubmenuMenuItem.setMenu(menu_1);
final MenuItem newItemMenuItem_6 = new MenuItem(menu_1, SWT.NONE);
newItemMenuItem_6.setText("使用文档");
final MenuItem newItemMenuItem_7 = new MenuItem(menu_1, SWT.NONE);
newItemMenuItem_7.setText("连接Intenet");
new MenuItem(menu_1, SWT.SEPARATOR);
final MenuItem newItemMenuItem_13 = new MenuItem(menu_1, SWT.NONE);
newItemMenuItem_13.setText("软件升级");
final Composite composite = new Composite(shell, SWT.NONE);
final FormData fd_composite = new FormData();
fd_composite.bottom = new FormAttachment(0, 35);
fd_composite.right = new FormAttachment(100, -5);
fd_composite.top = new FormAttachment(0, 5);
fd_composite.left = new FormAttachment(0, 5);
composite.setLayoutData(fd_composite);
composite.setLayout(new FormLayout());
final Button button_2 = new Button(composite, SWT.NONE);
button_2.setSize(80,10);
final FormData fd_button_2 = new FormData();
fd_button_2.top = new FormAttachment(100, -27);
fd_button_2.right = new FormAttachment(100, -40);
button_2.setLayoutData(fd_button_2);
button_2.setText("方案配置");
final Button button_1;
button_1 = new Button(composite, SWT.NONE);
button_1.setSize(50,10);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -