oracle笔记 之VI JDBC连接 Oracle 数据库

 <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%--
 使用JDBC连接Oracle数据库
--%>
<%!
 String DBDRIVER="oracle.jdbc.driver.OracleDriver";
 String URL="jdbc:oracle:thin:@localhost:1521:orcl";
 String USER="scott";
 String PASSWORD="tiger";
 Connection conn = null;
 Statement st = null;
%>

<%
 try{
  Class.forName(DBDRIVER);
  conn = DriverManager.getConnection(URL,USER,PASSWORD);
  String sql = "create table mldn(name varchar(20))";
  st = conn.createStatement();
  st.executeUpdate(sql);
  st.close();
  conn.close();

 
 }catch(Exception e){
  e.printStackTrace();
 }

%>