JBuilder2005 connected Oracle9i database
In the JBUILDER2005 development environment, connect Oracle9i databases via JDBC. First, create a new project DBVIEW, Tools-> Configure-> Libraries, as shown below:
Open Configure Libraries, add Oracle9i's JDBC driver, just take a name as ORA9I_LIB, followed by the project's Properties dialog, add the class library you just created in the Required Libraries tab.
Next, from Tools-> Database Pilot, create a Database URLS, the driver select Oracle.jdbc.driver.Orcledriver, URL is JDBC: Oracle: Thin: @HostName: 1521: ORCL (according to actual conditions), select Open, Enter the username and password, connect test, congratulations, success (if prompted to find drivers, a possible solution is: to Enterprise-> Enterprise setup, add ORA9I_LIB to enter, restart JBuilder2005).
You can now create an Application, add a few DataExpress components to your application, enter the UI interface, select Database from the DataExpress tab, set its properties Connection to the database connection you just created.
Then add QueryDataSet to Frame, and enter the SQL statement at its Query property. Switch to the DBSWING tab, add TableScrollPane, add JDBTABLE to TABLESCROLLPANE, set its DataSet property as the querydataSet1 just added. If you want to modify the name of the field display, you can switch to the Data Acup page for modification. Save, F9 runs, OK, you can see the result of the run.
