<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>JSP连接Oracle数据库</title></head>
<body>
<%
Connection conn = null;
//Statement stmt = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbc");
//MyDataSource为数据源名称,username、password为Oracle数据库的用户名和密码
conn = DriverManager.getConnection("jdbc:odbc:MyDataSource", "username", "password");
//stmt = conn.createStatement();
//String sql = "";
//ResultSet rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
%>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>JSP连接Oracle数据库</title></head>
<body>
<%
Connection conn = null;
//Statement stmt = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbc");
//MyDataSource为数据源名称,username、password为Oracle数据库的用户名和密码
conn = DriverManager.getConnection("jdbc:odbc:MyDataSource", "username", "password");
//stmt = conn.createStatement();
//String sql = "";
//ResultSet rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
%>
</body>
</html>
