oraclebean.java

来自「我在东软培训期间的小联系」· Java 代码 · 共 54 行

package com.neusoft;

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

public class OracleBean {
	private String driver = "oracle.jdbc.driver.OracleDriver";

	private String url = "jdbc:oracle:thin:@172.17.103.26:1521:ora";

	private String uid = "scott";

	private String password = "tiger";

	private Connection conn;

	public OracleBean() {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, uid, password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public ResultSet query(String sql) {
		ResultSet rs = null;
		try {
			Statement stmt = conn.createStatement(
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}

	public void update(String sql) {
		try {
			Statement stmt = conn.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}