用Tomcat + Java JDBC 连接使用Oracle数据库
用Tomcat + Java JDBC 连接使用Oracle数据库
首先把 Oracle安装目录中(D:\oracle\product\10.2.0\db_1\jdbc\lib\)的classes12.jar/ojdbc14.jar 驱动包放到 tomcat 的lib目录下
- <%@ page language="java" import="java.sql.*" pageEncoding="GBK"%>
- <%!String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
- String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";
- String USERNAME = "scott";
- String PASSWORD = "orcl";
- Connection conn = null;
- Statement stmt = null;%>
- <%
- try {
- //实例化驱动程序
- Class.forName(DBDRIVER);
- out.println("驱动实例化成功!");
- conn = DriverManager.getConnection(DBURL, USERNAME, PASSWORD);
- out.println("链接数据库成功!");
- String sql = "CREATE TABLE mldntab (name varchar(20))";
- stmt = conn.createStatement();
- stmt.executeUpdate(sql);
- out.println("表格已经创建!!");
- } catch (Exception e) {
- out.print("数据库操作出现问题!表格创建失败!" + e);
- }
- %>
评论暂时关闭