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();
 }
%>