1.JBuilder连接ACCESS(首先配置好ODBC)

package jdbc;
import java.sql.*;
public class testjdbc {
    public static void main(String[] args) throws Exception {
     String url="jdbc:odbc:ws";
     Connection conn;
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     conn=DriverManager.getConnection(url,"","");
     if(conn!=null){
         System.out.println("连接成功！");
         System.out.println("conn.getCatalog()="+conn.getCatalog());
     }
}
}

2.JBuilder连接SQLServer

package jdbc;
import java.sql.*;
public class sqljdbc {
    public static void main(String[] args) {
       String driver="conn.microsoft.jdbc.sqlserver.SQLServerDriver";
       String url="jdbc:microsoft:sqlserver://bemyfriend:1433;DatabaseName="+"pubs;User=sa;Password=";
       Connection conn=null;
       try{
           Class.forName(driver);
           conn=DriverManager.getConnection(url,"sa","");
           if(conn !=null)
           {
               System.out.println("连接成功！");
               System.out.println("conn.getCatalog()="+conn.getCatalog());
           }
       }
       catch(Exception e){
           e.printStackTrace();
       }
       try{
       conn.close();
      
   }
     catch(Exception e){
         e.printStackTrace();
     }
    }
}