Use com. Microsoft. JDBC. sqlserver. sqlserverdriver in JBuilder to connect to the SQL database

1. Are you sure you want to install the full JDBC version? Because there is a single-host version that can only connect to the SQL statements on the local machine, the single-host version is about 2 m, and the full version is about 6.5 m
2. After JDBC is installed, if the directory is in C:/program files/Microsoft SQL Server 2000 JDBC, open JBuilder and select Tools --> Configure libraries, select new in the list box on the left, enter name: SQL, Location: User Home, and click Add to add the directory c:/program files/Microsoft SQL Server 2000 JDBC/lib, OK
Iii. Project --> prject properties --> paths --> required libraries --> Add
Add the added user home/SQL to confirm
4. Tools --> enterprise setup --> database drivers --> Add, add user home/SQL, and then display SQL. config in the list box. OK. Restart JBuilder.
5. Tools --> Database Pilot --> View --> options --> drivers --> Add
Enter
Driver Class: COM. Microsoft. JDBC. sqlserver. sqlserverdriver
Simple URL: Microsoft: sqlserver: // localhost: 1433; databasename = mybase
After confirming, choose tools> Database Pilot> New Driver
Com. Microsoft. JDBC. sqlserver. sqlserverdriver
Enter in the URL:
Microsoft: sqlserver: // server IP address or host name: 1433; databasename = Database Name, OK!
Double-click or click "+" and enter the sqldatabase user name and password to connect JB to SQL!
You can view the connection code source!