JDBC连接Oracle数据库

1. 在工程Build Path中加入ojdbc14.jar

2. 在Oracle中建表，输入数据。

3. 编码如下：

package yerasel;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Java 连接 Oracle
 * 
 */
public class JDBCOracle {

	public static void main(String[] args) {
		// 访问路径
		String dbUrl = "jdbc:oracle:thin:@10.23.117.134:1521:*****";
		// 用户名
		String dbUsername = "*****";
		// 密码
		String dbPassword = "*****";

		String usrName = "Yerasel";

		String PSW = "123456";

		try {
			// 加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");

			// 得到数据库连接对象
			Connection connection = DriverManager.getConnection(dbUrl,
					dbUsername, dbPassword);
			Statement statement = connection.createStatement();

			// 查询数据
			String reqName = "select * from usrpsw where USRNAME = \'";
			reqName += usrName;
			reqName += "\'";
			ResultSet resName = statement.executeQuery(reqName);
			if (resName.next() == false) {
				System.out.println(usrName + " doesnot exists.");
			} else {
				String reqPSW = reqName;
				reqName += "and PSW = \'";
				reqName += PSW;
				reqName += "\'";
				ResultSet resPSW = statement.executeQuery(reqPSW);
				if (resPSW.next() == false) {
					System.out.println("Wrong Password for " + usrName);
				} else {
					System.out.println("Get it " + usrName + " " + PSW);
				}
			}
			// 打印数据
			/*
			 * while(results.next()){
			 * System.out.println("Usr:"+results.getString(1));
			 * System.out.println("Psw:"+results.getString(2));
			 * System.out.println("----------------------------------"); }
			 */
			connection.close();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

运行结果如下：