步骤:1.定义一系列的全局常量,驱动路径,连接地址,用户名,密码
2.加载驱动程序
3.连接数据库
4。操作数据库更新或查询。
5.关闭数据库。
代码:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>连接Oracle数据库的代码</title>
</head>
<body>
<%!
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:MLDN";
public static final String DBUSER = "scott";
public static final String DBPASSWORD ="tiger";
%>
<%
Connection conn = null;//数据库连接
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT empmo,ename,job FROM emp";
%>
<%
Class.forName(DBDRIVER);//返回值是CLASS
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
//index是从1开始 而Hibernate中的Query是从0开始
int empno = rs.getInt(1);
String ename = rs.getString(2);
String job = rs.getString(3);
}
//正着打开倒着关闭
rs.close();
pstmt.close();
conn.close();
%>
</body>
</html>
2.加载驱动程序
3.连接数据库
4。操作数据库更新或查询。
5.关闭数据库。
代码:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>连接Oracle数据库的代码</title>
</head>
<body>
<%!
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:MLDN";
public static final String DBUSER = "scott";
public static final String DBPASSWORD ="tiger";
%>
<%
Connection conn = null;//数据库连接
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT empmo,ename,job FROM emp";
%>
<%
Class.forName(DBDRIVER);//返回值是CLASS
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()){
//index是从1开始 而Hibernate中的Query是从0开始
int empno = rs.getInt(1);
String ename = rs.getString(2);
String job = rs.getString(3);
}
//正着打开倒着关闭
rs.close();
pstmt.close();
conn.close();
%>
</body>
</html>