All Examples This Package
Class examples.jdbc.mssqlserver4.LargeTableTests
java.lang.Object
|
+----examples.jdbc.mssqlserver4.LargeTableTests
- public class LargeTableTests
- extends Object
This example creates a large table, retrieves its contents, and
then deletes the table.
The application demonstrates how to:
- create a table using a Statement
- insert rows individually using separate Statements
- insert rows using PreparedStatements
- retrieve rows using Statements
- retrieve rows using a stored procedure (CallableStatement)
The test creates a stored procedure, so you must use an account that has
the required privileges.
To set up this example:
- Set up your development shell as described in Package examples.jdbc.mssqlserver4.
- Change the database URL, login, and password connection parameters
to correspond to your Microsoft SQL Server configuration. If you need
more help, check the section on connecting to a database in the
Developers Guide, Using
WebLogic jDriver for Microsoft SQL Server.
- Compile this example by executing the following command in your development shell:
$ javac -d c:/weblogic/mssqlserver4/classes LargeTableTests.java
- Run this example by executing the following command in your development shell:
$ java examples.jdbc.mssqlserver4.LargeTableTests
-
LargeTableTests()
-
-
main(String[])
-
LargeTableTests
public LargeTableTests()
main
public static void main(String args[])
All Examples This Package