oraclebean.java

来自「还是超市管理系统 和刚才那个不一样」· Java 代码 · 共 78 行

/**
*@author EvilSun
*@version 0.1  2006-07-27
*
*/


package javabean;

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

public class OracleBean {
	String url = "jdbc:oracle:thin:@eda21:1521:EvilSun";
	String driver = "oracle.jdbc.driver.OracleDriver";
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
	public OracleBean(){
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {			
			e.printStackTrace();
		}			
	}
	
	public ResultSet query(String sql){
		try{
			conn = DriverManager.getConnection(url,"scott","tiger");
			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{
			conn = DriverManager.getConnection(url,"scott","tiger");
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	
	public int delete(String sql){
		int flag = 0;
		try{
			conn = DriverManager.getConnection(url,"scott","tiger");
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			flag = stmt.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		
		return flag;
	}
	
	public void close(){
	  try{
	  	conn.close();
	  }catch(Exception e){
	  	e.printStackTrace();
	  }	
	}
	
	
	
	
}