主要由三个文件组成.一个是主执行文件,一个是用户界面文件,一个是数据模块文件.

用户界面这一块是用的eclipse的VE插件做的，只是还不知道如何发布这样的应用程序．唉...

 

 

//主程序
package com.fcgl;

public class FC {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
       Login.main(null);
      
     
 }

}

//用户界面
package com.fcgl;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

import org.eclipse.swt.SWT;
import org.eclipse.swt.graphics.Point;
import org.eclipse.swt.graphics.Rectangle;
import org.eclipse.swt.layout.FillLayout;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.List;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Text;

public class Login {

 private Shell sShell = null;  //  @jve:decl-index=0:visual-constraint="74,10"
 private Composite composite1 = null;
 private Button button1 = null;
 private Dm dm1;
 private Label label1 = null;
 private Text text1 = null;
 private Text text2 = null;
 private Text text3 = null;
 private Text textArea1 = null;
 private List list1 = null;
 private Button button2 = null;
 /**
  * This method initializes composite1 
  *
  */
 private void createComposite1() {
  composite1 = new Composite(sShell, SWT.NONE);
  composite1.setLayout(null);
  button1 = new Button(composite1, SWT.NONE);
  button1.setText("连接");
  button1.setSize(new Point(48, 22));
  button1.setLocation(new Point(176, 159));
  button1.addSelectionListener(new org.eclipse.swt.events.SelectionAdapter()

{
   public void widgetSelected(org.eclipse.swt.events.SelectionEvent e)

{
    dm1 = new Dm();
    boolean c = dm1.DconnectionOpen(text1.getText

(),text2.getText(),text3.getText());
    if (button1.getText() == "连接") {
     if (c == false) {
      label1.setText("连接失败");
     } else {
      label1.setText("连接成功");
      button1.setText("断开");
      ResultSet rs=dm1.ExeSQL(textArea1.getText

());
      try{
       list1.removeAll();
      while(rs.next()){
       for(int i=1;i<=3;i++){
             list1.add(rs.getString(i));
       }
         }
      }
      catch(Exception ee){
         ee.printStackTrace();
      }
      
     }
    } else {
     boolean d =dm1.DconnectionClose();
     if (d==false){
      label1.setText("断开失败");
     }
     else{
      label1.setText("断开成功");
      button1.setText("连接");
      }
     }
     
    
   }
  });
  label1 = new Label(composite1, SWT.NONE);
  label1.setBounds(new Rectangle(297, 163, 83, 12));
  label1.setText("");
  text1 = new Text(composite1, SWT.BORDER);
  text1.setBounds(new Rectangle(176, 16, 90, 17));
  text2 = new Text(composite1, SWT.BORDER);
  text2.setBounds(new Rectangle(176, 42, 90, 17));
  text3 = new Text(composite1, SWT.BORDER);
  text3.setBounds(new Rectangle(176, 69, 90, 17));
  textArea1 = new Text(composite1, SWT.MULTI | SWT.WRAP | SWT.V_SCROLL |

SWT.BORDER);
  textArea1.setBounds(new Rectangle(176, 91, 163, 59));
  list1 = new List(composite1, SWT.BORDER);
  list1.setBounds(new Rectangle(10, 11, 145, 169));
  button2 = new Button(composite1, SWT.NONE);
  button2.setBounds(new Rectangle(242, 160, 48, 22));
  button2.setText("字段");
  button2.addSelectionListener(new org.eclipse.swt.events.SelectionAdapter()

{
   public void widgetSelected(org.eclipse.swt.events.SelectionEvent e)

{
    list1.removeAll();
    ResultSetMetaData sm=dm1.GetField();
    try{
    for (int i=1;i<=sm.getColumnCount();i++){
     list1.add(sm.getColumnName(i));
    }
    }
    catch(Exception ee){
     ee.printStackTrace();
    }
   }
   });
   
 
 }

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  /* Before this is run, be sure to set up the launch configuration

(Arguments->VM Arguments)
   * for the correct SWT library path in order to run with the SWT dlls.
   * The dlls are located in the SWT plugin jar. 
   * For example, on Windows the Eclipse SWT 3.1 plugin jar is:
   *       installation_directory\plugins\org.eclipse.swt.win32_3.1.0.jar
   */
 
  Display display = Display.getDefault();
  Login thisClass = new Login();
  thisClass.createSShell();
  thisClass.sShell.open();

  while (!thisClass.sShell.isDisposed()) {
   if (!display.readAndDispatch())
    display.sleep();
  }
  display.dispose();
 }

 /**
  * This method initializes sShell
  */
 private void createSShell() {
  sShell = new Shell();
  
  sShell.setText("数据库连接");
  sShell.setSize(new Point(391, 221));
  sShell.setLayout(new FillLayout());
  /*Button btn1 =new Button(composite1,SWT.None);
  btn1.setBounds(12, 12, 22, 22);
  btn1.setText("连接");*/
  createComposite1();
  
  
 }

}

 

//数据模块
package com.fcgl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class Dm {
 Connection dcon;
 Statement stmt;
    ResultSet rs = null;
    ResultSetMetaData rmd;
 public boolean DconnectionOpen(String i,String u,String p){
  final String jdbc_driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  final String database_url =
  "jdbc:microsoft:sqlserver://"+i+":1433;DatabaseName=vllia-temp";
  final String user = u;
  final String password = p;
 try{
  Class.forName(jdbc_driver);
   dcon = DriverManager.getConnection(database_url, user,
                password);
   stmt = dcon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
              ResultSet.CONCUR_UPDATABLE);
  
 } 
 catch (Exception e) {
  e.printStackTrace();
  return false;
  
 }
  return true;
 }
 
 public boolean DconnectionClose(){
  try {
   
   stmt.close();
   dcon.close(); 
  } catch (Exception e) {
          e.printStackTrace();
          return false;
  }
  return true;
 }
 
 public ResultSet ExeSQL(String s){
  try{
  rs=stmt.executeQuery(s);
  }
  catch(Exception e){
   e.printStackTrace();
  }
  return rs;
  
 }
 public ResultSetMetaData GetField(){
  
  try{
   rmd =rs.getMetaData();
    
     }
  catch (Exception e){
   e.printStackTrace();
  
  }
  return rmd;
  
 }
 
}