| Java Tutorial » Database » Java DB Derby |
| 20. 33. Java DB Derby | ||||
| 20. 33. 1. | New to Java 6 is a lightweight database called Derby. | |||
| 20. 33. 2. | The JavaDB Directory Structure | |||
| 20. 33. 3. | The JavaDB Environments | |||
| 20. 33. 4. | JavaDB Drivers | |||
| 20. 33. 5. | JavaDB URLs | |||
| 20. 33. 6. | JavaDB Tools | |||
| 20. 33. 7. | You can use the server tool to start JavaDB in a network client environment. | |||
| 20. 33. 8. | Ping JavaDB. | |||
| 20. 33. 9. | To view run time information for JavaDB, you can use the following command: | |||
| 20. 33. 10. | To stop JavaDB, you can use the following command: | |||
| 20. 33. 11. | Using the ij Tool | |||
| 20. 33. 12. | You can use the connect command of ij to establish a connection with a database | |||
| 20. 33. 13. | Viewing and Switching Connections | |||
| 20. 33. 14. | Working with Tables | |||
| 20. 33. 15. | To view the structure of the Employee table | |||
| 20. 33. 16. | Using the sysinfo Tool | |||
| 20. 33. 17. | Connect to Java DB (Derby) with org.apache.derby.jdbc.EmbeddedDriver | |||
| 20. 33. 18. | The SQL script for creating the Employee Table | |||