Use Tomcat + Java JDBC to connect to an Oracle database

First, put the classes12.jar/ojdbc14.jar driver package in the Oracle Installation Directory (D: \ oracle \ product \ 10.2.0 \ db_1 \ jdbc \ lib \) to the tomcat lib directory.

1. <% @ Page language ="Java" Import="Java. SQL .*"PageEncoding ="GBK"%>
2. <%! String DBDRIVER ="Oracle. jdbc. driver. OracleDriver";
3. String DBURL ="Jdbc: oracle: thin: @ localhost: 1521: orcl";
4. String USERNAME ="Scott";
5. String PASSWORD ="Orcl";
7. Connection conn =Null;
8. Statement stmt =Null; %>
10. <%
11. Try{
13. // Instantiate the driver
14. Class. forName (DBDRIVER );
15. Out. println ("The driver has been instantiated! ");
16. Conn = DriverManager. getConnection (DBURL, USERNAME, PASSWORD );
17. Out. println ("Connected to the database succeeded! ");
18. String SQL ="Create table mldntab (name varchar (20 ))";
20. Stmt = conn. createStatement ();
21. Stmt.exe cuteUpdate (SQL );
23. Out. println ("The table has been created !! ");
25. }Catch(Exception e ){
27. Out. print ("Database operation problems! Table creation failed! "+ E );
28. }
29. %>