oraclebean.java

来自「一个利用java连接数据库的原来」· Java 代码 · 共 44 行

package oracle;

import java.sql.*;

public class oracleBean {
	String serverName = "localhost";
	String driver = "oracle.jdbc.driver.OracleDriver";
	String url = "jdbc:oracle:thin:@"+serverName+":1521:ora9";
	Connection connect = null;
	ResultSet rs = null;

	public oracleBean() {
		try {
			Class.forName(driver); 
		}
		catch(Exception e) {
			e.printStackTrace();
		}
	}
	
	public ResultSet query(String sql) {
		try {
			connect = DriverManager.getConnection(url, "scott", "tiger"); 
			Statement stmt = connect.createStatement();
			rs = stmt.executeQuery(sql);
		} 
		catch(Exception e) { 
			e.printStackTrace();
		}
		return rs;
	}
	
	public void update(String sql) {
		try {
			connect = DriverManager.getConnection(url, "scott", "tiger"); 
			Statement stmt = connect.createStatement();
			stmt.executeUpdate(sql);
		} 
		catch(Exception e) { 
			e.printStackTrace();
		}
	}	
}