1.打开oracle服务监听选项 (10G_home1TNSListener)
2.创建数据库
3.把oracle下的oracle/product/10.2.0db_1/jdbc/classes12.jar
jar包复制到tomcat的common/lib目录下
4.编写jsp代码
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
String DBURL ="jdbc:oracle:thin:@localhost:1521:zb";//zb是数据源
String DBUSER ="scott";
String DBPASSWORD ="tiger";
Connection conn =null;
Statement stmt = null;
%>
<%
try{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
//创建sql语句
String sql = "CREATE TABLE mldntab(name varchar(20))";
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}catch(Exception e){
out.println(e);
}
%>